Import Vendors from Sage 100 to Sage CRM

Note: This is a onetime process when you start using the integration. Alternatively, you can use this option if you are importing bulk data in your Sage 100 system through an external source and then want this to be synched to Sage CRM.

You will be able to view the Import vendor option only if you have at least one Sage 100 vendor configured. This screen will allow you to import Sage 100 vendors, their addresses and contacts into Sage CRM. The import procedure is explained in detail in the following section. You can refer the field and entity mappings excel provided along with the installation.

Select company from company block in Import customers tab.

There are 3 methods to import vendors from Sage 100 to Sage CRM.

• You just have to click on sync which will sync all vendors without any criteria

• You can select option -> vendors Added/Updated Since

a. You need to select a date by clicking on the calendar button. The single arrows on the extreme left and right will navigate through the months of the year and the double arrows will navigate through the years.

b. To select a particular date you need to click on the particular date cell and this date will be populated in the text box. See below image.

c. GUMU™ integration will now sync records from Sage 100 which have been added or updated on or after the specified date.

Note: The date displayed in the text-box would be in the MM/DD/YYYY format.

d. Click on the Sync button to sync records from Sage 100 to Sage CRM based on the date specified.

e. If there already exists a record in Sage CRM with the same customer number for a particular company then that record will be updated in Sync process.

• From Vendor and To Vendor Number

a. GUMU™ integration will sync the ‘customer number’ which is specified between ‘From’ and ‘To’ Customer.

b. Click on the Sync button to sync records from Sage 100 to Sage CRM based on the vendor specified.

If there is a record in Sage CRM with the same vendor number for a particular vendor then that record will be updated in Sync process.