← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 720919] Re: Report sales by category of products has divide by zero error

 

Hello,

This doesn't happen on version 6.0.
For the sake of minimum risk on version 5.0,we would like to ask you to contact Maintenance team via OpenERP Publisher Warranty.

Moreover, you could have selected positive qty in order to make this
work for you.

Thanks for understanding.

** Changed in: openobject-addons/5.0
       Status: Confirmed => Won't Fix

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/720919

Title:
  Report sales by category of products has divide by zero error

Status in OpenERP Modules (addons):
  Invalid
Status in OpenERP Addons 5.0 series:
  Won't Fix

Bug description:
  If some sales order lines have negative quantities, then the total
  units sold for a month in a particular category and sales order state
  can be zero. If the total is zero, then you can get a divide by zero
  in the Sales by Category of Products report that is part of the
  report_sale module.

  Detailed steps to reproduce:
  1. Create a new database with demo data. Select the manufacturing industry profile and leave all the other settings as the defaults.
  2. Install the report_sale module.
  3. Create a new sales order.
  4. Set the customer to Agrolait and the date ordered to one month ago.
  5. Add a new sales order line with all the default fields, plus Product Uom PCE, description "Paper plate", and unit price 2.00.
  6. Add a second line with all the default fields, plus Quantity UoM -1.00, Product Uom PCE, description "Napkin", and unit price 1.00.
  7. Confirm the sale order.
  8. From the Sales menu, choose Reporting: All Months: Sales by Category of Products.

  Expected behaviour: see the chart.

  Actual behaviour: Division by zero error.

  I am running OpenERP 5.0.15 on Ubuntu 10.04.



References