How to get Average Cost Price including landed costs - Odoo 8

Question

Hello,

Is there a way to get a ponderate price for a product?
E.g.:

I did 2 purchases of the same product with different landed costs:

1st purchase:
Units: 100
Product cost per unit: 300
Landed costs: 500

2nd purchase:
Units 30
Product cost per unit: 325
Landed costs: 250

Now I need to get the Average Cost price of the product + landed costs:

[(100 x 300 + 500) + (30 x 325 + 250)] / (100 + 30) = *311,538*

I would like to have this value for a new field in the product_product table, but I

Baiju KS · Answer

Hi Alejandro,

You can make your own custom module for this need, You can proceed in this way:-

First of all inherit product.template object and add a custom field avg_price as a functional field.

Then define that function to fetch average of last three purchase price with landed cost. thats all

I have made this module and it works perfect, if you have any doubts feel free to contact, baijuks@hotmail.com

Related Posts	Respostes	Vistes
eCommerce: How to remove the Address from Checkout purchase	3 d’ag. 25	720
How to prevent receipt creation after confirming a Purchase Order in Odoo 18? Solved purchase	1 de jul. 25	619
Is it possible to Merge Purchase Orders in odoo online? purchase	1 de jul. 25	1011
Odoo 18.2 - Print on Purchase Order prints RFQ and not Purchase Order purchase	1 de jul. 25	1367
Limit products to their suppliers/vendors purchase	2 de jul. 25	498