Available options to migrate Item into Sage 100 ERP

By | March 12, 2018

GUMU™  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 about the available options to convert Item 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 ERP.

New Stuff: Available option to migrate AR customer into Sage 100 ERP

Now, we will discuss about migrating masters into Sage 100 ERP. Unlike Sage 50 every item defined in Sage 100 ERP needs to have an item code. In migration process GUMU allows you to generate item codes for Items using four methods:

  1. Auto Number:Numeric item numbers automatically gets generated using a user-defined starting number and a user-defined increment.
        Stating Number 1010
      Number increment 10

Say for e.g. if you want to assign fist item code as 1000 and next code should get generated by 10 then it would look like as 1010, 1020 and so on as shown below:

  1. Item Initials:Item numbers are generated using first N user defined initials of item name and next three characters will be a number.

  1. Item Name:Item numbers are generated using first N (N is user-defined value) characters of item name and next three characters will be a number

  1. Peachtree Item ID: Item number can be converted as they exist in Sage 50 US. If length Source item number is greater than 20 than item number gets truncated to length 20.

In this way, Sage 50 Item masters is migrated into target Sage 100 ERP company database. In our Next Blog we will discuss about another method of generating Item Number.

About Us                

Greytrix is a 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 X3 from Sage Pro, Sage 50 US, Sage 50 CA, Sage 50 Usage Business Works, Sage Business Vision and QuickBooks.

For more information on migration solutions, please contact us at [email protected]. We will be glad to assist you.