{"id":10776,"date":"2015-04-29T07:17:14","date_gmt":"2015-04-29T07:17:14","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=10776"},"modified":"2015-04-29T07:17:14","modified_gmt":"2015-04-29T07:17:14","slug":"document-numbering-based-on-optional-field","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/","title":{"rendered":"Document numbering Based On Optional Field"},"content":{"rendered":"<p>In our previous blog<a title=\"Why Use Document Numbering\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/01\/31\/why-use-document-numbering\/\" target=\"_blank\"> \u201cWhy Use Document Numbering\u201d<\/a>, we had discussed about the use of document numbering for sage 300 ERP. We already know that the document numbering module generates the document numbers based on Location, Account set, combination of account set and also does generate based on the bank code. In this blog we will discuss about the new number generation method i.e. based on the optional field. This is the customization part which was done for one of our clients.<br \/>\nOptional field customization in document numbering of sage 300 ERP allows a user to generate the document number based on optional field condition.<br \/>\n<strong><em><span style=\"color: #800000\">New Stuff:<\/span><\/em><\/strong> <a title=\"Miscellaneous Payment Feature in SAGE 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/03\/24\/miscellaneous-payment-feature-in-sage-300-erp\/\" target=\"_blank\">Miscellaneous Payment Feature in SAGE 300 ERP<\/a><br \/>\nIn this method, the user needs to define an optional field which will be considered for number generation process. Based on that optional field value, the document number will be generated.<br \/>\nLet\u2019s take an example, to understand idea behind the number generation on optional field. First, the user needs do the configuration.<br \/>\nFor example, we will create configuration for IC shipment screen,<br \/>\n\u2981 \u00a0Create one or more optional field GNDNUM for defining values of optional fields defined in \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 transaction for number generation.<br \/>\nRefer below screen for IC shipment optional field configuration.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.png\" target=\"_blank\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-10845\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.png\" alt=\"11\" width=\"550\" height=\"293\" \/><\/a><br \/>\n\u2981 \u00a0Create one or more optional field GNDNUM for defining values of optional fields defined in \u00a0 \u00a0 \u00a0 transaction for number generation.<br \/>\nRefer below screen to define optional field values.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/122.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter wp-image-10846\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/122.png\" alt=\"12\" width=\"550\" height=\"293\" \/><\/a><br \/>\n\u2981 \u00a0Now, we need to define number series which would be generated for IC shipment.<br \/>\nPlease refer the below screen to define numbering mapping.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/131.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter wp-image-10844\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/131.png\" alt=\"13\" width=\"550\" height=\"319\" \/><\/a><br \/>\n\u2981 \u00a0Now, we will do the IC shipment entry with optional field \u201cRGP\u201d.<br \/>\nPlease refer the below screen for IC shipment transaction with optional field.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10787\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/04.png\" alt=\"04\" width=\"550\" height=\"313\" \/><\/a><br \/>\n&nbsp;<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10788\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/05.png\" alt=\"05\" width=\"500\" height=\"231\" \/><\/a><br \/>\n\u2981 \u00a0After posting, the number will be generated as per configuration.<br \/>\nPlease refer the below screen.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/055.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10789\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/055.png\" alt=\"055\" width=\"550\" height=\"311\" \/><\/a><br \/>\nWith the help of this customization, users can generate a number series on the basis of their requirements which are apart from Account set, Location, bank code and location | Account set.<br \/>\n<strong><em><span style=\"color: #800000\">Read Also:<\/span><\/em><\/strong><br \/>\n1.<a title=\"Document Numbering for AR Misc. Receipt\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/04\/16\/document-numbering-for-ar-misc-receipt\/\" target=\"_blank\">Document Numbering for AR Misc. Receipt<\/a><br \/>\n2.<a title=\"Grouping feature in Document Numbering Series for Sage Accpac\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/05\/17\/grouping-feature-in-document-numbering-series-for-sage-accpac\/\" target=\"_blank\">Grouping feature in Document Numbering Series for Sage Accpac<\/a><br \/>\n3.<a title=\"Set Document Numbering based on Bank Code for Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/08\/31\/set-document-numbering-based-on-bank-code-for-sage-300-erp\/\" target=\"_blank\">Set Document Numbering based on Bank Code for Sage 300 ERP<\/a><br \/>\n4.<a title=\"Configuring Document Numbering for Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/05\/07\/configuring-document-numbering-for-sage-300-erp\/\" target=\"_blank\">Configuring Document Numbering for Sage 300 ERP<\/a><br \/>\n5.<a title=\"Set Document Numbering for Sage 300 ERP on the combination of Account Set and Location\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/04\/19\/set-document-numbering-for-sage-300-erp-on-the-combination-of-account-set-and-location\/\" target=\"_blank\">Set Document Numbering for Sage 300 ERP on the combination of Account Set and Location<\/a><br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our previous blog \u201cWhy Use Document Numbering\u201d, we had discussed about the use of document numbering for sage 300 ERP. We already know that the document numbering module generates the document numbers based on Location, Account set, combination of account set and also does generate based on the bank code. In this blog we\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[811,1214,1803,2357],"class_list":["post-10776","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-document-numbering","tag-ic-shipment","tag-optional-field","tag-sage-300-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Document numbering Based On Optional Field - 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\/2015\/04\/29\/document-numbering-based-on-optional-field\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Document numbering Based On Optional Field - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our previous blog \u201cWhy Use Document Numbering\u201d, we had discussed about the use of document numbering for sage 300 ERP. We already know that the document numbering module generates the document numbers based on Location, Account set, combination of account set and also does generate based on the bank code. In this blog we\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-29T07:17:14+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.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\/2015\/04\/29\/document-numbering-based-on-optional-field\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/\",\"name\":\"Document numbering Based On Optional Field - 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\/2015\/04\/29\/document-numbering-based-on-optional-field\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.png\",\"datePublished\":\"2015-04-29T07:17:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Document numbering Based On Optional Field\"}]},{\"@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":"Document numbering Based On Optional Field - 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\/2015\/04\/29\/document-numbering-based-on-optional-field\/","og_locale":"en_US","og_type":"article","og_title":"Document numbering Based On Optional Field - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In our previous blog \u201cWhy Use Document Numbering\u201d, we had discussed about the use of document numbering for sage 300 ERP. We already know that the document numbering module generates the document numbers based on Location, Account set, combination of account set and also does generate based on the bank code. In this blog we\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-04-29T07:17:14+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.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\/2015\/04\/29\/document-numbering-based-on-optional-field\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/","name":"Document numbering Based On Optional Field - 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\/2015\/04\/29\/document-numbering-based-on-optional-field\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.png","datePublished":"2015-04-29T07:17:14+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/04\/113.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/04\/29\/document-numbering-based-on-optional-field\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Document numbering Based On Optional Field"}]},{"@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\/10776","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=10776"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/10776\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=10776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=10776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=10776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}