Implementation of a service to compute the product average cost

[Jacopo Cappellato]

Hi all,

I have to implement a service that computes the inventory average cost 
of a product (based on current QOH and inventory items' unit costs) and 
stores it somewhere...

Do you think that storing it in the ProductAverageCost entity is a good 
idea?

However I think that it is important to give the ability to maintain a 
separate cost for each facility (for example the items in a facility in 
US and the ones in a facility in China could have very different 
inventory costs); the key of the ProductAverageCost is now composed by 
productId, organizationPartyId, fromDate so I think we should add to it 
also the facilityId and possibly a productAverageCostTypeId field (to 
maintain different types of averages).

I don't see any code that is using this entity right now but, if I well 
remember, it is used by some code in the external Financial component... 
so I guess that Si could have some good advices :-)

Jacopo