How to automate updation of Last Sync Value field using a flow in GUMU™

By | February 12, 2024

In this blog post, we will show you how you can automate updation of Last Sync Value which is available once you are through the process of installing the flow package and fulfilling its prerequisites.

GUMU integration is a powerful tool that allows you to synchronize data between Salesforce and Sage ERP systems. However, if you want to import only a limited amount of data on a daily basis, you need to update the Last Sync Value field manually every time you run the import routines. This can be tedious and time-consuming, especially if you have multiple entities to sync.

The objective is to modify the flow to achieve the desired outcome: synchronizing a restricted set of data into Salesforce daily. This customized functionality will automatically update the LastSyncValue field, ensuring that import routines synchronize a limited amount of data each day.

Fortunately, there is a way to automate updation of Last Sync Value field using a flow in GUMU integration. A flow is a visual tool that lets you automate business processes and logic in Salesforce. By installing the flow package and fulfilling its prerequisites, you can modify the flow to achieve the desired outcome: synchronizing a restricted set of data into Salesforce daily. This customized functionality will automatically update the Last Sync Value field, ensuring that import routines synchronize a limited amount of data each day.

Prerequisites

Prior to the installation of the flow, make sure that the following prerequisites have been satisfied to automate updation of Last Sync Value.

  • Login to Salesforce org.
  • Go to App Launcher and Search ‘GUMU Settings’.
  • Select the “Entity Mapping/Import” tab.
  • To ensure the proper functioning of the flow, it is mandatory to fill in the ‘Last Sync Field’ within the Entity Mapping
Entity Mapping Screen
Entity Mapping Scree

Automate updation of Last Sync Value field

To proceed with the installation of flow, install the package by using the provided. And follow the steps mentioned below to automate updation of Last Sync Value.

Flow Package installation screen
Flow Package installation screen
  • Access the Quick Find box and look for Custom Settings. Proceed to Standard Settings and select edit.
  • Locate the Last Sync Day field, and enter the preferred number of days for data import.

Note: The field determines the days by which the data will be imported on a daily basis.

Custom Settings screen
Custom Settings screen
  • Navigate to Setup.
  • Type “Flows” in Quick Find and click on Flows. Choose “Last Sync Day Update” from the available list of flows.
  • To set a daily update for the last sync value, the user should edit the flow to adjust the date and time according to their preferences. This will allow user to automate updation of Last Sync Value field.
Schedule Trigger Flow
Schedule Trigger Flow
  • Verify the Last Sync Value for instances where the Last Sync Field is not empty. If a Last Sync value is present, it will be updated. For instance, if today’s date is January 3, 2024, and the Last Sync field in standard settings contains 5, then the Last Sync field will be set to December 28, 2023, through this flow.
automate updation of Last Sync Value field
Last Sync value updation

By following the above blog instructions, you will be able to learn about the newly added feature “How to automate updation of Last Sync Value field using a flow in GUMU“

More details about the product are available on our website and Salesforce AppExchange.

We hope you may find this blog resourceful and helpful. However, if you still have concerns and need more help, please contact us at salesforce@greytrix.com.

Related Posts