Ir al contenido
Menú
Se marcó esta pregunta

For Odoo accountants and functional configurators out there: Need help if this is either a process issue or a configuration issue on how to balance accounts for inventory valuation where Landed Costs are concerned.

So when purchasing inventory, inventory value gets assigned to the journal account for inventory assets called "Inventory Valuation" (debit) and corresponding credit for "Stock Interim (Received)" account.

After the vendor bill for the inventory purchase is made, the "Stock Interim (Received)" is reversed/debited accordingly (balanced mainly by "Accounts Payable" double entry as expected).


The concern I have comes in when I introduce a landed cost (e.g., "Delivery Fees") in the vendor bill. Once bill is confirmed, the landed cost is entered as "Expense" (debit) in the journal entry. Okay.

To add the landed cost in the valuation, I click on the Landed Cost button and tag the WH receipt to rightfully tag the additional valuation cost on the inventory items purchased. This adds a journal entry with debit for "Inventory Valuation" (okay) and credit for "Stock Interim (Received)" (also okay).

But unlike when vendor bill is validated for payment, the increase in credit for "Stock Interim (Received)" doesn't seem to be reversed anywhere else in the process. So every time landed costs are added for inventory purchases, inventory valuation will accumulate credit value for "Stock Interim (Received)."

Am I missing a process step for inventory valuation? Nothing is mentioned in the documentation: https://www.odoo.com/documentation/saas-18.4/applications/inventory_and_mrp/inventory/product_management/inventory_valuation/landed_costs.html

Avatar
Descartar
Mejor respuesta

Hi,

In Odoo flow,

1- Vendor Bill for Landed Cost product (service)

          - Post the bill with a special Landed Costs Clearing (balance‑sheet) account.

          - Entry:

                   *Dr Landed Costs Clearing

                  *Cr Accounts Payable

2- Landed Cost (Compute & Validate)

           - Odoo capitalizes the fee into stock value.

          - Entry:

                   *Dr Inventory Valuation

                   *Cr Landed Costs Clearing

These two moves offset in the clearing account. Your Stock Interim (Received) is not touched by the landed‑cost capitalization. Only Inventory Valuation increases.


Why you’re seeing credits in Stock Interim (Received) :-

Your landed‑cost line is likely posting to Stock Interim (Received) (or pulling stock interim from the product category) instead of a dedicated clearing (or expense) account. That makes the LC validation credit Stock Interim (Received), which won’t be auto‑reversed by any later step, hence the growing imbalance.


References:-

https://www.cybrosys.com/blog/how-to-manage-product-pricing-with-landed-costs-in-odoo-18

https://www.cybrosys.com/blog/an-overview-of-inventory-valuation-in-odoo-18


Hope it helps

Avatar
Descartar
Autor

Hi Cybrosys - Thanks for responding. I'm getting what you're saying (I think) especially for #1. The debit for the Landed Cost should have been the Landed Costs Clearing (my "Stock Interim (Received)"). On looking at Odoo's reference as well, I saw that it's also what the screenshot showed (but not explained in the text that the Product item used as Landed Cost should use the "Stock Interim (Received)" account. I'm referencing the Odoo documentation here ("Create Vendor Bill" section) that aligns with your point #1 (but correct me if I'm wrong): https://www.odoo.com/documentation/saas-18.4/applications/inventory_and_mrp/inventory/product_management/inventory_valuation/landed_costs.html

The references to your blog posts are great by the way, but I hope you can have some updated one where Landed Cost is applied with automatic valuation in place as well.

Publicaciones relacionadas Respuestas Vistas Actividad
1
may 25
686
1
ene 25
1107
1
jun 24
1515
2
oct 22
2410
2
jul 25
1849