{"id":9520,"date":"2024-09-28T09:14:45","date_gmt":"2024-09-28T09:14:45","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=9520"},"modified":"2024-09-30T08:40:51","modified_gmt":"2024-09-30T08:40:51","slug":"how-to-import-data-from-sage-300-erp-to-salesforce-using-the-last-sync-field-and-last-sync-value","status":"publish","type":"post","link":"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\/","title":{"rendered":"How to import data from Sage 300 ERP to Salesforce using the Last Sync field and Last Sync value"},"content":{"rendered":"\n<p>In this blog, we will explore how to import data from Sage 300 ERP to Salesforce using the <strong>Last Sync Field<\/strong> and <strong>Last Sync Value<\/strong> features. <\/p>\n\n\n\n<p>GUMU&#x2122; for Salesforce is a real-time, bi-directional integration that allows users to sync data between Salesforce and Sage ERP seamlessly. <\/p>\n\n\n\n<p>To import data from Sage 300 ERP to Salesforce using the <strong>Last Sync field<\/strong> and <strong>Last Sync value<\/strong> features, the process ensures that only new or updated records since the last synchronization are imported. The <strong>Last Sync Field<\/strong> tracks when a record was last modified or synced, and the <strong>Last Sync Value<\/strong> stores the most recent sync timestamp between Sage 300 and Salesforce.<\/p>\n\n\n\n<p>During each data transfer, Sage 300 compares the record timestamps with the <strong>Last Sync Value<\/strong> in Salesforce. Only the records created or updated after the last sync date are imported, avoiding redundant data transfers. After each sync, the <strong>Last Sync Value<\/strong> is updated to the current date and time, streamlining future imports and ensuring data accuracy. This works like kind of filter to the import data from Sage 300 ERP to Salesforce using the Last Sync field and Last Sync value.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><em><span style=\"text-decoration: underline;\">Import data from Sage 300 ERP to Salesforce using the Last Sync Field and Last Sync Value Features<\/span><\/em><\/strong><\/h4>\n\n\n\n<p>Below are the steps to be followed to import data from Sage 300 ERP to Salesforce using the Last Sync field and Last Sync value.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Log in to Salesforce.<\/li>\n\n\n\n<li>Go to the App Launcher, choose the \u201cGUMU Settings\u201d app from the list, and navigate to the Entity Mapping\/Import tab. The following page will appear:<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/09\/GUMU-Settings-Entity-Mapping.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\/09\/GUMU-Settings-Entity-Mapping.png\" alt=\"GUMU Settings - Entity Mapping\/Import\"><\/a><\/center><font size=\"2\"><center><i> GUMU Settings &#8211; Entity Mapping\/Import <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on&nbsp;the import routine you wish to set the date value.&nbsp;menu to view the entity list page.<\/li>\n\n\n\n<li>Click on the <strong>\u201cEdit\u201d<\/strong>&nbsp;button and then &#8220;Refresh Fields&#8221; button.<\/li>\n\n\n\n<li>Select the&nbsp;<strong>\u201cLast Sync field\u201d<\/strong>&nbsp;value from drop down, which shows all the fields of Sage 300 related to that API name.<\/li>\n\n\n\n<li>Enter the&nbsp;<strong>\u201cLast Sync Value\u201d<\/strong>&nbsp;as shown in the image below. This will allow you to add a filter to Import data from Sage 300 ERP to Salesforce using the Last Sync Field and Last Sync Value.<\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/09\/Last-sync-field-and-value.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\/09\/Last-sync-field-and-value.png\" alt=\"Import data from Sage 300 ERP to Salesforce using the Last Sync Field and Last Sync Value\"><\/a><\/center><font size=\"2\"><center><i> Last Sync Field and Last Sync Value <\/i><\/center><\/font>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finally, save the changes.<\/li>\n\n\n\n<li>As shown in the above image Last Sync field is <strong>\u2018DateLastMaintained\u2019 <\/strong>and the Last Sync Value is \u2018<strong>2024-07-01<\/strong>\u2019, so while the import routine runs the records that have a <strong>DateLastMaintained<\/strong> value and are greater than 2024-07-01 records will be imported into Salesforce.<\/li>\n\n\n\n<li>To check the records before syncing from Sage 300, use the <strong>&#8220;Preview&#8221; <\/strong>button and then continue with the import process. <\/li>\n<\/ul>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-content\/uploads\/2024\/09\/Previewed-data.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\/09\/Previewed-data.png\" alt=\"Previewed Data\"><\/a><\/center><font size=\"2\"><center><i> Previewed Data <\/i><\/center><\/font>\n\n\n\n\n<ul class=\"wp-block-list\">\n<li>Thus, the filter to Import data from Sage 300 ERP to Salesforce using the Last Sync Field and Last Sync Value is validated.<\/li>\n<\/ul>\n\n\n\n<p>By following the above blog instructions, you will learn <em><strong>\u201c<\/strong><\/em><strong><em>How to Import data from Sage 300 ERP to Salesforce using the Last Sync field and Last sync value<\/em><\/strong><em><strong>\u201d<\/strong><\/em>. 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>.<\/p>\n\n\n\n<p>More details about the Product are available on <a href=\"https:\/\/www.greytrix.com\/salesforce\/sage-300-integration\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.greytrix.com\/salesforce\/sage-300-integration\/\" 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 <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\/2024\/08\/27\/gumu-feature-use-filters-in-import-functionality\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/08\/27\/gumu-feature-use-filters-in-import-functionality\/\" 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\/2024\/02\/29\/exploring-the-gumu-enhanced-import-routine-process-of-required-parent-field-functionality\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/02\/29\/exploring-the-gumu-enhanced-import-routine-process-of-required-parent-field-functionality\/\" rel=\"noreferrer noopener\">Exploring the enhanced GUMU&#x2122; Import Routine process of \u2018Required Parent Field\u2019 functionality<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2024\/03\/28\/import-product-options-in-salesforce-from-sage-300\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to import Product Options in Salesforce from Sage 300C ERP<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/05\/18\/gumu-salesforce-tricks-tips-synching-additional-order-fields-from-salesforce-to-sage-300-erp\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.greytrix.com\/blogs\/salesforce\/2020\/05\/18\/gumu-salesforce-tricks-tips-synching-additional-order-fields-from-salesforce-to-sage-300-erp\/\" rel=\"noreferrer noopener\">GUMU&#x2122; Salesforce Tricks &amp; Tips \u2013 Synching Additional (Order) Fields from Salesforce to Sage 300 ERP<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we will explore how to import data from Sage 300 ERP to Salesforce using the Last Sync Field and Last Sync Value features. GUMU&#x2122; for Salesforce is a real-time, bi-directional integration that allows users to sync data between Salesforce and Sage ERP seamlessly. To import data from Sage 300 ERP to Salesforce\u2026 <span class=\"read-more\"><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\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":9557,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[956,2,957],"tags":[1752,1732,165,678,1753,185,189,1751,1750,1734,736,739,730,732,731,370,378,740,738,389,402,737,671,733,686,716,425,734,735,454,1733,461],"class_list":["post-9520","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gumu-features","category-gumu-salesforce","category-gumu-tricks-tips","tag-datelastmaintained-sage-300","tag-gumusfsage300c","tag-gumusfsage300erp","tag-gumulightninginterface","tag-import-routine-last-sync-field-and-last-sync-value","tag-integrate-salesforce-with-sage-300","tag-integrate-sfdc-and-sage-300","tag-last-sync-field-value-for-salesforce-sage-300c","tag-last-sync-value-for-300","tag-sage-300c-connector-with-salesforce","tag-sage-300c-erp","tag-sage-erp-connector-with-salesforce","tag-sage300c","tag-sage300c-salesforce","tag-sage300c-sf","tag-salesforce-sage-300","tag-salesforce-and-sage-300-integration","tag-salesforce-connector-for-sage-300","tag-salesforce-connector-for-sage-erp","tag-salesforce-crm-integration-for-sage-erp","tag-salesforce-integration-with-sage-300","tag-salesforce-lightning-sage300c-integration","tag-salesforce-lightning-and-sage-300-integration","tag-salesforce-lightning-integration-with-sage-300c","tag-salesforce-lightning-sage300-integration-2","tag-salesforce-sage-integration","tag-salesforce-with-sage-300-integration","tag-salesforce-with-sage-300c-integration","tag-salesforce-sage300c","tag-sfdc-sage-300","tag-sfdc-integration-with-sage-300c","tag-sfdc-with-sage-300-integration"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/9520","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=9520"}],"version-history":[{"count":5,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/9520\/revisions"}],"predecessor-version":[{"id":9550,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/9520\/revisions\/9550"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media\/9557"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=9520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=9520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=9520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}