Hi, I was making a report today that returned a very low value (see attach).
I went to look at the filtered records and the returned value should have been "0".
Used formula is a very simple one:=NL("Sum";"G/L Entry";"Amount";"G/L Account No.";$B8;"Global Dimension 1 Code";$B$2;"Document Date";$F$2)
Is this because the G/L Entry is more accurate than you can show in NAV?
When I fetch this formula:=NL("Rows";"G/L Entry";"Amount";"G/L Account No.";D2;"Document Date";D3;"Global Dimension 1 Code";D4)
I get the correct numbers:
-898,9
-365,55
-263,35
-237,71
-124,75
-97,85
1988,11
Date
Votes
2 comments
-
Jet Reports Historic Posts Are you sure you want to filter by Document Date? It may not yet be posted and that is why are not getting the correct values. I am not sure exactly what you are looking for but if you are trying to find the value in a g/l account I always sum by posting date.
Another option is to use the GL function that just gives you the balance of a g/l account within a particular date range. In the example below
=GL("balance",$C9,"7/1/2008","7/31/2008",,$C$3)
Hope that helps. -
Jet Reports Historic Posts Should of cleared that out ;). Yes, I need the document date. Usually I also take the posting date but with this report the document date is required.
It doesn't matter however what date I use, if I apply the same filter in NAV it should return the same value…
I know the diffirence is neglectable, but it's quite annoying (solved it with a ROUND() formula untill I know what is causing it).
Please sign in to leave a comment.