Data migration to the new ERP system

Have you ever been through the process of data migration and cleansing?

If so, you know perfectly well that this process is not so easy, fast and pleasant.Most often, companies simplify this process by migrating only open entries (the so-called Opening Balance), which may consist of:1) Open purchase orders (BO)2) Open purchase invoices (BO)3) Open sales orders (BO)4) Open sales invoices (BO)5) Open release orders (BO)6) Open assignment orders (BO)7) Orders in progress (BO)8) Warehouse indexes with stock level> 0 (BO)

Of course, there is the question of historical records such as:1) The history of purchases and sales of a given commodity2) Sales history for a given customer3) Purchase history with a given supplierThis can be done in three ways:1) Use the old system – unfortunately it is very tedious and takes an additional time slowing down users’ work2) Transfer historical records to the new system – unfortunately this is an expensive solution and not always feasible, due to differences in the architecture of the new and old system3) Use Business Intelligence tools – thanks to this, you can compare data between records in the old and new system. This is currently the most recommended method.