Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
pythontaxcomputationCEv15
1 Odgovori
6279 Prikazi
Avatar
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.

Avatar
Opusti
Tabrez
Avtor


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


image0


Please will appreciate your kind guidance.

Avatar
Mily Shajan
Best Answer

Hi 

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

Avatar
Opusti
Tabrez
Avtor

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.

Related Posts Odgovori Prikazi Aktivnost
My Odoo 15 Instance stops a few minutes after startup
python v15
Avatar
0
nov. 23
2176
Create order_line from code Solved
python v15
Avatar
Avatar
1
nov. 22
5004
How to inherit and modify Odoo Tax Calculation ?
tax v15
Avatar
0
avg. 22
3098
"Python Code (inverse)"
python tax
Avatar
0
mar. 15
4837
Python help for Taxing Product Category
python tax productcategory
Avatar
Avatar
1
feb. 25
1305