I’m looking for a way to easily show which user picked and packed a shipment--ideally without enabling Audit History for non-administrator user roles.
We’d like to track both who picked and packed each shipment. Is there a way to expose that information through a GI or report, perhaps by referencing system fields or tables that store user IDs tied to those actions?
If anyone has done this (or knows which tables or fields contain that data), I’d really appreciate any pointers.
Best answer by lauraj46
Hi
The audit trails are stored in the AuditHistory DAC. All of the modified fields are stored together, along with the new values, in AuditHistory.modifiedFields. Depending on the level of detail that you need, you could filter, for example, where the modifiedFields contains PickedTrue and Tablename equals SOShipment. In that example the CombinedKey will be the shipment number and the User should be the user who confirmed the Pick.
Hope this helps!
Laura
+11I assume you are not using picking worksheets?
Does the “LastModified By” in the SOShipLineSplit table do it? That is where the picked and packed qty is stored
I assume you are not using picking worksheets?
Does the “LastModified By” in the SOShipLineSplit table do it? That is where the picked and packed qty is stored
The LastModifiedBy field doesn’t always reflect who packed the order. By the time I need to review a shipment, it’s often already invoiced, and that field no longer gives an accurate picture of who picked or packed it.
I do have Audit History enabled, so I can dig into it when needed. I was more so looking for a more accessible view for our Warehouse Manager to see who handled the shipment without relying on me to pull that info manually.
+8Hi
The audit trails are stored in the AuditHistory DAC. All of the modified fields are stored together, along with the new values, in AuditHistory.modifiedFields. Depending on the level of detail that you need, you could filter, for example, where the modifiedFields contains PickedTrue and Tablename equals SOShipment. In that example the CombinedKey will be the shipment number and the User should be the user who confirmed the Pick.
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
