Last time we talked about Implementation Center, which allowed you to streamline and simplify the implementation process in SAP Business One. This article is sequel to Implementation Center in SAP Business One.

When we choose Administration > System Initialization > Implementation Center > Implementation Tasks, we can also manage data, such as copying data and importing data.

Data-Management-in-SAP-Business-One-1

Copying Data

When you choose Copy Data Between Companies, a window called Quick Copy will pop out. Copying in this way doesn’t need preparations or pre-formatting and will notify about the data dependencies before starting copying. The operation is similar as Copy to/Copy from.

Data-Management-in-SAP-Business-One-2

There are some notices of Quick Copy:

  • This function copy not only the setup and customization data, but also master data records from the test system to production system. But Quick Copy cannot copy transactional data.
  • This function applies changes made in one company to one or more companies and are able to copy the updates in partner’s solution.

Importing Data

There are several situations and correspond tools to importing data, but at first, we need an excel file which contains the data in a formatted structure, then we can try to import data.

One situation is when it is the first time to implement, which usually need you to import all the data from a 3rd party system(s) into SAP Business One. This kind of data set usually involves large amount of data, Data Transfer Workbench(DTW) may be a good choice.

Data-Management-in-SAP-Business-One-3

Another situation is ongoing updates, which recommend using the Import from Excel tool. For updating transactional records, recommend using the DTW.

Data-Management-in-SAP-Business-One-4

by MTC Systems on Nov 1, 2015 1:32:00 PM

Leave a comment

Related posts

No Restriction When Setting Revenue Accounts in SAP

SAP Business One is designed to fit all types of businesses. For example, usually we set the revenue accounts of a business as...

MTC Systems
By MTC Systems - November 14, 2017
Tips When Reading Forms in SAP Business One

It can be inconvenient when you company receives a document with a long list of items. Finding a specific item can also be...

MTC Systems
By MTC Systems - November 10, 2017
Tracking the Inventory Counting in SAP Business One

Inventory is an important direction of most of the manufactural companies. Inventory counting and tracking can be helpful in...

MTC Systems
By MTC Systems - February 2, 2017