0

G/L Function gives Zero Values

Jet Reports Historic Posts

May 04, 2015 17:24

None

Follow

Hi everyone,

I have a report that gives G/L values by dimension ("Advanced Project View"). The report was designed last fall and did work properly. Actually we have two different databases; and it still works perfectly fine for one of them. However, for the 2nd database the g/l function gives zero values for every line.

The NL function is still working (i.e. the right rows are shown). It is just the g/l that only show 0. I did try to update with last September's dates (the last time it did work; my saved copy still shows valuens); but once I refresh all I see is 0 values for the G/L function.

This is the G/L function (German office therefore ";" instead of ","):

=-GL("Saldo";$D38;L$3;L$4;"PROJEKT";"@@"&$C38;$E38;$F38;;;;$G38)
D38 => range of G/L accounts
L3 => Start Date
L4 => Ende Date
Projekt => Out advanced dimension view ( I checked in Navision; the view is automatically updated; and it was last updated today
C38 => Project Code
E38 => Cost Center
F38 => Cost Unit
G38 => Company

I am lost here.

Any help or creative thinking is highly welcome…..

Thanks,

Kathy

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts May 04, 2015 17:35

  Hi Kathy,
  
  If the range of accounts includes totaling accounts then the report will show 0 if there are more than one totaling account in the filters. To check this, look at the account types associated with the filter. If it's a totaling account and there is more than one then it will be ignored.
  
  Also, try using the browser on the two databases to see if you can find any differences. You mention that it was updated so when you browse the data it should have everything current in that table. Try performing a DrillDown on the table from the Jet Browser and look for the same information that the report should be pulling.
  
  I hope this helps. Jet queries the database based on the filters so my guess is that either the data isn't in the table or the filters are incorrect in some way and hopefully exploring the data will help us find the problem. Let us know how this goes and if it helps or not.
  
  Best.
  
  Jason T

• 0
  
  Jet Reports Historic Posts May 05, 2015 05:52

  Hi Jason,
  
  thanks for the answer. The drilldown was a perfect idea.
  
  Apparently somebody has changed the analysis view in our 2nd databse. So It then was a filter that did not work anymore.
  
  Thanks again for the prompt answer,
  
  Kathy