Cleaning Emptying Purging a Database

Bagheera

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.

Arhontis

Hi,

IMHO the proper way is to keep a clean company and a test company and synchronize the setup.

Now that you haven't a clean database, deleting records from the posting tables is a mistake.

I have used:
http://www.mibuso.com/dlinfo.asp?FileID=275
in the past and with caution it works fine...

kine

Or you can look into 4.01 and check codeunit 8604. It is new function for cleaning database from transactions (it is used in Setup Checklist in new function Implementation).