1099 report- program RFTW0010/RFTW0020

[Former Member]

Hello All

I am facing some issues with the 1099 reporting. We have many vendors that were setup incorrectly as 1099 vendors. A lot of documents have been posted to them. I deleted the withholding tax information and ran the correction program RFTW0010 and then ran the 1099 report S_P00_07000134 - Generic Withholding Tax Reporting but this report still shows all the documents already posted.

Looks like the only way for me to fix this, is to go and remove the withholding tax information from each line. This is not possible. Is there a solution for this? what is the use of these programs? they only update the with WITH_TAX tables and fix a vendor going forward right?

Does SAP not have a solution for this?

When do I run the program RFTW0010 vs RFTW0020.

[former_member229531]

Hi,

We are facing similar issue with withholding tax.may i know how did you resolve those issues?

1.If a vendor is not classified as a 1099 vendor and posted invoices and payments are processed. But later on realized that the vendor should have selected as a 1099 vendor.so now how do we correct already processed invoices and payments? So that correct amounts are included in 1099 report and form for IRS reporting.

Is there any program or report in SAP to execute after updating withholding tax information in the vendor master?

2.If a vendor is classified as a 1099 Vendor and posted invoices and payments are processed. But later on realized that the vendor is not 1099 vendor.so now how do we correct already processed invoices and payments? So that correct amounts are included in 1099 report and form for IRS reporting.

Is there any program or report in SAP to execute after remove withholding tax information from the vendor master?

Thanks,

Anusha

[Former Member]

anybody has any ideas on this? surely it must be very common for a vendor to be accidentally entered as a tax vendor and later on we realize that he should be a non 1099 vendor and we delete the withholding tax information from its master data and run the correction program we expect the system to remove the tax information from all documents posted so far.

Anyone 1 has experience with this?

[Former Member]

Hi,

The 2 reports mentioned by you viz., RFTW0010/RFTW0020 are to be used when you are changing the vendor master and then wants to correct the line items posted to be in sink with the changed vendor master.

I guess, in your instant case also, the report RFTW0020 is relevant, is you have changed the code and report RFTW0010 is relevant is you have changed the WT Type.

Hope this helps.

Vikas.

[Former Member]

Hi Vikas,

Thanks a lot for the response. When I run these programs, SAP doesn't go and change the line items for already posted documents. Is it supposed to do so?

[Former Member]

Hi,

Yes.. you are correct.. system will show up all the line items that were changed with messages.

but, did you change the WT code or WT type ? Based on that you need to run the reports. Please choose different radio buttons to suit your requirements. Try all and not just single option.

Hope this helps.

Vikas.