{"id":16722,"date":"2017-10-24T09:36:41","date_gmt":"2017-10-24T09:36:41","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=16722"},"modified":"2019-11-12T08:46:29","modified_gmt":"2019-11-12T08:46:29","slug":"validation-of-financial-registration-numbers-as-per-defined-norms","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/","title":{"rendered":"Validation on Financial Registration Numbers as per defined norms"},"content":{"rendered":"

In the previous blog we have seen details about auto generated vendor number on Vendor Master Screen for reference –
\nnew Stuff :-Auto Vendor \/ Customer Code Generation in Sage 300 ERP<\/a>
\nContinued with the same have done customization on the same vendor master screen for exact validation of GSTIN & PAN No according to the defined format by government. The purpose of this validation is to enter GSTIN & PAN No in proper format without any mistake. Now days according to the government norms these are the 2 important numbers which every customer & vendor has.
\nBelow is the screenshot of A\/P Vendor Master Screen in which we have created customization:
\n\"\"<\/a>
\nWe have done validation in which we have checked the length and every character of optional field value and will not allow user to save Vendor record until the characters are valid as per defined format.
\nSuppose if the user has optional field named as GSTIN & PAN and want to validate the same with specific characters & length. Below are the conditions:
\n1) GSTIN should have 15 alphanumeric characters & PAN should have 10 alphanumeric characters. And also in GSTIN the First 2 should be numeric, next 5 should be character, next 4 should be numeric, next 1 should be character, next 1 should be numeric, next 1 should be character & last 1 should be numeric.
\n2) And in PAN First five characters are letters, next four numerals and last character letter.
\nIf the user entered value of optional field doesn\u2019t satisfy the above condition then the system will throw error message to enter valid GSTIN no or PAN no and will not allow user to create vendor until the above conditions are satisfied.
\nBelow is the screenshot for the same when the user entered invalid optional field value named as PAN<\/strong>. For E.g.: Vendor Number C00004 has entered invalid optional field value for PAN.  <\/strong>So the system will give below error message for asking user to enter valid PAN No<\/strong> in optional field value while saving the records.
\n\"\"<\/a>
\nThe same goes with GSTIN No<\/strong> also, Vendor Number C00004 has entered invalid optional field value for GSTIN <\/strong>so the system will give below error message for asking user to enter valid GSTIN No<\/strong> in optional field value while saving the records.
\n\"\"<\/a>
\nThe main purpose of this blog is to provide validation to enter correct & valid optional field value in the system.
\nAlso Read:-<\/strong><\/p>\n

    \n
  1. Auto Vendor \/ Customer Code Generation in Sage 300 ERP<\/a><\/li>\n
  2. Optional field Validation on Order Entry Scree<\/a>n<\/li>\n
  3. Validate Item Segment in Sage 300 ERP<\/a><\/li>\n
  4. Auto-Update Bill-To-Address for Open Orders in Sage 300 ERP<\/a><\/li>\n<\/ol>\n

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

    In the previous blog we have seen details about auto generated vendor number on Vendor Master Screen for reference – new Stuff :-Auto Vendor \/ Customer Code Generation in Sage 300 ERP Continued with the same have done customization on the same vendor master screen for exact validation of GSTIN & PAN No according to\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":[834,1804,1808,2963,3006],"class_list":["post-16722","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-duplicate-vendor-name-validation","tag-optional-field-vendor-name-validation","tag-optional-field-validation-in-vendor-master","tag-validate-optional-field","tag-vendor-master-validation"],"yoast_head":"\nValidation on Financial Registration Numbers as per defined norms - 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\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Validation on Financial Registration Numbers as per defined norms - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In the previous blog we have seen details about auto generated vendor number on Vendor Master Screen for reference – new Stuff :-Auto Vendor \/ Customer Code Generation in Sage 300 ERP Continued with the same have done customization on the same vendor master screen for exact validation of GSTIN & PAN No according to\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-24T09:36:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-12T08:46:29+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/10\/Vendor1-1.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\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/\",\"name\":\"Validation on Financial Registration Numbers as per defined norms - 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\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/10\/Vendor1-1.png\",\"datePublished\":\"2017-10-24T09:36:41+00:00\",\"dateModified\":\"2019-11-12T08:46:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/10\/Vendor1-1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/10\/Vendor1-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Validation on Financial Registration Numbers as per defined norms\"}]},{\"@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":"Validation on Financial Registration Numbers as per defined norms - 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\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/","og_locale":"en_US","og_type":"article","og_title":"Validation on Financial Registration Numbers as per defined norms - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In the previous blog we have seen details about auto generated vendor number on Vendor Master Screen for reference – new Stuff :-Auto Vendor \/ Customer Code Generation in Sage 300 ERP Continued with the same have done customization on the same vendor master screen for exact validation of GSTIN & PAN No according to\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2017-10-24T09:36:41+00:00","article_modified_time":"2019-11-12T08:46:29+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/10\/Vendor1-1.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\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/","name":"Validation on Financial Registration Numbers as per defined norms - 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\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/10\/Vendor1-1.png","datePublished":"2017-10-24T09:36:41+00:00","dateModified":"2019-11-12T08:46:29+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/10\/Vendor1-1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2017\/10\/Vendor1-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2017\/10\/24\/validation-of-financial-registration-numbers-as-per-defined-norms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Validation on Financial Registration Numbers as per defined norms"}]},{"@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\/16722","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=16722"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/16722\/revisions"}],"predecessor-version":[{"id":27184,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/16722\/revisions\/27184"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=16722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=16722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=16722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}