{"id":7417,"date":"2023-07-25T06:21:40","date_gmt":"2023-07-25T06:21:40","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=7417"},"modified":"2023-07-25T06:21:44","modified_gmt":"2023-07-25T06:21:44","slug":"showing-additional-related-sage-x3-data-on-gumu-real-time-screen","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2023\/07\/25\/showing-additional-related-sage-x3-data-on-gumu-real-time-screen\/","title":{"rendered":"GUMU\u2122 Tricks &#038; Tips &#8211; Showing Additional (Related) Sage X3 Data on GUMU\u2122 real-time screen"},"content":{"rendered":"\n<p>In this blog, we will discuss on showing additional (related) Sage X3 data from any entity that has a table linked to records from other tables. The information presented here will assist users in configuring the Data Page. For instance, it explains how to access data related to customers from different tables within the Customer Layout. The blog focuses on fetching additional table records in Salesforce and pertains to the configuration of the GUMU\u2122 product.<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><em>Please note that you should be a Salesforce Admin in order to modify the details. Along with this you are also required to know the API details and structure of Sage X3 data and related list, grouping etc. for modifying the details on the GUMU\u2122 inquiry screen. Also note that this feature has been updated in GUMU\u2122 lightning package for it be in consistency with teh other features offered by the GUMU\u2122 integration.<\/em>  <\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><em>Additional (Related) Sage X3 data:-<\/em><\/strong><\/h4>\n\n\n\n<p>Below are the steps to fetch additional (related) Sage X3 table data from Sage X3 to the Real-time screen in Salesforce:-<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Log into Salesforce.   <\/li><li>In the App Launcher, search for Inquiries.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2023\/07\/GUMU-Inquiry-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\/2023\/07\/GUMU-Inquiry-Screen.png\" alt=\"GUMU Inquiry Screen\"><\/a><\/center>\n<font size=\"2\"><center><i>GUMU Inquiry Screen<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>Once found in the list of the details of the object search for &#8220;Customer&#8221; in the list as that&#8217;s the one associated with the GUMU\u2122 Customer\/Account records for displaying related information.<\/li><li>Go to the Customer Inquiry screen and click on the new data page section.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2023\/06\/1.-Customer-inquiry-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\/2023\/06\/1.-Customer-inquiry-Screen.png\" alt=\"Customer Inquiry Screen\"><\/a><\/center>\n<font size=\"2\"><center><i>Customer Inquiry Screen <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>Customer Inquiry screen details will contain previously defined section that can be modified by the user or updated as well in order to maintain the data visible to the user. <\/li><li>Further now the Admin can Create a new data page against Customer Inquiries.<\/li><li>Go to the related page and click on the new button.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2023\/06\/2.-Customer-Related-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\/2023\/06\/2.-Customer-Related-Screen.png\" alt=\"Customer Related Screen\"><\/a><\/center>\n<font size=\"2\"><center><i>Customer Related Screen <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>This will open up a new data page that will allow user to enter the details.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2023\/06\/3.-New-Data-Page-Section.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\/2023\/06\/3.-New-Data-Page-Section.png\" alt=\"New Data Page Section\"><\/a><\/center>\n<font size=\"2\"><center><i>New Data Page Section <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>Enter the Data Page Section Name and on the Related List Name field enter the Group code from Sage X3 from which table you want to get the additional (related) Sage X3 data and click on the save button.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2023\/07\/GUMU-Inquiries-page-section-with-required-data.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\/2023\/07\/GUMU-Inquiries-page-section-with-required-data.png\" alt=\"Data page section with required data\"><\/a><\/center>\n<font size=\"2\"><center><i>Data page section with required data <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>Save the &#8220;Data Page&#8221; record in the screen and if need be you can update the Sort Order or add more fields\/details to section for better visibility to the user.<\/li><li>Further navigate to the Account page and click on Customer Details.<\/li><li>Click on settings at the corner of the page and click on the field-level setup tab.<\/li><li>Select a section and add <em>additional (related) Sage X3 data <\/em>that should be displayed on that created section.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2023\/06\/5.-Field-level-Setup.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\/2023\/06\/5.-Field-level-Setup.png\" alt=\"Field level Setup\"><\/a><\/center>\n<font size=\"2\"><center><i>Field level Setup <\/i><\/center><\/font>\n\n\n\n<pre class=\"wp-block-verse\"><em><strong>Note<\/strong>:- To get the field data from Sage X3 to the real-time screen user have to set the API name in Field API Name under the data page Section.<\/em><\/pre>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2023\/06\/6.-Real-time-screen-with-fields-and-data.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\/2023\/06\/6.-Real-time-screen-with-fields-and-data.png\" alt=\"Additional (related) Sage X3 data\"><\/a><\/center>\n<font size=\"2\"><center><i>Real time screen with fields and data <\/i><\/center><\/font>\n\n\n\n<p>By following the above blog instructions, you should be able to learn \u201c<strong>Fetching additional (related) Sage X3 data to the real-time screen by using the data page and GUMU\u2122 Lightning interface<\/strong>\u201c. More detail about the Field Security and how to setup teh details\/access is available in one of our <a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/10\/19\/field-accessibility-configuration-on-gumu-real-time-inquiry-screen\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/10\/19\/field-accessibility-configuration-on-gumu-real-time-inquiry-screen\/\" rel=\"noreferrer noopener\">previous blog here<\/a>.<\/p>\n\n\n\n<p>If you still have queries or any related problems, don\u2019t hesitate to contact us at\u00a0<a href=\"mailto:salesforce@greytrix.com\" target=\"_blank\" rel=\"noreferrer noopener\">salesforce@greytrix.com<\/a>. More details about our integration product are available on\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">our website<\/a>\u00a0and\u00a0<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 contact us at&nbsp;<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\"><li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/05\/30\/promote-shipping-address-from-salesforce-to-sage-x3-using-gumu-integration\/#:~:text=Promoted%20Address%20in%20Sage%20X3%20Similarly%2C%20for%20promoting,Salesforce%20as%20well%20promote%20it%20to%20Sage%20X3\" target=\"_blank\" rel=\"noreferrer noopener\">Promote Shipping Address from Salesforce to Sage X3 using GUMU\u2122 Integration<\/a><\/li><li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/07\/22\/gumu-salesforce-tricks-tips-promoting-billing-address-from-sf-com-to-sage-x3-using-gumu-lightning-components\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU\u2122 Salesforce Tricks &amp; Tips \u2013 Promoting Billing Address from SF.com to Sage X3 using GUMU Lightning components<\/a><\/li><li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2021\/11\/30\/how-to-resolve-error-at-least-one-delivery-address-must-be-active-while-importing-customer-address-in-salesforce-from-sage-x3-erp\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to resolve error [At least one delivery address must be Active] while importing Customer Address in Salesforce from Sage X3 ERP<\/a><\/li><li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2022\/11\/25\/fix-change-in-progress-on-another-workstation-error-while-editing-a-sagex3-record-from-salesforce-to-sagex3\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2022\/11\/25\/fix-change-in-progress-on-another-workstation-error-while-editing-a-sagex3-record-from-salesforce-to-sagex3\/\" rel=\"noreferrer noopener\">How to fix Change in progress on another workstation error while editing a SageX3 record from Salesforce to SageX3 through GUMU\u2122<\/a><\/li><li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2023\/07\/03\/user-controlled-pdf-format-of-customer-transactions-from-sage-x3\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2023\/07\/03\/user-controlled-pdf-format-of-customer-transactions-from-sage-x3\/\" rel=\"noreferrer noopener\">GUMU\u2122 Salesforce Tricks &amp; Tips \u2013 User Controlled PDF Format of Customer Transactions on GUMU\u2122 Real-Time Inquiry from Sage X3<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we will discuss on showing additional (related) Sage X3 data from any entity that has a table linked to records from other tables. The information presented here will assist users in configuring the Data Page. For instance, it explains how to access data related to customers from different tables within the Customer\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2023\/07\/25\/showing-additional-related-sage-x3-data-on-gumu-real-time-screen\/\">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,957],"tags":[159,166,169,678,186,187,298,961,299,965,993,995,300,1425,1421,739,363,364,367,372,374,738,746,400,683,687,684,716,462,463],"class_list":["post-7417","post","type-post","status-publish","format-standard","hentry","category-gumu-features","category-gumu-salesforce","category-gumu-tricks-tips","tag-gumu-sf-integration","tag-gumusfsageem","tag-gumusfsageerpx3","tag-gumulightninginterface","tag-integrate-salesforce-with-sage-em","tag-integrate-salesforce-with-sage-x3","tag-real-time","tag-real-time-information","tag-real-time-integration","tag-real-time-customer","tag-real-time-inquiry","tag-real-time-inquiry-screen","tag-real-time-schema","tag-realtime-customer","tag-realtime-inquiry-page","tag-sage-erp-connector-with-salesforce","tag-sageem","tag-sagex3","tag-salesforce","tag-salesforce-sage-em","tag-salesforce-sage-x3","tag-salesforce-connector-for-sage-erp","tag-salesforce-connector-for-sage-x3","tag-salesforce-integration-with-sage","tag-salesforce-lightning-and-sagex3-integration","tag-salesforce-lightning-integration-with-sagex3","tag-salesforce-lightning-sagex3-integration","tag-salesforce-sage-integration","tag-sfdc-with-sage-em-integration","tag-sfdc-with-sage-x3-integration"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/7417","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=7417"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/7417\/revisions"}],"predecessor-version":[{"id":7446,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/7417\/revisions\/7446"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=7417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=7417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=7417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}