Finance | Project Operations, Human Resources, ...

Track changes to sales order line quantity

(1) Share

Report

Posted on by suttondart

We have a requirement to track changes to the sales order line quantity. Looking at order events, there is does not appear to be an option available to track these changes. Does anyone have a suggestion or workaround on how we can achieve this level of tracking?

All responses (2)

Answers (0)

Suggested answer

NikolajSorensen 1,703 on at

Like (0)

Report

Track changes to sales order line quantity

I usually advise against setting up database logging on sales order lines.

Depending on the volume of sales order lines, this could have a measurable negative performance impact.

You will need to carefully test and monitor performance impact if you opt for using database logging on this type of table.
Suggested answer

Bill Ngo 370 on at

Like (1)

Report

Track changes to sales order line quantity

Hi Suttondart,

You all right, in the order events D365SCM cannot track changes to the sales order line quantity.

I have a suggestion below so you can achieve this level of tracking specifically for qty change not only one change but multiple changes. You can also track the history quantity of each change.

1. Complete Database log setup: System administration > Setup > Database log > Database log setup

In Database log setup, click New, you will see a message

Click Yes to continue.

Click Next to pass Logging database changes session

in Table and fields session:

- select Show all tables and Show table names options

- in the tree: expand the Trade node > Expand the Sales line table and select fields to trace.

Example: for me I select 4 fields relating to Qty that I need to trace: ItemId, LineNum, modifiedBy, SalesQty

Click Next to finish Table and fields session

in Types of change session: if we trace update only then tick on this column.

Click Next to finish Types of change session

Nothing to do in Finish session, click Finish to complete setup (if there are some massage inform, click yes to continue)

Back to Database log setup form, review and close.

2. Now how to check result in Database log:

I open a sales order (with status allow to change) and change the Qty from 1 by 2.

Open Database log form: go to System administration > Inquiries > Database > Database log

Sort newest to oldest for column Created date and time in order to see lastest row to updated.

Click the tab History: then I can see previous Qty = 1, new Qty = 2, and who has been updated this change.

As same as next time who conitinues to change this Qty, system also trace the updated history.

I hope you can follow up and pratice it well.

Thank you and regards,

Bill