Migrate Open Purchase Order from QuickBooks to Sage 100 ERP

By | March 17, 2016

GUMU™ for QuickBooks to Sage 100 ERP is a Sage certified Migration solution. Greytrix is a pioneer in providing Migration services at its Sage Migration Centre and catering end-users business requirements. We at Greytrix help the end – user in implementing new Sage 100 ERP system through our various successful migration.

In this blog we will discuss about how GUMU™ migrates Purchase Orders from QuickBooks to Sage 100 ERP (Formerly known as MAS 90).

New Stuff: Migrate Vendor Term from QuickBooks to Sage 100 ERP

You can observe Open Purchase order in QuickBooks from the following path:
Quick Books -> Vendors -> Vendor centre -> Transaction tab
Click on Purchase order and filter by Open purchase order to observe all open purchase orders as shown in below screenshot:

Purchase order entry

Then double click on Vendor’s name to view purchase order details of specific Vendor, below screen will get displayed:

Purchase Order Entry

Above highlighted fields are migrated in Sage 100 ERP in below path:
Sage 100 -> Purchase Orders -> P/O Transactions -> Purchase Order Entry
You can observe Purchase order number, date, vendor, and addresses in Header tab as shown in below screenshot –

details of purchased Products in Lines tab

You can observe details of Purchase address and Ship to address in Address tab as shown in below screenshot –


You can observe details of purchased Products in Lines tab as shown in below screenshot –

Amount details of Purchase order in Totals tab

You can observe Amount details of Purchase order in Totals tab as shown in below screenshot –

quick books sage 100 mapping

After data migration from QuickBooks, the field values of Purchase order gets migrated with the following mapping.

Field value mapping of Purchase order

In this way, Purchase order is migrated into target ERP Sage 100 from company database of source ERP QuickBooks.

About Us:
Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
Greytrix helps in migrating to Sage 100, Sage 300 and Sage ERP X3 from Sage Pro, Sage 50 US, Sage 50 CA, Sage 50 Usage Business Works, Sage Business Vision, QuickBooks and MS Dynamics Great Plains.
 For more information on migration solutions, please contact us at erpmig@greytrix.com. We will be glad to assist you.