{"id":5259,"date":"2019-11-12T07:39:12","date_gmt":"2019-11-12T07:39:12","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=5259"},"modified":"2019-11-12T07:39:14","modified_gmt":"2019-11-12T07:39:14","slug":"create-entity-in-gumu-sage-100-integration-lightning-interface","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/11\/12\/create-entity-in-gumu-sage-100-integration-lightning-interface\/","title":{"rendered":"Create Entity in GUMU&#x2122; SAGE 100 Integration \u2013 Lightning Interface"},"content":{"rendered":"\n<p>In this blog, we will discuss how user can create a new Entity (for use in the import routine) in Salesforce using new lightning interface of GUMU&#x2122; &amp; Sage 100 SData API method.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p> <em>The prerequisite of any integration is to map the data between the two systems. GUMU&#x2122;, reads the table schema using <\/em><strong><em>Sage 100 SData API<\/em><\/strong><em> method and validate mapping details like field name, field label, data type that you can see under the mapping tab of the Import.<\/em><\/p><\/blockquote>\n\n\n\n<p>Let\u2019s walk you through the process of creating a new entity and get the real-time schema of ERP object. Once you have installed the <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">GUMU&#x2122; integration product<\/a> in your Salesforce organization follow the below steps: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Login to Salesforce.<\/li><li>Go to App Launcher Menu and select \u201cGUMU Settings\u201d App.<\/li><li>Click on \u201cEntity Setting\u201d menu. <\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/1.Sage-100-Entity-Setting.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.Sage-100-Entity-Setting.png\" alt=\"Sage 100 Entity Setting\"><\/a><\/center>\n<font size=\"2\"><center><i>Sage 100 Entity Setting<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>You can create a new entity by clicking on \u201cNew Entity\u201d button.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/2.Sage-100-New-Entity.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.Sage-100-New-Entity.png\" alt=\"Sage 100 New Entity\"><\/a><\/center>\n<font size=\"2\"><center><i>Sage 100 New Entity<\/i><\/center><\/font>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p> <em>If you want to find Sage 100 SData API method, just follow the mentioned below steps:-<br>\u2022 Open a new Internet Explorer window.<\/em><br><em>\u2022 Enter the URL as <strong>http:\/\/&lt;machine name which has the SData installed in its IIS>\/SData\/MasApp\/MasContract\/&lt;company name>\/$Schema<\/strong><\/em>.You can refer <a rel=\"noreferrer noopener\" aria-label=\"our video (opens in a new tab)\" href=\"https:\/\/www.youtube.com\/watch?v=g67DTeCFqlc\" target=\"_blank\">our video<\/a> showing the Sage 100 SData installation and once done the above URL will present you the definition of the schema of the specified Sage 100 company of your Sage system<br><em>\u2022 <\/em> <em>If you need to search for a Web Service API method (ex:-customer) just filter it out in the web page as shown <a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/3.Sage-100-SData-URL.png\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (opens in a new tab)\">in the screenshot here<\/a>. <\/em> <\/p><\/blockquote>\n\n\n\n<ul class=\"wp-block-list\"><li>Now enter the <strong>&#8220;Entity Code&#8221;<\/strong> of your choice, <em>preferably use the name of the entity in the same for easy identification<\/em>. <br><\/li><li>Enter the <strong>&#8220;API Method&#8221;<\/strong> name obtained from the Sage 100 system, steps mentioned above.<\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/4.Sage-100-Customer-Entity.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.Sage-100-Customer-Entity.png\" alt=\"Sage 100 Customer Entity\"><\/a><\/center>\n<font size=\"2\"><center><i>Sage 100 Customer Entity<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\"><li>Now, go to the <strong>\u201cDetails\u201d<\/strong>\u00a0tab and click on\u00a0<strong>\u201cRefresh fields\u201d<\/strong>\u00a0button to get exact fields available from the Sage system for performing actions (update) from Salesforce. And finally click the\u00a0<strong>\u201cSave\u201d<\/strong>\u00a0button to store the schema information for use in the GUMU&#x2122; mapping functionality. <\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/5.Sage-100-Refresh-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\/2019\/11\/5.Sage-100-Refresh-Fields.png\" alt=\"Sage 100 Refresh Fields\"><\/a><\/center>\n<font size=\"2\"><center><i>Sage 100 Refresh Fields<\/i><\/center><\/font>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><em>Please take a note each time you want additional data from the fields that were added to the schema after the definition was created, you will have to make sure that the Webservice API schema has been updated in Sage and you have hit the <strong>&#8220;Refresh Fields&#8221;<\/strong> button on the <strong>&#8220;Entity Setting&#8221;<\/strong>. For it to be available in the <strong>&#8220;Entity Mapping\/Import&#8221;<\/strong> configuration.<\/em> <\/p><\/blockquote>\n\n\n\n<ul class=\"wp-block-list\"><li>You can also define a primary key for Entity by selecting fields from the list as shown in below screen.<br><\/li><li>If you want to assign a composite key (combination of more than one field as the primary key) to the entity, you can add multiple rows under the Primary Key tab.<br><\/li><li>If you happen to add a primary key by mistake, you can simply check the field and hit \u201cDelete Primary Key\u201d button. <\/li><\/ul>\n\n\n\n\n\n<ul class=\"wp-block-list\"><li>Once configuration is done click on <strong>&#8220;Save&#8221;<\/strong> button to save the entity. <\/li><\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2019\/11\/7.Sage-100-List-Of-Entity.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\/7.Sage-100-List-Of-Entity.png\" alt=\"Sage 100 List Of Entity\"><\/a><\/center>\n<font size=\"2\"><center><i>Sage 100 List Of Entity<\/i><\/center><\/font>\n\n\n\n<p>And here you have your entity created and ready for integration. This entity can now be used in the Import routine for bringing the records into Salesforce from Sage 100 ERP.<\/p>\n\n\n\n<p>We hope you may find this blog resourceful and helpful. If you still have concerns and need more help, please contact us at\u00a0<a href=\"mailto:salesforce@greytrix.com\">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 rel=\"noreferrer noopener\" aria-label=\"GUMU&#x2122; Salesforce Tricks &amp; Tips \u2013 Synching Additional (Order Details) Fields from Salesforce to Sage 100 ERP (opens in a new tab)\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/09\/24\/gumu-salesforce-tricks-tips-synching-additional-order-details-fields-from-salesforce-to-sage-100-erp\/\" target=\"_blank\">GUMU&#x2122; Salesforce Tricks &amp; Tips \u2013 Synching Additional (Order Details) Fields from Salesforce to Sage 100 ERP<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/08\/29\/gumu-salesforce-tricks-tips-synching-additional-order-fields-from-salesforce-to-sage-100-erp\/\" target=\"_blank\">GUMU&#x2122; Salesforce Tricks &amp; Tips \u2013 Synching Additional (Order) Fields from Salesforce to Sage 100 ERP<\/a><br><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/07\/31\/gumu-salesforce-import-routine-tricks-and-facts-about-the-use-of-filter-functionality\/\" target=\"_blank\">GUMU&#x2122; Salesforce Import Routine \u2013 Tricks and Facts about the use of Filter Functionality<\/a><br><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/08\/21\/gumu-salesforce-import-routine-tricks-and-facts-about-creating-relationship-between-entities\/\" target=\"_blank\">GUMU&#x2122; Salesforce Import Routine \u2013 Tricks and Facts about creating Relationship between Entities<\/a> <\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we will discuss how user can create a new Entity (for use in the import routine) in Salesforce using new lightning interface of GUMU&#x2122; &amp; Sage 100 SData API method. The prerequisite of any integration is to map the data between the two systems. GUMU&#x2122;, reads the table schema using Sage 100\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/11\/12\/create-entity-in-gumu-sage-100-integration-lightning-interface\/\">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":[59,112,114,158,162,678,184,188,359,360,361,377,401,679,681,680,716,424,430],"class_list":["post-5259","post","type-post","status-publish","format-standard","hentry","category-gumu-salesforce","tag-create-entity","tag-entity","tag-entity-setting","tag-gumu-settings","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\/5259","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=5259"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/5259\/revisions"}],"predecessor-version":[{"id":5274,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/5259\/revisions\/5274"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=5259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=5259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=5259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}