Entity Setup

Create Entity in GUMU™ SAGE 100 Integration – Lightning Interface.

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.

  • You can create a new entity by clicking on “New Entity” button.

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.

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.

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.

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.