Inventory Item Stuck with Quantity 'In Shipping' When None are There

We have an item that is showing with a quantity of 4 "in shipping" which we can not clear or zero out. There are no open sales orders for that item currently. Also there are no invoices for that item which have not posted. I have checked in the AR module for invoices, in the Sales Order invoice data entry, and sales order shipping data entry. It seems that there is some "phantom" invoice that has this item and can not be posted/closed as if it actually shipped.

Does anyone have any suggestions on how I can clear this out, or try to figure out what is causing the qty 4 to show as being in shipping?

  • 0

    Query SO_InvoiceDetail, looking for orphaned data.

    Also check IM_DataEntryCostCalcCommit, which can hold temp data during the posting process (depending on Valuation)... but sometimes a crash during a journal update can leave something behind.

  • 0

    If there are "phantom" invoice data then try to see which sales order it is related to and see what happened to the sales order.  You might need to extract the data using Excel.  How did you find the data?  

  • 0 in reply to BigLouie

    We can see it when looking at Inventory Module -> Item Inquiry. The quantities down at the bottom shows qty 4 "In Shipping". There are no open sales orders with that item on it, looking on the "orders" tab in item inquiry. Also running the "open sales orders by item" report in sales order module for that item will show no orders. Also I've closed out and posted all batches in AR invoices, Sales Order invoices, and Sales Order shipping data entry.

    I can't figure out where to look next or how to figure out what's causing the qty 4 to be stuck in shipping.

  • 0 in reply to Steve_C

    "In Shipping" means invoice data, not an SO.

    Use Excel to query the two raw data tables I mentioned above.

    You can also try the "Rebuild Sort Files" utility (SO & IM modules) but I am not sure if that will help with this issue.

  • 0 in reply to Steve_C

    In item inquiry the panel you are looking at is based on sort files and as Kevin suggest rebuild them and see what happens.