Migration guide
Moving from SAP Business One to Odoo
Why move
Why companies leave SAP Business One
Broader suite
eCommerce, website, helpdesk and HR on the same database.
Flexible hosting
Odoo Online, Odoo.sh or your own servers.
Open development
A large pool of Odoo developers.
Mapping
How SAP Business One maps onto Odoo
| SAP Business One | Odoo | Note |
|---|---|---|
| Business partners | Contacts (customers and vendors) | |
| Items and item groups | Products and product categories | |
| Warehouses and bin locations | Warehouses and locations | |
| Bills of materials | Bills of materials | |
| Price lists | Pricelists | |
| Batches and serial numbers | Lots and serial numbers | |
| Profit centres / dimensions | Analytic plans |
What migrates
- GL accounts and opening balances
- Business partners with contacts and terms
- Items, BOMs, price lists, stock by warehouse with batches and serials
- Open sales orders, purchase orders, invoices and bills
What usually stays behind
- Closed transaction history (kept read-only in the old system or as an archive export)
- Bank rules, report layouts and automations (rebuilt in Odoo)
- Audit logs from the old system
Process
Migration steps
- 01
Scope and cut-over date
Agree what moves from SAP Business One, how much history, and a go-live date at a month, quarter or year boundary.
- 02
Extract
Extract through B1's export tools, SQL queries on the company database or the Service Layer API.
- 03
Clean and map
Remove duplicates and inactive records, then map accounts, taxes, products and partners onto the Odoo configuration.
- 04
Trial loads
Load into a test Odoo database at least twice and reconcile trial balance, receivables, payables and stock each time.
- 05
Cut-over
Freeze SAP Business One, load final balances and open items, reconcile, and go live. Keep SAP Business One read-only for reference.
Watch out for
Common pitfalls
Costing method
Align B1 item valuation with Odoo's costing method.
User-defined fields
Decide which UDFs are still needed in Odoo.
ERP Builders is an independent Odoo services company and is not affiliated with or endorsed by Odoo S.A. “Odoo” is a trademark of Odoo S.A.
FAQ
Frequently asked questions
Can we migrate production orders in progress?
Usually it is simpler to finish open production in B1 or recreate it in Odoo at cut-over.
Next step
Moving off SAP Business One?
We will review your data and give you a migration plan with a fixed scope.