cancel
Showing results for 
Search instead for 
Did you mean: 

Formula

Former Member
0 Kudos
42

hi

Pls help me on creating formula

Item Cost : 13000

Excise Duty 10% = 1300

Cess 2% = 26

HSCess 1% = 13

Cst 5% = 717

Surcharge@10% = 72

Surcharge@10% is calculated on CSt

Total = 15128

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Closed. Thanks

Former Member
0 Kudos

Hi Manish,

After defining the tax types, you can start by creating the formula's as mentioned below;

BED:

if (AssessableValue > 0)

{ BED_BaseAmt = AssessableValue*Qty }

else

{ BED_BaseAmt = Price*Qty }

BED_TaxAmt=BED_BaseAmt*BED_Rate

cess

Cess_BaseAmt=BED_TaxAmt

Cess_TaxAmt=Cess_BaseAmt*Cess_Rate

cst

cst_BaseAmt=TotalBED_TaxAmtCess_TaxAmt

cst_TaxAmt=cst_BaseAmt*VAT_Rate

surcharge:

sc_BaseAmt=cst_tax amount

sc_TaxAmt=sc_BaseAmt*sc_Rate

You may try this.Hope this helps.

Thanks,

Joseph