How to delete all the transactions.

chrispaul

Dear All
Please tell me how can i blank a database , i mean i have a datebase ready with me and now i want to delete all the transactions in it except the set up's . so tell me the best possible way to do it.

ecclectic

there's a utility in the download section that allows you to do that. else go to object designer, and delete the data in the tables. The most important thing is to know the relevant tables as you must make sure that you have deleted data from all linked tables.

E.G: if you want to delete sales transactions u need to del: 17, 45,46,110..115,21, 379, 355, 359,32, 5802, 365, 7154

Phenno

ecclectic wrote:

there's a utility in the download section that allows you to do that. else go to object designer, and delete the data in the tables. The most important thing is to know the relevant tables as you must make sure that you have deleted data from all linked tables.

E.G: if you want to delete sales transactions u need to del: 17, 45,46,110..115,21, 379, 355, 359,32, 5802, 365, 7154

and 339 too, and much more...

It's not so easy to delete all trans. tables and this utility that eccletction mentioned only helps you to do this faster.
It lists tables with number of records where you can mark the tables that you want and that delete the content with single click.

You have to be carefull with deleting...

Mbad

Create a new company, and transfer the setup using the setup check list. Delete the old company afterwards.

kine

I assume that you are using 4.0x version. There are implementation tools where you can find function which will clear the transactional tables for you. Try to look there:

Administration - Application Setup - General - Setup Checklist - Functions - Implementation - Data cleaning tab - Clean.

Of course it will not clear any user defined tables.