Quickly verify converted data between two ERP systems

By | December 21, 2013

Enterprise applications are quite huge as they are designed to cover whole process of a migration. Though the data migrations are complex and tedious task, but are quite useful if carried out correctly. They help in building the confidence of the users in the system and at the same time, helping users to access historical information quickly in the new existing system.
Sage Certified GUMU Migration solution is one such solution which converts the data from various source legacy enterprise systems to other target enterprise systems. It helps in migrating the data from QuickBooks, Sage Pro, Sage 50 (US, UK and Canada editions) to Sage 300 ERP systems.
Also Read: GUMU – A Sage Certified migration solution by Greytrix
As we all know that an ERP data is quite complex, but one can quickly verify the converted data by following the below processes –
General Ledger :

  • Comparing the no. of active and in-active accounts. 
  • Comparing the Opening Balances of both the systems 
  • Comparing the Trial Balances of both the systems

Accounts Receivable :

  • Comparing the no. of inactive and active customers
  • Comparing the current aging value of the customer 
  • Verify the count and sum of Invoices, Credit Notes, Prepayments, etc.

Accounts Payable :

  • Comparing the no. of inactive and active value of supplier / vendor
  • Comparing the current aging value of the value of supplier / vendor 
  • Verify the count and sum of Invoices, Credit Notes, Prepayments, etc.

Inventory Management :

  • Comparing the no. of inactive and active items 
  • Comparing the no of stock, non-stock items 
  • Comparing the no of service, miscellaneous charge type of items 
  • No of UOMs 
  • Current item-on-hand value of the item. 
  • Note: Item valuation may differ a bit the two systems.  

Sales Order :

  • Count of Open Sales Orders 
  • Total sum of Open Sales Orders

Purchase Order :

  • Count of Open Purchase Orders 
  • Total sum of Open Purchase Orders

Note: Apart from the above one should take out a record from each of the above listed modules and verify if the data is correct or not.
By following the above steps you can determine if your converted data is accurate. Obviously, there is no alternative to in-depth verification and checking of the data as they help in making the converted data more clear.
Related Posts:
1. What do you want to migrate to Sage ERP
2. Data migration from your accounting system to Sage ERP
3. Migration of Purchase Payment from QuickBooks to Sage 300
4. Migration of Banks from QuickBooks to Sage 300 ERP