0

How to use GL Function for different group account codes

Jet Reports Historic Posts

December 02, 2015 10:08

None

Follow

Hi expert there,

I am new to Jet.

I tried to use the GL function to join two different group of account, like "1110..1140|2110..2130" (GL("Balance","1110..1140|2110..2130",,"31/1/2015")), but it only return the balance for "1110..1140". Anything I have done wrong. I wish to have a single line or sum-up the figure in one line. Please help me.

Thank you.

Regards,
Ming

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts December 09, 2015 15:28 Official comment

  Hello Ming -
  
  What happens if you add a starting date to the GL() function in cell C3?
  
  =GL("Balance",B3,"1/1/2015","31/1/2015"
  
  Next, what happens if you exclude the closing entries?
  
  =GL("Balance",B3,"1/1/2015","31/1/2015",,,,,,,,,,"True")

• 0
  
  Jet Reports Historic Posts December 02, 2015 15:31

  Hello Ming -
  
  Let's have you perform a test.
  
  If you build and run the following report:
  
  
  Does the value in cell C7 not match the sum of the values for the Posting type accounts listed in that column?
• 0
  
  Jet Reports Historic Posts December 03, 2015 02:20

  Hi HPDeskJet,
  
  I have performed the test as per the formula, given, but the funny things is one of the G/L Account balance is incorrect. I further extended the GL Account with "1110..1140|2110..2130|2310..2340", also another GL account balance is not correct.
  
  I am using Cronus for testing purpose, the result as below, where the balance for GL Account 2120 & 2310 are different from COA:
  
  
  
  
  
  
  
  Please advise. Many Thanks
  
  Regards,
  Ming
• 0
  
  Jet Reports Historic Posts December 15, 2015 01:47

  Hi HPDeskJet,
  
  I got the right value now, thanks. ;)