Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
In the Sales module, I can add the calculated tax as a column to the Order lines table (Field name is price_tax)
However, I can't find such a field in the Accounting module. I want to add it to Invoice lines and use it when printing reports.
Is it possible to do this through Studio? If not, how can it be done with code?
Hello Nikita,
You can do this via Code. You need to add new field for total taxes in py and xml file of account.move.line and create compute method to calculate taxes per line.
Refer below example to calculate total taxes in acount.move.line.
Thanks, (Siddharth Tarpada)
total_taxes = fields.Monetary('Total taxes', compute='compute_total_taxes')
@api.depends('tax_ids', 'quantity', 'discount', 'price_unit')
def compute_total_taxes(self):
for res in self:
line_discount_price_unit = res.price_unit * (1 - (res.discount / 100.0))
if res.tax_ids:
taxes_res = res.tax_ids._origin.with_context(force_sign=1).compute_all(line_discount_price_unit,
quantity=res.quantity, currency=res.currency_id, product=res.product_id, partner=res.partner_id, is_refund=res.move_id.move_type in ('out_refund', 'in_refund'))
res.total_taxes = sum([tax['amount'] for tax in taxes_res['taxes']])
else:
res.total_taxes = 0.0
Hi Nikita,
maybe this module can do this for you:
https://apps.odoo.com/apps/modules/14.0/account_invoice_line_tax/
In this module, the tax field is added to other modules, but not to the accounting module
I'm looking for an opportunity to do the same, but in the accounting module
Sorry I don't get it; the field is visible in the invoice (backend and report). Isn't it what you want?
It is how Invoice line look in Accounting
https://prnt.sc/msXE9w1phRu0
I want to add column in which the calculated value from tax will be displayed. In this case, one line will be 84500 (5% of 1690000) And the second line will be 6870.7
This column(Total tax) was hidden in the Sales module. I opened it and now the table looks like this https://prnt.sc/LokseqTbV5Yd . I want do same with Accounting Invoice lines
again, the above module is adding this total tax to sales, purchase as well as invoice. if you want to make it visible and invisible like the three dots, you can give the attribute optional (hide/show) to the field in the view, so that you can (de-)select it.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
0
Dec 24
|
12 | ||
|
0
Nov 24
|
29 | ||
|
1
Nov 24
|
71 | ||
|
1
Sep 24
|
473 | ||
|
1
Jun 24
|
1739 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
I can do it in Sales module https://prnt.sc/LokseqTbV5Yd
But I’m looking opportunity to add a similar field to Accounting module