Skip to Content

Inventory Valuation in Odoo 19: Complete Guide to AVCO, Periodic and Perpetual

What changed, how to set it up, how to read the reports and how to close the month without gaps
February 1, 2026 by
Inventory Valuation in Odoo 19: Complete Guide to AVCO, Periodic and Perpetual
Wilfredo Fernando Pastor Avila
| No comments yet

If your inventory in Odoo 19 does not match your accounting, the cause is usually how valuation was configured and how the new reports are read, not bad data. This guide brings together what you need to understand the Odoo 19 model, choose between periodic and perpetual valuation, set up the accounts, read the average cost and close the month.

What changed in Odoo 19 inventory valuation

  • The separate Stock Valuation Layer model is gone: valuation is recorded on the stock move itself, so quantity and value are read in the same place.
  • Valuation is now chosen as Periodic (at closing) or Perpetual (at invoicing), at company level and per product category. The anglo-saxon accounting option still exists at company level.
  • Each stock move carries its own value, and the Unit Cost History report and the valuation list of moves are the detailed sources for auditing quantities and values.
  • With periodic valuation, regular moves do not create one journal entry each: they are consolidated in the closing entry generated from the Inventory Valuation report.

The checks that worked in Odoo 18, such as matching valuation layers against journal entries, no longer apply. They need to be replaced by checks based on the value of each stock move and on the difference between the inventory value and the accounting balance of the stock account, which is what the Inventory Valuation report shows.

Periodic or perpetual valuation: which one to choose

In Odoo 19, perpetual valuation (shown as Perpetual (at invoicing)) books the stock account when documents are posted: the vendor bill goes to the stock valuation account, and the customer invoice adds the cost of sales against stock. Receipts and deliveries alone create no entry. The exception is a move from or to a location that has a valuation account, such as inventory adjustments and scrap, which is posted when it is validated. Periodic valuation (Periodic (at closing)) posts vendor bills to the expense account and adjusts the stock account in a closing entry. Odoo describes periodic as common practice in Europe and perpetual as common practice in Anglo-Saxon countries. There is no universally better method: it depends on the volume of moves and the level of detail your accounting requires.

AspectPeriodicPerpetual
When it is postedAt closing, with the Inventory Valuation reportWhen the vendor bill and the customer invoice are posted, and on moves to or from valued locations
Customer invoiceNo cost-of-sales lines; stock is adjusted at closingAdds cost of sales against the stock account
Vendor billUses the expense accountUses the stock account
Journal entry volumeLower, consolidatedHigher, with detailed traceability
Where it is commonCommon practice in EuropeCommon practice in Anglo-Saxon countries

You can combine both in the same database: the valuation type is set by default on the company and can be overridden on each product category. If you mix them, keep separate accounts for perpetual and periodic products.

Step-by-step setup

  1. Set the company defaults under Accounting, Configuration, Settings, Inventory Valuation block (Odoo Enterprise): valuation, inventory period, costing method, valuation account and stock journal.
  2. Review each product category: the valuation type, costing method and accounts can override the company values.
  3. Set up the variation account on the stock valuation account. Odoo 19 no longer uses separate stock input and output accounts: the closing entry uses the variation account as counterpart, and it is an expense-type account in the chart of accounts templates.
  4. Assign a valuation account to the adjustment, scrap, donation and similar locations. Without an account on the location, an inventory adjustment under perpetual valuation does not create an entry.
  5. Test with one product from each category: a purchase, a sale and an adjustment, and check the result in Moves Analysis and in the journal entries.

Average cost (AVCO): how it is calculated and how to audit it

Each time a receipt is valued, Odoo adds its value to the previous total value and divides by the new total quantity. Sales leave at the current average cost and do not change it.

Illustrative numeric example: you hold 10 units at 50 and buy 10 units at 70. Total value is 1,200 for 20 units, so the average cost becomes 60. If you sell 5 units, they leave at 60 (cost of sales of 300) and the average of the remaining 15 stays at 60.

To see the detailed calculation, click the Unit Cost of the product in the stock report list (Inventory, Reporting, Stock) to open the Unit Cost History report: it shows each purchase, production, adjustment and sale in chronological order, with the resulting average after each move.

FIFO and standard price

With FIFO, each outgoing move is valued at the cost of the oldest receipts still in stock. Illustrative numeric example: you hold 10 units received at 50 and 10 received at 70. If you sell 15, the cost of sales is 10 x 50 + 5 x 70 = 850, and the 5 units left are valued at 70 (350). If an outgoing move exceeds the available stock, Odoo values the missing quantity at the last known price.

