Create Entity in GUMU™ SAGE 100 Integration – Lightning Interface

By | November 12, 2019

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™ & Sage 100 SData API method.

The prerequisite of any integration is to map the data between the two systems. GUMU™, reads the table schema using Sage 100 SData API method and validate mapping details like field name, field label, data type that you can see under the mapping tab of the Import.

Let’s walk you through the process of creating a new entity and get the real-time schema of ERP object. Once you have installed the GUMU™ integration product in your Salesforce organization follow the below steps:

  • Login to Salesforce.
  • Go to App Launcher Menu and select “GUMU Settings” App.
  • Click on “Entity Setting” menu.
Sage 100 Entity Setting
Sage 100 Entity Setting
  • You can create a new entity by clicking on “New Entity” button.
Sage 100 New Entity
Sage 100 New Entity

If you want to find Sage 100 SData API method, just follow the mentioned below steps:-
• Open a new Internet Explorer window.

• Enter the URL as http://<machine name which has the SData installed in its IIS>/SData/MasApp/MasContract/<company name>/$Schema.You can refer our video 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
If you need to search for a Web Service API method (ex:-customer) just filter it out in the web page as shown in the screenshot here.

  • Now enter the “Entity Code” of your choice, preferably use the name of the entity in the same for easy identification.
  • Enter the “API Method” name obtained from the Sage 100 system, steps mentioned above.
Sage 100 Customer Entity
Sage 100 Customer Entity
  • Now, go to the “Details” tab and click on “Refresh fields” button to get exact fields available from the Sage system for performing actions (update) from Salesforce. And finally click the “Save” button to store the schema information for use in the GUMU™ mapping functionality.
Sage 100 Refresh Fields
Sage 100 Refresh Fields

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 “Refresh Fields” button on the “Entity Setting”. For it to be available in the “Entity Mapping/Import” configuration.

  • You can also define a primary key for Entity by selecting fields from the list as shown in below screen.
  • 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.
  • If you happen to add a primary key by mistake, you can simply check the field and hit “Delete Primary Key” button.
  • Once configuration is done click on “Save” button to save the entity.
Sage 100 List Of Entity
Sage 100 List Of Entity

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.

We hope you may find this blog resourceful and helpful. If you still have concerns and need more help, please contact us at

About Us
Greytrix – 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.

Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3Sage 100 and Sage 300 (Sage Accpac). 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.

The GUMU™ 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.

For more information on our Salesforce products and services, contact us at We will be glad to assist you.

Related Posts