Whenever a stock adjustment is validated in Odoo, the system refreshes the information stored in the related lot. This includes the latest on-hand quantity, the total value of the items in that lot, and the average cost. These updates ensure the lot always shows correct and current inventory data.<\/p>\n\n\n\n
Before this process works correctly, two important prerequisites must be met. The product must be tracked either by Lots<\/strong> or Unique Serial Numbers<\/strong>, and the Product Category must be configured with the Average Costing Method. These settings allow Odoo to compute and update the average cost within each lot accurately.<\/p>\n\n\n\n For example,<\/strong> a lot has a Current On-Hand Quantity 2 PCS (after sales & returns) with a average cost of 102.90 and a Total value of 205.8. The System uses this information to keep your inventory valuation accurate.<\/p>\n\n\n\n You can check these details anytime by opening the Lot\/Serial Number Master inside the Inventory module. Here, all the lot information, such as quantity and cost is displayed in one place.<\/p>\n\n\n\n To create a stock adjustment in Odoo, click +New<\/strong> to start a new document. The Document Type<\/strong> will automatically appear as Stock Adjustments. Select the Source Location<\/strong> where the products are stored and choose the appropriate Product Category<\/strong> from the dropdown. Once you click Save<\/strong>, Odoo will generate a unique Stock Adjustment Document Number to track the adjustment.<\/p>\n\n\n\n After creating the document, add the products that need adjustment. Select the product and choose the correct Lot<\/strong> or Serial Number<\/strong>. The system will then automatically fill in key details like the Lot Barcode<\/strong>, On-Hand Quantity<\/strong>, and GRN<\/strong> Date.<\/strong><\/p>\n\n\n\n You then enter the physically counted quantity \u2014 for example, 5 PCS. Odoo compares this with the system quantity and shows the difference as Adjust Quantity <\/strong>which in this case is 3 PCS.<\/p>\n\n\n\n When all entries are correct, you can click Validate<\/strong>. As soon as the adjustment is validated, the System immediately updates the lot values. The on-hand quantity changes based on the new count, and the total value and average cost are recalculated. These changes help maintain accurate inventory valuation.<\/p>\n\n\n\n To see the updated results, you can return to the same lot in the Lot\/Serial Number Master. For example, if the new on-hand quantity after adjustment is 5 PCS<\/strong> and cost taken from the stock adjustment document is 102.90 <\/strong>this cost is used for calculating the Total Value<\/strong>, which is determined using the formula:<\/p>\n\n\n\n The Average Cost<\/strong> is then displayed using the formula:<\/p>\n\n\n\n With every stock adjustment, Odoo keeps your lot values accurate and up to date. This automatic update process ensures your inventory always reflects the real quantities and costs. It helps maintain smooth, reliable, and error-free stock management.<\/p>\n","protected":false},"excerpt":{"rendered":" Managing inventory accurately is important for any business, and Odoo makes this easier with features that automatically adjust lot values […]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[382],"tags":[448,99,496],"class_list":["post-33695","post","type-post","status-publish","format-standard","hentry","category-inventory","tag-costing-calculation","tag-inventory","tag-stock-adjustment"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33695","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=33695"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33695\/revisions"}],"predecessor-version":[{"id":37011,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/33695\/revisions\/37011"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=33695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=33695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=33695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number--1024x858.png\" "\\"\\"")
<\/figure>\n\n\n\nCreation of Stock Adjustment in Odoo Inventory<\/h2>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Inventory-Completed-Stock-Adjustment--1024x310.png\" "\\"\\"")
<\/figure>\n\n\n\nValidating the Stock Adjustment Document<\/strong><\/h2>\n\n\n\n
Viewing the Updated Lot Details<\/strong><\/strong><\/h2>\n\n\n\n
Total Value = Cost \u00d7 On-Hand Quantity\nTotal Value = 102.90 \u00d7 5 = 514.5<\/code><\/pre>\n\n\n\nAverage Cost = Total Value \u00f7 On-Hand Quantity\nAverage Cost = 514.5 \u00f7 5 = 102.90<\/code><\/pre>\n\n\n\n![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Stock-Adjustment-1024x858.png\" "\\"\\"")
<\/figure>\n\n\n\n