Migrate Sales Invoices from QuickBooks to Sage 300 ERP

By | October 21, 2014

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 300 ERP.
New Stuff: Migrate Purchase Payment from Sage 50 US to Sage 300
Today we will see how QuickBooks Sales invoice gets migrated to Sage 300 through GUMU. Let’s have a quick look at QuickBooks Sales invoice screen. The invoice has been created with few Inventory Type Items available in QuickBooks.
Note: We need Account Receivable, Inventory module and Order Entry module while running the migration of Sales transactions through GUMU.
After data migration from QuickBooks the field values of QuickBooks invoice gets converted with the following mapping:
Here is the converted Sales invoice of QuickBooks into Sage 300 (refer below screen shots) where the Invoice Transactions have been converted as per mapping.
Once you do the IC Day end processing in Sage 300, the above Sales Transaction get created into AR module as Invoice with GL Accounts selected in grid other than line Items.