Migrate Sales Invoice from QuickBooks to Sage 100 ERP

By | March 17, 2016

GUMU™ for QuickBooks to Sage 100 ERP is a Sage-certified Migration solution. Greytrix provides Migration services at its Sage Migration Centre and fulfills the business requirements.

New Stuff: Migrate Purchase Invoice from QuickBooks to Sage 100 ERP

This blog is in continuation to our series GUMU™ ERP Migration services. In our previous blog, we discussed how to Migrate Open Sales Orders from QuickBooks to Sage 100 ERP. In this blog, we are going to discuss about how Sales Invoice gets migrated from QuickBooks to Sage 100 ERP (Formerly known as MAS 90) using GUMU™.

To create a Sales Invoice in QuickBooks follow the below path and the below screen will get displayed :
Quick Books -> Customers ->  Customers Center ->Invoice Entry.

Sales Invoice in QuickBooks

You can observe existing Sales Invoices in QuickBooks through the below path :
Quick Books -> Customers ->  Customers Center –
Click on a specific customer and go to the Transaction tab of that customer as shown in below screenshot:

QuickBooks_Sales

Above highlighted fields are migrated in Sage 100 in below path:
Sage 100 -> Sales Order -> Main -> Invoice Data Entry
You can observe Sales order details and Customer in Header tab, as shown in below screenshot –

Header tab Sage 100 

You can observe Address details in Address tab, as shown in below screenshot –

Address tab Sage 100 

You can observe Item details of the Sales order in Lines tab, as shown in below screenshot –

Lines tab Sage 100

You can observe Invoice Balance details of Sales order in Totals tab, as shown in below screenshot –

Totals tab Sage 100

After data migration from QuickBooks the field values of Sales Invoice gets converted with the following mapping:

QuickBooks the field values conversion mapping

In this way, Sales Invoice is migrated into target Sage 100 ERP from company database of source ERP QuickBooks. For more information on ERP data migration, drop us a mail at erpmig@greytrix.com.