{"id":34737,"date":"2025-12-05T11:43:44","date_gmt":"2025-12-05T11:43:44","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=34737"},"modified":"2025-12-11T05:03:42","modified_gmt":"2025-12-11T05:03:42","slug":"how-lot-is-updated-after-completing-a-delivery-order-in-odoo-sales","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/sales\/how-lot-is-updated-after-completing-a-delivery-order-in-odoo-sales\/","title":{"rendered":"How Lot is updated after Completing a Delivery Order in odoo Sales"},"content":{"rendered":"\n<p>Once the Delivery Order is completed, the details are updated in the lot or batch for a lot-based product. The on-hand quantity, transfer quantity, cost, and sales count are all updated in the Lot Master.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Creating a Sales Order in Odoo<\/strong><\/h2>\n\n\n\n<p>To create a <strong>Sales Order<\/strong>, first choose the customer. Once the customer is selected, the <strong>Invoice<\/strong> <strong>Address<\/strong> and <strong>Delivery<\/strong> <strong>Address<\/strong> are automatically filled in. These three fields are mandatory. The <strong>Payment<\/strong> <strong>Terms<\/strong> field is optional.<\/p>\n\n\n\n<p>In the <strong>Order Lines<\/strong> section, click Add a <strong>Product<\/strong>. You can add the product using the product code or the lot\/serial barcode. For a lot product, you must select the <strong>Lot<\/strong>; otherwise, an <strong>invalid operation <\/strong>error will occur.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"252\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-1024x252.png\" alt=\"Odoo Sales Lot\" class=\"wp-image-34742\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-1024x252.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-300x74.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-768x189.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot.png 1128w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Check the product&#8217;s on-hand quantity, total value, cost, and average cost. Also, verify the unit price and ensure that the quantity is accurate.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>To view and Complete the Delivery Order<\/strong><\/h2>\n\n\n\n<p>Once the Sales Order is <strong>confirmed<\/strong>, it becomes locked. Click <strong>Delivery<\/strong> to view the Delivery Order.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"570\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Sales-Order-1024x570.png\" alt=\"Odoo Sales Lot Sales Order\" class=\"wp-image-34745\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Sales-Order-1024x570.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Sales-Order-300x167.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Sales-Order-768x427.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Sales-Order.png 1156w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Check the product availability. If the product is not available, you cannot proceed with completing the Delivery Order, and a validation error will occur.<\/p>\n\n\n\n<p>Once you change the correct source location, the product availability will show as Available. The <strong>Source Document <\/strong>will also display correctly based on the Sales Order number (e.g., <em>S00405<\/em>). You can change the <strong>Scheduled Date<\/strong>, but it is not necessary. The Delivery Order ID will be generated automatically. In the <strong>Operations<\/strong> tab, you will see the product, quantity, and unit price pulled from the confirmed Sales Order. Once you <strong>Validate<\/strong> the Delivery Order, the product will be dispatched and delivered to the customer\u2019s address.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"381\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Delivery-Order-1024x381.png\" alt=\"Odoo Sales Lot Delivery Order\" class=\"wp-image-34748\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Delivery-Order-1024x381.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Delivery-Order-300x112.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Delivery-Order-768x286.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Delivery-Order.png 1174w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once the delivery order is complete, verify the product lot. Before the delivery order, the on-hand quantity was 16. After completing the delivery order, the on-hand quantity is now 15. Based on this change, the total value is updated and calculated as <strong>on-hand quantity * cost (15 * 32 = 480)<\/strong>. The average cost and the cost are also updated and recalculated based on the<strong> total value divided by the on-hand quantity (480 \/ 15 = 32).<\/strong><\/p>\n\n\n\n<p>Additionally, the sales and transfers at the top of the page are also updated accordingly<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"381\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Updated-1-1024x381.png\" alt=\"Odoo Sales Lot Updated\" class=\"wp-image-34750\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Updated-1-1024x381.png 1024w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Updated-1-300x112.png 300w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Updated-1-768x286.png 768w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Updated-1.png 1174w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>Note: The total value, average cost, and cost are updated based on the &#8216;Valuation by Lot\/Serial Number&#8217; setting enabled in the Product Master. If this setting is disabled, the total value, average cost, and cost will be shown as zero.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"564\" height=\"230\" src=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Traceability.png\" alt=\"Odoo Sales Lot Traceability\" class=\"wp-image-34752\" srcset=\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Traceability.png 564w, https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/12\/Tenthplanet-Odoo-Sales-Lot-Traceability-300x122.png 300w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Once the Delivery Order is completed, the details are updated in the lot or batch for a lot-based product. The [&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":[399],"tags":[451,457,107,458],"class_list":["post-34737","post","type-post","status-publish","format-standard","hentry","category-sales","tag-delivery-order","tag-lot-product","tag-sales","tag-sales-order"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34737","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=34737"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/34737\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=34737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=34737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=34737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}