c2c-oerpscenario team mailing list archive

[Thomas Rogeau <814613@xxxxxxxxxxxxxxxxxx>]

I think I have found the bug, it's in
/Server/addons/account/report/account_invoice_report.py :

here a paste with a suggested bugfix :
           /* TRO310711 bugfix for bug #814613 : OpenERP V6.02 : monthly turnover (from partner form) : price excluding VAT doesn't include discounts
                commented following lines
                    sum(case when ai.type in ('out_refund','in_invoice') then
                         ail.quantity*ail.price_unit * -1
                        else
                         ail.quantity*ail.price_unit
                        end) / cr.rate as price_total,
           + added following lines */
                    sum(case when ai.type in ('out_refund','in_invoice') then
                         ail.price_subtotal * -1
                        else
                         ail.price_subtotal
                        end) / cr.rate as price_total,
            /*TRO310711 end of bugfix*/

-- 
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/814613

Title:
  OpenERP V6.02 : monthly turnover (from partner form) : price excluding
  VAT doesn't include discounts

Status in OpenERP Modules (addons):
  Confirmed

Bug description:
  1) to reproduce
  A. create a partner
  B. create and validate an invoice for him, let's say a 800 € tax excluded product with a discount of 25%. The real tax excluded sell is 600 €.
  C. return on the Partner Form, click on the right part on "Monthly Turnover" (rough translation, I'm working in french and the text is "Chiffre d'affaire mensuel")

  (see attachment)
  2) and 3) And now the bug : in the tax excluded total column, it's written 800 € instead of 600 €.
  As the Tax INCLUDED Total is correct (717,60 with 19,6 % VAT), we can see a tax included total smaller than tax excluded one. Great impact in front of a customer... :_-(

  4) Platforms : windows with all-in-one 6.02 install, Ubuntu with 6.02
  install. Confirmed on each.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/814613/+subscriptions