Skip to Content
0

clear transactions in Business One

Apr 19, 2017 at 03:30 AM

103

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jerusha Lala Apr 19, 2017 at 06:41 AM
2

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

Share
10 |10000 characters needed characters left characters exceeded
Johan Hakkesteegt Apr 19, 2017 at 06:17 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 04, 2017 at 08:46 AM
0

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.


copycompany.png (54.5 kB)
copyto.png (55.1 kB)
Share
10 |10000 characters needed characters left characters exceeded