How to migrate open transactions into Odoo safely

Open sales, purchases, invoices, stock moves, and manufacturing orders carry relationships and accounting consequences that closed history does not.

Migrating open work is harder than importing master data because the records must remain operational after cutover. A sales order may be partly delivered and partly invoiced. A purchase order may include receipts, returns, vendor bills, and landed costs. Recreating only the visible document can produce the wrong stock or accounting position. Define what open means Do not use one definition for every process. An open quotation, an undelivered sales order, an unpaid invoice, and a partially consumed manufacturing order each need different rules. Agree a cut-off status and migration method for every document family. Preserve relationships, not screen copies The target system needs enough linked records to continue the transaction correctly. That may include order lines, deliveries, invoice lines, payments, lots, analytic accounts, taxes, and currency rates. Importing a flat summary can make the screen look right while breaking later actions. Choose recreation or controlled opening entries Some documents should be recreated in their operational state. Others are better represented by opening balances or reference-only history. The choice depends on what users must do after go-live, not on how easy the import script is to write. Rehearse the cut-off Run at least one timed rehearsal with a copy of realistic data. Measure extraction, transformation, import, reconciliation, and exception handling. The final cutover plan should include who stops transactions, who validates each area, and what happens if a critical check fails. Practical checklist Define open status separately for sales, purchase, stock, finance, and manufacturing. List every relationship required to continue each document. Decide which history is operational and which is reference-only. Rehearse the final extraction and import with realistic volumes. Document cut-off ownership, reconciliation, and rollback criteria. Final decision The goal is not to reproduce every old technical state. It is to establish a correct opening position from which users can continue work without duplicated deliveries, missing liabilities, or unexplained balances.