Skip to Content
Feb 21 at 07:38 PM

Delete SalesOrders and Invoices using SQL

366 Views Last edit Feb 21 at 07:38 PM 2 rev

I'm looking for a method or tool, similar to the Master Data Cleanup Wizard, for obliterating all Sales Orders and all Invoices. I am not interested in creating reversals or credit memos, in fact, I want to wipe those out, too.

I am asking if there's a pre-formulated SQL query that someone already has which can achieve this, without corrupting my installation.

This is a sandbox environment with a new CompanyDB that we are almost ready to put into production, but, I need a repeatable way to wipe out all the data from multiple rounds of testing