Differentiating Normal Sales Orders and Sales Orders created on behalf of a 'Sales Return Order'

(2) Share

Report

Posted on by NI-V3

291

Hi,
We have processed an Item replacement(exchange) for an item sold by us, I have created a sales return order (for the replacement) and also created a sales order abiding the 'Sales Return Order' process. Now, apart from customization, How do I know that sales order is created for a exchange/replacement item? How do I identify and differentiate it from other normal sales orders? Any field present in sales header that helps in differentiating them?

Categories:

Microsoft Dynamics NAV

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (4)

Sort by

Verified answer

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

Like (3)

Report
Copy link

Link copied!

However, when you use the "Create Return-Related Documents" function to generate a replacement Sales Order, the system adds a comment line in the Sales Order referencing the original Sales Invoice. Additionally, you can use the 'External Document No.' field while creating the return order—add a sequence like 'RO001'—so when a Sales Order is created from it, you can easily identify that it originated from a return order. This helps differentiate it from regular sales orders. 🙌

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

One option is to use External Document No. or Your Reference to tag it as exchange/replacement.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 99,968 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Do you have item tracking details, such as lot number? If so, you can find the history.

Otherwise, apart from the number management mentioned by the two experts below, you can only find records by posting date.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 32,497 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

If you have a lot of sales orders for item replacements, another option is to create multiple no. series. So your regular sales orders have the current no. series, but you would add a 2nd number series for item replacement sales orders. This way you could easily find the 2 different sets of orders. You can even use the no. series field on the sales order header as a filter.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No