{"id":20200,"date":"2026-07-10T11:18:25","date_gmt":"2026-07-10T11:18:25","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=20200"},"modified":"2026-08-20T11:38:58","modified_gmt":"2026-08-20T11:38:58","slug":"how-to-configure-serial-no-control-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-serial-no-control-in-idempiere\/","title":{"rendered":"How to Configure Serial No Control in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Serial No Control window in iDempiere defines the rule set used to auto-generate serial numbers for products that require individual tracking.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is used in Material Management, applying to products with serial number attributes referenced during Sales Orders, Shipments, and Physical Inventory.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This configuration ensures consistent, non-duplicate serial sequences, supporting traceability, warranty tracking, and accurate inventory reporting.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Process Flow Diagram<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"219\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-window-SerialNoControl-ProcessFlow.png\" alt=\"\" class=\"wp-image-28100\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-window-SerialNoControl-ProcessFlow.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-window-SerialNoControl-ProcessFlow-300x64.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-window-SerialNoControl-ProcessFlow-768x164.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Active Serial No Control records are the only ones available for assignment to Attribute Set.<\/li>\n\n\n\n<li>Current Next automatically increments each time a serial number is generated.<\/li>\n\n\n\n<li>Increment value sets the gap between two consecutively generated serial numbers.<\/li>\n\n\n\n<li>Prefix and Suffix values are appended automatically to every generated serial number.<\/li>\n\n\n\n<li>Start No applies only to the first serial number issued under the sequence.<\/li>\n\n\n\n<li>Exclude tab entries prevent this rule from applying to selected tables or transactions.<\/li>\n\n\n\n<li>Organization scope determines which business unit can use this Serial No Control record.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisites<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Organization configured.<\/li>\n\n\n\n<li>Product or Product Category requiring serial number tracking identified.<\/li>\n\n\n\n<li>Role and window access rights configured for Serial No Control.<\/li>\n\n\n\n<li>Sales Transaction document types identified, if exclusion rules are needed.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigation<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Opening this window displays the Serial No Control header with <strong>Name<\/strong>, <strong>Start No<\/strong>, <strong>Current Next<\/strong>, <strong>Increment<\/strong>, <strong>Prefix<\/strong>, and <strong>Suffix<\/strong> fields, along with an Exclude tab for restricting the rule from specific tables or Sales Transactions.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"658\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-2-1024x658.png\" alt=\"TenthPlanet-iDempiere-Master-SerialNoControl-2\" class=\"wp-image-20205\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-2-1024x658.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-2-300x193.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-2-768x494.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-2-1536x987.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-2-2048x1316.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Configuration Steps<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Define the Serial No Control Header<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This step identifies the serial numbering rule so it can be selected later from products or related transactions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Enter a unique Name and optional Description. Keep the Active checkbox enabled so the record is available for selection during transaction entry.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"500\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-3-1024x500.png\" alt=\"TenthPlanet-iDempiere-Master-SerialNoControl-3\" class=\"wp-image-20207\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-3-1024x500.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-3-300x146.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-3-768x375.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-3-1536x750.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-3-2048x1000.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Name<\/td><td>SN-WARRANTY-01<\/td><td>Unique identifier for this serial numbering rule<\/td><\/tr><tr><td>Description<\/td><td>Warranty item serial rule<\/td><td>Optional explanatory text<\/td><\/tr><tr><td>Active<\/td><td>Checked<\/td><td>Controls whether the rule is available for use<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Set the Starting Sequence Values<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The starting values determine where the serial number sequence begins and where the next number will be issued from.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Enter Start No as the first serial number in the sequence. Current Next initializes to the same value and updates automatically after each number is issued.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"500\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-4-1024x500.png\" alt=\"TenthPlanet-iDempiere-Master-SerialNoControl-4\" class=\"wp-image-20208\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-4-1024x500.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-4-300x146.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-4-768x375.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-4-1536x750.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-4-2048x1000.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Start No<\/td><td>100<\/td><td>First serial number in the sequence<\/td><\/tr><tr><td>Current Next<\/td><td>100<\/td><td>Next serial number to be issued; auto-updates<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Configure Increment and Formatting<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Increment controls sequence spacing, while Prefix and Suffix format the serial number for readability or classification.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Set Increment to the desired step value. Enter Prefix or Suffix text if the serial number must include fixed identifiers, such as a location or product code.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"500\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-5-1024x500.png\" alt=\"TenthPlanet-iDempiere-Master-SerialNoControl-4\" class=\"wp-image-20209\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-5-1024x500.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-5-300x146.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-5-768x375.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-5-1536x750.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-5-2048x1000.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Increment<\/td><td>1<\/td><td>Value added to Current Next after each serial number is issued<\/td><\/tr><tr><td>Prefix<\/td><td>SN-<\/td><td>Fixed text added before the generated number<\/td><\/tr><tr><td>Suffix<\/td><td>-CDC<\/td><td>Fixed text added after the generated number<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Exclude Specific Tables or Transactions<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Exclude tab restricts this Serial No Control rule from applying to selected tables or Sales Transaction document types.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Open the Exclude tab, add a new line, select the Table to exclude, and enable Sales Transaction if the exclusion applies only to sales documents.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"383\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-6-1024x383.png\" alt=\"\" class=\"wp-image-20210\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-6-1024x383.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-6-300x112.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-6-768x287.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-6-1536x575.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Master-SerialNoControl-6-2048x766.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Organization<\/td><td>CDC<\/td><td>Organization scope for the exclusion rule<\/td><\/tr><tr><td>Table<\/td><td>M_InOutLine<\/td><td>Table excluded from this serial number rule<\/td><\/tr><tr><td>Sales Transaction<\/td><td>Checked<\/td><td>Limits exclusion to sales-side transactions<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Serial number not incrementing<\/td><td>Increment value left at 0<\/td><td>Set Increment to 1 or the required step value<\/td><\/tr><tr><td>Duplicate serial numbers generated<\/td><td>Start No overlaps existing issued numbers<\/td><td>Set Start No higher than the last issued serial number<\/td><\/tr><tr><td>Serial No Control not available for selection<\/td><td>Record is not Active<\/td><td>Enable the Active checkbox and save<\/td><\/tr><tr><td>Prefix or Suffix missing on generated numbers<\/td><td>Fields left blank during setup<\/td><td>Enter the required Prefix or Suffix values<\/td><\/tr><tr><td>Rule applies to unintended Organization<\/td><td>Record created under the wrong Organization<\/td><td>Recreate the record under the correct Organization or use Global (*)<\/td><\/tr><tr><td>Exclude rule not taking effect<\/td><td>Table or Sales Transaction not set correctly<\/td><td>Verify the correct Table is selected and the flag is enabled<\/td><\/tr><tr><td>Users cannot access the window<\/td><td>Role lacks window or table access<\/td><td>Grant Serial No Control window access to the required Role<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next Steps<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Configure the Product window to link products to this Serial No Control record.<\/li>\n\n\n\n<li>Verify Attribute Set Instance setup for products requiring serial tracking.<\/li>\n\n\n\n<li>Test serial number generation through a Sales Order or Shipment transaction.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Serial No Control window in iDempiere defines the rule set used to auto-generate serial numbers for products that require [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,10],"tags":[],"class_list":["post-20200","post","type-post","status-publish","format-standard","hentry","category-idempiere-inventory","category-idempiere-product"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=20200"}],"version-history":[{"count":5,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20200\/revisions"}],"predecessor-version":[{"id":28107,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/20200\/revisions\/28107"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=20200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=20200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=20200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}