0

GL("Balance") pulling balance and budget

Jet Reports Historic Posts

January 27, 2009 16:34

None

Follow

The following cell command is pulling both budgets and balance amounts.

=-gl("Balance",$B18,$F$14,$F$15)

B18 is the account number
F14 is the beginning date
F15 is the ending date

How do I get it to pull only balance amounts.

Tim

• Facebook
• Twitter
• LinkedIn

7 comments

• 
  Jet Reports Historic Posts January 27, 2009 18:29 Official comment

  Yes, I am sorry to report that the GL() function does not work with Serenic Nav. :cry:

• 0
  
  Jet Reports Historic Posts January 27, 2009 18:04

  Are you using Serenic NAV?
  
  I would assume that you might have some customization done so the GL() function isn't working like it should. When you look at your G/L Entry table, do you have a Transaction Type? If so, the GL() function will not work for you. You will need to use the NL() function to get your information.

• 0
  
  Jet Reports Historic Posts January 27, 2009 18:08

  Yes, Serenic NAV. Is that going to prevent me from using the GL function?
  
  Tim

• 0
  
  Jet Reports Historic Posts January 27, 2009 18:37

  Thanks for your help.
  
  Tim

• 0
  
  Jet Reports Historic Posts February 12, 2009 09:57

  What is Serenic NAV :?: :?: :?:

• 0
  
  Jet Reports Historic Posts February 12, 2009 15:11

  Serenic NAV is a version of Dynamics NAV modified for use by non-profits. They modified the GL table to add actuals, budgets, encumberances, and a few others. That prevents the GL function from working as the GL function can not restrict on their new type.

• 0
  
  Jet Reports Historic Posts March 04, 2009 14:22

  Thanks Tim. I was having the same problem. It sucks, but at least now I know why.