Analytics on Killed Orders

Sort:
You are not authorized to post a reply.
Author
Messages
bcarmichael1
New Member
Posts: 1
New Member
    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
      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
        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
        You are not authorized to post a reply.