News and Announcements icon

Dynamics 365 CommunityForums Supply chain | Supply Chain Management, Commerce Updating the bulk canc...

Supply chain | Supply Chain Management, Commerce

Suggested answer

Updating the bulk cancelled sale order line status to open order

(0) Share

Report

Report

Posted on by Santosh.Andhe

5

Hi Experts,

Due to some error in the batch job 52k sale order lines got cancelled and removed the reservations.
We have to update 52k of the cancelled sale order lines to open order in bulk by updating the deliver remainder.
Could you please help us through this if we have an option to update this in bulk using deliver reminder which would be very helpful.

Thanks,
Santosh.

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Updating the bulk cancelled sale order line status to open order

Hi Santosh,
For bulk changes, you can try lvdtang's suggestion to modify the state using an excel sheet then import it. And there are similar problems, you can view it for reference.
Dynamics Community Forum Thread Details

Dynamics Community Forum Thread Details
Best Regards,
Hana
lvdtang 1,913 on at

Like (0)

Report

Updating the bulk cancelled sale order line status to open order

Hi Santosh,

You might try to do an import and export of the sales order lines with the data entity 'Sales order lines V2'

In Excel you can change the status in the column SALESORDERLINESTATUS from cancelled to 'Backorder'. After changing the status you can try to import the records back in Dynamics.

Regards,

Laurens van der Tang

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans