Skip to Content
avatar image
Former Member

clear transactions in Business One

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 19, 2017 at 06:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 19, 2017 at 06:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 04, 2017 at 08:46 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded