Landed Cost Default Account

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project
MRP

All apps

All Posts People Badges

Tags (View all)

odoo accounting v14 pos v15

About this forum

Help

Landed Cost Default Account

accounting landed-costs

3 Replies

2326 Views

Marcel Patzsch

Hello,

how can I set the account for landed costs?
If i add a landed cost to an bill it will always use the account 3970 for this item, regardless of the product account or the product category account. Where is this setting made? Is it hard coded?

This account is not the right one for german accounting. I can edit the line in the bill by hand, but one can forget this small step easily. So how can i teil odoo to use the account given by the landed cost product when entering a bill.

Kind regards,
Marcel

Niyas Raphy (Walnut Software Solutions)

the accounts are taken from product and product category, could you update your question with some screen shots of the product and category screens

Ben Fischinger

Hello,
we have the same problem here.
Also german accounting!

This should be improved for the german Odoo users because it looks like a bug.

Daniel Dawson

Hello, in case anyone else is having trouble with their landed cost product defaulting to the wrong account:

I had to set my landed cost product category to automated inventory valuation and set my account stock properties there.

This is for Odoo version 18.0 self-hosted.

Chris TRINGHAM

The problem seems to happen if you define the Landed Cost as a Landed Cost

Then it uses the stock interim account from the Product Category:

If it is NOT defined as a landed cost, it's OK (even if you select it as a Landed Cost on the Vendor Bill):

Now the account is taken from the Product:

In summary, this seems to be a bug in v17 that needs to be reported to Odoo.

A simple workaround is to set the stock interim accounts on the Product Category that you use for Landed Cost (easy if you enabled automatic inventory accounting, more difficult but not impossible if you did not).

Bhumika Panchal

Hello

If you are not using Automated Accounting your Product category configuration should be as below:

As per my understanding if using the standard method with manual accounting if you are using the same:

In the product which contains the LC you should add the account in the expense account and then it works:

But you have to set the account inside the product as mentioned below:

After the creation of the bill, it will be reflected as below:

It is working perfectly fine in the 17 version. Please check again.

Marcel Patzsch

Author

Hello,

yes of course i tried this also. I does not work either.

What do you mean by stock account?
In the product in the accounting tab i set "Income Account" to 3800.

I wanted to add some screenshots, but unfortunately I can not post another "Answer" only comment on other answers, but there I cannot attach pictures. Sorry this is my first time using this forum.

Bhumika Panchal

Hello

Stock Accounting here means are you using the Automated accounting which is passing the journal entry on automatically on the stock movement?
Or you are using the normal Accounting

I hope now my question is clear

Marcel Patzsch

Author

Hello,

question is clear now.
I do not use automatic accounting.

Marcel Patzsch

Author

Hello,

I'm sorry I do not understand the difference. I set everything up like in your pictures. Still it does not use the configured account.

Bhumika Panchal

Hello

Please share your configuration along with the costing method and you are in the enterprise version correct?

Marcel Patzsch

Author

Hello,

yes i use the enterprise cloud version sass~17.1+e.

Like i said before I would like to attach screenshots to share my configuration but it seems like this is not possible. I'm very confused by this forum. I think you did edit you answer, the answer i comment below is not the same as before right?
This is really a terrible way of communication. I would appreciate a linear way of communication. I don't understand why I can not just reply to the overall communication instead of commenting on "answers".

Regardless, I share my configuration in text form:

Settings
Accounting -> Stock Valuation -> Automatic Accounting: Disabled
Inventory -> Valuation -> Landed Costs: Enabled
Inventory -> Valuation -> Landed Costs Default Journal: Left Empty

Purchased Product Category
Costing Method: FIFO
Income Account: 8400
Expanse Account: 3400

Purchased Product Accounting
Income Account: Left Empty
Expanse Account: Left Empty

Freight Charge Product Category
Costing Method: Standard Price
Income Account: 8400
Expanse Account: 3400

Freight Charge Product Accounting
Income Account: Left Empty
Expanse Account: 3800

I would like to point out that I have my purchased product costing method set to FIFO, not to Standard Price as in you screenshots. This i because in the documentation It says I have too.
See https://www.odoo.com/documentation/17.0/applications/inventory_and_mrp/inventory/warehouses_storage/inventory_valuation/integrating_landed_costs.html

"Note
The product that the landed cost is applied to must have a product category set to a FIFO or an AVCO method."

Marcel Patzsch

Author

Of course I also tried setting the purchased product costing method to standard price to have the exact same setup as in your screenshots. But it doesn't changed the account. I did not get it to work this way.

Marcel Patzsch

Author

Hello Niyas,

that's how I would imagine it works. Unfortunately it doesn't work for me.

I have attached some screenshots.

I have added the product "Versand" to the invoice, which gets the assigned account 3970.

However, the product "Versand" belongs to the product category "Alle / Versand" for which account 3800 is configured.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
simplified chart of accounts for non-profit organization accounting	1 Aug 25	251
Why does the same bank transaction appear on different bank statements? How can I fix it? accounting	0 Aug 25	186
Bill import template accounting	2 Aug 25	191
Analytical distributions by amount in accounting app Solved accounting	2 Aug 25	773
Can Odoo replace Winauditor ? How is the Peppol functionality? Is it free? Solved accounting	2 Aug 25	502

This question has been flagged

Enjoying the discussion? Don't just read, join in!