Back to Tutorials
DTW & Migration•11 min read
TUTORIAL • FREE MEMBER

Zero-Error Data Transfer Workbench (DTW): Migrating Business Partners & Open Balances

Avoid the notorious "Internal Error (-5002)" and currency mapping failures during go-live cutovers. Includes our proven import sequence, CSV column rules, and post-import SQL audit.

SB1

SAP B1 Academy Editorial

Published • 11 min read

Save
Data migration staging & CSV validation checklist.
Data migration staging & CSV validation checklist. (Image source: SAP B1 Academy Lab)

A clean go-live in SAP Business One depends heavily on how cleanly legacy data is imported through the Data Transfer Workbench (DTW). Even experienced consultants lose hours troubleshooting cryptic DI API error codes when parent-child CSV templates are misaligned.

Mandatory Import Sequence

Never import open A/R or A/P invoices before locking down your master data dependencies in this exact order:

  1. Chart of Accounts & G/L Account Determination
  2. Payment Terms, Price Lists & Warehouse Codes
  3. Business Partner master data (OCRD + CRD1 addresses + OCPR contacts)
  4. Item master data (OITM) and opening stock via Inventory Opening Balance
  5. Open A/R and A/P documents, then G/L opening balances

Preparing the CSV Templates

Every DTW template ships with two header rows: the first is the DI API field name (CardCode, CardName), the second is the database column name. DTW reads the first row only, so never delete or rename it.

  • Keep RecordKey (header) and ParentKey (lines) aligned. Every address row in BPAddresses.csv must reference an existing RecordKey in BusinessPartners.csv.
  • Save as Unicode Text (tab-delimited) when names contain accented characters; plain CSV exports from Excel silently corrupt them.
  • Use the code values, not descriptions, for enumerations — cCustomer / cSupplier for CardType, bo_ShipTo / bo_BillTo for AddressType.
Free Member Content

Create a free account to unlock the full step-by-step guide & copy the production SQL script.

Join SAP Business One consultants and key users worldwide. Free forever, no credit card required.

or use a magic link