D365: Inventory Transactions - User ID who created record

(3) Share

Report

Posted on by BradleyBrown_D365F&O

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 (3)

Answers (2)

BradleyBrown_D365F&O 19 on at

Like (0)

Report

D365: Inventory Transactions - User ID who created record

Thank you Jones and Martin for your suggested answers. This was incredibly helpful, letting me know the exact user id was in fact not on the inventory transaction table. I understand a log would show the user creating records, but adding to such a high volume table is not encouraged. The suggestion to look at the WHSWorkQuarantine was exactly the work around I was looking for. I used my system admin role in combination with the Table Browser extension to view it. I do not have to setup additional logging, and this helps identify the true user who performed the change, which I ultimately want available should it happen again.
Verified answer

Jonas "Jones" Melgaard 3,510 Super User 2025 Season 1 on at

Like (1)

Report

D365: Inventory Transactions - User ID who created record

Hi Brad,

I fully agree with Martin, especially the DB logging on inventory transactions.

On an unrelated note: Warehouse Management / WHS is using something called quarantine transactions (WHSWorkQuarantine) to do the status changes in this job. It's not available from the user interface as far as I recall, but in a pinch you can have a developer or administrator help you to extract the data for analysis. It also contains the user that performed the change.

Here is an example from my sandbox environment, where I have changed the status of all of my A0001 items.
Verified answer

Martin Dráb 233,013 Most Valuable Professional on at

Like (2)

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.