Small and medium business | Business Central, N...

Sales Return Order reversing quantities on open Sales Order

(1) Share

Report

Posted on by CU11061339-0

Hi All,

When we create a Sales Return Order from a posted invoice (linked to an open Sales Order with backorders), posting the return resets the original Sales Order’s Qty. Shipped and Qty. Invoiced to 0.

This makes the order look open again and causes users to re-ship.

Scenario

A Sales Order is created with partial shipment (backorder remains open).
A Posted Sales Invoice is created from that Sales Order.
Later, we create a Sales Return Order using Get Posted Document Lines to Reverse (based on the posted invoice).
We post the Return Shipment and Credit Memo

And the issue is

On the original Sales Order (which is still open):
- Qty. Shipped = 0
- Qty. Invoiced = 0
- The order now appears as if nothing has been shipped.

Is this expected behavior?
How do you prevent duplicate shipments in this scenario?
Any response or best practices would be greatly appreciated.

Thanks in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Grigorios Mavrogeorgis 2,320 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, this one I have not seen in standard.

A separate Sales Return Order, posted as return receipt and credit memo, should not touch the Qty. Shipped / Qty. Invoiced on the original Sales Order line - those get set when you post the shipment/invoice of that same order, and a return is its own document with its own item entries. So reset to 0 on the live order sound wrong to me.

First thing I would check is if there is customisation or an event subscriber on the return posting that write back to the sales line, because base BC does not do that as far as I know. Also confirm it really is a separate return order and not the same order reused.
If you only want to undo a wrong shipment, the proper native way is Undo Shipment on the posted shipment, not a return order.

Which version you are on, cloud or on-prem?

Hope this helps

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards

Gregory Mavrogeorgis

Work: GMSOFT Limited
Blog: Inside Business Central
LinkedIn: www.linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,625 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

https://learn.microsoft.com/en-ca/dynamics365/business-central/sales-how-process-sales-returns-orders#create-a-sales-return-order-based-on-one-or-more-posted-sales-documents

Is there any customization or extension in your environment that may be affecting the Sales Return Order posting process?

In standard Business Central, creating a Sales Return Order using Get Posted Document Lines to Reverse should reverse the posted document/item entry, but it should not normally reset Qty. Shipped and Qty. Invoiced to 0 on the original open Sales Order.

Please try to reproduce the same scenario in a clean sandbox without custom extensions. If it works correctly there, then the issue is most likely caused by customization or an event subscriber.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Sales Return Order reversing quantities on open Sales Order

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Sales Return Order reversing quantities on open Sales Order

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates