{"id":1255,"date":"2017-02-23T09:39:48","date_gmt":"2017-02-23T09:39:48","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1255"},"modified":"2018-10-09T09:50:12","modified_gmt":"2018-10-09T09:50:12","slug":"upc-code-generated-at-item-master-in-sage-500","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/","title":{"rendered":"UPC Code generated at Item Master in Sage 500"},"content":{"rendered":"<p style=\"text-align: justify;\">There was a very unique but interesting requirement from one of our clients recently; the requirement is the new Item id need to be generated automatically by using Universal Product Code generation logic in Sage 500 Erp.<\/p>\n<p style=\"text-align: justify;\"><em><strong>New Stuff<\/strong><\/em>:\u00a0<a href=\"http:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/01\/31\/vendor-return-flow\/\" target=\"_blank\" rel=\"noopener\">Vendor Return Flow<\/a><\/p>\n<p style=\"text-align: justify;\">Basically, the Universal Product Code is the unique 12- digit number and the purpose is to make item id easily identify the product features like brand, style, color, and size. The UPC code always helpful in tracking inventory, Maintain Barcode and Fixed asset Management.\u00a0 The barcode scanner can immediately scan the UPC Code item id and identify the product to provide all the information quickly. Also, improve the efficiency and reliability while tracking the inventory.<\/p>\n<p style=\"text-align: justify;\">The formula of UPC Code generation is very unique which is a combination of UCC Code + Product Seq No + Algorithm no to check digit calculation.<\/p>\n<p style=\"text-align: justify;\"><strong>UPC Code formula (12 digit)<\/strong> = <strong>UCC Code (6 digit) + Product Seq No (5 digit) + Check Sum will be auto-calculated by using algorithm no to check digit calculation (1 digit)<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>UCC Code (6 digit no):<\/strong> A uniform commercial code is first published in 1952, is one of the 6 digit numbers which is generally used while commercial transactions. Our client was fixed 6 digit UCC code: 998877.<\/li>\n<li><strong>Product Seq. no. (5 digit no)<\/strong>: This sequence no we have auto-generated based on the item generation history. Example: \u201c00001\u201d\u00a0 &#8211; 1st Item, \u201c00002\u201d \u2013 2nd Item,\u201d00003\u201d \u2013 3rd Item<\/li>\n<li><strong>The checksum will be auto-calculated by using algorithm no to check digit calculation (1 digit)<\/strong> : This formula basically uses for determining what number needs to be added.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Check Sum Calculation Logic:<\/strong><\/p>\n<p style=\"text-align: justify;\">Let&#8217;s assume that we are using the fictitious code 05432122345.<\/p>\n<ol>\n<li style=\"text-align: justify;\">Add all of the digits in the odd positions (digits in position 1, 3, 5, 7, 9, and 11) \u00a00 + 4 + 2 + 2 + 3 + 5 = 16<\/li>\n<li style=\"text-align: justify;\">Multiply by 3.\u00a0 \u00a0E.g.\u00a0\u00a0 16 * 3 = 48<\/li>\n<li style=\"text-align: justify;\">Add all of the digits in even positions (digits in position 2, 4, 6, 8 and 10). \u00a0 5 + 3 + 1 + 2 + 4 = 15<\/li>\n<li style=\"text-align: justify;\">Sum the results of steps 3 and 2.\u00a0 E.g. 48 + 15 = 63<\/li>\n<li style=\"text-align: justify;\">Determine what number needs to be added to the result of step 4 in order to create a multiple of 10.\u00a0 E.g.\u00a0\u00a0 63 + 7 = 70<\/li>\n<li style=\"text-align: justify;\">The check digit therefore equals\u00a07.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Finally, using this formula we need to generate the output item id code: UPC Code\u00a0=\u00a0998877000017 UPC CODE (998877000017) = UCC Code (998877) + Product Seq no (00001) + Checksum digit no (7)<\/p>\n<p style=\"text-align: justify;\">To achieve this requirement, what we did we incorporated the UCC Code with textbox into the Setup IM Options which is fixed 6 digit no \u201c998877\u201d.<\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/02\/IMAGE1-3-3.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-1257 size-full aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/02\/IMAGE1-3.jpg\" alt=\"SetUP Im Option screen\" width=\"637\" height=\"499\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Then, we have introduced new next number button on the Maintain Items Screens to generate the UPC code. Whenever user clicks to next number button our customization has been followed all calculation formula of UPC code and generate the UPC code no. 998877000017.<\/p>\n<p style=\"text-align: justify;\">This way we managed the UPC code generation logic and incorporated into the Maintain Items screen.<\/p>\n<p style=\"text-align: justify;\">It would be interesting to know if this kind of functionality is required by others as well.<\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/02\/IMAGE2-2-2.jpg\"><img decoding=\"async\" class=\"wp-image-1258 size-full aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/02\/IMAGE2-2.jpg\" alt=\"Maintain Item\" width=\"666\" height=\"564\" \/><\/a><\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\nGreytrix is a one-stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0has some unique solutions of\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,\u00a0and <a href=\"http:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com\u00a0<\/a> along with Sage 100 Migration from <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/sage-50-us-sage-100-migration\">Sage 50 US<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\">Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n<p>For more details on Sage 100 Services, please contact us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There was a very unique but interesting requirement from one of our clients recently; the requirement is the new Item id need to be generated automatically by using Universal Product Code generation logic in Sage 500 Erp. New Stuff:\u00a0Vendor Return Flow Basically, the Universal Product Code is the unique 12- digit number and the purpose\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/\">Read More &raquo;<\/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":[180],"tags":[327,412,472,473],"class_list":["post-1255","post","type-post","status-publish","format-standard","hentry","category-sage-500-erp","tag-item-master","tag-sage-500","tag-upc-code","tag-upc-code-generated-at-item-master"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>UPC Code generated at Item Master in Sage 500 - GUMU\u2122 Integrations \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\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"UPC Code generated at Item Master in Sage 500 - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"There was a very unique but interesting requirement from one of our clients recently; the requirement is the new Item id need to be generated automatically by using Universal Product Code generation logic in Sage 500 Erp. New Stuff:\u00a0Vendor Return Flow Basically, the Universal Product Code is the unique 12- digit number and the purpose\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-23T09:39:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-09T09:50:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/02\/IMAGE1-3.jpg\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\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\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/\",\"name\":\"UPC Code generated at Item Master in Sage 500 - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/02\/IMAGE1-3.jpg\",\"datePublished\":\"2017-02-23T09:39:48+00:00\",\"dateModified\":\"2018-10-09T09:50:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"UPC Code generated at Item Master in Sage 500\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"UPC Code generated at Item Master in Sage 500 - GUMU\u2122 Integrations \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\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/","og_locale":"en_US","og_type":"article","og_title":"UPC Code generated at Item Master in Sage 500 - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","og_description":"There was a very unique but interesting requirement from one of our clients recently; the requirement is the new Item id need to be generated automatically by using Universal Product Code generation logic in Sage 500 Erp. New Stuff:\u00a0Vendor Return Flow Basically, the Universal Product Code is the unique 12- digit number and the purpose\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2017-02-23T09:39:48+00:00","article_modified_time":"2018-10-09T09:50:12+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/02\/IMAGE1-3.jpg","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/","name":"UPC Code generated at Item Master in Sage 500 - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2017\/02\/IMAGE1-3.jpg","datePublished":"2017-02-23T09:39:48+00:00","dateModified":"2018-10-09T09:50:12+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/02\/23\/upc-code-generated-at-item-master-in-sage-500\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"UPC Code generated at Item Master in Sage 500"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=1255"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1255\/revisions"}],"predecessor-version":[{"id":3094,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1255\/revisions\/3094"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=1255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=1255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=1255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}