0

Month to date and Year to date

Jet Reports Historic Posts

May 04, 2011 18:19

None

Follow

Hi All,

I am trying to create a new report using JET Reports. I need all G/L Accounts with Month to Date and Year to Date. User want to apply the Date filter in the Request Form. I am using GL Function but In NAV i used Net change field to get Month to Date and Balance to Date filed to get Year to Date. with JET REPORTS GL Function I don't have Net Change and Balance to Date field.

Can any one help me how to create this kind of report.

Thanks,

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts May 05, 2011 06:13

  The GL function is not referring to a NAV field. It is a special function for G/L Accounts and thus has special financial arguments.
  
  In your case I think you will need the first 4 arguments: What, Account, Start date, End date
  An example could be =GL("Balance","8000","1-1-2011","4-5-2011") which would calculate the actual amount posted on G/L Account 8000 from Jan 1 to May 4.
  
  In the Jet Reports Help and manual there's a lot more info about the GL function. Also, you will find some very nice examples here http://community.jetreports.com/viewtopic.php?f=13&t=280 to help you understand how it works.

• 0
  
  Jet Reports Historic Posts September 17, 2012 09:50

  We have a financial year from july 1st until june 30th. Last year I used the function Balance at Date for my cost-centre reports (compared with budget at date) for each account-line.
  In the new year 2012/2013 Balance at Date still has the balance-data from 2011/2012. I use the date filter 01-07-2012..31-08-2012 but that does not help.
  Any suggestions?
  Thanks,
  Paul

• 0
  
  Jet Reports Historic Posts September 17, 2012 14:01

  Hi Paul,
  
  Did you run the NAV process to close your financial year? That will bring the balance of the income accounts to zero at the end of a fiscal year. This process runs in NAV, not in Jet.
  
  You say you used the "Balance at date" function. Is that an NF function with the "Balance at date" field from the G/L Account table? How about using the "Net change" field instead with your date filter. Does that give the result you were expecting? Or give the GL Function a try as described.
  
  Did that help?