Whenever a products are returned to the vendor, 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<\/strong> must be configured with the Average Costing Method<\/strong>. These settings allow Odoo to compute and update the average cost within each lot accurately.<\/p>\n\n\n\n For example, consider a lot that currently has an on-hand quantity of 25 PCS<\/strong> (after purchase and sales) with an Final Gross Cost <\/strong>of 160, and the total value <\/strong>of 4000 , <\/strong>so the average cost <\/strong>is 160. Odoo uses this stored information during a vendor return to ensure that your inventory valuation remains accurate.<\/p>\n\n\n\n To start a new Vendor Return process, navigate to the Inventory module, click Operations and select Vendor Return<\/strong>. Click the +New<\/strong> button to create a new document. Choose the vendor from the Vendor drop down, then select the reason for the return from the Reasons for Return<\/strong> field. After you save the record, Odoo will automatically generate a Document Number<\/strong> for the return.<\/p>\n\n\n\n Next, click Add a line<\/strong> to include the product you want to return. You can choose the product and select the related GR Bill from the Bill drop down and enter the return quantity as 4 in the Demand <\/strong>field. Once done, click Mark as To Do<\/strong>. Select the appropriate lot in the Available Lot<\/strong> field so the Cost <\/strong>field displays the Final Gross Cost of the selected lot. Make sure the Product is available using the Product Availability.<\/p>\n\n\n\n When all entries are correct, you can click Validate<\/strong>. As soon as the vendor return document 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 a 4 PCS from a lot is returned to vendor so the new on-hand quantity<\/strong> becomes 21 PCS and cost taken from the vendor return document is 160 . 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 So Total Value is displayed as 3360.00 and Average Cost is displayed as 160. This ensures that both stock and financial records remain accurate after the returned items are removed from the system. Odoo handles these updates automatically, giving users reliable information about stock levels and lot-specific valuation at all times.<\/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":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[382],"tags":[99,724,464],"class_list":["post-34765","post","type-post","status-publish","format-standard","hentry","category-inventory","tag-inventory","tag-lot-values-calculation","tag-vendor-return"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34765","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=34765"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34765\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-1-1024x818.png\")
<\/figure>\n\n\n\nCreating a new Vendor Return in Odoo Inventory<\/strong><\/h2>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Completed-Vendor-Return-1024x442.png\")
<\/figure>\n\n\n\nValidating the Vendor Return Document<\/strong><\/h2>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Vendor-Return-1024x779.png\")
<\/figure>\n\n\n\nViewing the updated Lot Details in Odoo Inventory<\/strong><\/h2>\n\n\n\n
Total Value = Existing Total value - (Cost \u00d7 On-Hand Quantity)\nTotal Value = 4000 \u2013 (160 * 4) = 3360<\/code><\/pre>\n\n\n\nAverage Cost = Total Value \u00f7 On-Hand Quantity\nAverage Cost = 3360 \u00f7 21 = 160<\/code><\/pre>\n\n\n\n