{"id":35160,"date":"2025-12-10T12:40:26","date_gmt":"2025-12-10T12:40:26","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=35160"},"modified":"2025-12-11T05:02:40","modified_gmt":"2025-12-11T05:02:40","slug":"how-lot-values-are-updated-after-completing-the-off-claim-invoice-in-odoo-inventory","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/inventory\/how-lot-values-are-updated-after-completing-the-off-claim-invoice-in-odoo-inventory\/","title":{"rendered":"How Lot values are updated after Completing the Off Claim Invoice in Odoo Inventory"},"content":{"rendered":"\n<p>Managing additional charges in Off claim Invoices is an important part of accurate inventory and accounting in Odoo. When costs such as freight charges or cash discounts are applied to an Off claim Invoice, these cost adjustments are automatically reflected in the valuation of the associated product lots.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Creating an Off claim Invoice in Odoo Inventory<\/strong><\/h2>\n\n\n\n<p>To create an new Off claim Invoice, go to the <strong>Inventory<\/strong> module from your dashboard. Then click on <strong>Operations<\/strong> and under <strong>Adjustments<\/strong> choose<strong> Additional Cost . <\/strong>Click <strong>+New<\/strong> to create a new Offclaim Invoice document.<\/p>\n\n\n\n<p>The <strong>Date<\/strong> field defaults to the current date. In the <strong>Apply On<\/strong> field, select <strong>Off claim Invoice<\/strong> to specify the type of cost adjustment. Before saving, you must fill in two mandatory fields: <strong>Vendor Name<\/strong> and <strong>Products<\/strong>. Enter the vendor name in the <strong>Vendor<\/strong> field and select the correct vendor from the drop down list. Only products associated with the selected vendor will appear. You can add products using the Product Code, Name or Lot Barcode.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"484\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Creation-1024x484.png\" alt=\"Odoo Inventory Off Claim Invoice Creation\" class=\"wp-image-35163\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Creation-1024x484.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Creation-300x142.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Creation-768x363.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Creation.png 1169w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once the products are added, the corresponding product lots will appear in the <strong>Product Lots<\/strong> field. You can select multiple lots for a single product . After selecting the vendor, products and lots, click <strong>Save<\/strong> to generate the document number and store the invoice.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Applying Cash Discount in Off Claim Invoice<\/strong><\/h2>\n\n\n\n<p>To account any cash discounts then under the <strong>Additional Costs<\/strong> section, click <strong>Add a Line<\/strong> and select the product called [CD] CASH DISCOUNT , enter the cost as a negative value (for example, -\u20b9100). As configured in the service product, the split method is set to By Current Cost<strong>.<\/strong> These charges are now linked to the selected lots. Click <strong>Validate<\/strong> to finalize the Off claim Invoice.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"624\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Cash-Discount-Applied-1024x624.png\" alt=\"Odoo Inventory Off Claim Invoice Cash Discount Applied\" class=\"wp-image-35164\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Cash-Discount-Applied-1024x624.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Cash-Discount-Applied-300x183.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Cash-Discount-Applied-768x468.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Cash-Discount-Applied.png 1189w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Applying Freight Charges in Off Claim Invoice<\/strong><\/h2>\n\n\n\n<p>To account any freight charges then under the Additional Costs section, click <strong>Add a Line<\/strong> and select the product called [FREIGHT] FREIGHT CHARGES 0% and enter the cost as a positive value, (for example, \u20b91500). As configured in the service product, the split method is set to By Current Cost. These charges are now linked to the selected lots. Click <strong>Validate<\/strong> to finalize the Off claim Invoice.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"766\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Freight-Charges-Applied-1024x766.png\" alt=\"Odoo Inventory Off Claim Invoice Freight Charges Applied\" class=\"wp-image-35166\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Freight-Charges-Applied-1024x766.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Freight-Charges-Applied-300x225.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Freight-Charges-Applied-768x575.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Off-Claim-Invoice-Freight-Charges-Applied.png 1189w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Total Value Recalculation under Valuation Adjustment tab<\/strong><\/h2>\n\n\n\n<p>Once the Off claim Invoice is validated, In the <strong>Valuation Adjustment<\/strong> tab, the system displays key details that show how the cost has been adjusted for each lot. The <strong>Original Value<\/strong> represents the existing Total Value for the lot before any adjustments, while the <strong>Additional Cost<\/strong> field shows the exact charge entered in the Off claim Invoice such as freight charges(positive value) or cash discount (negative value). The <strong>Quantity <\/strong>displays the current On Hand Qty of the lot.<\/p>\n\n\n\n<p>The <strong>New Value<\/strong> is then calculated by using the formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>New Value = Original Value \u00b1 Additional Cost<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><strong>Viewing the Updated Lot Values in Odoo Inventory<\/strong><\/strong><\/h2>\n\n\n\n<p>After validation, the updated values are immediately reflected in the Lot Master. The Total Value field in the lot displays the newly calculated New Value and the Additional Cost per unit is calculated by dividing the total additional cost by the On Hand Quantity of the lot. This ensures that every unit within the lot carries the correct adjusted cost.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Impact of Cash Discount on Lot Values<\/strong><\/h3>\n\n\n\n<p>When you open the Lot or Serial Number Master for a lot where a cash discount was applied, the Add Cost field appears as a negative amount, indicating that the lot\u2019s cost has been reduced. Odoo recalculates the Total Value using the formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>New Value = Original Value \u2013 Additional Cost<\/code><\/pre>\n\n\n\n<p>The updated <strong>New Value<\/strong> is then displayed in the <strong>Total Value<\/strong> field of the lot.<br>Additionally, the <strong>Add Cost per unit<\/strong> is automatically calculated using:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Add Cost per Unit = Total Additional Cost \u00f7 On Hand Quantity<\/code><\/pre>\n\n\n\n<p>Based on this updated Total Value, the <strong>Average Cost<\/strong> is also recalculated to ensure that the inventory valuation accurately reflects the impact of the cash discount.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"750\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Cash-Disc-1024x750.png\" alt=\"Odoo Inventory Lot and Serial Number Values Updated after Off Claim Invoice for Cash Disc\" class=\"wp-image-35169\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Cash-Disc-1024x750.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Cash-Disc-300x220.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Cash-Disc-768x563.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Cash-Disc.png 1189w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Impact of Freight Charges on Lot Values<\/strong><\/h3>\n\n\n\n<p>When you open the Lot or Serial Number Master for a lot where a freight charges was applied, the Add Cost field appears as a positive amount, indicating that the lot\u2019s cost has been increased. Odoo recalculates the Total Value using the formula:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>New Value = Original Value + Additional Cost<\/code><\/pre>\n\n\n\n<p>The updated <strong>New Value<\/strong> is then displayed in the <strong>Total Value<\/strong> field of the lot.<br>Additionally, the <strong>Add Cost per unit<\/strong> is automatically calculated using:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Add Cost per Unit = Total Additional Cost \u00f7 On Hand Quantity<\/code><\/pre>\n\n\n\n<p>Based on this updated Total Value, the <strong>Average Cost<\/strong> is also recalculated to ensure that the inventory valuation accurately reflects the impact of the cash discount.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"711\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Freight-Charges-1024x711.png\" alt=\"Odoo Inventory Lot and Serial Number  Values Updated after Off Claim Invoice for Freight Charges\" class=\"wp-image-35170\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Freight-Charges-1024x711.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Freight-Charges-300x208.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Freight-Charges-768x533.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/TenthPlanet-Odoo-Inventory-Lot-and-Serial-Number-Values-Updated-after-Off-Claim-Invoice-for-Freight-Charges.png 1189w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In the <strong>Price Info<\/strong> tab, both the <strong>Purchase Cost<\/strong> and <strong>Selling Price<\/strong> sections are updated based on the new costs. This ensures that any changes from freight charges, cash discounts, or other adjustments are reflected immediately, keeping the product\u2019s pricing accurate without any manual updates.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Managing additional charges in Off claim Invoices is an important part of accurate inventory and accounting in Odoo. When costs [&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,724,529],"class_list":["post-35160","post","type-post","status-publish","format-standard","hentry","category-inventory","tag-inventory","tag-lot-values-calculation","tag-off-claim-invoice"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/35160","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=35160"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/35160\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=35160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=35160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=35160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}