Tax Computation using Python Code

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Účetnictví
Sklad
PoS
Project
MRP

All apps

All Posts Lidé Odznaky

Štítky (View all)

odoo accounting v14 pos v15

O tomto fóru

Pomoc

Tax Computation using Python Code

python tax computation CE v15

1 Odpovědět

5430 Zobrazení

Tabrez

Hi,

We have a requirement where the GST has to be used as Group Tax and has to be equally distributed. For example GST 18% will have a group of CGST as 9% and SGST as 9%. For that we want to use the python code.

Under SGST 9% and CGST 9% python code I want use the following condition;

For example Product website listed price is 399 then the Sales Order should have Untaxed amount as 338.13 and CGST 30.43 and SGST 30.43. These numbers we can get it by doing the following equation, i.e. product_price/1.18 = 399/1.18=338.13. Then remaining amount will be for tax 300-338.13=60.87. That will be further divided by 2, 60.87/2=30.43.

Product Price = 399

Untaxed Amount = 338.13

CGST = 30.43

SGST = 30.43

Not able to put the same in python code. Any help or guidance in the above requested will be really appreciated.

Tabrez

Autor

I tried using the shared code as shown above, but I am getting the following error;

Please will appreciate your kind guidance.

Mily Shajan

You can try the following code

By inheriting the sale.order.line, Here is an example

class SaleOrderLineInherit(models.Model):
    _inherit='sale.order.line'

    price_untaxed = fields.Float(compute='_compute_untaxed_price', store=True)
    cgst = fields.Float(compute='_compute_cgst', store=True)
    sgst = fields.Float(compute='_compute_sgst', store=True)

    @api.depends('price_unit')
    def _compute_untaxed_price(self):
        for rec in self:
            rec.price_untaxed = rec.price_unit / 1.18

    @api.depends('price_untaxed')
    def _compute_cgst(self):
        for rec in self:
            rec.cgst = (rec.price_unit - rec.price_untaxed) / 2

    @api.depends('price_untaxed')
    def _compute_sgst(self):
        for rec in self:
            rec.sgst = (rec.price_unit - rec.price_untaxed) / 2

Regards

Tabrez

Autor

Thanks a lot Bella for your response.

I tried as per your guidance but it did not work. Please, I have shared the screenshots for your kind reference.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Přihlásit se

Related Posts	Odpovědi	Zobrazení
My Odoo 15 Instance stops a few minutes after startup python v15	0 lis 23	1384
Create order_line from code Vyřešeno python v15	1 lis 22	3917
How to inherit and modify Odoo Tax Calculation ? tax v15	0 srp 22	2366
"Python Code (inverse)" python tax	0 bře 15	4057
Python help for Taxing Product Category python tax productcategory	1 úno 25	774

This question has been flagged

Enjoying the discussion? Don't just read, join in!