{"id":5617,"date":"2013-12-27T07:53:59","date_gmt":"2013-12-27T07:53:59","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=5617"},"modified":"2019-11-12T09:25:00","modified_gmt":"2019-11-12T09:25:00","slug":"create-significant-item-name-with-separator-and-prefix-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/","title":{"rendered":"Create significant item name with separator and prefix in sage 300 ERP"},"content":{"rendered":"

Consider a scenario where user wants to create an item code which should symbolize the item description. For e.g. The Item Code could contain Item Category, style and color. The benefit of this would be that the user identifies the item by just reading the code and need not lookup in the Item Master.
\nSage 300 ERP delivers a very powerful and user friendly feature to do this.  Let\u2019s have a look at the steps involved in achieving the above task.
\nWe shall consider the example of an item code containing Item Category, style and color. I.e. 3 segments to be used in 1 single item code.
\nFirst of all we need to create an Item structure code in sage 300 ERP.
\nItem structure can contain a separator character between consecutive segments and a prefix character in front of the first segment. For example, item number A1-101\/B<\/strong> contains two separator characters i.e.:  – and \/ (please refer the below screen shot)
\nIn item number \u201cA1-101\/B\u201d:
\n\u201cA1\u201d is a Category which explains that item is from category Accessories, \u201c103\u201d is style and \u201c0\u201d is color code like 0 for red, 1 for blue etc. Separators help us to create appropriate item structure. Just by seeing the item code you can get the idea about item.<\/p>\n

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

To use a separator while creating item structure, user needs to select the same in I\/C Options –> Items Tab (please refer the below screen shot):
\nNavigate to Inventory Control –> I\/C Setup –>Options –>Item Tab<\/p>\n

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

Mark the Use column as YES<\/strong> for the separator which you want to use in item structure.
\nWhen you are dealing with separator keep it in mind that if you change the value of \u201cUse\u201d column to \u201cNO\u201d then you cannot reset it to \u201cYES\u201d<\/strong>. It will remain \u201cNO\u201d for rest of the time. To use character as separator keep value of Use column to \u201cYES\u201d.<\/strong>
\nNote that if you specify particular character as a separator then it cannot be used elsewhere in an item number.
\nYou can also use prefix character for creating item.
\nlet\u2019s construct an Item code(refer the below screen shot):<\/p>\n

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

Hope, the above information will help you to get the information about characters that you can use as separators and Prefix Characters in your item number structures.
\n  Also Read:<\/span><\/p>\n

    \n
  1. Quantity and Cost restriction in PO Transaction<\/a><\/li>\n
  2. OE Sales Register Report for Sage 300 ERP<\/a><\/li>\n
  3. Generate Separate Payment for each Invoice<\/a><\/li>\n
  4. Integration of Infrasys POS with Sage 300 ERP<\/a><\/li>\n
  5. Hide or Remove Presentation Strings from Drop Down Controls in Sage 300 ERP<\/a><\/li>\n<\/ol>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Consider a scenario where user wants to create an item code which should symbolize the item description. For e.g. The Item Code could contain Item Category, style and color. The benefit of this would be that the user identifies the item by just reading the code and need not lookup in the Item Master. Sage\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":[444,1398,1417,2357,2628],"class_list":["post-5617","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-characters-user-as-separator","tag-item-creation","tag-item-structure","tag-sage-300-erp","tag-separators"],"yoast_head":"\nCreate significant item name with separator and prefix in sage 300 ERP - 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\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create significant item name with separator and prefix in sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Consider a scenario where user wants to create an item code which should symbolize the item description. For e.g. The Item Code could contain Item Category, style and color. The benefit of this would be that the user identifies the item by just reading the code and need not lookup in the Item Master. Sage\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-27T07:53:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-12T09:25:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/12\/jjj.png\" \/>\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=\"2 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\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/\",\"name\":\"Create significant item name with separator and prefix in sage 300 ERP - 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\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/12\/jjj.png\",\"datePublished\":\"2013-12-27T07:53:59+00:00\",\"dateModified\":\"2019-11-12T09:25:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/12\/jjj.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/12\/jjj.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create significant item name with separator and prefix in sage 300 ERP\"}]},{\"@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":"Create significant item name with separator and prefix in sage 300 ERP - 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\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Create significant item name with separator and prefix in sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Consider a scenario where user wants to create an item code which should symbolize the item description. For e.g. The Item Code could contain Item Category, style and color. The benefit of this would be that the user identifies the item by just reading the code and need not lookup in the Item Master. Sage\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-12-27T07:53:59+00:00","article_modified_time":"2019-11-12T09:25:00+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/12\/jjj.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/","name":"Create significant item name with separator and prefix in sage 300 ERP - 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\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/12\/jjj.png","datePublished":"2013-12-27T07:53:59+00:00","dateModified":"2019-11-12T09:25:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/12\/jjj.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/12\/jjj.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/27\/create-significant-item-name-with-separator-and-prefix-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Create significant item name with separator and prefix in sage 300 ERP"}]},{"@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\/5617","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=5617"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/5617\/revisions"}],"predecessor-version":[{"id":27418,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/5617\/revisions\/27418"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=5617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=5617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=5617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}