{"id":33226,"date":"2025-11-21T05:43:35","date_gmt":"2025-11-21T05:43:35","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=33226"},"modified":"2026-07-07T06:12:51","modified_gmt":"2026-07-07T06:12:51","slug":"how-to-calculate-stock-adjustment-values-in-odoo","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/inventory\/how-to-calculate-stock-adjustment-values-in-odoo\/","title":{"rendered":"How to Calculate Stock Adjustment Values in Odoo"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Managing inventory efficiently is one of the most important aspects of any business, and Odoo makes this process easier through its Stock Adjustment feature. Odoo Stock adjustments help businesses correct differences between the system\u2019s recorded stock levels and the actual physical count. This ensures that your inventory records remain accurate, allowing for smooth operations and informed decision-making.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating a Stock Adjustment<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To begin, you need to create a new Stock Adjustment document in Odoo. Click on <strong>+New<\/strong> to start, and by default, the document type will appear as <strong>Stock Adjustment<\/strong>. Choose the <strong>Source Location<\/strong> where the products are stored, and then select the relevant <strong>Product Category<\/strong> from the dropdown list.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you click <strong>Save<\/strong>, Odoo will automatically generate a unique Stock Adjustment Document Number. This document will be used to record and track all your stock adjustment details.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After creating the document, you can start adding products that need adjustment. Choose the specific product and, if applicable, select the correct <strong>Lot or Serial Number<\/strong>. Once you make the selection, Odoo will automatically update important details such as the <strong>Lot Barcode<\/strong>, the current <strong>On-Hand Quantity<\/strong>, and the <strong>Goods Receipt Note (GRN) Date<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"335\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Creation-1024x335.png\" alt=\"Odoo Stock Adjustment Creation\" class=\"wp-image-33227\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Creation-1024x335.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Creation-300x98.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Creation-768x251.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Creation-1536x503.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Creation.png 1836w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Next, you\u2019ll need to enter the actual physical stock count. The system will initially show the <strong>Counted Quantity<\/strong> as zero, and you can then input the physically available quantity in the <strong>Counted Qty<\/strong> field. It\u2019s important to note that this quantity must always be a positive number. If a negative number is entered, Odoo will display a validation reminding you to <strong>\u201c<\/strong><strong>Enter positive counted quantity!\u201d<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For products tracked by serial numbers, if you try to enter a counted quantity greater than one, the system will display a validation stating that the <strong>\u201cThe serial number has already been assigned: Product: \u2018Product Code + Product Name\u2019, Serial Number: \u2018Lot\/Serial Number\u2019\u201d<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"523\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Serial-No-Validation-1024x523.png\" alt=\"Odoo Stock Adjustment Serial No Validation\" class=\"wp-image-33229\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Serial-No-Validation-1024x523.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Serial-No-Validation-300x153.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Serial-No-Validation-768x392.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Serial-No-Validation-1536x784.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Serial-No-Validation.png 1842w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Odoo automatically calculates the difference between your counted quantity and the system\u2019s on-hand quantity. This value is known as the <strong>Adjusted Quantity<\/strong>, and it is determined using the formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Adjusted Quantity = Counted Quantity - On-Hand Quantity<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If the adjusted quantity is zero, the system will show an alert indicating that <strong>\u201c<\/strong><br><strong>The product quantity is zero, so adjustments need to be done\u201d<\/strong>, no changes have been made and prompting you to verify the stock levels again.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"523\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Quantity-Validation-1024x523.png\" alt=\"Odoo Stock Adjustment Quantity Validation\" class=\"wp-image-33230\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Quantity-Validation-1024x523.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Quantity-Validation-300x153.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Quantity-Validation-768x392.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Quantity-Validation-1536x784.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Stock-Adjustment-Quantity-Validation.png 1842w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">To make it easier to understand, Odoo uses color indicators for the adjusted quantity. A <strong>negative<\/strong> adjustment (when the counted quantity is less than the system quantity) appears in <strong>red<\/strong>, while a <strong>positive<\/strong> adjustment (when more stock is found than recorded) appears in <strong>green<\/strong>. Once the adjustment is validated, the adjusted quantity will automatically change to green to indicate successful confirmation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Calculating Cost and Total Value<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Along with quantity adjustments, Odoo also helps you calculate the financial value of your stock changes. The system displays the <strong>average cost<\/strong> of each selected lot in the <strong>Cost<\/strong> field. Using this cost, it automatically computes the <strong>Total Value<\/strong> of the adjustment with the formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Total Value = Cost \u00d7 Adjusted Quantity<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This total is then displayed in the <strong>Total Value <\/strong>field, giving you a clear view of the financial impact of your stock adjustment.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"523\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Completed-Stock-Adjustment-1024x523.png\" alt=\"Odoo Completed Stock Adjustment\" class=\"wp-image-33232\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Completed-Stock-Adjustment-1024x523.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Completed-Stock-Adjustment-300x153.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Completed-Stock-Adjustment-768x392.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Completed-Stock-Adjustment-1536x784.png 1536w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Completed-Stock-Adjustment.png 1842w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After entering all necessary details, review them carefully to ensure accuracy. Once confirmed, click the <strong>Validate<\/strong> button. When you validate the document, Odoo updates the lot\u2019s <strong>On-Hand Quantity<\/strong>, <strong>Total Value<\/strong>, and <strong>Average Cost<\/strong> based on your adjustments. This ensures your inventory data is up to date and correctly reflects the actual stock situation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Managing inventory efficiently is one of the most important aspects of any business, and Odoo makes this process easier through [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[382],"tags":[99,496],"class_list":["post-33226","post","type-post","status-publish","format-standard","hentry","category-inventory","tag-inventory","tag-stock-adjustment"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33226","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=33226"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33226\/revisions"}],"predecessor-version":[{"id":37065,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33226\/revisions\/37065"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=33226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=33226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=33226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}