Migrate PO Invoice (Detail) from Sage BusinessWorks to Sage 300 ERP

By | February 25, 2016

GUMU™ for Sage BusinessWorks ERP to Sage 300 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 300 ERP system through our various successful migration and integration solutions.
New Stuff: Migrate AP Invoice (summary) from Sage BusinessWorks to Sage 300 ERP.
In our previous blog we discussed about migration of AP Invoice (summary). In this blog, we will discuss about how Sage BusinessWorks PO Invoice (Detail) is migrated to Sage 300 ERP (Formerly known as Accpac) using GUMU™.
Note: During migration process, we consider all Invoices which are created using reference of purchase order as a detail type PO Invoice in Sage BusinessWorks.
Navigate through the below link to check the invoice records in Sage BusinessWorks.
Modules-> Accounts Payable -> Vendor Inquiry -> Enter Vendor ID and click on Transactions to check all transaction’s records related to entered vendor id.
BW1
Above screen will pop after you navigate to check the transaction. As you can view, here we have referred the transaction of Vendor ‘Metal Fab & Welding’ and Invoice Number ‘234098WEREW002’.
To check the details of this invoice open this invoice in BusinessWorks.
BW2
This screenshot will display reference of PO Number. To check the details of this invoice you need to check the Closed Order. Here we are referring PO Number 2112.
Below screenshot shows, details information of Purchase Order related to above invoice.
BW3
Note: While converting closed purchase order, first we create receipt of it and then create Invoice from the receipt’s record. Below are the screenshots of the converted Sage 300 data.
Sage300_1_1
Sage300_1
Sage300_2
Sage300_3
Above screenshots shows, the converted PO Receipt and Invoice (Detail) in the Sage 300 as same details present in Sage BusinessWorks.
Note: The master’s codes (i.e. Ship-To-Location, Terms Code, Item Number, Vendor Number, Account Number) displayed in above screenshots are mapped during migration.
After data migration from Sage BusinessWorks the field values of Sage BusinessWorks PO Invoice (Detail) get converted with the following mapping:

In this way, Sage BusinessWorks PO Invoices (Detail) are migrated into target Sage 300 ERP company database. For more information on ERP data migration, drop us a mail at erpmig@greytrix.com