Odoo Help


Calculating landed costs across multiple parties

on 7/17/14, 8:54 PM 2,809 views

Hi guys,

I haven't managed to find a credible answer to my scenario so figured this was a good place to ask the question.  If anything is unclear or further information is required, please don't hesitate to contact me.


My wife runs a very small business importing products from the UK and selling them here in New Zealand.  Currently all order tracking and sales management etc is done in Excel which has become a little unwieldy for what she needs and I've been playing with OpenERP 7 for some time to figure out the best way to configure it to do what she needs.  I've pretty much nailed it for most parts (even if a full ERP stack is overkill for a business of this size) however I'm still getting stuck on the landed costs calculations.

Current Configuration:

All products are setup to use Average Price and are sourced from a supplier in the UK who I have setup with a GBP pricelist, the correct pricelist version etc.  When I make test orders and add the freight as a landed cost on the Purchase Order (distributed by value) I get the expected result so I know this side of things is working as I'd hoped.

Process Flow:

  1. Order placed with supplier for varying items (for resale) in GBP
  2. Order dispatched from supplier with accompanying invoice that includes inbound international freight (still in GBP)
  3. Incoming shipment reaches NZ border and NZ Customs generate an invoice for inbound customs charges and NZ taxes (in NZD)
  4. Customs invoice paid, goods released and then received into saleable stock (again in NZD)

The "problem":

I have two key issues.

  1. The inbound international freight is charged by the supplier so also needs to appear as a line item on the Invoice whilst at the same time being a cost factor into the landed cost for each of the product line items.
  2. Each inbound order also attracts additional costs (such as NZ Goods & Services Tax, duty, customs processing costs etc.) when entering New Zealand which is invoiced separately by a different partner, in a different currency from the main order.  These costs also need to be reflected in the landed costs of the line items in the original Purchase Order.


I'm sure this is simply my infancy with using OpenERP rather than a systemic issue but for the life of me I can't figure out what I need to do to enable the functionality that is required.  Can anyone provide guidance?

Many thanks in advance,



Apologies - I also should have mentioned that this is on OpenERP 7.0.

on 7/21/14, 7:22 PM

Thanks Zura - appreciate your feedback!

on 7/21/14, 7:23 PM

Hiren - my apologies, I noticed that I hadn't mentioned in my original post that I was already using the "purchase landing costs" module. That is how I've managed to get as far as I have. I just haven't figured out how to get it to apply the costs from additional invoices (in a different currency) as landed costs to the line items in the original supplier PO/invoice.

on 7/21/14, 7:25 PM

Hi Dave, I'm not sure if this link to the documentation regarding the landed costs will help: https://www.odoo.com/forum/how-to/warehouse-management-6/how-can-i-assign-landed-costs-to-my-cost-price-55132 https://www.odoo.com/forum/how-to It's helped me in regards to understanding how the landed costs module works so I am posting this just in case you have not yet seen this documentation. I believe this is written for the 8.0 branch so I am unsure of it's relevance to your situation given you are using 7.0. If you'd like to see how it works in 8.0 you can just test it using the runbots: http://runbot.odoo.com/runbot click the blue arrow button on the 8.0 branch row.

Luke Branch
on 7/23/14, 6:12 AM
Carlos Liébana Anero
On 11/5/15, 12:43 PM


Have you managed to get the landed costs calculation work with multicurrency?

Best regards.

On 8/13/15, 8:28 PM

Does anybody know if this has been resolved in Odoo v8? It looks like the landed cost functionality has been built into the core product now but I haven't managed to ascertain if it has delivered against the use case I mentioned in my original post. I have had a play with a number of ERP solutions and ERPNext has a quite elegant way of dealing with it in the sense that you can apportion landed costs that are on the same invoice as the purchased products (such as freight) immediately and then add the supplementary landed costs as "valuation items" only ie. they influence the landed cost of each product but don't explicitly create book entries for the transactions. This means that you can then submit a separate supplier invoice (ie. from customs or the like) which will submit the actual ledger costs discretely. Regrettably there are a number of different issues with that application that preclude its use for our business. Perhaps something similar could be implemented in Odoo? I'm no programmer so its not something that I can whip up to "scratch my own itch" so to speak :(

on 8/13/15, 8:29 PM

Zura Tsiklauri

--Zura Tsiklauri--

| 5 2 6
Tbilisi, Georgia
--Zura Tsiklauri--
Zura Tsiklauri
On 7/21/14, 3:51 AM


    The problem you just described does exist: 1. There is no module in Open ERP for landed costs. There is just a community module created by users of OpenERP. 2. This community module doesn't work properly. There are no correct journal entries generated as the landed costs dont add the value to cost of goods. There are no separate liablilites created against possible multiple landed cost suppliers as transport companies, customs department etc. I was a bit dissapointed when I understood that I needed a customization.

Maybe you should contact the software developer and customize the purchase order or Invoice documents as you wish if it will be priceworth for you;  

Wish U Success;






Hello Dave,

I read your requirement, I have worked on landed cost module in V6.1. It was custom requirement. I am not sure if that module will well-work on V7. So for now, you can try following module,


Install and test this module, I think this module will solve your problems.

Let me know if this helps, if not I will install and then help you.







About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

4 follower(s)


Asked: 7/17/14, 8:54 PM
Seen: 2809 times
Last updated: 11/5/15, 12:43 PM