Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

How can I access the details of the Inventory Variation posted at month end in Odoo 19?

inventory end quickstart month 19.0 variation

1 Vastaa

383 Näkymät

Community Question

I understand Odoo 19 no longer posts journal entries with each Inventory Transfer, but delays the posting until the associated Customer Invoice or Vendor Bill is recorded.

If a large quantity of goods are delivered or received in a given period, but there is no Invoice or Bill until the next period, I understand the closing process will take care of updating the balance sheet, but I am not seeing where I can dig into the details of the what products and orders are awaiting invoices or bills.

Is this somewhere else?

All I can see is a single Journal Entry being generated at period end that doesn't show any detailed information.

Ray Carnes (ray)

Paras vastaus

You are right, the end of period 'Inventory Variation' entry is a high-level summary and intentionally lacks detail. The product and order level detail you are looking for are found in separate entries: the Accrual Entries - Accrued Expenses (for purchases) or Accrued Revenue (for sales).

The Accrued Expense Entry and Accrued Revenue Entry Wizards from the Purchase and Sales App are used in conjunction with the closing entry to provide this detail.

For convenience, these Wizards can also be accessed from the Accounting App:

Let's work through a scenario on the Purchase side where we order four products from three vendors without receiving any Vendor Bills, and follow the period end close process to see how Odoo accounts for the inventory postings we can expect when the details arrive.

Three Purchase Orders:

Three Warehouse Receipts:

The Inventory Stock Report:

The Moves Analysis Pivot:

At this point, we have nothing on our Balance Sheet since no Journal Entries were created when we received goods and there are no Vendor Bills.

Our Inventory Valuation Report looks like this:

As part of the closing process we also run our accrued entries for expected postings to the balance sheet when the Bills are posted:

Note: we can also use the new Menu's in the Accounting App for this.

This is the entry for our Purchases Received but not Billed:

So at this point our Balance Sheet looks like this:

Then we generating the closing entry which looks like this:

At this point our Balance Sheet looks like this:

The Journal Items posted in the General Ledger:

As you can see, there is a debit for each expected posting to come next period for the Vendor Bills, showing the PO, the Product, the Quantity and the unit price that the Bill should show.

Now, in the next period, let's receive the Bills just for the first and third purchase order.

Since Vendor Bills post Journal Entries for inventory, we will see these Journal Items in December:

Let's look at the Balance Sheet after the recording of the two Bills, but before the close:

It is a bit of a mess, showing $20,896.25 worth of Merchandise Inventory and $8,262.25 worth of total Inventory. We know this is wrong. It is temporarily double counting the inventory we have now updated with the bills received.

This is a massive conceptual shift. The Balance Seet is no longer "live" for inventory.

Remember, with Odoo 19 we are now operating under a delayed posting and closing required approach for our Balance Sheet. The closing entry is needed before we look at the Balance Sheet. If needed, this entry can be automated on a daily or monthly basis.

The Inventory Stock Report is now the source for real-time inventory quantities and values - updated instantly. The Balance Sheet is accurate when the closing entry is run and, as needed, in conjunction with the accrual entries at the end of the period.

So, we repeat the closing process.

First, the entry for our Purchases Received but not Billed:

At this point our Balance Sheet looks like this:

The first part of the mess is gone.

Our Inventory Valuation Report:

Then we generating the closing entry which looks like this:

At this point our Balance Sheet looks like this:

Our Balance Sheet is fully correct.

The scary part of this is that our Balance Sheet is under construction in between each closing entry. Remember, this entry can be generated daily (automatically) if needed.

Recall that nobody should be looking at the Balance Sheet until it is ready - certainly not during the day when transactions are still being posted - so what we have to get used to now is that it will only show an accurate inventory balance when the closing is completed - daily for those who need it, end of month or on demand for those who don't.

The Inventory Stock Report is the place we look now for the most up to date, real time, amount and quantity of Inventory we have.

The Balance Sheet is where we look after the closing entry is generated for our current asset balance.

Hope this helps.

Additional background:

In Odoo 19, stock accounting journal entries are no longer posted during receipt and delivery (and returns) transfers. The concept of direct vs delayed posting is introduced.

Direct posting - Operation is Trigger

- physical inventory

- scrap

- manufacturing orders

Delayed posting - Financial Step is Trigger

- inventory revaluation

- delivery, receipt, return of goods

- landed costs

Due to this, there is now (conceptually) a subledger that keeps track of inventory variation amounts (the new single stock interim account) and a closing entry is therefore generated as needed to match the inventory app stock report (quantity and value) to the balance sheet.

In conjunction, accrual entries for delivered goods not invoiced, invoiced goods not delivered, received goods not billed, and billed goods not received are made to account for expected revenue, deliveries, liabilities and receipts.

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Odoo 19 - How do I manage consignment when I am the one consigning the inventory? Ratkaistu management inventory quickstart 19.0 consignee	2 marrask. 25	307
Odoo 19: How to investigate Stock Variation amounts from the Inventory Valuation report? balance inventory valuation quickstart drilldown review 19.0 v19 variation	1 marrask. 25	376
Using MTO and Dropshipping in a Single Sales Order in Odoo inventory quickstart	2 huhtik. 25	2461
2 companies => one warehouse (inter-company and Dropship) Ratkaistu inventory quickstart	1 elok. 24	3882
Cancel a transfer after it's done Ratkaistu inventory quickstart	3 maalisk. 24	7553

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!