[ https://issues.apache.org/jira/browse/OFBIZ-193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacopo Cappellato closed OFBIZ-193. ----------------------------------- Resolution: Incomplete > New service to automatically calculate the product's average cost > ----------------------------------------------------------------- > > Key: OFBIZ-193 > URL: https://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...) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.