With FIFO there is no running average to audit, so the Unit Cost History link is disabled for FIFO products; audit through the value of each receipt. With Standard Price, moves are valued at the fixed cost set on the product.

Landed costs

To use landed costs, enable Landed Costs in Inventory, Configuration, Settings, and create a service product marked Is a Landed Cost with a default split method (equal, by quantity, by current cost, by weight or by volume). The received products must belong to a category with AVCO or FIFO costing. From the vendor bill, use Create Landed Costs, select the receipt, Compute and Validate. Odoo 19 adds the cost to the value of the original receipt move instead of creating a separate valuation record. If you buy 10 units at 50 (500 in total) and add 100 of freight, that same move now carries a value of 600.

Under perpetual valuation, validating the landed cost posts an entry in the landed cost journal that debits the stock valuation account and credits the account of the cost line (by default the expense account of the cost product), only for the quantity still in stock; the part already sold stays in cost of sales. Under periodic valuation no entry is posted at validation, and the stock value is adjusted in the closing entry.

The reports you need for control

  • Moves Analysis: the detailed source of moves. Filter by date and operation type to support cost of sales in an audit.
  • Unit Cost History (technical model stock.avco.report): it lists each receipt, outgoing move and manual adjustment in chronological order, with the resulting unit cost.
  • Inventory Valuation (Accounting, Review, Inventory; Odoo Enterprise): it shows initial balance, stock variation, inventory loss and ending stock, compares the inventory value with the accounting balance of the stock account and lets you generate the closing entry. It can be run manually or scheduled with the Inventory Period setting (manual, daily or monthly).

When the closing entry sends everything to a global account

The entry proposed by Inventory Valuation concentrates the net variation of each stock account against its variation account (line Closing: Stock Variation Global). For accounting that gets audited, that is usually not enough. A practical procedure, which is accounting practice and not an Odoo feature, is: generate the entry, reverse the global variation account and create a detailed entry with cost of sales, purchase variance and adjustments, taking the amounts from Moves Analysis filtered by receipts, deliveries and adjustments.

Retroactive corrections: unrecorded purchases or wrong dates

  1. Record the missing receipt with the real effective date, not today's date.
  2. Understand the effect: the unit cost history is recalculated in chronological order, so a receipt with an earlier date changes the average that applies to the moves after it.
  3. Outgoing moves that were already validated keep the value stored when they were validated. If that value has to change, Odoo lets you set a manual value on a move (Adjust Valuation), and the change appears in the unit cost history.

Changing move dates has a knock-on effect on later averages and valuations. Do it with a defined procedure and, if periods are already closed, with your accountant in the loop.

Month-end close: goods in transit and bills without receipt

If the supplier bill arrives before the goods, the balance sheet can show inventory that is not yet in your warehouse. Under perpetual valuation, Odoo posts the vendor bill to the stock valuation account, so the balance sheet can show more inventory than the physical stock until the receipt. If that matters at the cut-off date, reclassify the amount with a manual entry to a goods-in-transit or goods-to-receive asset account and reverse it when the goods arrive.

  • Before generating the Inventory Valuation report, process bills awaiting receipt and deliveries not yet invoiced.
  • Review the purchase orders that are billed but not yet received at the cut-off date.
  • Check that the stock journal and the variation account are set: the variation account is the counterpart of the closing entry and is an expense-type account, because it reduces expenses by the change in stock.
  • When the goods arrive, the in-transit entry is reversed and the value stays in inventory.

Common problems

Inventory adjustments do not create an entry

Check that adjustment, scrap and similar locations have an account assigned. It is the most common cause under perpetual valuation.

Before migrating to Odoo 19

  • Test in a staging environment with every scenario: domestic and imported purchases, sales, returns, manufacturing and adjustments.
  • Train each role on what changes: warehouse, purchasing and accounting.
  • Define the rollback plan and the new controls based on stock move values beforehand.

Where Ganemo can help

Ganemo is an Odoo partner and also an accounting firm, so we review valuation from both the inventory side and the accounting side. If your implementation does not reconcile, see our Odoo implementation rescue service, the accounting services page or reach out through contact. If you operate in Peru, also see the Peruvian localization for Odoo, and to review the accounting concepts you can use the inventory valuation course material.

Related video

Inventory Valuation in Odoo 19: Complete Guide to AVCO, Periodic and Perpetual
Wilfredo Fernando Pastor Avila February 1, 2026
Share this post
Tags
Archive
Sign in to leave a comment
Does Your System Show Accounts Receivable in Real Time But Not at Cut-Off Dates? Here's the Solution
Discover how to turn real-time information into accurate historical reports for closings, audits, and strategic financial management