D365: Inventory Transactions - User ID who created record

Like (0) Share

Report

Posted on 14 Mar 2025 19:51:07 by CU14031925-1

Hello,

We recently had a user execute the "warehouse Management inventory status change" functionality using the wrong filters, changing a large number of inventory pallets to an undesired inventory status. There is a "created by" and two "modified by" fields on the table, but none are the actual user that resulted in the new record being created. Data Source: InventTrans, InventTransOrigin

Example of inventory transactions:

The "created by" field is related to the inventory dimension, and "Modified by" fields are related to the inventory dimension and inventory module parameter. They are not related to the inventory transaction, and thus are not dependable for audit reasons.

How can I audit which user caused these inventory transaction records to be completed?

Thank You,

Brad

Categories:

Dynamics 365 Supply Chain Management

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 231,760 Most Valuable Professional on 15 Mar 2025 at 15:37:20

Like (0)

Report

D365: Inventory Transactions - User ID who created record

Most likely, you'd have to set up logging before the change happened.

InventTrans table doesn't have either CreatedBy or ModifiedBy enabled by default; you'd have to create an extension to start populating the values. You could also configure DB logging, but it would also have to be done beforehand and actually doing that on inventory transaction would be a bad of idea because of performance implications.