{"id":10449,"date":"2025-04-28T11:26:26","date_gmt":"2025-04-28T11:26:26","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=10449"},"modified":"2025-09-05T05:23:10","modified_gmt":"2025-09-05T05:23:10","slug":"view-sage-100-customer-statistics-in-salesforce-with-gumu-lightning-integration","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2025\/04\/28\/view-sage-100-customer-statistics-in-salesforce-with-gumu-lightning-integration\/","title":{"rendered":"View Sage 100 Customer Statistics in Salesforce with GUMU&#x2122; Lightning Integration"},"content":{"rendered":"\n<p>In this blog, we will explore a key feature of GUMU&#x2122; Integration within the Lightning interface: the enhanced support for displaying Customer Statistics from Sage 100. This powerful functionality enhances the ERP Addresses and Fields tab under the Account object by seamlessly integrating real-time data from the ERP system, ensuring accurate and up-to-date information representation.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">How to Enable Customer Statistics in Salesforce<\/mark><\/strong><\/h3>\n\n\n\n<p>Follow the steps below to set up this feature in your Salesforce Org securely and efficiently:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Login<\/strong> to your Salesforce Org.<\/li>\n\n\n\n<li>Open the <strong>GUMU&#x2122; Integration<\/strong> app.<\/li>\n\n\n\n<li>Go to the <strong>Account<\/strong> tab.<\/li>\n\n\n\n<li>Scroll to the <strong>ERP Addresses and Fields<\/strong> section.<\/li>\n\n\n\n<li>If the <strong>Customer Statistics<\/strong> section isn\u2019t visible:\n<ul class=\"wp-block-list\">\n<li>Navigate to <strong>Setup<\/strong> \u2192 <strong>Edit Page<\/strong> to customize the layout.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2025\/06\/1.-ERP-Addresses-and-Fields.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\/2025\/06\/1.-ERP-Addresses-and-Fields.png\" alt=\"ERP Addresses and Fields\"><\/a><\/center><font size=\"2\"><center><i> ERP Addresses and Fields <\/i><\/center><\/font>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">Configuring in Lightning App Builder<\/mark><\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the Lightning App Builder, click on ERP Addresses and Fields.<\/li>\n\n\n\n<li>In the Components tab (left-hand side), search for Customer Statistics.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2025\/06\/2.-Lightning-App-Builder-Screen.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\/2025\/06\/2.-Lightning-App-Builder-Screen.png\" alt=\"Lightning App Builder Screen\"><\/a><\/center><font size=\"2\"><center><i> Lightning App Builder Screen <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Drag and drop the Customer Statistics component below Sage Addresses.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2025\/06\/3.-Lightning-App-Builder-Screen-after-Dragging-CustStats.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\/2025\/06\/3.-Lightning-App-Builder-Screen-after-Dragging-CustStats.png\" alt=\"Lightning App Builder Screen after Dragging Cust Stats\"><\/a><\/center><font size=\"2\"><center><i> Lightning App Builder Screen after Dragging Cust Stats <\/i><\/center><\/font> \n\n\n\n<ul class=\"wp-block-list\">\n<li>Click <strong>Activate<\/strong>, select <strong>Org Default<\/strong> and <strong>App Default<\/strong>, then click <strong>Save<\/strong>.<\/li>\n\n\n\n<li>Return to the Customer record \u2013 the <strong>Customer Statistics<\/strong> tab should now be active.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2025\/06\/4.-Final-Customer-Statistics-Screen.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\/2025\/06\/4.-Final-Customer-Statistics-Screen.png\" alt=\"Final Customer Statistics Screen\"><\/a><\/center><font size=\"2\"><center><i> Final Customer Statistics Screen <\/i><\/center><\/font>\n\n\n\n<h3 class=\"wp-block-heading\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\"><strong>Customer Statistics Fields &amp; Insights<\/strong><\/mark><\/h3>\n\n\n\n<p>Click on the <strong>Customer Statistics<\/strong> tab to view real-time metrics pulled from Sage 100, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>YTD Sales<\/strong> (Year to Date): Total sales for the current fiscal year.<\/li>\n\n\n\n<li><strong>LYTD Sales<\/strong> (Last Year to Date): Total sales for the previous fiscal year.<\/li>\n\n\n\n<li><strong>LLYTD Sales<\/strong> (Last to Last Year): Sales from the fiscal year before the last.<\/li>\n\n\n\n<li><strong>% Change (YTD vs LYTD)<\/strong>: <code>(YTD \/ LYTD) - 1<\/code><\/li>\n\n\n\n<li><strong>% Change (LYTD vs LLYTD)<\/strong>: <code>(LYTD \/ LLYTD) - 1<\/code><\/li>\n\n\n\n<li><strong>Last Invoice Date<\/strong>: Most recent invoice date from Sage 100.<\/li>\n\n\n\n<li><strong>Last Sales Order Date<\/strong>: Most recent sales order date from Sage 100.<\/li>\n\n\n\n<li><strong>Days Since Last Order<\/strong>: Number of days since the most recent order.<\/li>\n\n\n\n<li>These real-time insights are calculated using ERP data retrieved via GUMU&#x2122;, helping you track customer activity trends and identify potential revenue opportunities directly within Salesforce.<\/li>\n<\/ul>\n\n\n\n<p>By following the above blog instructions, the user can view real-time data in the Customer Statistics section, enabling quicker insights and more informed decision-making directly within the Salesforce interface. <\/p>\n\n\n\n<p>If you still have queries or any related problems, don\u2019t hesitate to contact us at&nbsp;<a href=\"mailto:salesforce@greytrix.com\" target=\"_blank\" rel=\"noreferrer noopener\">salesforce@greytrix.com<\/a>. More information about the Product is available on&nbsp;<a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-100-integration\/\" data-type=\"link\" data-id=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-100-integration\/\" target=\"_blank\" rel=\"noreferrer noopener\">our website<\/a>&nbsp;and&nbsp;<a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noreferrer noopener\">Salesforce AppExchange<\/a>.<\/p>\n\n\n\n<p>We hope you may find this blog resourceful and helpful. However, if you still have concerns and need more help, please get in touch with us at <a href=\"mailto:salesforce@greytrix.com\" target=\"_blank\" rel=\"noreferrer noopener\">salesforce@greytrix.com<\/a>.<\/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\">\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/09\/09\/promote-sales-order-from-sf-to-sage-100-erp-through-gumu-using-salesforce-lightning-components\/\" target=\"_blank\" rel=\"noreferrer noopener\">Promote Sales Order from SF to Sage 100 ERP through GUMU&#x2122; using Salesforce Lightning Components<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/05\/30\/syncing-data-from-sage-100-into-salesforce-using-gumu\/\" target=\"_blank\" rel=\"noreferrer noopener\">Syncing data from Sage 100 into Salesforce using GUMU&#x2122;<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/08\/27\/gumu-feature-use-filters-in-import-functionality\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Feature \u2013 Use Filters in Import functionality<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we will explore a key feature of GUMU&#x2122; Integration within the Lightning interface: the enhanced support for displaying Customer Statistics from Sage 100. This powerful functionality enhances the ERP Addresses and Fields tab under the Account object by seamlessly integrating real-time data from the ERP system, ensuring accurate and up-to-date information representation.\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2025\/04\/28\/view-sage-100-customer-statistics-in-salesforce-with-gumu-lightning-integration\/\">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":[956,2],"tags":[162,163,678,1710,184,188,271,277,1145,1144,745,739,359,360,361,377,744,738,743,401,679,681,680,716,424,430],"class_list":["post-10449","post","type-post","status-publish","format-standard","hentry","category-gumu-features","category-gumu-salesforce","tag-gumusfsage100","tag-gumusfsage100erp","tag-gumulightninginterface","tag-gumusalesforce","tag-integrate-salesforce-with-sage-100","tag-integrate-sfdc-and-sage-100","tag-promote-account","tag-promote-customer","tag-qle","tag-quick-line-entry","tag-sage-100-connector-with-salesforce","tag-sage-erp-connector-with-salesforce","tag-sage100","tag-sage100-salesforce","tag-sage100-sf","tag-salesforce-and-sage-100-integration","tag-salesforce-connector-for-sage-100","tag-salesforce-connector-for-sage-erp","tag-salesforce-connector-with-sage-erp","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\/10449","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=10449"}],"version-history":[{"count":5,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/10449\/revisions"}],"predecessor-version":[{"id":11073,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/10449\/revisions\/11073"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=10449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=10449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=10449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}