This question has been flagged
1 Reply
8041 Views
totalinvoice.linetaxes
Avatar
Victor Godayer

Hi,


I try to show both columns in the account invoice form :

* total of an invoice line, tax excluded

* total of an invoice line, tax included.


I know that it is possible to set the tax object to be included or excluded in product price, but I don't see the way to show both in invoice form.


I already extended account.invoice.line as follow :



from openerp import api, models, fields

import openerp.addons.decimal_precision as dp

class cap_account_invoice_line(models.Model):

     _inherit = 'account.invoice.line'

     price_with_tax = fields.Float(string='Prix TTC', digits= dp.get_precision('Product Price'), store=True, readonly=True,)


"""

     I guess I should override the method below, but i don't know how to calculate and load the total line with included tax into the line...

     @api.multi

     def button_reset_taxes(self):

         ???

"""



Thank you in advance for your help

Victor

Avatar
Discard
Avatar
Cyril Gaspard (GEM)
Best Answer

Hi,

this is an example, but you can override existing function _compute_price used by the field price_subtotal ...


from openerp import api, models, fields

import openerp.addons.decimal_precision as dp



class AccountInvoiceLine(models.Model):

     _inherit = 'account.invoice.line'


     price_subtotal_tax = fields.Float(compute='_compute_price_tax', string=' Total including tax', digits= dp.get_precision('Product Price'), store=True)


    

    @api.one

     @api.depends('price_unit', 'discount', 'invoice_line_tax_id', 'quantity',

         'product_id', 'invoice_id.partner_id', 'invoice_id.currency_id')

     def _compute_price_tax(self):

         price = self.price_unit * (1 - (self.discount or 0.0) / 100.0)

         taxes = self.invoice_line_tax_id.compute_all(price, self.quantity, product=self.product_id,

                                                                                  partner=self.invoice_id.partner_id)

         self.price_subtotal_tax = taxes['total_included']

         if self.invoice_id:

             self.price_subtotal_tax = self.invoice_id.currency_id.round(self.price_subtotal_tax)


Bye

Avatar
Discard
Victor Godayer
Author

Thanks a lot, it works like a charm, and understood the logic, so I did the same one sale_order_line!