Supply chain | Supply Chain Management, Commerce

Updating the bulk cancelled sale order line status to open order

(0) Share

Report

Posted on by Santosh.Andhe

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.

I have the same question (0)

All responses (2)

Answers (0)

Laurens vd Tang 3,983 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No