Migrate Product Lines from Sage BW to Sage 300

By | March 14, 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 PO Invoice (Detail) from Sage BusinessWorks to Sage 300 ERP
In our previous blog we discussed about migration of PO Invoice (Detail). In this blog, we will discuss about how Sage BusinessWorks Product Lines are migrated to Sage 300 ERP using GUMU™
Navigate through the below link to check the Product Lines in Sage BusinessWorks.
Modules-> Inventory Control -> Utilities -> Product Lines -> Maintain
Product Lines in Sage BusinessWorks

Above screenshot will display Product Line ID named ‘ACCESSRY’ present in Sage BusinessWorks.
While converting ‘Product Lines’ from Sage BusinessWorks to Sage 300 ERP, we migrate data present in this into ‘I/C Categories’ and ‘I/C Account Sets’. JFYI, we convert ‘Sales Account’ and ‘Cost of Goods Sold account’ into ‘I/C Categories’ and ‘Inventory’ into ‘I/C Account Sets’.
Below are the screenshots of the converted Sage 300 data.
Sage-300-2
Sage 300 1
Above screenshots shows, the converted Product lines from Sage BW into I/C Categories and Account Set of Sage 300 ERP.
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. We used 0000 as default suspense account , we can set any account as default account as per the customer’s requirement.

After data migration from Sage BusinessWorks the field values of Sage BusinessWorks Product Line get converted with the following mapping:
Field Mapping

In this way, Sage BusinessWorks Product Lines are migrated into target Sage 300 ERP company database.

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.

Also Read:
1) Migrating Ship-Via Codes from Sage BusinessWorks to Sage 300 ERP
2) Migrate Inventory On Hand Quantity from Sage BusinessWorks to Sage 300 ERP
3) Migrate Open Sales Orders from Sage BusinessWorks to Sage 300 ERP
4) Migrate Vendor Notes from Sage BusinessWorks to Sage 300 ERP.