The IRN (Invoice Reference Number)<\/strong> is mandatory and should be entered as required. After entering the necessary details and creating the corresponding lot, simply click Validate<\/strong> to complete the GR process.<\/p>\n\n\n\n When the Goods Receipt is validated, Odoo either creates a new lot or updates an existing one, depending on the selection made during the GR process. If a new lot or serial number is entered, Odoo creates a new lot record for that product.<\/p>\n\n\n\n If an existing lot or serial number is selected, the system updates that lot with the new quantities and cost values. This ensures that every time a GR is completed, the lot data remains current and accurate.<\/p>\n\n\n\n Odoo automatically updates the on-hand quantity for each lot after a GR is completed. The Once the GR is validated, the sales price of the corresponding product is displayed in the system. You can find this value inside the lot<\/strong>, under the Price Info<\/strong> tab, within the Selling Price<\/strong> field. This helps users quickly view the latest selling price linked to the product and lot after the receipt process is completed.<\/p>\n\n\n\n The total value of a lot in Odoo is calculated by adding the values from each purchase order related to that lot. The formula used is:<\/p>\n\n\n\n For instance, if the first GR has a final gross cost of \u20b910 for 20 units, the total value will be \u20b9200. When a second GR is validated with a cost of \u20b915 for 35 units, the total value becomes \u20b9525. Adding these together gives a new total value of \u20b9725, which is displayed in the Odoo automatically calculates the average cost of each lot after every GR is validated. The formula used is:<\/p>\n\n\n\n Each time a GR is completed, Odoo recalculates the average cost based on the updated total value and on-hand quantity. This ensures that the average cost always reflects the most recent purchase prices and quantities.<\/p>\n\n\n\n For products that are tracked by lot, Odoo automatically generates a Lot Barcode<\/strong> once the Goods Receipt is completed. This barcode is created using a specific format that combines the product code with the lot ID.<\/p>\n\n\n\n For example, if the product code is 2014063<\/strong> and the lot ID is 62118<\/strong>, the generated lot barcode will be 201406362118<\/strong>. The barcode is displayed in the Lot Barcode<\/strong> field, making it easy to identify and trace the lot in future transactions.<\/p>\n\n\n\n For products tracked by serial numbers, the barcode is manually entered during the lot creation process in the GR. After the GR is validated, this barcode is displayed in the lot record for reference.<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" In Odoo, the lot plays a key role in maintaining accurate inventory records. The main purpose of lot updation after […]<\/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":[383],"tags":[448,447,459],"class_list":["post-32585","post","type-post","status-publish","format-standard","hentry","category-purchase","tag-costing-calculation","tag-lot-serial-number","tag-purchase"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/32585","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=32585"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/32585\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=32585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=32585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=32585"}],"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-Purchase-GR-Completion-Screen-1024x536.png\")
<\/figure>\n\n\n\nLot Creation and Updation After GR<\/h2>\n\n\n\n
Updating On-Hand Quantity After GR<\/h2>\n\n\n\n
on-hand quantity represents the actual quantity available in stock for that particular lot. For
example, if a product already has 20 units on hand and a new GR adds 35 more units, the updated on-hand quantity becomes 55 units. This automatic update helps users keep track of the real-time quantity available for each lot.<\/p>\n\n\n\n![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Lot-Or-Serial-Number-Quantity-updates-after-GR-1024x787.png\")
<\/figure>\n\n\n\nDisplaying Sales Price After GR Validation<\/h2>\n\n\n\n
Calculation of Total Lot Value<\/strong><\/h2>\n\n\n\n
Total Value = (Final Gross Cost\u2081 \u00d7 Quantity\u2081) + (Final Gross Cost\u2082 \u00d7 Quantity\u2082) + \u2026<\/code><\/pre>\n\n\n\n
Total Value<\/strong> field of the lot.<\/p>\n\n\n\nAverage Cost Calculation in Lot<\/h2>\n\n\n\n
Average Cost = Total Value \/ On-Hand Quantity<\/code><\/pre>\n\n\n\n![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Lot-Or-Serial-Number-Cost-updation-after-GR-1-1024x768.png\")
<\/figure>\n\n\n\nLot Barcode Generation After GR<\/h2>\n\n\n\n
![\"Odoo](\"https:\/\/tenthplanet.in\/odoo\/wp-content\/uploads\/sites\/8\/2025\/11\/Tenthplanet-Odoo-Lot-Or-Serial-Number-Lot-Barcode-updates-after-GR-1024x853.png\")
<\/figure>\n\n\n\n