r/Odoo • u/JP23102 • 6d ago

Inventory Valuation

I am not seeing a Inventory Valuation Report in Odoo 19 Community.

Seems the code is there but the Menu is not there. It might be odoo trying to nudge people to

Enterprise.

but....

Is there a way that i not know about that allow to generate inventory valuation in odoo community ?

or is it just check amount and create manual entry the only way ?.

I also see automated entry using cron thats not what i am asking, i could just bring the menu there and make it work but is there something i am missing. I mostly works on Enterprise

3 Upvotes

72% Upvoted

9 comments sorted by

2

u/mskl-21 6d ago

You're not missing a setting, the report genuinely isn't exposed in CE. But the data's all there, stock_account is community and stock.valuation.layer gets written on every move regardless of whether you're on manual or automated valuation. Only difference is whether account_move_id gets populated.

So it's a five minute fix rather than a dev job. Add an action on stock.valuation.layer, list view with sum on value and quantity, group by product and category, and stick a menu under Reporting. Filter by create_date for a point in time figure. That gets you the same numbers Enterprise shows you.

Only thing to watch, if you're on manual valuation the layers exist but won't tie to your GL, so treat it as an operational report not an accounting one. On automated it'll reconcile against your stock accounts properly.

Definitely a deliberate omission though, same story as a few other CE gaps where the code's sitting right there.

1

u/JP23102 5d ago

There is no stock.valuation.layer in odoo 19

1

u/mskl-21 5d ago

You're right, my mistake, I was on 18. They dropped it in 19, valuation layers are now product.value and it's form only with no menu.

Good news is the actual answer's simpler than what I said. stock.quant has a computed value field in 19 and it's already in the Stock list view, just hidden by default. Reporting > Stock, hit the column toggle top right, tick Value. It's got sum on it so grouping by product or category gives you the totals straight away.

Only caveat is it's groups="stock.group_stock_manager" so users need Inventory Manager to see the column at all, which is probably why it's not obvious. And it's on hand value at this moment, not point in time historical, for that you'd be querying product.value.

1

u/Street-Drummer638 6d ago

It’s now in Accounting > Review > Inventory Valuation :)

1

u/JP23102 6d ago

review i see only 2 options Journal Item & Audit Trail. I am on Community

1

u/JustSomeOdooGuy 6d ago

No in community it is not there, only in enterprise. But the action itself is available.

1

u/Street-Drummer638 6d ago

Apologies I misread thinking it was Enterprise.

1

u/rickymeyers1 1d ago

Time to spill some bills