Hi,
We are using Microsoft Navision 2015.
I am looking for a report that will display a list of the purchases to be received the next day.
Purchase order on the system is on the status: Open (they can only be released when the goods arrive, the next morning).
Report needed:
List of all item purchases to be received the next day, with details of the item code, description, quantity to be received and price per item.
Many thanks for your help !
*This post is locked for comments
Hi,
You need to create a new report with all the fields that you wish to display and using your base table.
In on pre report you can add a filter
Create a new variable in globals with datatype 'Date' say Nextday
In OnAfterGetRecord trigger you can add following
I have considered Datefield as the field from the table which has the date of receiving of purchases
Nextday := CALCDATE ('CD+1',TODAY);
Record.setfilter (Datefield, Nextday);
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
