Supply chain | Supply Chain Management, Commerce

Quantity variance between order line and inventory transaction

(4) Share

Report

Posted on by Kent Wei

Hello All,

We’ve recently encountered an issue where the purchase order line quantity is misaligned with the inventory transaction line quantity.

This PO was firmed via MRP with a sales order line marked against it, and the user adjusted the PO line quantity prior to receipt. The PO was subsequently received and invoiced using the adjusted line quantity, while the Deliver remainder field was left unmodified.

Would anyone have insights into the root cause and a recommended resolution for this issue?

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 305,182 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Kent,

Depending on settings, there is an option to allow for over- and under delivery. This can be a case where more items were received and/or invoiced. As there is one inventory transaction, I think it was an over delivery posted together with the product receipt.

The second order line has the same item number. What is the status of that line? Maybe someone overlooked the fact that you have two lines with a total of 50.

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 1,675 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kent Wei,

Could you please confirm that only Line 1 has been invoiced with a quantity of 49 qty and transactions showing 50 qty?

Also, could you confirm that the PO status is still open and advise how many units are showing as remaining to be delivered for Line 1?

What is the status of Line 2?

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
Kent Wei 52 on at

Like (1)

Report
Copy link

Link copied!

Hi Syed Haris Shah,

Thanks for your reply!

The PO has already been received and invoiced with the matching line quantity on all lines, and two of the lines have different Lot IDs. The purchase unit and inventory unit are the same for this order, and I’ve identified no abnormal operational steps taken on it whatsoever.

1 people found this reply helpful.

Was this reply helpful? Yes No
Kent Wei 52 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

As shown in the attached screenshot, the user did not use overdelivery/underdelivery for any of the order lines.

Was this reply helpful? Yes No
Suggested answer

Drew Lencsak 433 on at

Like (1)

Report
Copy link

Link copied!

It's possible the user updated the line by going to the Delivery remainder form and updating only the Inventory quantity field:

If the user updates the Purchase quantity in this form, the Inventory quantity updates in sync. If the user manually just updates the Inventory quantity, the Purchase quantity field is not updated. I have seen this occur several times so ask users never manipulate the Inventory quantity when canceling or updating Delivery remainders.

Was this reply helpful? Yes No
Kent Wei 52 on at

Like (0)

Report
Copy link

Link copied!

Hello Drew Lencsak,

Thanks for your input! I’ve confirmed with the user, and she stated she made no further modifications to the order other than adjusting the line quantities.

Also, when the Deliver remainder function is used, the product receipt quantity and PO line quantity should be different, correct? However, that’s not the case here – the two quantities match exactly in this scenario.

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 1,675 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kent Wei,

Thanks for the clarification.

If the PO quantity does not match the posted inventory transaction quantity, you can fix this by using the “Correct purchase order line manually” feature.

Have you tried using this option to correct the purchase order line? It includes an option to recalculate the inventory quantity.

You can access it via:
Procurement and sourcing > Periodic tasks > Clean up > Correct purchase order line manually

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 1,675 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kent Wei,

I’m checking in to see if the suggestion helped.
If it worked, please verify the answer so it can help others facing the same issue.

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
Syed Haris Shah 1,675 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kent Wei,

If you have any updates, please share them here.

Regards,
Syed Haris Shah

Was this reply helpful? Yes No