{"id":5276,"date":"2019-11-18T12:34:00","date_gmt":"2019-11-18T12:34:00","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=5276"},"modified":"2019-11-19T04:37:12","modified_gmt":"2019-11-19T04:37:12","slug":"gumu-salesforce-tricks-tips-data-validation-for-sage-100-country-code-in-salesforce","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/11\/18\/gumu-salesforce-tricks-tips-data-validation-for-sage-100-country-code-in-salesforce\/","title":{"rendered":"GUMU&#x2122; Salesforce Tricks &#038; Tips \u2013 Data Validation for Sage 100 Country Code in Salesforce"},"content":{"rendered":"\n<p>In this blog we will be discussing the data length issue related to the billing country field existing in Address (Billing or Shipping). Since  <a rel=\"noreferrer noopener\" aria-label=\"GUMU&#x2122;  integration (opens in a new tab)\" href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\" target=\"_blank\">GUMU&#x2122;  integration<\/a>, consists of <a rel=\"noreferrer noopener\" aria-label=\"Account Promote\/Update functionality (opens in a new tab)\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/07\/09\/promote-salesforce-account-to-sage-100-customer-using-gumu-lightning-version\/\" target=\"_blank\">Account Promote\/Update functionality<\/a> 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.<\/p>\n\n\n\n<p>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. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Click on the <strong>Promote Customer<\/strong> Button <\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/1.Account-Detail.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/1.Account-Detail.png\" alt=\"Account Details\"><\/a><\/center>\n<font size=\"2\"><center><i>Account Details<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>After entering all the valid information in the Promote page, if the user is receiving the below error.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/2.Error_.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/2.Error_.png\" alt=\"Country Code Error\"><\/a><\/center>\n<font size=\"2\"><center><i>Country Code Error<\/i><\/center><\/font>\n\n\n\n<p><em>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.<\/em><\/p>\n\n\n\n<p><em>To Check for the proper country code that has been setup in your Sage 100 ERP System, kindly follow the below steps:<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><em>Login to your Sage 100 ERP System.<\/em><\/li><li><em>From the Modules, select the Library Master Module.<\/em><\/li><li><em>Expand the Setup menu and look for the Country Code Maintenance option.<\/em><\/li><li><em> Open the file and you will find the Country Code list that has been setup in your Sage 100 ERP System.  <\/em><\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/3.Country-Code-List.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/3.Country-Code-List.png\" alt=\"Sage 100 Country Code List\"><\/a><\/center>\n<font size=\"2\"><center><i>Sage 100 Country Code List<\/i><\/center><\/font>\n\n\n\n<p><em>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.<\/em><\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/4.Billing-Country.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/4.Billing-Country.png\" alt=\"Salesforce Billing Country\"><\/a><\/center>\n<font size=\"2\"><center><i>Salesforce Billing Country<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>Go Back to the Account Entry screen and enter valid Country Code in the Address field.<\/li><li>Click on Promote to Save the record in Sage.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/5.Promoted-customer.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/5.Promoted-customer.png\" alt=\"Promoted Customer\"><\/a><\/center>\n<font size=\"2\"><center><i>Promoted Customer<\/i><\/center><\/font>\n\n\n\n<p>Once successfully promoted the Integration keys is generated when the Account is promoted from Salesforce to Sage 100 ERP system &amp; a link is also generated to Customer number in order to view the ERP customer details as and when needed.<\/p>\n\n\n\n<p>In case if you still have any query\/question, please contact us on<a href=\"mailto:salesforce@greytrix.com\">salesforce@greytrix.com<\/a>. We will be glad to assist you. <\/p>\n\n\n\n<p style=\"text-align: justify\"><b>About Us<\/b><\/br>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u2013 a globally recognized and one of the oldest Sage Development Partner and 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.<br><br> Greytrix has some unique solutions for Cloud CRM such as <a href=\"\">Salesforce Sage integration<\/a> for <a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/integration\/\">Sage X3<\/a>, <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-100-integration\/\">Sage 100<\/a> and <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-300-integration\/\">Sage 300 (Sage Accpac)<\/a>. We also offer best-in-class Cloud CRM <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/crm-development\/\">Salesforce customization and development services<\/a> along with services such as Salesforce <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/data-migration-support\/\">Data Migration<\/a>, <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/crm-development\/\">Integrated App development<\/a>, Custom App development and Technical Support business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU&#x2122; integration for Sage ERP \u2013 Salesforce is a 5-star rated app listed on <a href=\"https:\/\/appexchange.salesforce.com\/appxListingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<br> The GUMU&#x2122; Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.<br><br> For more information on our Salesforce products and services, contact us at <a href=\"mailto:salesforce@greytrix.com\">salesforce@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n<p><strong>Related Posts<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/11\/12\/create-entity-in-gumu-sage-100-integration-lightning-interface\/\">Create Entity in GUMU&#x2122; SAGE 100 Integration \u2013 Lightning Interface<\/a><\/li><li> <a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2018\/06\/01\/gumu-add-on-for-promoting-salesforce-account-as-a-vendor-to-sage-100\/\" target=\"_blank\">GUMU&#x2122; Add-on for Promoting Salesforce Account as a Vendor to Sage 100<\/a><br><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/10\/30\/promote-salesforce-contacts-to-sage-100-erp-using-gumu\/\" target=\"_blank\">Promote Salesforce Contacts to Sage 100 ERP using GUMU&#x2122;<\/a><br><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/04\/26\/promote-shipping-address-in-salesforce-sage-100-integration\/\" target=\"_blank\">Promote Shipping Address in Salesforce \u2013 Sage 100 Integration<\/a><br><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/05\/30\/syncing-data-from-sage-100-into-salesforce-using-gumu\/\" target=\"_blank\">Syncing data from Sage 100 into Salesforce using GUMU&#x2122;<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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&#x2122; 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\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/11\/18\/gumu-salesforce-tricks-tips-data-validation-for-sage-100-country-code-in-salesforce\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[728,727,162,678,184,188,359,360,361,377,401,679,681,680,716,424,430],"class_list":["post-5276","post","type-post","status-publish","format-standard","hentry","category-gumu-salesforce","tag-country-code-error","tag-data-validation","tag-gumusfsage100","tag-gumulightninginterface","tag-integrate-salesforce-with-sage-100","tag-integrate-sfdc-and-sage-100","tag-sage100","tag-sage100-salesforce","tag-sage100-sf","tag-salesforce-and-sage-100-integration","tag-salesforce-integration-with-sage-100","tag-salesforce-lightning-and-sage-100-integration","tag-salesforce-lightning-integration-with-sage-100","tag-salesforce-lightning-sage100-integration","tag-salesforce-sage-integration","tag-salesforce-with-sage-100-integration","tag-salesforce-sage100"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/5276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/comments?post=5276"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/5276\/revisions"}],"predecessor-version":[{"id":5283,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/5276\/revisions\/5283"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=5276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=5276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=5276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}