{"id":35098,"date":"2025-12-10T11:08:10","date_gmt":"2025-12-10T11:08:10","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=35098"},"modified":"2025-12-11T05:02:45","modified_gmt":"2025-12-11T05:02:45","slug":"how-to-process-a-stock-adjustment-for-serial-number-products-in-odoo-inventory","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/inventory\/how-to-process-a-stock-adjustment-for-serial-number-products-in-odoo-inventory\/","title":{"rendered":"How to Process a Stock Adjustment for Serial Number Products in Odoo Inventory"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Managing items tracked by unique serial numbers requires extra care, especially when performing stock adjustments. Odoo Inventory provides a structured and accurate way to handle these adjustments so that every serial-tracked product reflects the correct quantity and valuation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Enabling Tracking for Products in Odoo Inventory<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before starting a stock adjustment, the product must be configured to use <strong>Tracking by Unique Serial Number<\/strong>. This ensures that each unit is managed individually instead of in bulk. To enable this, open the Product Master, under Traceability, select <strong>By Unique Serial Number<\/strong> under the Tracking section.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Inventory-Traceability-Unique-Serial-Number-1024x529.png\" alt=\"Odoo Inventory Traceability Unique Serial Number\" class=\"wp-image-35100\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Inventory-Traceability-Unique-Serial-Number-1024x529.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Inventory-Traceability-Unique-Serial-Number-300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Inventory-Traceability-Unique-Serial-Number-768x397.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Inventory-Traceability-Unique-Serial-Number-1536x794.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Inventory-Traceability-Unique-Serial-Number.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Once tracking is enabled, Odoo will require you to choose a lot or serial number every time the product is moved, received, or adjusted. This setup improves traceability, prevents duplication of serial numbers, and ensures more accurate stock control.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating a New Stock Adjustment Document<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To begin a stock adjustment, click <strong>+ New<\/strong> in the Stock Adjustment menu. Select the <strong>Source Location<\/strong> where the stock currently exists and choose the appropriate <strong>Product Category<\/strong> from the dropdown. After entering these details, click <strong>Save<\/strong>, and Odoo will automatically generate a unique Stock Adjustment Document Number for reference.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you select <strong>Validate<\/strong> before adding any products, Odoo will display a validation saying: <strong>\u201cNo scrap lines with products found. Please add products to validate.\u201d <\/strong>This means that at least one product must be added before proceeding.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-No-Scrap-Lines-Validation-1024x529.png\" alt=\"Odoo Stock Adjustment No Scrap Lines Validation\" class=\"wp-image-35103\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-No-Scrap-Lines-Validation-1024x529.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-No-Scrap-Lines-Validation-300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-No-Scrap-Lines-Validation-768x397.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-No-Scrap-Lines-Validation-1536x794.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-No-Scrap-Lines-Validation.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Selecting Products and Serial Numbers<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Products can be added to the Stock Adjustment document either by typing the product code, entering the product name, or scanning the lot\/serial barcode. Since the product is tracked by unique serial numbers, Odoo will require you to select the correct serial number for each item added.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once a serial number is selected, Odoo automatically displays important information such as the <strong>Lot Barcode<\/strong>, <strong>On-Hand Quantity<\/strong>, and <strong>GRN Date<\/strong>. The Lot Barcode appears only if the serial number has an assigned barcode. The On-Hand Quantity is always based on the selected Source Location, and for serial-number products it will always show <strong>1 or 0<\/strong>, since each serial represents one physical item. The GRN Date indicates when the specific serial was received into stock.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"520\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Draft-Document-1024x520.png\" alt=\"Odoo Stock Adjustment Draft Document\" class=\"wp-image-35105\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Draft-Document-1024x520.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Draft-Document-300x152.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Draft-Document-768x390.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Draft-Document-1536x781.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Draft-Document.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can add multiple products in a single document and can even add the same product multiple times as long as each entry has a different serial number. However, if you try to add the same product with the same serial number more than once, Odoo will display a validation message: <strong>\u201c[Product Code + Product Name] Insufficient Quantity To Scrap\u201d<\/strong>, indicating that the serial number cannot be used again because its available quantity has already been recorded.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Quantity Adjustment and Cost Calculation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After selecting a serial number, you can enter the <strong>Counted Quantity<\/strong>. For serial-tracked products, this quantity must always be <strong>1 or 0<\/strong>. If you enter any value greater than 1, Odoo will stop you with a validation message: <strong>\u201cThe serial number has already been assigned: Product: <\/strong><strong>[<\/strong><strong>Product Code + Product Name<\/strong><strong>]<\/strong><strong>, Serial Number: <\/strong><strong>[<\/strong><strong>Lot\/Serial number<\/strong><strong>]<\/strong><strong>.\u201d<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Serial-Number-Validation-1024x529.png\" alt=\"Odoo Stock Adjustment Serial Number Validation\" class=\"wp-image-35106\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Serial-Number-Validation-1024x529.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Serial-Number-Validation-300x155.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Serial-Number-Validation-768x397.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Serial-Number-Validation-1536x794.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Serial-Number-Validation.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The system then automatically calculates the <strong>Adjusted Quantity<\/strong> based on the difference between On-Hand and Counted Quantity.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For serial-based products, Odoo automatically displays the <strong>Average Cost<\/strong> tied to the selected serial number. The <strong>Total Value<\/strong> of the stock adjustment is then calculated by multiplying the Adjusted Quantity with the product\u2019s cost. This helps maintain accurate inventory valuation whenever quantities change.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Validating the Stock Adjustment<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once all product entries and quantities are correct, click <strong>Validate<\/strong>. After validation, Odoo updates the on-hand quantity, total value, and average cost for every affected serial number. This ensures your inventory remains precise and fully aligned with the actual physical stock available in your warehouse.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"522\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Completed-Document-1024x522.png\" alt=\"Odoo Stock Adjustment Completed Document\" class=\"wp-image-35108\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Completed-Document-1024x522.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Completed-Document-300x153.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Completed-Document-768x391.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Completed-Document-1536x782.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Stock-Adjustment-Completed-Document.png 1830w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Managing items tracked by unique serial numbers requires extra care, especially when performing stock adjustments. Odoo Inventory provides a structured [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[382],"tags":[99,450,496],"class_list":["post-35098","post","type-post","status-publish","format-standard","hentry","category-inventory","tag-inventory","tag-serial-number-product","tag-stock-adjustment"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/35098","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/comments?post=35098"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/35098\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=35098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=35098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=35098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}