Inventory Management: Orphaned Finished Goods Amounts

Solved

I have three issues related to sales orders that were deleted and LOT Value inventory never reallocated, and I have no idea how to troubleshoot them. I'd like to start with this one. It's probably the least goofed up of the three. Thank you in advance for any assistance.

A sales order we placed a week ago was (for unknown reasons), doubling the weight and total cost of a finished good. The person only discovered the values were wrong after accepting it. He contacted me about it. My thoughts: we try removing the item code from the sales order, accepting it, and then tried entering it in again. We did and the same thing happened. 

We created a second sales order as a test to see see if that same item would double the amount and total cost, but this time, it was correct. We figured it was a sales order hiccup and deleted the original,offending sales order. We completed the new one and all was well.

Now I don't think the amount on the original broken sales order was issued back into inventory for the LOT we were pulling from, because when the next two orders were placed for the item on the same day, from the same LOT number (one drum per order), inventory management said we only had one drum, when we should have had 2 drums. the other was showing as sales order committed in the Cost Detail tab. 

As a fix, someone issued in a single drum as a receipt of goods in order to be able to ship to both customers, and now after all invoicing is complete, we have a phantom drum of the product in item maintenance that appears to be sales order committed with no sales order, and Inventory Valuation says we still have that one drum on hand.

There is no sales order showing for this phantom allocation in the Orders tab, and the Cost Detail Tab shows it's SO Committed, but I don't have a Sales Order to connect it to, and I am pretty sure it's the original drum that was orphaned with that original wonky Sales Order.

How do I correct this?

Parents Reply Children
No Data