Tds calculation on cummulative amount

[Former Member]

hi

my client wants to calculate TDS only when invoice's amount exceeds 50000/-. for ex: when the first invoice amount is 10000/- then they won't calculate TDS, in the second invoice if it is for 30000/- then also they won't calculate and in third invoice if it is 10000/- then they will calculate TDS in that invoice for the total 50000/- . To do this what settings i have to do in addition to normal settings.

it is urgent

please if anyone knows give me the solution i will assign points

[Former Member]

Hi

When you are making advance payment to the vendor, you please select both with holding tax type and withholding code key and click the liability check and give the receipent type, and for payment only you select withholding tax type. When you are making advance payments system will take you to withholding tax tab, there you delet the with holding tax code (not in master, only that particular transaction) like this you make for all the advance payments whenever you wish to deduct the TDS give the tax code and select the wht.base amount Rs.50000 then system calculates TDS on Rs.50000.

You try as above and let me know the result.

Regards & all the best

Prabhakar

[Former Member]

Hi

When you are making advance payment to the vendor, you please select both with holding tax type and withholding code key and click the liability check and give the receipent type, and for payment only you select withholding tax type. When you are making advance payments system will take you to withholding tax tab, there you delet the with holding tax code (not in master, only that particular transaction) like this you make for all the advance payments whenever you wish to deduct the TDS give the tax code and select the wht.base amount Rs.50000 then system calculates TDS on Rs.50000.

You try as above and let me know the result.

Regards & all the best

Prabhakar

[Former Member]

Hi,

There is no requirement of workaround here. You can still do that configuration in Minimum base amount for the tax type. This can be done in the menu WITH HOLDING TAXEXT WITH HOLINDG TAXCALCULATION--DEFINE MIN/MAX WITHHOLDING TAX TYPE

Go to new entries. Give tax type,valid from and give minimum base amount as 50000/-.

Then go to the concerned tax type and Give Accumulation type as per year starting with month 4 (India).

Then it will not calculat the WHTAX up the amount of 50000/-. Once tha amount crossed 50000/- it will deduct the tax considering the earlier invoices also.

If any clarification required get back to me.

Regards

siva

[Former Member]

hi siva

i did whatever u told, but it is calculating only on the last invoice amount not for the total amout.

i posted 20000/- in first invoice, 10000/- in second invoice and 30000/- in third invoice. in third invoice it is calculating tds on 30000/- but i want it to calculate on total i.e., 60000/- in third invoice.

it is urgent pls help me

[va_joshi]

Did anyone found solution? Even I have same case. Kindly help

[Former Member]

hi,

In this case you have to do some work around by manual work. Till u r limit dont apply tax code of WHT. When the amt is reached apply tax code. Make tax code ready for manual amount. When amt is reachead enter manually the base amt and wht amount.

CHEERS

[Former Member]

hi

see how user will know the total invoices amounts to specify the base amount. he will not remember the past invoices values know. i want system to identify and calculate automatically

[Former Member]

Hi,

Syestm charges tax on posting amt in document and not on the basis of vendor acct total. You can maximum set minimum amt exempt fro tax in doc. In your case you can create a table with the help of abaper and use user exit or other tchnical development to calculate wht once total exceeds the limit. I have not configuresd this scenario. If it is legal requirement then u can post it to sap service.

Hope this will help you.

CHEERS