0

Multiple Budgets to report

Jet Reports Historic Posts

January 13, 2009 22:24

None

Follow

If we want to use 2 budget files in Navision (eg orginal budget vs forcast update), how do I specify an amount from only one of the 2 budgets? If I use the function GL("Budget",{account},{fromdate},{todate},,,,,,,,{database}) it adds up amounts from both budgets.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 14, 2009 06:49

  The GL function does have a Budget argument. Enter the budget name or select it via the lookup button and you will get the result you wish to have.
  
  =GL("Budget";{fromdate};{todate};;;;;;;;{budgetname})
  
  If you look in the Jet Reports Help in Excel or Jet Reports PDF file on Page 190 you will find an explanation of all the GL arguments.