GUMU™ Salesforce Tricks & Tips – Data Validation for Sage 100 Country Code in Salesforce

By | November 18, 2019

In this blog we will be discussing the data length issue related to the billing country field existing in Address (Billing or Shipping). Since GUMU™ integration, consists of Account Promote/Update functionality for data consistency between Salesforce Account and Sage 100 Customer, users would face errors related to the data validation settings in the 2 systems while updates.

If a user is attempting to promote a newly created (or non-linked) Account from Salesforce to Sage 100 ERP system, he follows the below steps in order to promote an Account from Salesforce to Sage 100 ERP system.

  • Click on the Promote Customer Button
Account Details
Account Details
  • After entering all the valid information in the Promote page, if the user is receiving the below error.
Country Code Error
Country Code Error

This indicates that the length of the Billing Address or Shipping Address or both, entered in the Salesforce org against the Account is greater than the specified limit allowed in the Sage 100 ERP system.

To Check for the proper country code that has been setup in your Sage 100 ERP System, kindly follow the below steps:

  • Login to your Sage 100 ERP System.
  • From the Modules, select the Library Master Module.
  • Expand the Setup menu and look for the Country Code Maintenance option.
  • Open the file and you will find the Country Code list that has been setup in your Sage 100 ERP System.
Sage 100 Country Code List
Sage 100 Country Code List

The country code defined in Sage 100 ERP has the maximum limit up to 3 characters. Therefore the integration prevents from promoting an account from Salesforce to Sage 100 ERP System. So according to the country code data that has been setup in the Sage 100 ERP system, we have changed the value of billing Country in Salesforce.

Salesforce Billing Country
Salesforce Billing Country
  • Go Back to the Account Entry screen and enter valid Country Code in the Address field.
  • Click on Promote to Save the record in Sage.
Promoted Customer
Promoted Customer

Once successfully promoted the Integration keys is generated when the Account is promoted from Salesforce to Sage 100 ERP system & a link is also generated to Customer number in order to view the ERP customer details as and when needed.

In case if you still have any query/question, please contact us onsalesforce@greytrix.com. We will be glad to assist you.

About Us
Greytrix – a globally recognized and one of the oldest Sage Gold Development Partner, as a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.

Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3Sage 100 and Sage 300. We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data MigrationIntegrated App developmentCustom App development and Technical Support to business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow.

Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star rated app listed on Salesforce AppExchange.

For more information, please contact us at salesforce@greytrix.com. We will be glad to assist you.

Related Posts