Here is an example. This problem only happens with items that have gone to negative due to being out of stock/backorders, then inventory is updated via Purchase Order received.
It doesn't happen with other items
Items are low stock or out of stock, so Stock Central shows balance as negative and these negative amounts are correct, because they are actually out of stock/backordered
So I place order with Suppliers, when stock arrives I update the status of the PO to Received
After PO is received the balances are all showing as correct: it has correctly added the 100 of each items to the negative backorder balances, and the net total is correct until a customer places an order. I will replicate the problem here by placing an order.
Inventory is correct for backordered items (only items that are actually backordered/out of stock showing here before customer places an order
Then customer places order for these items: (this is a test order I entered myself just now to try to replicate the problem)
Items that have been marked received on the purchase order are now back on the Backorder list as negative amounts. The amounts are out by exactly 100 from the purchase order amounts:
I edit them manually typing into Stock Central to correct it, then press Save
Save it and it is correct
When I refresh the page the Items that have been marked received on the purchase order are now back into negative amounts:
I am having to update these items manually every day to stop them showing as backordered, because this stops customers from buying it because they think the stock is 4 weeks away.
Let me know what you think is happening?