Hi,
I'm making a Report for the NAV(5.1) basic Report "G/L Total-Balance" with the help of JetReports.
I want to find the Starting date of a certain Accounting Period, based on the Date the User enters,
but because the entered date does not have to be a date that is a really existing Startingdate in The "Accounting Period" - Table,
I need to filter for a Date that is below the date, which is entered by the user.
My attempts don't seem to work, cause i got no result at all.
That is what I have done:
=NL("Rows";"Accounting Period";"Starting Date";"New Fiscal Year";"-1";"Starting Date";NP("Date Filter";;Options!$D$6))
Does anyone have ideas and can help me.
Thank you in advance.
Solved the problem. The Formula was more or less correct (if i replace "rows" with "last" it does exactly what it should do).
Just my C/Front worked wrong after Navision 2009 - Upgrade
Date
Votes
1 comment
-
Jet Reports Historic Posts So what is the answer on finding the Starting Accounting Period Date based on the actual Posting Date using NAV 2009? Does anyone have the formula to do such?
Please sign in to leave a comment.