Merging of vendor masters into Sage 100 ERP

By | May 21, 2018

GUMU™ for Sage 50 US (Peachtree) to Sage 300 ERP is a Sage certified Migration solution. Greytrix is a pioneer in providing Migration services at its Sage Migration Center and catering end-user business requirements. We at Greytrix are focused to help the client in successfully implementing the new Sage 100 ERP system through our various successful migration and integration solutions.

In this blog, we would discuss the merging of Vendor masters into Sage 100 ERP. We convert masters by using below-mentioned methods from Sage 50 US (Peachtree), QuickBooks. In this blog, we have taken the example of Sage 50 US ERP.

 New Stuff: Number of ways to migrate AR Customer into Sage 300 ERP

In, a continuation of our previous blog, here we would discuss merging of multiple vendors into a single vendor. Generally, this gets needed if the user in source ERP system created multiple vendor masters records for the same vendor. So in such case, if they want to maintain the single vendor record for duplicate masters then they can opt for the merging process during vendor number mapping.

In our migration process, we do incorporate this requirement through User defined mapping process. Let’s elaborate this in a detail with an example – we have 2 vendors with different codes but with similar or different names and users want to merge these vendors into a single Vendor master record with ‘AMEX’.

For this requirement, we do send the template vendor number mapping sheet to our client before proceeding with the migration process. The format of the sheet is as below which contains the columns – Sage 50 Vendor Number, Sage 50 Vendor Name, Sage 100 ERP Vendor Code and Sage 100 ERP Vendor Name. We expect the filled sheet from client wherein he needs to fill their desired vendor masters code and their names as they want to convert into Sage 100 ERP against the existing Sage 50 Vendor details. The vendors which they want to merge into target ERP system should have mentioned the same ‘Sage 100 Vendor number’ into mapping sheet as shown below.

vendor mapping sage 100

Once we receive the filled sheet from the client, we process them accordingly into migration and client’s desired vendor number gets merged into Sage 100 and their transactions also get migrated against single vendor into target Sage 100 ERP.

In this way, Sage 50 Vendor masters get merged and migrated into target Sage 100 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 has some unique solutions of Sage 100 integration with Sage CRM, and  along with Sage 100 Migration from Sage 50 US, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more details on Sage 100 Services, please contact us at We will be glad to assist you.