{"id":10118,"date":"2026-11-16T09:28:25","date_gmt":"2026-11-16T06:28:25","guid":{"rendered":"https:\/\/machinser.com\/?p=10118"},"modified":"2026-11-16T09:28:25","modified_gmt":"2026-11-16T06:28:25","slug":"odoo-19-fifo-avco-inventory-costing","status":"publish","type":"post","link":"https:\/\/machinser.com\/ar\/odoo-19-fifo-avco-inventory-costing\/","title":{"rendered":"FIFO vs AVCO in Odoo 19: Which Inventory Costing Method Is Right for Your Business?"},"content":{"rendered":"<p class=\"western\">Inventory costing is more than assigning a price to a product. It affects the value of your stock, the cost of goods sold, and the profit shown in your financial reports.<\/p>\n<p class=\"western\">Imagine a business that purchases the same product several times at different prices. The first batch costs \u20b9100 per unit, the next costs \u20b9120, and a later batch costs \u20b9130. When the business sells one unit, which purchase cost should Odoo use?<\/p>\n<p class=\"western\">The answer depends on the costing method configured for the product category.<\/p>\n<h2 class=\"western\">The Three Main Costing Methods<\/h2>\n<ul>\n<li>Standard Price: Uses a manually maintained cost.<\/li>\n<li>Average Cost (AVCO): Calculates the average cost of available inventory.<\/li>\n<li>First In First Out (FIFO): Uses the cost of the earliest inventory layer first.<\/li>\n<\/ul>\n<p class=\"western\">In this guide, we explore how these methods work in Odoo 19, compare them with practical examples, and explain how to choose the right method for your business.<\/p>\n<h2 class=\"western\">What Is Inventory Costing in Odoo?<\/h2>\n<p class=\"western\">Inventory costing is the method used to determine the financial value of products held in stock and the cost assigned to products when they are sold or consumed.<\/p>\n<p class=\"western\">For example, a wholesale business purchases 100 units of a product at \u20b9100 each. A week later, it purchases another 100 units at \u20b9120 each. The business now has 200 units, but they were not purchased at the same price.<\/p>\n<p class=\"western\">When some of these units are sold, Odoo needs a method to calculate their cost. This is where Standard Cost, AVCO, and FIFO become important.<\/p>\n<p class=\"western\">The selected costing method can influence:<\/p>\n<ul>\n<li>Inventory valuation<\/li>\n<li>Cost of goods sold (COGS)<\/li>\n<li>Product profitability<\/li>\n<li>Manufacturing costs<\/li>\n<li>Financial reporting<\/li>\n<\/ul>\n<p class=\"western\">Important: In Odoo, the costing method is configured at the product category level. Products assigned to that category follow its costing method.<\/p>\n<h2 class=\"western\">Understanding the Three Costing Methods<\/h2>\n<h3 class=\"western\">A. Standard Price \u2013 A Fixed Cost for the Product<\/h3>\n<p class=\"western\">Standard Price uses a predefined cost for a product. The cost does not automatically change every time the business purchases the product at a different price.<\/p>\n<p class=\"western\">Example: A company sets the standard cost of a product at \u20b9100 per unit.<\/p>\n<p>&nbsp;<\/p>\n<table width=\"666\" cellspacing=\"0\" cellpadding=\"7\">\n<tbody>\n<tr>\n<td bgcolor=\"#17365d\" width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Transaction<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Purchase price<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Standard cost<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">First purchase<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Second purchase<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">120<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Third purchase<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">130<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p class=\"western\">Even if the supplier increases the purchase price, the product&#8217;s standard cost remains \u20b9100 until someone updates it.<\/p>\n<p class=\"western\">When is Standard Price useful?<\/p>\n<ul>\n<li>Businesses that work with relatively stable product costs.<\/li>\n<li>Companies that want a predefined cost for planning.<\/li>\n<li>Manufacturing businesses that use planned or estimated production costs.<\/li>\n<\/ul>\n<p class=\"western\">Example: A furniture manufacturer may set a standard cost for a chair based on its expected material and production expenses. The actual cost may vary, but the standard cost provides a consistent reference.<\/p>\n<h3 class=\"western\">B. Average Cost (AVCO) \u2013 Cost Based on Average Inventory Value<\/h3>\n<p class=\"western\">Average Cost, commonly called AVCO, calculates the average cost of the inventory currently available. When new stock is received at a different price, Odoo recalculates the average cost based on the existing inventory value and the incoming inventory value.<\/p>\n<p>&nbsp;<\/p>\n<table width=\"666\" cellspacing=\"0\" cellpadding=\"7\">\n<tbody>\n<tr>\n<td bgcolor=\"#17365d\" width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Purchase<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Quantity<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Unit price<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Total value<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">First<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">10,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Second<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">120<\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">12,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Third<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">130<\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">13,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Total<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">300<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\"><\/td>\n<td width=\"152\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">35,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p class=\"western\">Average cost = \u20b935,000 \u00f7 300 = \u20b9116.67 per unit (approximately).<\/p>\n<p class=\"western\">If the company sells 50 units, the cost assigned to those units is approximately \u20b95,833.50.<\/p>\n<p class=\"western\">When is AVCO useful?<\/p>\n<ul>\n<li>Retail and wholesale businesses.<\/li>\n<li>Businesses that purchase the same products at changing prices.<\/li>\n<li>Companies that prefer a blended cost rather than tracking individual purchase layers.<\/li>\n<\/ul>\n<p class=\"western\">Example: A grocery wholesaler purchases cooking oil from suppliers at different prices throughout the month. AVCO provides an average cost based on the inventory received and still available.<\/p>\n<h3 class=\"western\">C. FIFO \u2013 First In First Out<\/h3>\n<p class=\"western\">FIFO stands for First In First Out. Under this method, the cost of the earliest received inventory is used first when calculating the cost of products leaving stock.<\/p>\n<p>&nbsp;<\/p>\n<table width=\"666\" cellspacing=\"0\" cellpadding=\"7\">\n<tbody>\n<tr>\n<td bgcolor=\"#17365d\" width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Purchase batch<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Quantity<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Unit cost<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Batch 1<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Batch 2<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">120<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Batch 3<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">130<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p class=\"western\">The company now has 300 units and sells 150 units. Under FIFO, the first 100 units are valued at \u20b9100 each and the next 50 units are valued at \u20b9120 each.<\/p>\n<p class=\"western\">Cost of sale = (100 \u00d7 \u20b9100) + (50 \u00d7 \u20b9120) = \u20b916,000.<\/p>\n<p>&nbsp;<\/p>\n<table width=\"666\" cellspacing=\"0\" cellpadding=\"7\">\n<tbody>\n<tr>\n<td bgcolor=\"#17365d\" width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Remaining batch<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Quantity<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Unit cost<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Value<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Batch 2<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">50<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">120<\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">6,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Batch 3<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">100<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">130<\/span><\/span><\/p>\n<\/td>\n<td width=\"152\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">13,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"152\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Total<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">150<\/span><\/span><\/p>\n<\/td>\n<td width=\"153\"><\/td>\n<td width=\"152\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">19,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p class=\"western\">When is FIFO useful?<\/p>\n<ul>\n<li>Businesses dealing with products purchased at changing prices.<\/li>\n<li>Companies that want inventory costs to follow receipt order.<\/li>\n<li>Businesses that manage stock with batches or dated inventory.<\/li>\n<\/ul>\n<p class=\"western\">Example: An electronics distributor purchases the same accessory at different prices over several months. FIFO helps calculate the cost of outgoing stock using the oldest cost layers first.<\/p>\n<h2 class=\"western\">How to Configure Costing Methods in Odoo 19<\/h2>\n<p class=\"western\">Odoo allows you to configure the costing method from the product category. Follow these steps to set it up.<\/p>\n<ol>\n<li>Go to Inventory \u2192 Configuration \u2192 Product Categories.<\/li>\n<li>Open an existing category or create a new one. Locate the Inventory Valuation section.<\/li>\n<li>Select Standard Price, Average Cost (AVCO), or First In First Out (FIFO) as the costing method.<\/li>\n<\/ol>\n<figure id=\"attachment_10119\" aria-describedby=\"caption-attachment-10119\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-10119 size-large\" src=\"https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/2-1-1024x685.png\" alt=\"\" width=\"1024\" height=\"685\" srcset=\"https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/2-1-1024x685.png 1024w, https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/2-1-300x201.png 300w, https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/2-1-768x514.png 768w, https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/2-1-18x12.png 18w, https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/2-1.png 1316w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption id=\"caption-attachment-10119\" class=\"wp-caption-text\">Figure 1. Choose Standard Price, First In First Out (FIFO), or Average Cost (AVCO) in the product category.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p class=\"western\">After saving the category, open the relevant product and assign it to that category. The second screenshot shows the TV product assigned to the Electronics category.<\/p>\n<figure id=\"attachment_10120\" aria-describedby=\"caption-attachment-10120\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"wp-image-10120 size-large\" src=\"https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/1-1-1024x685.png\" alt=\"\" width=\"1024\" height=\"685\" srcset=\"https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/1-1-1024x685.png 1024w, https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/1-1-300x201.png 300w, https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/1-1-768x514.png 768w, https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/1-1-18x12.png 18w, https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/1-1.png 1316w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption id=\"caption-attachment-10120\" class=\"wp-caption-text\">Figure 2. The TV product is assigned to the Electronics category and follows that category&#8217;s costing configuration.<\/figcaption><\/figure>\n<p class=\"western\">Manual valuation updates inventory valuation through periodic accounting entries. Automated valuation creates relevant accounting entries when stock valuation changes. Automated valuation requires the appropriate stock valuation and accounting accounts to be configured.<\/p>\n<p class=\"western\">The exact options visible can depend on installed applications and database configuration. Review the accounting implications before changing settings in a live database.<\/p>\n<h2 class=\"western\">FIFO vs AVCO: A Practical Comparison<\/h2>\n<p class=\"western\">Using the same example, a business purchases 300 units: 100 at \u20b9100, 100 at \u20b9120, and 100 at \u20b9130. It then sells 150 units.<\/p>\n<p>&nbsp;<\/p>\n<table width=\"666\" cellspacing=\"0\" cellpadding=\"7\">\n<tbody>\n<tr>\n<td bgcolor=\"#17365d\" width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Costing method<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Cost assigned to 150 units sold<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Remaining stock value<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Standard Price (\u20b9100)<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">15,000<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">15,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">AVCO (\u20b9116.67)<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">17,500.50*<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">17,500.50*<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">FIFO<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">16,000<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\">\u20b9<span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">19,000<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p class=\"western\">Calculated using the average cost of \u20b9116.67 per unit, rounded to two decimal places. Actual Odoo valuation may retain greater precision.<\/p>\n<p class=\"western\">The results differ because each costing method applies a different approach to assigning costs. Standard Price keeps the predefined cost, AVCO uses a blended average cost, and FIFO uses the oldest remaining cost layers first.<\/p>\n<p class=\"western\">There is no single method that always produces the highest profit. The result depends on purchase prices, stock movements, and the method selected.<\/p>\n<h2 class=\"western\">FIFO and Product Returns in Odoo<\/h2>\n<p class=\"western\">Returns are an important part of inventory management. Consider a business that sells a product and later receives some of those units back from the customer.<\/p>\n<p class=\"western\">With FIFO, the cost associated with a return can matter because inventory valuation is based on cost layers. When a return is linked to the original delivery, Odoo can use the original movement&#8217;s valuation information when reversing the stock movement.<\/p>\n<p class=\"western\">Practical recommendation: Process customer returns using the original delivery&#8217;s return action whenever appropriate. This helps keep the return linked to the original transaction.<\/p>\n<h2 class=\"western\">Understanding Costing Methods in Manufacturing<\/h2>\n<p class=\"western\">Costing methods are also relevant to manufacturing businesses. Imagine a company that manufactures wooden tables using wooden boards, screws, paint, labour, and production operations.<\/p>\n<p class=\"western\">The total manufacturing cost can include the cost of components and other production costs configured in the manufacturing workflow. The costing method determines how the cost of inventory is valued as products enter or leave stock.<\/p>\n<p class=\"western\">This makes costing methods important for understanding the value of raw materials, the cost of finished products, the cost of products sold, and the value of remaining inventory.<\/p>\n<p class=\"western\">The exact manufacturing valuation also depends on the Bill of Materials, component consumption, operations, and the manufacturing and accounting configuration.<\/p>\n<h2 class=\"western\">FIFO Costing vs FIFO Stock Removal: What Is the Difference?<\/h2>\n<p class=\"western\">Both features use the term FIFO, but they serve different purposes.<\/p>\n<h4 class=\"western\">FIFO Costing Method<\/h4>\n<p class=\"western\">FIFO costing determines how Odoo assigns costs to outgoing inventory and values the remaining stock.<\/p>\n<h4 class=\"western\">FIFO Removal Strategy<\/h4>\n<p class=\"western\">The FIFO removal strategy determines which physical stock is selected for an outgoing transfer. It prioritises the stock that entered the location first.<\/p>\n<p class=\"western\">For example, if Batch A was received on 1 November and Batch B on 10 November, FIFO removal prioritises Batch A when preparing an outgoing transfer.<\/p>\n<p class=\"western\">Selecting FIFO as the costing method does not automatically mean that the FIFO removal strategy is configured for warehouse operations. These settings have different purposes.<\/p>\n<h2 class=\"western\">Common Mistakes to Avoid<\/h2>\n<ul>\n<li><b>Confusing costing methods with removal strategies: <\/b>FIFO costing and FIFO removal are separate configurations. One deals with financial valuation; the other deals with physical stock selection.<\/li>\n<li><b>Changing the costing method without reviewing its impact: <\/b>Changing a product category&#8217;s costing method can affect future inventory valuation. Review accounting and valuation implications before changing it in a live database.<\/li>\n<li><b>Ignoring inventory valuation settings: <\/b>Selecting a costing method alone does not complete the accounting configuration. Check manual or automated valuation and configure the necessary accounts.<\/li>\n<li><b>Forgetting to review product categories: <\/b>Products follow the costing method of their assigned category. An incorrect category can result in an unintended costing method.<\/li>\n<li><b>Processing returns incorrectly: <\/b>Use the appropriate return workflow and link the return to the original delivery whenever possible.<\/li>\n<\/ul>\n<h2 class=\"western\">Which Costing Method Should Your Business Choose?<\/h2>\n<p>&nbsp;<\/p>\n<table width=\"666\" cellspacing=\"0\" cellpadding=\"7\">\n<tbody>\n<tr>\n<td bgcolor=\"#17365d\" width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Business type<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Possible choice<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<td bgcolor=\"#17365d\" width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"color: #ffffff;\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\"><b>Why?<\/b><\/span><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Retail business<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">AVCO or FIFO<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Useful for products purchased at changing prices.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Wholesale distributor<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">AVCO or FIFO<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Helps value inventory when purchase prices vary.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Manufacturing company<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Standard Price, AVCO or FIFO<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Depends on how material and production costs are managed.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Business with stable costs<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Standard Price<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Provides a consistent predefined cost.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Business handling dated stock<\/span><\/span><\/p>\n<\/td>\n<td width=\"208\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">FIFO<\/span><\/span><\/p>\n<\/td>\n<td width=\"207\">\n<p class=\"western\" align=\"left\"><span style=\"font-family: Aptos, serif;\"><span style=\"font-size: small;\">Helps align cost layers with the order inventory is received.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p class=\"western\">These are general examples, not strict rules. Accounting policies, local requirements, and business operations should guide the final choice.<\/p>\n<h2 class=\"western\">Frequently Asked Questions<\/h2>\n<p class=\"western\"><b>Where can I configure FIFO in Odoo 19?<\/b><\/p>\n<p class=\"western\">Go to Inventory \u2192 Configuration \u2192 Product Categories, open the relevant category, and select FIFO as the costing method.<\/p>\n<p class=\"western\"><b>Does AVCO change automatically when a new purchase is received?<\/b><\/p>\n<p class=\"western\">Under AVCO, the average cost is recalculated when inventory is received at a different cost, based on existing inventory value and incoming stock value.<\/p>\n<p class=\"western\"><b>Does FIFO always mean the oldest physical product is delivered first?<\/b><\/p>\n<p class=\"western\">No. FIFO costing determines how inventory costs are assigned. The FIFO removal strategy determines which physical stock is selected for outgoing transfers.<\/p>\n<p class=\"western\"><b>Can I use different costing methods for different products?<\/b><\/p>\n<p class=\"western\">Yes. Assign products to different product categories, each with its own costing method. Products within a category follow that category&#8217;s configuration.<\/p>\n<p class=\"western\"><b>Which method is best for a manufacturing company?<\/b><\/p>\n<p class=\"western\">There is no universal best method. The choice depends on whether the business uses predefined costs, prefers average material costs, or wants cost layers to follow receipt order.<\/p>\n<p class=\"western\"><b>Does the costing method affect the profit shown in Odoo?<\/b><\/p>\n<p class=\"western\">Yes. The cost assigned to outgoing products affects cost of goods sold and therefore influences gross profit. Remaining stock value is also affected.<\/p>\n<h2 class=\"western\">Conclusion<\/h2>\n<p class=\"western\">Choosing the right inventory costing method is an important part of setting up Odoo for accurate stock and financial management.<\/p>\n<p class=\"western\">Standard Price is suitable when a business wants to maintain a predefined product cost. AVCO provides an average cost as new inventory is received. FIFO uses the earliest remaining inventory cost layers first.<\/p>\n<p class=\"western\">Odoo 19 provides these methods to support different inventory and accounting requirements. Understanding how each one works helps businesses make better decisions about stock valuation, product profitability, and financial reporting.<\/p>\n<p class=\"western\">Before selecting a method, consider how frequently your purchase prices change, how your warehouse manages stock, and how your accounting team wants inventory to be valued.<\/p>\n<p>Check out our new blogs related to Odoo inventory<\/p>\n<ul>\n<li><a href=\"https:\/\/machinser.com\/ar\/odoo-product-packaging\/\">Odoo prodcut packaging<\/a><\/li>\n<li><a href=\"https:\/\/machinser.com\/ar\/odoo-20-lots-and-serial-numbers-tracking-guide\/\">Odoo lots and serial numbers<\/a><\/li>\n<li><a href=\"https:\/\/machinser.com\/ar\/odoo-19-make-to-order-mto-purchasing\/\">Odoo MTO<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Inventory costing is more than assigning a price to a product. It affects the value of your stock, the cost of goods sold, and the profit shown in your financial reports. Imagine a business that purchases the same product several times at different prices. The first batch costs \u20b9100 per unit, the next costs \u20b9120, [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":10121,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[318,325,198],"tags":[],"class_list":["post-10118","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-odoo-19","category-odoo-20","category-odoo-inventory"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/machinser.com\/wp-content\/uploads\/2026\/11\/FIFO-vs-AVCO-Inventory-Guide.png","_links":{"self":[{"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/posts\/10118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/comments?post=10118"}],"version-history":[{"count":3,"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/posts\/10118\/revisions"}],"predecessor-version":[{"id":10124,"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/posts\/10118\/revisions\/10124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/media\/10121"}],"wp:attachment":[{"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/media?parent=10118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/categories?post=10118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/machinser.com\/ar\/wp-json\/wp\/v2\/tags?post=10118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}