How to manually remove allocated stock from completed order

[mjw45]

Hi,

Using Sage 17.0.15.208
A sales order was created for a customer, delivery note printed and order completed and so sent to invoice.
In the meantime, a colleague created a separate invoice for the same order and printed and posted.
The original sales order invoice was then re-used for a completely different supply-only customer and so printed and posted and the sales order deleted.
The problem being that the stock allocated from the sales order being completed has stayed as allocated. Is there any way I can get these items back into stock?

Thanks.

[brucedenney]

The problem being that the stock allocated from the sales order being completed has stayed as allocated

The stock should not be allocated, it should have been taken out when the invoice was created, and when the other invoice was updated.

The "allocation" of stock should be fine, the problem should be that the stock has been taken out twice and the actual stock levels are wrong.

Can you confirm this is the situation and that I have not misunderstood.

[mjw45]

What you suggested is what I rather expected to happen however because the invoice created from the sales order was used for entirely different products, (the original product lines were just removed) the stock allocated by the sales order has not been removed from stock, it has just stayed allocated.

[brucedenney]

Hmmnn seems strange.

Backup, Run error checking and then run fix, even if there are only warnings and comments.