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

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Martin Dráb 237,803 Most Valuable Professional on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Verified answer

Jonas "Jones" Melgaard 4,926 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
BradleyBrown_D365F&O 23 on at

Like (0)

Report

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.

Was this reply helpful? Yes No