Share
ReportHello,
how can I find out if an purchase line in an order has been added later, although the purchase order has already been created for a week?
Do you have any ideas?
Thank you.
You’re offline. This is a read only version of the page.
30
Hello,
how can I find out if an purchase line in an order has been added later, although the purchase order has already been created for a week?
Do you have any ideas?
Thank you.
I would also suggest looking in the option ZHU mentioned - activate change log on Table 39 (Purchase Line) and You can activate only the Insert and check 1 field Line No., so You don't generate too much entries.
Then You can view the Change Log Entries, filter by table 39, and sort /filter by document No. - You will see which User and when created each line.
It would give You info in the form of this:
Unfortunately NAV does not have timestamps on records. Have to upgrade to BC for that or else create your timestamps yourself with custom fields. We've been using NAV for 12 years and so we have LOTS of "Created At" and "Created By" custom fields throughout the system--with custom code to populate them.
The key question here is when you say "lines added later", how do you define "later". Some users will create PO lines quickly, others more slowly. Sometimes a user might get interrupted and come back hours later (if not the next day) to finish creating the PO lines.
Once you have that defined, then a custom field (or maybe 2) and a little custom code "OnInsertPurchaseLine" should be fairly easy to write for any NAV Developer.
Hi, If you don't want to customize, you can set the Change log, but this is not the same as the original usage, so it may be a bit troublesome to find it from the Change Log Entries.
More details:
https://learn.microsoft.com/en-us/dynamics-nav-app/across-log-changes
https://archerpoint.com/change-logs-and-microsoft-dynamics-nav-2016/
Hope this helps.
Thanks.
ZHU
you could consider to use workflow to approve PO if strict control is required. After user changes the line, the change in PO would be detected by system and needs to be approved
It is difficult for the system to decide which lines were created when the header was created and which lines were created after a couple of days, without the help of any timestamp mark. For humans it is quite easy to point that difference, not for a 2-Dimensional software.
You can check in SQL if there are any timestamps columns, and filter on that to determine when the record was created
To the best of my knowledge an additional field may be necessary for you
So there is no way to get this information without doing an adjustment by a new field?! From SQL I cannot get this out either? I cannot do anything with the timestamp there, since I cannot resolve it. I also do not necessarily need a date, I would just need to know which rows were created subsequently.
In the newer version of NAV (i.e. Business Central) this is quite attainable by using OOTB features but in NAV2017, to the best of my knowledge it may not be available OOTB
You will have to ask a developer/your partner (CSP) to add customized fields on the PO Lines: Last Modified at (DateTime). The logic will be written such that whenever a new line is created or an older one is modified, this datetime stamp gets updated. You may chose to name the field as required
#1
André Arnaud de Cal...
291,684
Super User 2024 Season 2
#2
Martin Dráb
230,414
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
