GL Report not picking up all the entries

Jet Reports Historic Posts

February 09, 2016 05:14

None

Hi,

I have just encountered an issue where the GL function is not picking up all the entries from NAV. Although when you drill down on the aggregate figure, then it shows you the correct entries (including the one that is missing from the report).

The report is showing GL Balance for Start Date = '01/12/2015' and End Date = '31/12/2015'.

For an example, see attached. If you look at L40 cell of the GL_Report, the amount showing is $288.18. However, when i drilldown on it (see attachment GL_Report_DrillDown) it shows me 2 entries for $288.18 and $14147.93.

i have also attached the source file. Please can this be looked into asap?

Thanks
Jasneet

Date Votes

4 comments

0

Jet Reports Historic Posts February 09, 2016 20:31

Hello Jasneet,

Can you check to see if Entry No. 94649 on G/L Account No. 4000 is a closing entry?
e.g. C31/12/2015
It might be helpful to change your Drilldown setting to Drilldown into the NAV Classic Client directly to see if that may be the case.
This can be done in the Jet Data Source Settings > General tab.

Best regards,
MWilson

Comment actions Permalink
0
Jet Reports Historic Posts February 09, 2016 21:47
Hello MWilson,

Thanks for your reply. In data source setting, all other Radio button options are disabled (see attached). Is it because i am using Jet Express?

Thanks
Jasneet
- Drilldown_Setting.jpg
Comment actions Permalink
0

Jet Reports Historic Posts February 10, 2016 00:11

Hello Jasneet,

My apologies, yes, that is because of Jet Express.
Can you manually navigate to those entries in the NAV RTC and verify if it is a closing entry?

Best regards,
MWilson

Comment actions Permalink
0

Jet Reports Historic Posts February 10, 2016 00:18

Thanks for your help. The issue is now fixed. The client didn't close the income statement initially.

Regards
Jasneet

Comment actions Permalink

Please sign in to leave a comment.