Configuration Section
Last updated
Last updated
Fill in the below-required details.
Field Name | Description |
DSN Name | This is the system DSN (Data Source Name) name created by the setup. DSN contains the configuration information provided in the setup to connect to Sage 100. “GUMU™MAS90”is the default value. (Do not change/edit this.) |
Company Code | It is the Sage 100 Company Code which you want to integrate with your Sage CRM. |
Company Description | Fill in the Company description as set in Sage 100 for corresponding company code. |
Sage 100 Home Directory | This is the path wherein Sage 100 home directory is installed. For instance, it would be Program Files\Sage Software\Sage 100\Version4\MAS90\Home. |
Sage 100 User Name | User Id of the Sage 100 user with admin level rights. |
Sage 100 Password | Password of the Sage 100 user which is configured in the Sage 100 User Name field. |
Synchronization | This field provides the option to set the integration direction. You have the following options One Way- Sage CRM to Sage 100: The data would be updated on a real time basis, only from Sage CRM to Sage 100 and not from Sage 100 to Sage CRM. One Way- Sage 100 to Sage CRM: The data would be updated on a real time basis, only from Sage 100 to Sage CRM and not from Sage CRM to Sage 100. Both: The data would be updated bi-directionally on a real time basis from both the systems. None: The integration is disabled. Data from neither system would be updated. |
Sage 100 Version | Put the version of your Sage 100 system like 5.0,5.1,5.2,5.3,5.4 |
Prospect Customer | Specify sample customer number which is present in Sage100. This customer number is used to create quotes for a prospect. All default information (pricing, Taxes) will get loaded as per this sample customer number for prospect. Refer the below Link for more details- Price Calculation for Non-promoted customer in Sage CRM (prospect) |
Create A/R Invoice | If user wants to create and promote AR Invoices from Sage CRM to Sage 100, user can check this checkbox. This functionality is available only in GUMU™ Complete Integration. |
Vendor Integration | If this check box is checked, it will enable Vendor Integration Functionality part i.e. Promote and Import Vendors from Sage CRM to Sage 100. |
Integrate Account Manager with Salesperson | If this check box is checked, it will integrate Account Manger field of Company summary screen with Sage 100 Sales person based on Sales persons mapped in MAP CRM Users section. |
Edit Order | If this checkbox is checked, it will enable Edit Order functionality part i.e. user can update promoted Orders from Sage CRM to Sage 100. |
Generate GUMU™ Logs | If this checkbox is checked, user can view GUMU™ error logs under below directory, Promote Records (Customer/Order/Invoice) and GUMU™ Tabs: User can check error message at below path of Sage CRM installation directory, “C:\Program Files\Sage\CRM\CRM\CustomDotNet\” Real time Sage CRM to Sage 100 changes : For real time changes between Sage CRM to Sage 100 ,GUMU™ create a logs at the below path of GUMU™ installation directory. “C:\Program Files\Greytrix\GUMU™ for Sage CRM Server – Complete\GUMU™\” |
Sage 100 Server Name | Enter the Sage 100 server name in this text box. |
Default Company | If this checkbox is checked, then it will consider that company code as a default company code. This default company code is used while creating quotes\Order for a prospect. All the default information (pricing, Taxes) will get loaded as per this default company code. |
Is Linked Server present? | The setup of linked servers is determined by the configuration of Sage 100. This configuration option enables users to indicate whether the linked server has been established. By utilizing the linked server, we are able to access the Sage 100 database and display real-time charts and the Kendo grid. |
If the Sage 100 version is SQL version only then fill in SQL server details or leave it blank.
SQL Details | Description |
SQL Server Name | Put the SQL server Name where Sage 100 Database is stored. |
SQL Company Instance Name | Specify Sage 100 company instance name, which is attached to SQL server. For example Sage 100_ABC, Sage 100_XYZ |
Impersonation Section
Windows Authentication | Details |
Domain Name | The network domain name where Sage CRM exists |
Windows User | Specify domain user with administrative rights |
Windows Password | Password of the domain user |
4. A successful save would take you to the configuration List where you will be able to see the configuration record just added. Since GUMU™ is multiple-company integration you can add more companies (of the same Sage 100 install) to the list following similar steps.