{"id":9863,"date":"2024-11-15T07:37:29","date_gmt":"2024-11-15T07:37:29","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=9863"},"modified":"2025-09-18T06:43:55","modified_gmt":"2025-09-18T06:43:55","slug":"automatically-update-last-sync-date-field-in-entity-mapping","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/11\/15\/automatically-update-last-sync-date-field-in-entity-mapping\/","title":{"rendered":"GUMU&#x2122; Feature: Auto Update the Last Sync Date field in Entity Mapping\/Import after the import routine successfully runs"},"content":{"rendered":"\n<p>In this blog post, we&#8217;ll walk through a solution that automatically updates the <strong>Last Sync Date<\/strong> field in <strong>Entity Mapping\/Import<\/strong> after the import routine successfully runs. This update is based on the value in the <strong>&#8220;Update_Last_Sync_by_Days__c&#8221;<\/strong> field, which allows users to add a specified number of days to the current sync date and reflect as the <strong>Last Sync Date<\/strong> field in <strong>Entity Mapping<\/strong>.<\/p>\n\n\n\n<p>For instance, if the user inputs <strong>&#8220;10&#8221;<\/strong> in the <strong>Update_Last_Sync_by_Days__c<\/strong> field and the current <strong>Last Sync Date<\/strong> is <strong>&#8220;2023-11-01&#8221; <\/strong>after the import routine completes successfully, the new <strong>Last Sync Date<\/strong> will be automatically updated to <strong>&#8220;2023-11-11&#8221;<\/strong>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\"><em>Prerequisites<\/em><\/mark><\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Make sure the Entity Mapping \/ Import should be created in your Salesforce environment.<\/li>\n\n\n\n<li>Select the Last Sync Field:\n<ul class=\"wp-block-list\">\n<li>Make sure you have the correct Last Sync field specified.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Enter the Last Sync Value:\n<ul class=\"wp-block-list\">\n<li>Just input the current Last Sync value that you&#8217;d like to update.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><em><span style=\"text-decoration: underline;\">Last Sync Date field in Entity Mapping<\/span><\/em><\/strong><\/h4>\n\n\n\n<p>To Update the Last Sync Date field in Entity Mapping after it runs successfully, follow the below steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enter the number of days you wish to add in the <strong>Update Last Sync by Days<\/strong> field.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/11\/1.-Enter-value-Update-Last-Sync-By-Days.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\/11\/1.-Enter-value-Update-Last-Sync-By-Days.png\" alt=\"Update Last Sync By Days field in Entity Mapping\/Import\"><\/a><\/center><font size=\"2\"><center><i> Update Last Sync By Days field in Entity Mapping\/Import<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the <strong>Sync Now<\/strong> button to initiate the update to Last Sync Date field in Entity Mapping.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/11\/2.-Sync-Now.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\/11\/2.-Sync-Now.png\" alt=\"Sync Now\"><\/a><\/center><font size=\"2\"><center><i> Sync Now <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Refresh the Import Routine and check that the new date has been added to the Last Sync Value based on the number of days you entered and thus an update to Last Sync Date field in Entity Mapping happens.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/11\/3.-Verify-the-Update.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\/11\/3.-Verify-the-Update.png\" alt=\"Verifying the update date value\"><\/a><\/center><font size=\"2\"><center><i> Verifying the update date value <\/i><\/center><\/font>\n\n\n\n<p>By following the above blog instructions, you will be able to learn the new GUMU&#x2122; Feature: &#8220;<strong><em>Automatically update the Last Sync Date field in Entity Mapping\/Import after the import routine successfully runs<\/em><\/strong>&#8220;. <\/p>\n\n\n\n<p>If you still have questions or problems related to the product or details shared above, please contact us at <a href=\"mailto:salesforce@greytrix.com\" target=\"_blank\" rel=\"noreferrer noopener\">salesforce@greytrix.com<\/a>. More information about the Product is available on <a href=\"https:\/\/www.greytrix.com\/product\/gumu\/salesforce-sage-erp-integration\" 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 will find this blog resourceful and helpful. However, if you still have concerns and need more help, please get in touch with us at <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 Post<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/09\/28\/how-to-import-data-from-sage-300-erp-to-salesforce-using-the-last-sync-field-and-last-sync-value\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to import data from Sage 300 ERP to Salesforce using the Last Sync field and Last Sync value<\/a><\/li>\n\n\n\n<li><a 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\" rel=\"noreferrer noopener\">GUMU&#x2122; Salesforce Import Routine \u2013 Tricks and Facts about the Use of Filter Functionality<\/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\/2024\/08\/27\/gumu-feature-use-filters-in-import-functionality\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Feature \u2013 Use Filters in Import functionality<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/05\/11\/gumu-features-import-or-export-entity-mapping-in-sync-routines-using-gumu-lighting-interface\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Features \u2013 Import or Export Entity Mapping in Sync routines using GUMU&#x2122; Lighting Interface<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In this blog post, we&#8217;ll walk through a solution that automatically updates the Last Sync Date field in Entity Mapping\/Import after the import routine successfully runs. This update is based on the value in the &#8220;Update_Last_Sync_by_Days__c&#8221; field, which allows users to add a specified number of days to the current sync date and reflect as\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/11\/15\/automatically-update-last-sync-date-field-in-entity-mapping\/\">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":[1874,1866,67,1868,1873,1882,1877,1870,113,781,1864,125,1869,638,159,162,163,164,1732,1883,165,169,801,1884,678,1876,181,789,1871,184,185,187,188,189,1863,1886,1865,1880,745,321,327,1734,736,340,739,347,747,359,360,361,730,732,731,364,367,370,374,377,378,1709,744,740,738,746,743,389,400,401,402,737,679,671,683,681,733,687,680,686,684,716,424,425,734,430,735,454,1733,461,463,1872,1875,1881,1887,1867,1879,1862],"class_list":["post-9863","post","type-post","status-publish","format-standard","hentry","category-gumu-features","category-gumu-salesforce","tag-automated-workflow","tag-automation","tag-custom-fields","tag-data-integration","tag-data-sync","tag-data-update","tag-date-adjustment","tag-date-calculation","tag-entity-mapping","tag-entity-mapping-import","tag-entity-mapping-import-2","tag-field-mapping","tag-field-update","tag-gumu-integration","tag-gumu-sf-integration","tag-gumusfsage100","tag-gumusfsage100erp","tag-gumusfsage300","tag-gumusfsage300c","tag-gumusfsage300cerp","tag-gumusfsage300erp","tag-gumusfsageerpx3","tag-gumusfsagex3","tag-gumusfsagex3erp","tag-gumulightninginterface","tag-import-configuration","tag-import-data","tag-import-routine","tag-import-success","tag-integrate-salesforce-with-sage-100","tag-integrate-salesforce-with-sage-300","tag-integrate-salesforce-with-sage-x3","tag-integrate-sfdc-and-sage-100","tag-integrate-sfdc-and-sage-300","tag-last-sync-date","tag-last-sync-date-field","tag-number-of-days","tag-process-automation","tag-sage-100-connector-with-salesforce","tag-sage-100-erp","tag-sage-300-erp","tag-sage-300c-connector-with-salesforce","tag-sage-300c-erp","tag-sage-erp","tag-sage-erp-connector-with-salesforce","tag-sage-erp-x3","tag-sage-x3-connector-with-salesforce","tag-sage100","tag-sage100-salesforce","tag-sage100-sf","tag-sage300c","tag-sage300c-salesforce","tag-sage300c-sf","tag-sagex3","tag-salesforce","tag-salesforce-sage-300","tag-salesforce-sage-x3","tag-salesforce-and-sage-100-integration","tag-salesforce-and-sage-300-integration","tag-salesforce-automation","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-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-300c","tag-sfdc-with-sage-300-integration","tag-sfdc-with-sage-x3-integration","tag-sync-automation","tag-sync-date-logic","tag-sync-logic","tag-sync-now-button","tag-sync-process","tag-system-integration","tag-update-last-sync-by-days"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/9863","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=9863"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/9863\/revisions"}],"predecessor-version":[{"id":9869,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/9863\/revisions\/9869"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=9863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=9863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=9863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}