Auditing the On-Hand List Quantity Adjustment

(1) Share

Report

Posted on by BradleyBrown_D365F&...

Is there any way to see which user processed an adjustment using the On-Hand List Quantity Adjustment function? In my example, I have adjusted out 8 qty of inventory using this function. The button opens a WMS Online Counting page.

The Inventory Transaction table (InventTrans) does not have a user id, nor does the warehouse transaction view (WHSInventTransAndWarehouseTransactionView).

Using this function does not create a record into the InventJournalTrans table like a regular inventory adjustment journal would. Is there another table or view that would have this user ID information?

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Mia Remme 178 on at

Like (0)

Report
Copy link

Link copied!

Hi

You can use "View" counting history from the on hand list form to see the history for a selected item.

The same table with all items - both from counting journal and using quantity adjust feature you will find under Inventory management - Inquires and Report-Counting history. The difference between them is that the items counted using "Quantity adjust" feature will not have recorded an journal number in the table.

Was this reply helpful? Yes No
Suggested answer

Zain Mehmood 4,311 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Adjustments made using the On-Hand List > Quantity Adjustment function don’t go through the standard inventory journal posting, so you won’t find user info in InventJournalTrans.

The InventTrans and WHSInventTransAndWarehouseTransactionView tables also don’t capture the user ID.

You can try checking:
InventTransOrigin: Might give a traceable reference.
WMSOrderTrans or WHSWorkUserSession: If WMS is involved, these could capture user actions.
Database logging: If user tracking is needed long term, consider enabling logging on key fields.

Apparently, there’s no out-of-the-box link to the user for this action, so a customization or process change may be needed if auditability is a requirement.

Warm Regards,

Zain

Was this reply helpful? Yes No