Posted 4/24/2010 6:31:31 AM
|
|
|
|
We have an item that physically has zero in stock. We have shipped 6,873 pieces. We had an opening balance of 4,590 pieces and a GRN of 2,000 pieces.
Long story short. We have put into stock 6,875 pics and shipped out 6,873. All of these were put on sales orders, then rolled to invoices. The problem is that ISE shows 6,821 pieces committed still. If you go into the Inventory Module and call up the item, then click on the committed amount the "stock detail" box pops up and shows zero committed, but the Warehouse Stock Total box shows 2 on hand, 6,821 committed, free stock -6,819.
So, first, any ideas how it might have gotten out of balance? That's almost everything we have shipped on this item since the first of the year when we started ISE still showing committed. I have looked everywhere I can think of to see where it might be committed but there are no outstanding sales orders, no duplicated ones. Another odd piece to this is that there are 6,821 committed and we have shipped 6,873. That makes it off by 54 pieces. I have no transaction for 54 pieces.
Any ideas on how to fix it and get everything back in balance?
Thanks,
Donna
|
|
|
|