Migrate AP Invoice (summary) from Sage BusinessWorks to Sage 300 ERP

By | February 23, 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: Migrating Open Purchase Order from Sage BusinessWorks to Sage 300 ERP.
In this blog, we will discuss about how Sage BusinessWorks AP Invoices (Summary) are migrated to Sage 300 ERP (Formerly known as Accpac) using GUMU™.
Note: During migration process, we consider all Invoices which are note created using close order as a summary type APInvoice in Sage BusinessWorks.
Navigate through the below link to check the AP Invoice (summary) 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.
Sage_BW_1
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 ‘0401’. To check the details of this invoice open this invoice in BusinessWorks.
Sage_BW_2
Sage_BW_3
Above two screenshots shows the detail information (i.e. GL Distribution details, Invoice Date, Due Date, Discount Date, Discount Amount and Original Amount) of Invoice Number ‘0401’.
Below are the screenshots of the converted Sage 300 data.
Sage 300_1
Sage 300_2
Sage 300_3
Above screenshots shows, the converted AP Invoice (Summary) 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, VendoNumber,Account Number) displayed in above screenshots are mapped during migration.
After data migration from Sage BusinessWorks the field values of Sage BusinessWorks AP Invoice (Summary) get converted with the following mapping:

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