Cleaning Emptying Purging a Database

Hello all,

We have a Navision 3.7 Database ready to go live at a Customer. All tests are successful all functionality is implemented all setup has been done. During the tests both at our company and at the client's site (using real data) have generated documents, posted invoices, ledger entries and so on.

Most functional areas are uses that is Sales / Purchases / Inventory / CRM / Services etc.

We need to delete all data so every customer, every vendor and every item are 0 balance / quantity etc BUT we NEED to keep all CRM and all Service data. We also use dimensions.

Is there any obvious way to do this? Will this require manual purging of some tables? If that is the case which are these tables? (I know the main ones like ledger entry tables but I am sure there are plenty of other tables populated with data - such as BOM tables, LOT and SN tables etc).

Can anyone please indicate what is the proper way to deal with this issue?

Best regards, and thank you all in advance for your valuable support and sharing of opinions.