cancel
Showing results for 
Search instead for 
Did you mean: 

Copy data to another Company

Former Member
0 Kudos

Hi,

I'm running one company in SBO. Now created another company and want to import Chart of Accounts, Business Partners, Items and Warehouse master data into the new company from the old company.

How can I do so?

Regards

Sibasish

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sibasish,

There're several suggestions for using Copy Exress or it will fail.

1. create a new DB with the following checkboxes checked

Copy user-defined fields and tables

Copy user-defined objects

2. copy one Data Category at one time.

Data Categories sequence is based on a logical data transfer and DB

modification structure. It's recommended to copy part by part, instead

of all of them. In this case, we can also narrow down which category

goes wrong.

3. use 'Leave existing and add new' instead of 'replace all' as Copy

Method

4. In Authorizations->Data Details->Uncheck all users that're with

Superuser authorization before copy. (this is important)

It's because Superusers have full authorizations by default and it can't

be changed. It's very likely to fail the copy process.

Please try the suggestions and keep me posted with the progress.

In addition, we have Expert Empowerment Session (EES) on this topic. You

can find it at channel partner portal-> Archive: Empowerment

Sessions->17.01.2007 - CopyExpress.

Hope it helps.

Regards,

Jacqueline Jiang

SAP Business One Forums Team

Answers (2)

Answers (2)

former_member187989
Active Contributor
0 Kudos

You can also use DTW to upload data's into new company.

1.Extract details of chart of accounts-OACT table,business partner-OCRD,CRD1,CRD7 tables,item master-OITM table,warehouse master-OWHS tables using these table derive a query using query generator in old company database and export it to excel.

2. Fill the required datas extracted from query into respective DTW templates oChartOfAccounts,oBusinessPartners,

oItems,oWarehouses.

By this way you can upload large volume of masters easily.

Jeyakanthan.

Former Member
0 Kudos

Thanx Jeya

Plz give me the link to download Copy Express.

Former Member
0 Kudos

Hi

You can use 'Copy Express' Addon to copy Master Data and other settings from one company to another.

The Addon is free and can be downloaded from the SAP Portal.

Former Member
0 Kudos

Thanx a lot for the soln.

How can I export those data into excel file?

Former Member
0 Kudos

Hi

You need not export the data to excel. Copy Express Addon copies the settings and Master Data based on the Parameters that you select and copies them to the Target Database.

Any how, if you want to explicitly export the data, write a query in the Query Manager and execute. Now click on the Excel icon in the tool bar, which exports the results to Excel.

Former Member
0 Kudos

Plz give me the link to download Copy Express.

Former Member
0 Kudos

Step1:

Try the following link:

[https://websmp104.sap-ag.de/~sapidb/011000358700007392752004E]

Step2:

SAP Business One Products -> Updates for SAP Business One -> SAP Business One 2005-> SAP Business One 2005B -> B1 ADD-ON - COPY EXPRESS 05SP1