Skip to Content
0
Former Member
Jan 08, 2011 at 10:15 AM

Formula In Tax

36 Views

Hi All,

Following is the formula created for cess code which I have used.

Cess_BaseAmt=BED_TaxAmt

Cess_TaxAmt=Cess_BaseAmt*Cess_Rate

Cess_TaxAmt=Round(Cess_TaxAmt,0)

Its considering 25.34 as 26 where as it should be 25. Why? and How to correct this? Decimal setting for amount. prices, rate etc is set to 2.

Consider the example mentioned below

Qty Rate Tax

370 18.34 ED 10Cess2HeCess1+vat5

370 15.90 ED 10Cess2HeCess1+vat5

Thanks,

Joseph

Edited by: Joseph Antony on Jan 8, 2011 3:48 PM