On Order quantity Duplicate from Cancelled Purchase Orders

(0) Share

Report

Posted on by Community Member

We have a few Purchase Orders that have been cancelled and for some reason if I look at the on-hand stock & transactions the PO is showing twice so the original quantity appears twice as much On-Order.

In my example attached:

PO-000131 for 1,000

this order was cancelled

On hand stock shows On order 2,000

Transactions show PO-000131 for 1,000 twice

Any idea why? can anyone help?

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi carsz,

It could be caused by a bug or customization. Usually when you cancel a line or part of the quantity, the inventory transactions should be adjusted accordingly.

Can you check the status on the order lines? What is the remaining quantity now? Possibly you can try to "re-open" the order and then first cancel the lines (set delivery remainder to 0).

Was this reply helpful? Yes No
Bashir Ahmad 5,248 on at

Like (0)

Report

Is there any Customization You have on Screen.?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We do have customization on different areas, not specific to purchase order though.

At least one of the purchase orders has no lines (they were removed before it was cancelled)

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Probably the lines were removed in an incorrect way, leaving orphaned records. If the PO lines don't exist anymore, you can try to delete the related information from e.g. the tables InventTransOriging and InventTrans. Caution: there might be more tables involved. Do this from the AX table browser and test it in a separate environment first.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The lines are still showing on the PurchLine Table (even when they have been removed from the PO) and they all show as Line Status: Cancelled

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Check if there are cancelled PO lines where the quantity in the inventory transactions are updated correctly. Then check how it should look. Possibly you still have to do some manual updates/deletes on the inventory transaction tables.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

André, how is the best way to delete that information from the InventTrans table?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

This cannot be answered on a forum. Try to get a very experienced consultant on-site if you need assistance. This person should be able to do troubleshooting, having knowledge of the data model and experienced with this kind of corrections. It is too dangerous to just suggest the steps what to do.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok thanks anyways

Was this reply helpful? Yes No
mehmetyunus27 57 on at

Like (0)

Report

Hello Microsoft Family,

I have encountered the same error. My case is about the change management. After all workflow steps are completed, i press "Request Change" button and purchase order header's document state is turning into "Draft" status. After i cancel this purchase order, purchase order line status turns into "Cancelled" status but the records on inventory transaction table at the receipt status "On order" still exist.[quote user="carsz"]

We have a few Purchase Orders that have been cancelled and for some reason if I look at the on-hand stock & transactions the PO is showing twice so the original quantity appears twice as much On-Order.

In my example attached:

PO-000131 for 1,000

this order was cancelled

On hand stock shows On order 2,000

Transactions show PO-000131 for 1,000 twice

Any idea why? can anyone help?

[/quote]

Was this reply helpful? Yes No