sale category report uses wrong variables

[Ferdinand]

price_total instead of price_average

[Ferdinand (office-chricar)]

branch-server 1795
branch-addons 2329

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello Ferdinand,

The Report is for average sales of the Month.

Thanks.

[Ferdinand (office-chricar)]

sorry do not agree

this line of report_sale_order_product calculates the average price (basically value/qty)
(sum(l.product_uom_qty*l.price_unit)/sum(l.product_uom_qty*u.factor))::decimal(16,2) as price_average

no one needs a "pie" chart for average price

it may be interesting to compare the average price and or totals per product(group) from month to month,
for this one needs a bar chart.

I do not understand what this means
"The Report is for average sales of the Month."
we can have
* sales of the month
* average monthly sales ((l.product_uom_qty*l.price_unit / number of month)

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello Dr. Ferdinand,

Can you check the facility available in trunk ?

Thanks for the suggestions.

[Jay Vora (Serpent Consulting Services) (jayvora)]

Sales Related report have been improved on trunk.
Thanks.