You will select a excel file with column sales order numbers,
Pick the sales order from the column and delete the sales order,
How do we create a batch job to delete sales order.
this is howl we can create a job to delete sales order
1st step:- upload the excel
2nd:- read the excel.
3rd:- read the excel lines salesid
4th:- find all tables used in salesorder
5th:- delete the data from those tables on the basis of relation
Hello M_R,
Please let us know if you have an answer to your question now.
Hi M_R, As Andre mentioned, it can be done using power automate. However, in case you or your client is not using power platform then you can create custom staging table to import sales orders numbers and create a custom batch job to delete sales orders matching sales order number in that staging table. After deletion, either delete records in staging table or if you need tracking for future references then create a checkbox isDeleted in staging and mark it on records that are deleted and in batch job add parameter to pick only those records where isDeleted is No.
Hi M_R,
In the past, for a similar requirement, I used Power Automate where the flow did read the Excel file and deleted the sales order and sales order lines. When you will use the same approach, you don't need to develop anything new.
Hello M_R,
If I get you right, you want to delete sales order by uploading an Excel file which will contain the sales order numbers.
Hi,
What is the issue here? what is your question here?
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156