• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Analytics on Killed Orders

 2 Replies
 2 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
bcarmichael1
New Member
Posts: 1
New Member
12/29/2015 4:25 PM
We use Mobile Supply Chain Management for our warehouses. If a picker is told to pick an item or unable to completely fill the requested item, we have a stockout board the picker is supposed to write the item number on. If I wanted to compare who killed items while picking with when the item was last adjusted, what would be the best method. I have a pretty good knowledge of queries through addins but no knowledge on LBI. Can this be figured out through queries, if so what forms should I query?
Stephanie
Veteran Member
Posts: 86
Veteran Member
12/29/2015 4:42 PM
I would think you would want a report that relates at least WHSHIPLINE, REQLINE and ITEMLOC. Also adding in ITEM MAST, RQLOC would give you more detail.

Hope this helps!
Stephanie Kowal | skowal@rpic.com
David Williams
Veteran Member
Posts: 1127
Veteran Member
12/30/2015 12:26 PM
For Analytics on killed quantities, you can query the shiplines for what was killed during picking but you may also want to look at ictrans to compare the Original-Qty to Quantity to find what was killed when the requisition was processed (when using Fill or Kill set to Kill).
David Williams