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.
Hi,
What is the issue here? what is your question here?
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 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.
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.
Please let us know if you have an answer to your question now.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader
