I need the code to exclude closing entries for a report. I searched 7.1 manual and found a reference on page 75 to use "<>C&" in front of my date filter but it still includes these entries.
<>C&01/01/2008..31/12/2008
I assume that I should only use G/L entry table with NL function instead of GL with Balance, since GL requires starting and ending date in different cells…correct? :oops:
Thanks again!
Date
Votes
2 comments
-
Jet Reports Historic Posts Just to add that I have used GL field Exclude Close (True) and still get closing entries. I have to mention that these entries were posted manually with the C in front of the posting date.
-
Jet Reports Historic Posts Consider this is solved :oops:
Since the user has been closing the company manualy in quarters then this means there was no need to close the accounting periods in Navision. I have seen that the date filter Jet uses for <>C and exclude closing (in GL formulas) checks the accounting periods to filter those closing dates. So what I did was to change the starting periods to quarters in Navision and the filter now checks for those dates. :D
Please sign in to leave a comment.