openerp-dev-web team mailing list archive

["Ashvin Rathod \(OpenERP\)" <ara@xxxxxxxxxxx>]

Ashvin Rathod (OpenERP) has proposed merging lp:~openerp-dev/openobject-addons/trunk-bug-inv_analysis_remove_vat_include-ara into lp:openobject-addons.

Requested reviews:
  OpenERP Core Team (openerp)

For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-inv_analysis_remove_vat_include-ara/+merge/60495

Hello,

Remove the 'total with tax' field from invoice analysis.

Thanks,
ara
-- 
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-bug-inv_analysis_remove_vat_include-ara/+merge/60495
Your team OpenERP R&D Team is subscribed to branch lp:~openerp-dev/openobject-addons/trunk-bug-inv_analysis_remove_vat_include-ara.

=== modified file 'account/report/account_invoice_report.py'
--- account/report/account_invoice_report.py	2011-05-06 11:32:52 +0000
+++ account/report/account_invoice_report.py	2011-05-10 11:55:56 +0000
@@ -47,7 +47,6 @@
         'company_id': fields.many2one('res.company', 'Company', readonly=True),
         'user_id': fields.many2one('res.users', 'Salesman', readonly=True),
         'price_total': fields.float('Total Without Tax', readonly=True),
-        'price_total_tax': fields.float('Total With Tax', readonly=True),
         'price_average': fields.float('Average Price', readonly=True, group_operator="avg"),
         'currency_rate': fields.float('Currency Rate', readonly=True),
         'nbr':fields.integer('# of Lines', readonly=True),
@@ -121,21 +120,6 @@
                           ail.price_subtotal
                         end) / cr.rate as price_total,
 
-                    sum(case when ai.type in ('out_refund','in_invoice') then
-                         -ai.amount_total
-                        else
-                         ai.amount_total
-                         end) / (CASE WHEN
-                              (select count(l.id) from account_invoice_line as l
-                               left join account_invoice as a ON (a.id=l.invoice_id)
-                               where a.id=ai.id) <> 0
-                            THEN
-                              (select count(l.id) from account_invoice_line as l
-                               left join account_invoice as a ON (a.id=l.invoice_id)
-                               where a.id=ai.id)
-                            ELSE 1
-                            END) / cr.rate as price_total_tax,
-
                     (case when ai.type in ('out_refund','in_invoice') then
                       sum(-ail.price_subtotal)
                     else

=== modified file 'account/report/account_invoice_report_view.xml'
--- account/report/account_invoice_report_view.xml	2011-05-06 11:32:52 +0000
+++ account/report/account_invoice_report_view.xml	2011-05-10 11:55:56 +0000
@@ -32,7 +32,6 @@
                 <field name="product_qty" sum="Qty"/>
                 <!-- <field name="reconciled"  sum="# Reconciled"/> -->
                 <field name="price_total" sum="Total Without Tax"/>
-                <field name="price_total_tax" sum="Total With Tax"/>
                 <field name="residual"  sum="Total Residual" invisible="context.get('residual_invisible',False)"/>
                 <field name="due_delay"  sum="Avg. Due Delay" invisible="context.get('residual_invisible',False)"/>
                 <field name="delay_to_pay"  sum="Avg. Delay To Pay" invisible="context.get('residual_invisible',False)"/>