cancel
Showing results for 
Search instead for 
Did you mean: 

ROUNDING OF TAX

Former Member
0 Kudos

Hi All,

I have the following querry. Can we round off the tax amount to nearest Ruppe in row wis or in total.As in practical scenario peoples are rounding the tax amount. for example in 1st line calculation is as per SAP and in 2nd line is as per practice of the industry.

qty price total ED CESS H.CESS VAT FINAL TOTAL ROUNDING

23 2.35 54.05 7.56 .15 .07 2.47 64.30 64

23 2.35 54.05 8 0 0 3 65.05 65

Accepted Solutions (1)

Accepted Solutions (1)

former_member187989
Active Contributor
0 Kudos

Hi santhosh,

You need to use round function in tax formula as below.

ED

BED_BaseAmt=Total

BED_TaxAmt=Round((BED_BaseAmt*BED_Rate),0)

Use round function for es,hecs and vat formulas.

Hope it will help you.

Jeyakanthan

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

For your requirement 1st option is suitable.

Your formula code should be like this:

BED formula:

if (AssessableValue > 0)

{ BED_N_BaseAmt = AssessableValue*Qty+PNF_TaxAmt }

else

{ BED_N_BaseAmt = Price*Qty + PNF_TaxAmt }

BED_N_TaxAmt=Round(BED_N_BaseAmt*BED_N_Rate,0)

Education Cess formula:

CES_N_BaseAmt=BED_N_TaxAmt

CES_N_TaxAmt=CES_N_BaseAmt*CES_N_Rate

Higher Education cess formula:

SHE_N_BaseAmt=BED_N_TaxAmt

SHE_N_TaxAmt=SHE_N_BaseAmt*SHE_N_Rate

VAT_BaseAmt=Total

VAT_TaxAmt=round(VAT_BaseAmt*VAT_Rate,0)

I worked out this it works perfectly. Try this if you have any doubt let me know.

Sagar

former_member187989
Active Contributor
0 Kudos

santhosh,

You can use round function by selecting it from

operation option in respective tax formulas.

You can round base amount and assign it to tax amount.

Hope it will help you.

Jeyakanthan

Former Member
0 Kudos

Hi Jeyakanthan,

Can you explain it in detail exactly what I have to do. Here my ED is 14% and Cess 2% Hcess1% and VAT 4%.

Thanks

Santosh