Migration of Purchase Invoices from QuickBooks to Sage 300

By | June 16, 2012

We continue our series how data is migrated from QuickBooks to Sage (Accpac) 300 ERP using our Sage Certified GUMU solution. Our GUMU QuickBooks migration utility converts all Master and Open transactions along with Sales, Purchase and GL historical data from QuickBooks to Sage (Accpac) 300 ERP.

Migration of Item Transactions from QuickBooks to Sage 300 ERP
Migration of Credit Card Transactions from QuickBooks to Sage 300 

Today we will see how QuickBooks Purchase invoices get migrated to Sage (Accpac) 300 through GUMU. Let’s have a quick look at QuickBooks purchase invoice screen. The invoice has been created with few Inventory Type Items available in QuickBooks. Note we need Account Payable, Inventory module and Purchase module while running the migration of Purchase transactions through GUMU.

After data migration from QuickBooks the field values of QuickBooks invoice get converted with the following mapping:

Here is the converted Purchase invoice of QuickBooks into Sage Accpac (refer below screen shot) where the Invoice Transactions have been converted as per mapping.

Once you do the IC Day end processing in Sage Accpac, the above PO Transaction get created into AP module as Invoice with GL Accounts selected in grid other than line Items.
Have a GUMU Day.