Re: Implementation of a service to compute the product average cost

[Rashko Rejmer <rr...@iguanait.com>]

Hi Jacopo, 

I have similar needs to yours. I want to create jira issue and then to
implement the service that you proposed, but I am not sure if I am not
missing something that has changed until now. 

First I wanted to implement the service and to use it in a report - similar
to "Inventory Item Totals".
Then I intend to make suggested changes to the ProductAverageCost entity and
to persist the result of the metioned service there. 

Any suggestions are velcome.

Regards,
Rashko Rejmer


Jacopo Cappellato wrote:
> 
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/Implementation-of-a-service-to-compute-the-product-average-cost-tp7891049p16490988.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.