SAP Business One Data Migration Mapping Worksheet
Data migration is where Business One projects slip. This worksheet gives each object an owner, a mapping note, record counts and a status, so progress is visible and not a feeling.
| B1 object | Legacy source | Mapping note | Data owner | Legacy records | Cleansed and ready | Ready | Status | |
|---|---|---|---|---|---|---|---|---|
76.8% | ||||||||
60.9% | ||||||||
32.6% | ||||||||
0% | ||||||||
100% |
Business One data can be loaded with the Data Transfer Workbench (DTW) or other import tools, depending on your version and partner practice. Always load into a test company first and reconcile counts and values before the production load.
Legacy data profiling
Ask about a read-only profile of your legacy data for duplicates and gaps before migration.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per object and source. Record how many legacy records exist and how many have been cleansed and approved for loading. The ready column calculates the percentage per row and the summary shows overall readiness weighted by record count. Update it weekly in the project meeting and export to Excel for the steering group.
Mapping and loading
For each object, write the mapping rule in plain words: which legacy field becomes which Business One field, which values are translated, which records are dropped. Business One offers the Data Transfer Workbench for bulk loads of objects such as business partners, items and some documents, and partners often use scripted loads for others. Whichever tool you use, run a test load, count records, and compare values before the production load.
- Agree what history is migrated and what is archived
- Load masters before transactions
- Reconcile counts and totals after each load
Reading the percentages
A high average can hide a blocked object. Look at the lowest rows first. Items and BOMs usually lag because engineering must confirm which revisions are active. Opening stock is deliberately last because it depends on the cutover count. The status column tells you whether a row has only been cleansed or actually reconciled.
Common mistakes
Migrating dirty data on the theory that users will fix it later, loading transactions before the master data is stable, and skipping the test load. Another is never agreeing a data owner, so cleansing questions wait in an inbox.
Frequently Asked Questions
Which tool loads data into Business One?
Many projects use the Data Transfer Workbench, the DI API or partner scripts. The right choice depends on the object and volume. Your partner will usually propose one; the mapping worksheet is useful whichever you pick.
How much history should we migrate?
Master data and open items, plus balances. Full transaction history is rarely worth the effort. Keep older history in a read-only archive or the legacy system for audit and reference.
What does reconciled mean?
Counts and values in Business One agree to the legacy source or to an agreed control total, and a named person has signed it off. Loaded without reconciliation is not done.
How do I handle duplicates?
Resolve them in the legacy extract before loading. Decide a survivor record using tax ID, address and activity, and map retired codes so that history references still make sense.
Netray can help profile legacy databases for duplicates and gaps before you load. We work read-only and can run on-premises.
Related Tools
SAP Business One Go-Live Readiness Checklist
A five-group checklist to confirm an SAP Business One implementation is ready for cutover, with the critical blockers marked.
SAPSAP B1 Business Partner Master Data Request Form
A fill-in request form for creating or changing a customer or vendor in SAP Business One, with the fields finance needs and an approval block.
SAPSAP Business One BOM Cost Rollup Worksheet
An editable component cost worksheet with scrap allowance that rolls up material cost per finished unit, for checking a Business One BOM before loading it.
SAPSAP Business One User-Defined Fields and Tables Register
An editable register of every user-defined field and table in a Business One company, with owner, purpose and change status.
More SAP tools
See all- SAP B1 User Permission Matrix Worksheet
- SAP B1 Period End Close Checklist
- SAP B1 Approval Procedure Template
- SAP Business One User Acceptance Test Script Template
- SAP Business One Document Object Type Codes
- SAP Business One User-Defined Field Planning Worksheet
- SAP Business One Private AI Layer Blueprint Generator
- SAP Business One AI Assistant Sizing and Value Calculator
- SAP B1 Item, Warehouse and Batch Columns Reference (OITM, OITW, OITL, OBTN)
New to SAP Business One? Start with the SAP Business One guide and toolkit.
Keep exploring
Free tools
- SAP Data Migration Object WorksheetAn editable register of S/4HANA migration objects with record counts, cleansing progress, load method and mock load effort.
- SAP Business One SQL Server to HANA Migration ChecklistPre-assessment, SQL rewrite, migration, validation and cut over checks for moving SAP Business One company databases from SQL Server to SAP HANA.
- SAP Business One Database Tables ReferenceSearchable lookup of the core SAP Business One tables, with the matching row table and what each one stores.
ERP fixes and how-tos
- Private AI for SAP Business One: Service Layer, a read replica and a local modelAdd a private AI assistant to SAP Business One: Service Layer reads, SQL Server or HANA replica, document index, local LLM, permissions and approvals.
- SAP Business One production planning: MRP, production orders, cost and variancesSAP Business One production planning end to end: MRP, planned to released orders, cost rollup, variance reporting and when you need a manufacturing add-on.
- Production standard cost in SAP Business One: how it works and where it stopsHow standard cost works for production orders in SAP Business One: valuation method, issue and receipt values, variances at close and process limits.
Runs with your ERP
- Spreadsheet Server with SAP Business One: live Excel reporting on inventory, sales and costHow insightsoftware Spreadsheet Server gives Excel live drill-down on SAP Business One inventory, sales and production cost data, with setup and pitfalls.
- TrueCommerce EDI with SAP Business OneHow the TrueCommerce EDI add-on automates sales orders, 940/945 warehouse documents, ASNs and invoices in SAP Business One, with setup, pitfalls and AI.
- SPS Commerce EDI with SAP Business OneHow SPS Commerce Fulfillment connects SAP Business One to retail trading partners: EDI orders, ASNs, invoices, setup, pitfalls and a private AI layer.
Guides
- AI-Assisted ERP Data Migration Best PracticesMaster ERP data migration with AI. Automated data cleansing, validation, and mapping for Infor SyteLine, LN, M3, and Salesforce migrations.
- ERP Data Mapping Best PracticesMaster ERP data mapping with source-to-target techniques, transformation rules, and field-level documentation. Prevent data loss during ERP migration.
- ERP Data Cleansing Before MigrationClean your data before ERP migration with proven cleansing techniques. Address duplicates, incomplete records, and format inconsistencies systematically.
AI on your ERP
- AI-assisted data migration for ERP implementationsAI speeds ERP data migration by profiling legacy data, proposing field mappings, and flagging cleansing issues before cutover, with a human validating every rule.
- AI for SAP Business One, Without Sending Your Books to a Public APIAdd AI to SAP Business One without sending customer data or financials to a public API. Service Layer and DI API integration, sized for an SMB budget.
Integrations
- How to add AI agents to SAP Business OneHow to put AI agents on SAP Business One: Service Layer tool design, read-only first, draft documents for human approval, and an on-prem model option.
- How to use ChatGPT with SAP Business OneUsing ChatGPT with SAP Business One: exports versus live Service Layer access, custom GPT actions, enterprise data controls, and when a private model fits better.
Software
- SAP Business OneSAP Business One explained for small manufacturers: modules, Service Layer and DI API, deployment, limits, alternatives and where AI helps on top of it.
- SAP Business ByDesignSAP Business ByDesign explained: cloud ERP modules for midsize firms, extensibility, integration options, limits, alternatives and where AI fits.