We are working on a data migration strategy to migrate current 2 years’ financial transactions to the new system. In between, we need to determine what are the transaction data/tables and master configuration data/tables to extract from today’s legacy system over to the new one. One concern is how to get the extracted tables to map onto 1 or more excel/CSV templates which are those that map and migrates over to the new system.
The engineer suggests we obtain the new system’s current data dictionary, share with the legacy system’s vendor to design the extraction tool to follow the new system’s structure. This will use as a supporting tool to validate the correctness and integrity of the extraction tool.
We looked onto the types of data to migrate over to the new financial system and below are the few identified:
- Aging ARs (Accounts Receivables) and APs (Accounts Payables).
- Opening balances
- Master data (Fixed Assets, Suppliers, Customers, etc). Note: The fixed assets data may not need to migrate over as doing so may results double-entries of assets depreciation to the new system.
Good job, team!