[
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.