cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating ED and CST combined

Former Member
0 Kudos

Hi Friends,

I'm trying to combine ED (Excise duty) and CST for Purchase process.

ED is calculated at 12.5% based on assessable value and added to the

Total amount and CST 2% calculated on the resulting value.

E.g  GRPO amount - Rs 44045 (based on unit price * qty)

       Assessable value - Rs 30544 | ED 12.5% is calculated on this - Rs 3818

       Total = 44045 + 3818 = 47863

       CST 2% on 47863 = 957.26

       Grand Total = 47863 + 957.26 = 48820.26

From above its obvious both ED and CST should be combined into one tax code.

I need help in coding the Tax formula to arrive at the required amount. Please help.

With Thanks & Regards

Shiva Venkat

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I already have setup the above mention code for Excise 12.5 and CST 2 in my system.

Please find the screenshot for tax formula and tax code.

Let me know if you need any further help on how to create this.

Thanks,

Harshal

Former Member
0 Kudos

Hi Harshal,

Thanks for the reply. I did the same as you have done; but the requirement is not to just combine the tax codes. ED is based on 'assessable value', which is added to the total invoice and CST 2% is calculated on this amount. Please look carefully at my calculation given.

With Warm Regards

Shiva

Former Member
0 Kudos

Hi,

Let me know the Quantity, Assessable rate and Unit price for above mention example by you, I want to try in my system.

Thanks,

Harshal

Former Member
0 Kudos

Hi Harshal,

Quantity = 19.5

Assessable Rate = Rs. 159.5

Unit Price = Rs 230

Many Thanks

Shiva

Former Member
0 Kudos

Hi,

I have run the same scenario as mention above just quantity you message is wrong I guess.

Qty = 191.5

Unit Price = 230

Ass. rate = 159.5

I am getting correct value as you are expecting.

Just check the Snap shot.

Thanks,

Harshal

Former Member
0 Kudos

Hi Harshal,

Thanks for the reply. This is what I was looking for. Can you please tell me where i can get this window. And also kindly show the tax code, tax combination structure so that I can replicate it on my database.

Further, the base amount mentioned for BED is automatic or have to be manually entered. Because there is field called 'Assessable value' in GRPO.

Many thanks

Shiva

Former Member
0 Kudos

Hello Siva,

As per your given information in the first post you had mention Assessable Value = 30544, so accordingly per unit assessable value is 30544/19.5 (19.5 is your quantity) = 1566.35. On assessable value we had charged 12.5% ED so it comes as 3818 INR. And as sggested by harshal , and in provided screenshot for BED Calculation formula, harshal had taken BaseAmt = Assessable value * Qty. So on your GRPO you need to mention Assessable value for per unit that is 1566.35 and for your CST Calculation you need to create the TAx formula for CST as :

BaseAmt=(qty*Price)+BED_TaxAmt

TaxAmt=BaseAmt*Rate


Perform these steps and let us know the result.



Regards,

Bhushan Verma

Former Member
0 Kudos

Hi Harshal,

Sorry for the trouble, can you please also send me the screen shot of that formula code - CST@CENVAT mentioned in the first screenshot as well.

Many Many Thanks

Shiva

Former Member
0 Kudos

You need to enter the Assessable value manually in given field @GRPO

Regards,

Bhushan Verma

Former Member
0 Kudos

Hi Bhushan,

That I got it, but I want know from where this widow for 'Tax Distribution' is coming from in marketing doc. I wanted to know whether the assessable value is automatically picked up from marketing doc or it has to be entered manually again in this window.

Many Thanks

Shiva

Former Member
0 Kudos

Hi Bhushan,

Thanks, I will try that and let you know.

Many thanks

Shiva

Former Member
0 Kudos

Hi Siva,

That tax distribution window is coming from a Field knows as Tax Amount, you need to check your form setting for GRPO whether you had enabled this field or not, and if not then you need to do so, from Form Setting, and then you will see a yellow arrow just in front of numeric value which is called as Linking Arrow, and then thru this you can reach to tax distribution window.

And system pick assessable value automatically, you need not enter this again.

Regards,

Bhushan Verma

Former Member
0 Kudos

Hi Bhushan,

I tried to create Tax formula based on your input for CST. But CST does not have BED_TaxAmt

as one of its variable. How do I bring this BED_TaxAmt into CST formula.

Former Member
0 Kudos

Hi,

Assessable value can be enter manually in GRPO and if you do not want to be enter manually you can set assessable value in Item Master Data also which will take it up automatically in documents.

You can click on Tax Amount Link arrow in GRPO to open this window.

First Create the Tax Code as BED@12, ecess@12 and HSCBED@12 and also CST@2

Then create the Tax type combination as per attached screenshot.

Also create the Tax formula for BED and CST as per attached screenshot.

Let me know if you have any doubt or need any help.

Thanks,

Harshal

Former Member
0 Kudos

Hi Siva,

You can do this by following steps:

1. Under Formula Input section click on the second column of the blank row

2.  Press Tab

3. a list will open , there in find field, enter BED_TAXAMOUNT, by doing this system will direct you to right field.

4. Double click on BED_TAXAMOUNT and you will get this under formula input

5. To include this in formula (in Right hand side section), place the cursor beside '+' sign and then click the grey area of the row of Bed_TaxAmount.

Regards,

Bhushan Verma

Former Member
0 Kudos

Hi Bhushan,

Thanks for your valuable suggestion and help. Issue solved.

Many Thanks and Regards

Shiva

Former Member
0 Kudos

Hi Harshal,

I did as per your advice and issue is now resolved

Thanks for taking time and helping me out.

Many Thanks and Regards

Shiva

Answers (0)