TCS Calculation Issue

pashya1972

Hi,

We ve observed TCS wrong calculation issue.

In the beginning rounding off was "nearest to rupees 10" ..It was calculated tcs perfectly but since rounding off to 10 rs was not acceptable we drop the idea and make changes to nearest to rupee "1". But now the system does not calculating the TCS accurately . In 2-3 invoices TCS has not been applied due to wrong calculation. Set-up is overlook surcharge and rate @ 1% +10% Surcharge+2% cess+1% she cess.

Surprisingle TCS is calculating far below i.e. 50% or so. Also while checking it is observed that Say a base amount of invoice is 100000 it is showing 47K . I cud not find the diff as to why the system is taking base amt diff from the invoice?

Thanx'

Prashant

srinivas.chittem

Hi Prashant,

Please check the Effective dates, TCS%, Surcharge%.

And TCS threshold Amount, Surcharge threshold Amount.

Effective date is very important when we calculate TCS

ssingla

Check for Invoice Discount and amount calculated in the structure. TDS/TCS Base amount is calculated as per the below formula:

TCSBaseLCY := ABS("Line Amount" - "Inv. Discount Amount" + StructOrderLine."Amount (LCY)");

pashya1972

I ve verified the structure however it seems to be ok.

Attached herewith sample case.

Prashant

ritesh.singh

working fine in base product. even with rounding nearest to Rs. 10.
Check the setup once again and try to do the transaction in Base product.