Hi there,

I have set the cost of 3 products.

item #1 = $1
item #2 = $1
item #3 = $1

I have setup Bill of Material where item#4 is produced as a finished good by adding above 3 items in it.

Currently item#4 is 0 in stock. The cost price setup on Item#4 is $1 and costing method is set to Average.

Now, when we produce 10 pcs of this Item#4 through manufacturing order, it will add 10 pcs of item#4 in stock and minus 10 pcs each of item#1, #2 and #3. All good to this stage.

However the cost of item#4 remains $1 and does not change. Shouldn't this cost change automatically to $3 now? Because cost of item #4 is $3 based on 3 raw materials of $1 each that we combine to produce this item#4.

I have checked all possible options but can't seem to find a way to do this. Any comments will be appreciated.

Thanks
Sunny

Hi Sunny - did you ever get this fixed. I have the same problem with the selling price. Surely the selling price of #4 should be equal to the sum of of the selling prices of it's components - but it's not. It seems the selling price of #4 has no relation to its components.
PS I'm new to OpenERP so I might be doing something wrong.
Thanks
Roly

Hi Roly,

Not fixed yet. I am on it and will update you once I am able to get this resolved.

Thanks
Sunny

use this function...

def addition(self, cr, uid, ids,no1,no2,no3):

a=self.pool.get('add.button').browse(cr,uid,no1)
sub = no1 + no2 + no3
return {'value': {'sums': sub}}

add.button is class name
no1 = no2=no3 are field name that u enter
sums is also fields in which u get ur output,,

I think I have the answer as far as the cost price goes - although it's a manual process, I'm sure it could be automated.
You set the costing method on the parts of the component to 'average'. Then if you go to one of these products, click on the 'Update' button and tick the 'update parent price'. This updates the cost price of the product line as well as the Bill of Material cost price.
I think the selling price is a separate issue and is probably correct as it is i.e you don't want the selling price adjusting automatically as the cost price changes. I guess you would monitor your GP and adjust the selling price when you reach some sort of threshold.
Let me know it this solves your problem.

you can try product_extended module, it was helpful for me
http://doc.openerp.com/v5.0/technical_g ... ended.html

Thanks Amgad - but unfortunately it doesn't install with v6.0.3