How to find out, if a purchase line has been added to an existing purchase order?

(1) Share

Report

Posted on by Maddin

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 have the same question (0)

All responses (8)

Answers (5)

Verified answer

NAV_with_Narang 2,294 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Maddin 30 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,294 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Greg Enns 1,106 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (3)

Report

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:

Was this reply helpful? Yes No
Maddin 30 on at

Like (1)

Report

Thank you all very much your great help :)

Was this reply helpful? Yes No