{"id":4560,"date":"2013-10-19T12:49:24","date_gmt":"2013-10-19T12:49:24","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=4560"},"modified":"2025-10-08T11:19:14","modified_gmt":"2025-10-08T11:19:14","slug":"item-master-auto-synchronization-between-two-systems","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/","title":{"rendered":"Item Master Auto Synchronization between Two Systems"},"content":{"rendered":"

Consider a business where an actual inventory data is collected through web \/ecommerce system which as a different ERP integrated with it other than Sage. How difficult it would be to keep the Inventory Masters of these 2 different ERPs synchronized when they are not integrated with each other. Users will have to manually maintain the data either in CSV file or Excel sheet. And finally at the end of the day, all these data need to be moved to Sage 300 ERP System. The result is a heterogeneous set of software applications requiring data sharing.
\nTo synchronize all these items (collected from web) with Sage 300 ERP, there are many ways but we have chosen a simplest method that will help user to synchronize both the system more quickly & efficiently.
\nLet see how it works:
\nTo move data from excel\/CSV sheet (collected from web portal) to Sage 300 ERP System, we have developed a routine i.e. \u201cItem master import routine\u201d which will create the below mentioned master data in Sage 300 ERP.
\n1.\u00a0IC => Item Master
\n2.\u00a0IC=>\u00a0 Item Pricing
\n3.\u00a0IC => Location Details
\n4.\u00a0IC => Vendor Details
\nFor this, we simply provide an installable file, which can be started on a single click. The following screen will appear;
\nThe New Stuff:\u00a0 <\/em><\/span><\/strong>How to set default reserved quantity in Sage 300 ERP<\/a><\/p>\n

\"Item<\/a><\/p>\n

a)\u00a0Select Excel File: User has to browse the path, wherein they keep the Excel sheet to perform the import routine in Sage 300 ERP system.
\nb)\u00a0Once the correct excel file is selected, click on Import to perform the import routine in Sage 300 ERP system.
\nNote:<\/strong> The excel sheet header once prepared by mutual consideration between company and client, the data on the excel sheet must be entered and arranged in a proper order as provided to the user. Similarly it will be applicable for csv file.
\nFor example suppose the excel sheet header prepared as shown in the following table:\u00a0\"Excel\"
\nHere in the table, the headers are item number, structure code, Sage Category Code and so on up to the Taxes. Once the header of excel sheet prepared, during data entry its position must not be changed.
\nThe user has to enter data for Item number like MT-12993, MT-12994 and so on.
\nSimilarly the user has to enter data for structure Code like ITM, etc.
\nThe specialty of this Add -on is that, it does not only import items in the item master, but also import the required information of item such as Vendor details, Item Pricing, Location details, and Taxes on those items. This product is also not only used for importing the items but also for updating the items and its required fields in Sage 300 ERP System.
\nThus this Add-on reduces the heavy work load of entering each data in the Sage 300 ERP System, and also save the time of the user.
\nAlso read:<\/strong><\/span>
\n1.\u00a0Custom Bills of Material Report for Sage 300 ERP 2012<\/a>
\n2.\u00a0POS Sage 300 ERP Integration<\/a>
\n3.\u00a0Export Items with Criteria on Optional Fields<\/a>
\n4.\u00a0Location Grouping in GreyMatrix for Sage 300 ERP<\/a>
\n5.\u00a0Adjustment Entry in Inventory Control<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Consider a business where an actual inventory data is collected through web \/ecommerce system which as a different ERP integrated with it other than Sage. How difficult it would be to keep the Inventory Masters of these 2 different ERPs synchronized when they are not integrated with each other. Users will have to manually maintain\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[1279,1413,1430,2357,2999],"class_list":["post-4560","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-import-routine","tag-item-pricing","tag-items","tag-sage-300-erp","tag-vendor-details"],"yoast_head":"\nItem Master Auto Synchronization between Two Systems - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Item Master Auto Synchronization between Two Systems - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Consider a business where an actual inventory data is collected through web \/ecommerce system which as a different ERP integrated with it other than Sage. How difficult it would be to keep the Inventory Masters of these 2 different ERPs synchronized when they are not integrated with each other. Users will have to manually maintain\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-19T12:49:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-08T11:19:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/10\/Item-Import.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/\",\"name\":\"Item Master Auto Synchronization between Two Systems - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/10\/Item-Import.jpg\",\"datePublished\":\"2013-10-19T12:49:24+00:00\",\"dateModified\":\"2025-10-08T11:19:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/10\/Item-Import.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/10\/Item-Import.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Item Master Auto Synchronization between Two Systems\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Item Master Auto Synchronization between Two Systems - Sage 300 ERP \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/","og_locale":"en_US","og_type":"article","og_title":"Item Master Auto Synchronization between Two Systems - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Consider a business where an actual inventory data is collected through web \/ecommerce system which as a different ERP integrated with it other than Sage. How difficult it would be to keep the Inventory Masters of these 2 different ERPs synchronized when they are not integrated with each other. Users will have to manually maintain\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-10-19T12:49:24+00:00","article_modified_time":"2025-10-08T11:19:14+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/10\/Item-Import.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/","name":"Item Master Auto Synchronization between Two Systems - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/10\/Item-Import.jpg","datePublished":"2013-10-19T12:49:24+00:00","dateModified":"2025-10-08T11:19:14+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/10\/Item-Import.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/10\/Item-Import.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/10\/19\/item-master-auto-synchronization-between-two-systems\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Item Master Auto Synchronization between Two Systems"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/4560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=4560"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/4560\/revisions"}],"predecessor-version":[{"id":36430,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/4560\/revisions\/36430"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=4560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=4560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=4560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}