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?
GL Report not picking up all the entries