Odoo Help

Welcome!

This community 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.

0

How to compute cost price?

By
Hasna LAKHRISSI
on 3/7/14, 6:15 AM 1,591 views

Hello everybody! I need to compute the cost price of the imported articles (i need to include the customs fees, the transportation, warehousing, etc) in order to compute the sales price. So I need to add some fields in the article interface (view) to enter each one of these parameters and display the results (cost price and sales price), of course i need to encode the way those prices are calculated using these parameters (specefic formulas) ? Can you please help me!! ? Thanks in advance!! ?

PS: I am using OpenERP 7

Did you find a way of accomplishing that?

Santi
on 11/26/14, 5:17 AM
1
Paulo Matos‏
On 11/26/14, 11:57 AM

Take a look at the "purchase_expense_distribution" module for odoo v7. Google it.

This module is simple to use. Basically:

- Enter Purchase Order;

- Register Reception of articles;

- Access the cost distribution on purchases

- Follow the wizard and apply all expenses related (freight, customs, etc.)

I have tested this module myself an it works. It will update the purchase price on product form based on all expenses entered on wizard. You can then use price lists to adapt prices based on product cost field.

The only problem I found in this module is that it does not calculate the exchange rate if you use a currency other than company currency. Perhaps you can solve this by adding an extension to the module (I do not know how to do it).

Hope this helps

PS: By the way, if you solve the currency exchange rate for purchase orders in foreign currencies, please post it here.

Regards

Paulo

1
Hasna LAKHRISSI
On 11/26/14, 2:37 PM

Thank you all community memebrs! To Santi, if you are looking for a simple solution , you can use analytic accounting , by creating an analytic account for each cost; and then you can add them to your invoices.
Of course, it's more interesting to create a specific module that suits your need, you can take a look at the existing similar modules such as purchase_landed_costs to inspire you.
Good luck!

1

Ivan

--Ivan--
3210
| 5 3 6
Jakarta, Indonesia
--Ivan--
Ivan
On 11/26/14, 5:42 AM

There are some Landed Cost modules out there by community, one example is: https://www.odoo.com/apps/7.0/purchase_landed_costs/.  Using this module you can add customs fees, transportation, warehousing fees into the purchase.  The part to get the sale price from those calculation is, AFAIK, not yet available.  You need to develop that module, and especially paying attention on tracking which item is sold in which sale order (by way of Serial Number, maybe).

thanks for the quick reply John. I checked that module, but it's not what I'm looking for, I'm looking for a simpler solution to enter those additional costs manually...either in the product form (as the author of the original question suggested) or in a pricelist.

Santi
on 11/26/14, 7:04 AM

Santi, sorry I can't help further if you are looking for such functionality.

Ivan
on 11/28/14, 4:04 AM
0
Kazim Mirza
On 3/7/14, 7:57 AM

first you have to make the new module for all the new cost like customs fees, the transportation, warehousing.

and inherit the sale module

make the calculation the total price with these all new cost .

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 3/7/14, 6:15 AM
Seen: 1591 times
Last updated: 3/16/15, 8:10 AM