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

By | May 27, 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 Sage Business Works Company Database to Sage 300 ERP

In our previous blog we discussed about overall review of Sage BusinessWorks to Sage 300 migration. 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 the reference of Sales Order as a detail type SO Invoice in Sage 300.

Navigate through the below link to check the Sales Order and Invoice records in Sage BusinessWorks.
To view Sales Invoice : Modules -> Order Entry -> Customer Enquiry -> Enter Customer ID and click on transaction check all transactions related to entered Custom ID.
BWThe above screen will pop up after you navigate to check the transaction. As you can view, here we have referred the transaction of Vendor ‘Stan’s Cycllery’ and invoice number 5. To check the details of this invoice open this invoice in BusinessWorks.

To View Sales Order : Modules-> Order Entry -> Sales Order Inquiry -> Enter Customer ID
BW1Note. We convert Sales Order of Status Closed as SO Invoice in Sage 300. While converting closed sales order, first we create shipment of it and then create an Invoice from the shipment’s record. Below are the screenshots of the converted Sage 300 data.
Sage300 Sage300_1 Sage300_2 Sage300_3Above screenshot shows the converted SO Shipment and Invoice (Detail) in 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 SO Invoice (Detail) get converted with the following mapping:
mappingIn this way, Sage BusinessWorks SO 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

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at accpac@greytrix.com. We will be glad to assist you.