TDS getting deducted Twice

[former_member193801]

Dear Gurus,

TDS is getting deducted Twice one for the Invoice through T-code: F-43 and other for the F-53.

Done the changes by Un-ticking the Liable in the vendor master Data. Still no luck...

At that time system is showing the inconsistency in the Data ERROR.

I have gone through the previous blogs related to this but still no use.

I have Removed the Tax code as said in the previous blogs still it showing the TDS amount in the Witholding TAB in the F-53.

Any inputs on this is highly appreciated and awarded points.

Regards,

Rohit.....

[Former Member · Accepted solution]

Hi Rohit,

Please check the Invoice Document No. - With holding Tax Tab - Payment Related Withholding Tax Code must be blank.

Also run program RFWT0010 to adjust the With holding Tax Information.

Regards,

Jaymin R. Bhatt

[Former Member]

Hi Rohit,

TDS is deducted at the time of Invoice or Payment whichever is earlier, so for this reason we maintain tax type and tax code both for Invoice and Payment in the Vendor master. It is Maintained like this..

Tax Type       Tax Code

A1(Invoice)                A1

A2 (Pmt)                 ....

So if it is maintained like this in the Vendor master, system would automatically deduct TDS at the time of Invoicing but at the time of Payment you need to choose manually.And, if you maintain tax code for payment also, it will deduct twice as it is happening in your case.

You don't need to untick the liable tick as that is not right, because you want the system to deduct TDS.. If you switch off the liable tick it will issue unconsistency message.. and you need to execute the report as suggested by jaymin RFWT0010. If there are already open items for that vendor and you chnage Tax settings, you will get inconsistency message.

If you want the correction in the already posted documents then you need to reverse it. Then change the Tax settings in the Vendor master( Making tax code field blank against the with holding tax type for Payment) and then repost the Payment. Then you will not get TDS deducted twice.

Please note that if you chnage the Tax code only in the Vendor master, you will not get inconsistency message.

(Recently the same issue was faced by one of the Indian clients and it got resolved this way)

Hope this helps..

Regards,

Kavita

[former_member193801]

Dear Kavita,

Thanks for your valuable suggestions.

But my concern was only one document is showing the Error like as below.

1 items have not been activated due to inconsistent withholding tax info

Message no. F5787.

I done the configuration changes only in the vendor master data.

Any suggestions on this is really appreciated.

Regards,

Rohit....

[Former Member]

Please execute the Program "RFWT0010" to remove the inconsistency,

Regards,

Jaymin R. Bhatt

[former_member193801]

Dear Jaymin,

I Tried with the Program Mentioned above but still no use.

This document is cleared document. So is this could be the reason for not running this Program.

I Tried with other Program: RFWT0020 which we will run for the cleared Documents. Even this is of no Use.

So, Please help me on this...

I am really confused....

Regards,

Rohit....

[Former Member]

Hi,

Try this solution.

Please remove withholding tax code (only for payment) from vendor master.

By doing this, system will not calculate TDS automatically at the time of payment.

If it is required to calculate TDS during payment, user will be able to add WHT code manually.

Please try this solution and revert.