Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I cannot find a way to have Odoo 7 to automatically update the product cost price based on the last purchase order made or at least by the average cost price.
What I need is to have Odoo to automatically update the product cost price whenever I register a PO.
Thank you very much
You can build your own custom module for this requirement. You can proceed in these ways: You should first inherit mrp.bom and add a new field 'price_unit': fields.float('Unit Price') and redefine the onchange_product_id function define compute_price and compute_total function to calculate "line price" and "total price" Then you have to inherit mrp.production and define compute_production_cost function to update cost_price from BOM. We have created this custom module and it works perfect , in my module it takes avg purcahse price in BOM and we added an extra tab to manufactring form to compute Production Cost , in that tab you can add extra charges like electicity etc.. , that charges also added to cost by calculating per_unit charge depending on UOM. for any help you can contact us email@example.com, firstname.lastname@example.org
The solution is Anglo Saxion Accounting. Then set the default in caaounting tab of product: Valuation: Real Time, Automated. and also set: Average price default in procurement tab of product.
U get auto update of cost price based on average and also cost of goods journal entry when selling.
Thank you very much.
In fact, what I need is a module that updates the product cost price when we register a Purchase Order.
When we register a PO on core Odoo, the product price on the product table is not automatically updated. What I need is to have a module that updates this price whenever I register a purchase order. Perhaps there's a way to do it on standard Odoo functionality but I do not know how. Can you please help?
Thank you once again
Yes, the above is correct as we are using purchase_landed_costs and confirm the following with camptocamp module:
=> I understand. The point is, this is very difficult and cost a lot to achieve due to the structure of OpenERP (or odoo).
Currently, we solved that this way: * AVG price is computed with the PO landed costs when receiving the goods (picking ->done)
* The margin in the SO line are computed using the current value (means the actual AVG price before ordering new goods to the supplier)
* IF THE CUSTOMER INVOICE is generated AFTER deliveries, then you can have the proper margin computed in the invoice line using the product_historical_margin module). Because here, the AVG cost taken is the one after validating the incoming shipment from the supplier. So:
a) SO confirmed by customer with margin = current value
b) PO ordred to supplier
c) Goods received and AVG price updated
d) Customer invoice generated with proper margin
So my advice is here to compute commission based on invoice line instead of sales order lines.
Our next module is to create an a workflow "Waiting Landed Costs" so we will not receive the product until we have all Landed costs on the product view and sales order line. With using margin-analysis modules from camptocamp we can generate the true margin for reporting
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 6/16/14, 11:49 AM|
|Seen: 8512 times|
|Last updated: 3/16/15, 8:10 AM|