clear transactions in Business One

[peter_le_grand]

Is there a way to delete all transactions in a SAP Business One database and just have the master data left?

[JerushaLala]

Hi Peter

You will probably have to create a new database with the applicable configurations.

You can then use the Copy Data Between Companies function under Administration -> Implementation Center -> Implementation Tasks, and under the Data Management Tab.

Hope that will help.

Regards,
Jerusha

[peter_le_grand]

I have tried the function "Copy Data Between Companies" and selected all data to be sent to a file. (Checked all checkboxes). When I want to use this file in a new company, it shows that it didn't copy the COA. What can I do about this? See attachment.

[Johan_H]

Hi Peter,

There is no way to clean a company database up that way. However, you can use queries to export all master data, and the DTW to import it all into a new company database.

To my knowledge there are also one or two tools around to automate this process.

Regards,

Johan