{"id":11854,"date":"2025-11-28T09:37:09","date_gmt":"2025-11-28T09:37:09","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=11854"},"modified":"2025-11-25T09:40:37","modified_gmt":"2025-11-25T09:40:37","slug":"auto-update-the-last-sync-value-to-current-date-in-entity-mapping-import-tab","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2025\/11\/28\/auto-update-the-last-sync-value-to-current-date-in-entity-mapping-import-tab\/","title":{"rendered":"Auto Update the Last Sync Value to Current Date in Entity Mapping\/Import tab"},"content":{"rendered":"\n<p>Keeping your Salesforce org in sync with your ERP data shouldn\u2019t require manual effort every time. With our GUMU&#x2122; Settings App enhancement, users can now automatically update the <strong>Last Sync Value<\/strong> for any import routine, making incremental syncs smoother, faster, and more reliable.<\/p>\n\n\n\n<p>In the <strong>GUMU&#x2122; Settings App \u2192 Entity Mapping \/ Import<\/strong> tab, each import routine has a <strong>Last Sync Value<\/strong> field that controls the starting date for the next sync. With this feature enabled, you can set the system to automatically update this date to <strong>today\u2019s date<\/strong> during the next sync run, removing the need for manual updates.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">How It Works<\/mark><\/strong><\/h2>\n\n\n\n<p>To automatically update the Last Sync Value to the current date, follow the steps below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the <strong>Edit<\/strong> button next to any import routine in the Entity Mapping \/ Import tab.<\/li>\n\n\n\n<li>Choose the correct <strong>Last Sync Field<\/strong> (e.g., <em>DateUpdated<\/em>).<\/li>\n\n\n\n<li>Set the <strong>Last Sync Value<\/strong> to any date from which you want the sync to begin.\n<ul class=\"wp-block-list\">\n<li>Set <strong>Update Last Sync by Days = 0<\/strong> and click <strong>Save<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2025\/11\/1.jpg\" 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\/2025\/11\/1.jpg\" alt=\"Update Last Sync by Days Field\"><\/a><\/center><font size=\"2\"><center><i>Update Last Sync by Days Field<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the <strong>Sync Now<\/strong> button.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2025\/11\/2.jpg\" 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\/2025\/11\/2.jpg\" alt=\"Sync Now Button\"><\/a><\/center><font size=\"2\"><center><i>Sync Now Button<\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once the sync runs, the <strong>Last Sync Value<\/strong> will automatically update to today\u2019s date.<\/li>\n\n\n\n<li>Refresh your browser, navigate back to the Import Routine, and confirm that the Last Sync Value now reflects the current date.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2025\/11\/3.jpg\" 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\/2025\/11\/3.jpg\" alt=\"Last Sync Value Field\"><\/a><\/center><font size=\"2\"><center><i>Last Sync Value Field<\/i><\/center><\/font>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">Why This Matters<\/mark><\/strong><\/h2>\n\n\n\n<p>\u2022 Eliminates manual updates to the Last Sync Date<br>\u2022 Ensures the latest data is always imported<br>\u2022 Reduces unnecessary load on Apex Jobs<br>\u2022 Prevents full data pulls unless intentionally performed<br>\u2022 Enables smooth, consistent, incremental syncs<\/p>\n\n\n\n<p>By keeping the <strong>Update Last Sync by Days<\/strong> field at <strong>0<\/strong>, users ensure that Salesforce stays up to date without extra effort and without adding unnecessary strain to the system.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">Conclusion<\/mark><\/strong><\/h2>\n\n\n\n<p>Automating the Last Sync Value update in the GUMU&#x2122; Settings App helps Salesforce users maintain accurate and up-to-date ERP data without manual effort. By setting Update Last Sync by Days = 0, the system intelligently updates the Last Sync Value to the current date after every sync, ensuring smoother incremental imports and improved performance. This feature not only saves time but also reduces system load and prevents unnecessary full data pulls.<\/p>\n\n\n\n<p>By following the above blog instructions, you will be able to learn <strong>Auto Update the Last Sync Value to Current Date in Entity Mapping\/Import tab<\/strong>. If you still have queries or any related problems, don\u2019t hesitate to contact us at <a href=\"mailto:salesforce@greytrix.com\" target=\"_blank\" rel=\"noreferrer noopener\">salesforce@greytrix.com<\/a>. More details about our integration product are available on <a href=\"https:\/\/www.greytrix.com\/salesforce-cloud-services\/sage-intacct-integration\/\" target=\"_blank\" rel=\"noreferrer noopener\">our website<\/a> and <a href=\"https:\/\/appexchange.salesforce.com\/appxListingDetail?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 <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\/11\/15\/automatically-update-last-sync-date-field-in-entity-mapping\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Feature: Auto Update the Last Sync Date field in Entity Mapping\/Import after the import routine successfully runs<\/a><\/li>\n\n\n\n<li><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\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to automate updation of Last Sync Value field using a flow in GUMU&#x2122;<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/11\/15\/automatically-update-last-sync-date-field-in-entity-mapping\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Feature: Auto Update the Last Sync Date field in Entity Mapping\/Import after the import routine successfully runs<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Keeping your Salesforce org in sync with your ERP data shouldn\u2019t require manual effort every time. With our GUMU&#x2122; Settings App enhancement, users can now automatically update the Last Sync Value for any import routine, making incremental syncs smoother, faster, and more reliable. In the GUMU&#x2122; Settings App \u2192 Entity Mapping \/ Import tab, each\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2025\/11\/28\/auto-update-the-last-sync-value-to-current-date-in-entity-mapping-import-tab\/\">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,3],"tags":[2528,2532,2540,2529,2534,159,162,163,1732,165,169,678,187,188,189,1734,739,747,361,730,732,731,364,367,374,2539,389,2537,2541,2530,2533,2535,2531,684,716,2536,1733,463,2538,1862],"class_list":["post-11854","post","type-post","status-publish","format-standard","hentry","category-gumu-features","category-salesforce-srv","tag-auto-update-last-sync-value-salesforce","tag-entity-mapping-salesforce","tag-gumu-erp-integration","tag-gumu-salesforce-integration","tag-gumu-settings-app","tag-gumu-sf-integration","tag-gumusfsage100","tag-gumusfsage100erp","tag-gumusfsage300c","tag-gumusfsage300erp","tag-gumusfsageerpx3","tag-gumulightninginterface","tag-integrate-salesforce-with-sage-x3","tag-integrate-sfdc-and-sage-100","tag-integrate-sfdc-and-sage-300","tag-sage-300c-connector-with-salesforce","tag-sage-erp-connector-with-salesforce","tag-sage-x3-connector-with-salesforce","tag-sage100-sf","tag-sage300c","tag-sage300c-salesforce","tag-sage300c-sf","tag-sagex3","tag-salesforce","tag-salesforce-sage-x3","tag-salesforce-apex-jobs-optimization","tag-salesforce-crm-integration-for-sage-erp","tag-salesforce-data-synchronization","tag-salesforce-dateupdated-field","tag-salesforce-erp-sync","tag-salesforce-import-routine","tag-salesforce-incremental-sync","tag-salesforce-last-sync-date-update","tag-salesforce-lightning-sagex3-integration","tag-salesforce-sage-integration","tag-salesforce-sync-automation","tag-sfdc-integration-with-sage-300c","tag-sfdc-with-sage-x3-integration","tag-sync-now-button-salesforce","tag-update-last-sync-by-days"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/11854","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=11854"}],"version-history":[{"count":9,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/11854\/revisions"}],"predecessor-version":[{"id":11863,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/11854\/revisions\/11863"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=11854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=11854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=11854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}