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?

Parents
  • 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.

Reply
  • 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.

Children