Yes Thanks
On Sun, 2006-09-03 at 10:16 -0700, Jacques Le Roux (JIRA) wrote: > [ > http://issues.apache.org/jira/browse/OFBIZ-193?page=comments#action_12432357 > ] > > Jacques Le Roux commented on OFBIZ-193: > --------------------------------------- > > Daniel, > > Do you want that we remove your 2 comments ? > > Jacques > > > New service to automatically calculate the product's average cost > > ----------------------------------------------------------------- > > > > Key: OFBIZ-193 > > URL: http://issues.apache.org/jira/browse/OFBIZ-193 > > Project: OFBiz (The Open for Business Project) > > Issue Type: New Feature > > Components: order, product > > Reporter: Jacopo Cappellato > > Priority: Minor > > > > Implement a service to automatically calculate the average cost > > (ProductPrice.averageCost) based on previous purchases. > > Right now the value is just set manually. These averages would have nothing > > to do with what is used for inventory costing. The average could somewhat > > easily be calculated from the order or invoice histories as a weighted sum > > based on the quantity and price. (suggested By David Jones) > > Such a service could be based on a SQL command like this one: > > SELECT > > PRODUCT_ID, SUM(UNIT_PRICE * QUANTITY) / SUM(QUANTITY) AS AVERAGE_COST > > FROM > > ORDER_ITEM AS OI, ORDER_HEADER AS OH > > WHERE > > OH.ORDER_ID = OI.ORDER_ID AND > > OH.ORDER_TYPE_ID = 'PURCHASE_ORDER' AND > > ORDER_DATE > '2004-12-31 00:00:00.0' > > GROUP BY > > PRODUCT_ID > > However this is only a draft (e.g. we should also take into account > > cancelled items, adjustments etc...) >
