Say, we have product stock balance as elements against each facility filled up every month. Now, we have to calculate
‘stock value’ = balance x ‘unit price’
Now, this unit price is ‘fixed’ for a product and valid for all facilities. Is there any way other than storing the same price against each facility every month as element (which is a serious 1000 times duplication)?