Skip to Content
This question has been flagged
warehouseproductcost_price
3 Replies
9477 Views
Avatar
Simplify it!

Hey guys, I have the following question. How could I structure the costs per product?

As you know If I have shops and warehouses on different cities and states, costs are not always the same. That's why I need to store costs per warehouse even for accounting entries. Actually OpenERP stores cost of products on standard price, but it doesn't work when you have different costs on each warehouse. Does someone knows a way to handle this? I thought about multi-company but this is not the case, because each shop belongs to the same company. I only want to have different costs based on warehouse.

Is there an addon that handles this?

Thanks.

Avatar
Discard
Avatar
Israel Cruz Argil
Best Answer

Hello Grover,

Review this module, lp:~argilsoft/+junk/hesatec_product_cost_multicompany

It handles product cost per company, this was our approach to one project with multishops. Finally the company wants to measure performance for each shop, so we took the path using multicompany environment.

 

Kind Regards

Avatar
Discard
Avatar
AJ Schrafel Paper Corp
Best Answer

Possible solutions without custom coding. 1. Create different products - one for each warehouse with cost. 2. Create attributes for the product that indicate the warehouse and add the appropriate amount to the product price.

If those don't work for you, you are going to have to do some custom coding.

Avatar
Discard
Simplify it!
Author

Thanks for your response, but these options doesn't work for me because I do need the same products on each warehouse. I think that I've to code this but it's going to be really difficult because I need the standard price on account journals too and everyplace where standard price is called.

Avatar
Ray Carnes
Best Answer

Have you tried the FIFO (first in first out) module?

https://code.launchpad.net/~openerp-dev/openobject-addons/7.0-lifo-fifo-qdp

Product prices are persisted for every unit of a product based on the price paid when received.

Avatar
Discard
Simplify it!
Author

I'll give a try to check if this is what I need. Thanks

Zulfazli Shaharudeen

Unsure if this is still the case...The documentation for v15 states that

"Pay attention, that this is a financial FIFO. The first value “in” is the first value “out”, no matter the storage location, warehouse or serial number."

Source: https://www.odoo.com/documentation/15.0/applications/inventory_and_mrp/inventory/management/reporting/inventory_valuation_config.html

Related Posts Replies Views Activity
Warehouse in Product form
warehouse product
Avatar
Avatar
1
Apr 23
1946
V10 CE - unable to set cost price for imported products
product cost_price
Avatar
0
May 17
2677
Receive Shipment by weight but then sort into products?
warehouse product
Avatar
0
Mar 15
3837
How to set default procurement method for all products at once ?
warehouse product
Avatar
Avatar
Avatar
2
Mar 15
8023
Evaluation of production cost
product cost_price
Avatar
0
Mar 15
3563