taxes rounding *

[Former Member]

Hi all,

Sale price 10000.00

P& F 3% 300.00

-

---

Assessable value 10300.00

BE Duty 14% on sale pri 1442.00 (R/off to next rupee)

ECS 2% on BED 29.00 (28.84 Rounded off)

SHE 1% on BED 15.00 (14.42 Rounded off)

-

---

Subtotal 11,786.00

In the above scenario - the BED, Education Cess & Higher Education cess are rounded off to the next rupee. I has to configure the same scenario in the system.

while doing tax formula setup - there are some options @ the operation dropdown list

1. Round(Number, Decimals as Number)

2. Round(Number, Type)

How the above two are useful & where that has to be inserted in the formula.

BED formula:

if (AssessableValue > 0)

{ BED_N_BaseAmt = AssessableValue*Qty+PNF_TaxAmt }

else

{ BED_N_BaseAmt = Price*Qty + PNF_TaxAmt }

BED_N_TaxAmt=BED_N_BaseAmt*BED_N_Rate

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

Thanks & Regards

Ganesh Varma. G

[Former Member · Accepted solution]

Hi Sagar,

I am very thankful to U. It's working. I tested by putting 0.49,0.50 &0.51. in the formula in different ways.

It's working (on all the above inputs)

What's the logic behind that (why u selected 0.49) in the formula.

As per u'r suggestion I am taking 0.49 only. If there is any logic behind that - plz elobrate on that.

Plz mail u'r mail id & I am very thankful for u'r solution.

Ganesh Varma. G

[Former Member · Accepted solution]

Hi,

Mantra behind Technical people. Sorry if u need i will mail u.

Don't forget to put point on it.

SAGAR

[Former Member · Accepted solution]

Hi Sagar.

I like u'r mantra. Mail the logic behind that. I am really eager to know abt that.

varmab2b-gmail com

Thanks for u'r help.

Ganesh Varma. G

[Former Member]

Hi,

Is there any way to round off the duties at header level than at item level?

[Former Member]

not

[Former Member]

Thanks for u'r reply.

I am asking about BED, ECes & HECes round off. not about total document round off.

Plz go through the scenario - which i explained above.

ganesh

[Former Member]

Hi Ganesh Varma,

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=Round(CES_N_BaseAmt*CES_N_Rate,0)

Higher Education cess formula:

SHE_N_BaseAmt=BED_N_TaxAmt

SHE_N_TaxAmt=Round(SHE_N_BaseAmt*SHE_N_Rate,0)

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

[Former Member]

Hi

Thanks for u'r valuable answer. but - it's not solving my purpose.

My scenario is - all excise duties has to be rounded up to next rupee.

ex:

total 88.00

BED:(14%) - 88*14/100 = 12.32 ( it should be rounded up to 13.00)

ECes(2%) - 13*2/100 = 0.26 (it should be rounded up to 1/-)

HECes(1%) - 13*1/100 = 0.13 (it should be rounded up to 1/-)

all excise dutie values which cross .01 also - should be rounded up to next rupee.

If u have any answer for this - help me out.

ganesh varma. g

[Former Member]

Hi Ganesh,

In all the tax formula if Excise Duty Formula

BED_TaxAmt=Round(BED_BaseAmtBED_Rate,0*)

0(Zero)

If you do this for all tax formulas its should be rounded off automatically to nearest amount (according to your requirement).

For me total = 719,810

BED@14% = 100,773 (but actual =100773.40)

Ecess@2%= 2,015 (but actual=2015.46)

Hcess@1%= 1008 (but actual=1007.734)

Try it again

[Former Member]

Hi Ganesh,

Above method only possible rounding to nearest one only possible. Otherwise they have to manually change the amount.

[Former Member]

Hi

Thanks for u'r reply

As per u'r scnario:

For me total = 719,810

BED@14% = 100,773(but actual =100773.40)

Ecess@2%= 2,015 (but actual=2015.46)

Hcess@1%= 1008 (but actual=1007.734)

I want Both BED & Ecess to be rounded up to next rupee

As per my scenario - i want it in the below way (check the star marks)

BED@14% = 100,774 (but actual =100773.40)

Ecess@2%= 2,016 (but actual=2015.46)

ex: even if it is 10.01(it should round off to 11.00)

[Former Member]

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.49),0)

Education Cess formula:

CES_N_BaseAmt=BED_N_TaxAmt

CES_N_TaxAmt=Round(((CES_N_BaseAmt*CES_N_Rate) + 0.49),0)

Higher Education cess formula:

SHE_N_BaseAmt=BED_N_TaxAmt

SHE_N_TaxAmt=Round(((SHE_N_BaseAmt*SHE_N_Rate) + 0.49,0)

Hope this will work for u.

SAGAR

Edited by: sagar simle on May 8, 2008 12:23 PM

Edited by: sagar simle on May 8, 2008 12:24 PM

[Former Member]

Hi,

To rounding off,

Goto Administration --> System Initialization --> Document Settings. In that Click "By Currency" in Rounding Method.

Then Goto --> Administration --> Setup --> Financials --> Currencies. In that you can round off the amount by Rounding Off to Tenth Hundreds option.

I hope this could help you.

Raja.S