{"id":7936,"date":"2024-02-12T07:21:49","date_gmt":"2024-02-12T07:21:49","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=7936"},"modified":"2024-08-26T06:01:07","modified_gmt":"2024-08-26T06:01:07","slug":"how-to-automate-updation-of-last-sync-value-field-using-a-flow-in-gumu","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/02\/12\/how-to-automate-updation-of-last-sync-value-field-using-a-flow-in-gumu\/","title":{"rendered":"How to automate updation of Last Sync Value field using a flow in GUMU&#x2122;"},"content":{"rendered":"\n<p>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. <\/p>\n\n\n\n<p>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.<\/p>\n\n\n\n<p>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.<\/p>\n\n\n\n<p>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.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><em>Prerequisites<\/em><\/strong><\/h4>\n\n\n\n<p>Prior to the installation of the flow, make sure that the following prerequisites have been satisfied to automate updation of Last Sync Value.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Login to Salesforce org.<\/li>\n\n\n\n<li>Go to App Launcher and Search \u2018GUMU Settings\u2019.<\/li>\n\n\n\n<li>Select the \u201cEntity Mapping\/Import\u201d tab.<\/li>\n\n\n\n<li>To ensure the proper functioning of the flow, it is mandatory to fill in the &#8216;Last Sync Field&#8217; within the Entity Mapping<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/02\/1.Entity-Mapping-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\/2024\/02\/1.Entity-Mapping-Screen.png\" alt=\"Entity Mapping Screen\"><\/a><\/center>\n<font size=\"2\"><center><i>Entity Mapping Scree <\/i><\/center><\/font>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><em>Automate updation of Last Sync Value field<\/em><\/strong><\/h4>\n\n\n\n<p>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.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/02\/2.-Flow-package-installation-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\/2024\/02\/2.-Flow-package-installation-screen.png\" alt=\"Flow Package installation screen\"><\/a><\/center>\n<font size=\"2\"><center><i> Flow Package installation screen<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Access the Quick Find box and look for Custom Settings. Proceed to Standard Settings and select edit.<\/li>\n\n\n\n<li>Locate the Last Sync Day field, and enter the preferred number of days for data import.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Note: <\/strong>The field determines the days by which the data will be imported on a daily basis.<\/p>\n<\/blockquote>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/02\/3.Custom-Settings-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\/2024\/02\/3.Custom-Settings-screen.png\" alt=\"Custom Settings screen\"><\/a><\/center>\n<font size=\"2\"><center><i> Custom Settings screen <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate to Setup.<\/li>\n\n\n\n<li>Type \u201cFlows\u201d in Quick Find and click on Flows. Choose &#8220;Last Sync Day Update&#8221; from the available list of flows. <\/li>\n\n\n\n<li>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.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/02\/4.-Schedule-Trigger-Flow.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\/2024\/02\/4.-Schedule-Trigger-Flow.png\" alt=\"Schedule Trigger Flow\"><\/a><\/center>\n<font size=\"2\"><center><i> Schedule Trigger Flow<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>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&#8217;s date is <strong><em>January 3, 2024<\/em><\/strong>, and the Last Sync field in standard settings contains 5, then the Last Sync field will be set to <strong><em>December 28, 2023<\/em><\/strong>, through this flow.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/02\/5.-Last-Sync-value-updation.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\/2024\/02\/5.-Last-Sync-value-updation.png\" alt=\"automate updation of Last Sync Value field\"><\/a><\/center>\n<font size=\"2\"><center><i> Last Sync value updation<\/i><\/center><\/font>\n\n\n\n<p>By following the above blog instructions, you will be able to learn about the newly added feature &#8220;<strong><em>How to automate updation of Last Sync Value field using a flow in GUMU\u201c<\/em><\/strong> <\/p>\n\n\n\n<p>More details about the product are available on <a href=\"https:\/\/www.greytrix.com\/salesforce\/salesforce-integration\/\" data-type=\"URL\" target=\"_blank\" rel=\"noreferrer noopener\">our website<\/a> and <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\u00a0<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\">\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/12\/27\/import-data-from-erp-to-salesforce-in-sage-x3-using-last-sync-field-and-value\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2017\/12\/27\/import-data-from-erp-to-salesforce-in-sage-x3-using-last-sync-field-and-value\/\">Import Data From ERP to Salesforce in Sage X3 using Last Sync field and value<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2019\/09\/10\/gumu-features-security-matrix-in-salesforce-lightning-interface\/\" target=\"_blank\" rel=\"noreferrer noopener\">Security Matrix in Salesforce<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/01\/27\/gumu-salesforce-tricks-tips-scheduling-import-routines-in-gumu-lighting-interface\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Salesforce Tricks &amp; Tips \u2013 Scheduling Import Routines in GUMU&#x2122; Lighting Interface<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2021\/01\/13\/promote-quote-from-salesforce-sage-100-integration-using-gumu-lightning-version\/\" target=\"_blank\" rel=\"noreferrer noopener\">Promote Quote from Salesforce \u2013 Sage 100 Integration using GUMU&#x2122; lightning version<\/a><\/li>\n\n\n\n<li><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/02\/12\/how-to-automate-updation-of-last-sync-value-field-using-a-flow-in-gumu\/\">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],"tags":[159,162,163,164,165,166,169,678,184,185,186,187,188,189,736,739,359,360,361,730,732,731,363,364,367,370,372,374,377,378,744,740,738,746,743,389,400,401,402,737,679,671,683,681,673,733,687,680,686,684,716,424,425,734,430,735,454,458,461,462,463],"class_list":["post-7936","post","type-post","status-publish","format-standard","hentry","category-gumu-features","category-gumu-salesforce","tag-gumu-sf-integration","tag-gumusfsage100","tag-gumusfsage100erp","tag-gumusfsage300","tag-gumusfsage300erp","tag-gumusfsageem","tag-gumusfsageerpx3","tag-gumulightninginterface","tag-integrate-salesforce-with-sage-100","tag-integrate-salesforce-with-sage-300","tag-integrate-salesforce-with-sage-em","tag-integrate-salesforce-with-sage-x3","tag-integrate-sfdc-and-sage-100","tag-integrate-sfdc-and-sage-300","tag-sage-300c-erp","tag-sage-erp-connector-with-salesforce","tag-sage100","tag-sage100-salesforce","tag-sage100-sf","tag-sage300c","tag-sage300c-salesforce","tag-sage300c-sf","tag-sageem","tag-sagex3","tag-salesforce","tag-salesforce-sage-300","tag-salesforce-sage-em","tag-salesforce-sage-x3","tag-salesforce-and-sage-100-integration","tag-salesforce-and-sage-300-integration","tag-salesforce-connector-for-sage-100","tag-salesforce-connector-for-sage-300","tag-salesforce-connector-for-sage-erp","tag-salesforce-connector-for-sage-x3","tag-salesforce-connector-with-sage-erp","tag-salesforce-crm-integration-for-sage-erp","tag-salesforce-integration-with-sage","tag-salesforce-integration-with-sage-100","tag-salesforce-integration-with-sage-300","tag-salesforce-lightning-sage300c-integration","tag-salesforce-lightning-and-sage-100-integration","tag-salesforce-lightning-and-sage-300-integration","tag-salesforce-lightning-and-sagex3-integration","tag-salesforce-lightning-integration-with-sage-100","tag-salesforce-lightning-integration-with-sage-300","tag-salesforce-lightning-integration-with-sage-300c","tag-salesforce-lightning-integration-with-sagex3","tag-salesforce-lightning-sage100-integration","tag-salesforce-lightning-sage300-integration-2","tag-salesforce-lightning-sagex3-integration","tag-salesforce-sage-integration","tag-salesforce-with-sage-100-integration","tag-salesforce-with-sage-300-integration","tag-salesforce-with-sage-300c-integration","tag-salesforce-sage100","tag-salesforce-sage300c","tag-sfdc-sage-300","tag-sfdc-integration-with-sage-300","tag-sfdc-with-sage-300-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\/7936","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=7936"}],"version-history":[{"count":8,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/7936\/revisions"}],"predecessor-version":[{"id":9275,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/7936\/revisions\/9275"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=7936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=7936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=7936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}