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.
Context:
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:
- Order placed with supplier for varying items (for resale) in GBP
- Order dispatched from supplier with accompanying invoice that includes inbound international freight (still in GBP)
- Incoming shipment reaches NZ border and NZ Customs generate an invoice for inbound customs charges and NZ taxes (in NZD)
- Customs invoice paid, goods released and then received into saleable stock (again in NZD)
The "problem":
I have two key issues.
- 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.
- 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,
Dave
Apologies - I also should have mentioned that this is on OpenERP 7.0.
Thanks Zura - appreciate your feedback!
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.
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.