RFWT0010 and RFWT0020 is not working when updating 1099

[former_member857785]

Good Morning SAP Guru's.

We are currently on ECC 6.0.

I used these transactions before however it is not updating Vendor Master changes where payments should be reportable and not reportable.  Most common scenario is where the Vendor should not have been reportable so to correct the issue we removed the Tax Type and Tax Code under Vendor Master and then we execute the following before running S_P00_07000134.

Unfortunately, we have a lot of Vendors that need to be updated and I am nervous why we cannot correct them.

Any ideas? 

I have checked the blog and found that most of the issues are 4 years old.  This is a brand new implementation and I did not see any OSS Notes to apply.

I did find OSS Note 363650 and I see where it mentions something about Document Change Rules.  Is this necessary to update the document change rules and could this be the problem?

Thank you.

[former_member207607 · Accepted solution]

Dear Albert,

report RFWT0010 can be used for changing relevant WT types as result of legal changes. In case You need to change WT codes, You should use the workarond to define a new combination of WT type and code and then run RFWT0010 afterwards.

Please be kindly informed that the report can be used:

for the already posted invoices with the WT type defined at the Payment time.

for the parked invoices with the WT type defined at the Invoice time

Report RFWT0020 can be used for subsequent creating and changes to WT data with Withholding tax rate of 0% and when the correcponded wt types are for

posting payments.

I hope this can help You.

mauri

[former_member857785 · Accepted solution]

Thank you Nishan and Maurizioi-

I have 1099 reporting at the time of payment.

We have Vendors that were incorrectly marked as reportable and that shouldn't be.

So which transaction/ program do I use?  I think the Note is necessary to change data in order for the programs to work correctly?

with the currenct configuration, the correction isn't working because I cannot modify the cleared line items.

We have vendors that were paid and showing reportable and they shouldn't so I know to remove the 1099 reportable in the vendor master but it is still showing on the 1099 report.

I am still not clear when to use RFWT0010 and when to use RFWT0010.

Thank you.

[former_member857785 · Accepted solution]

Maurizio-

I understood that RFWT0010 will not work because it only works for invoices and not payment docs??

These are payment documents already cleared.

[former_member207607 · Accepted solution]

Dear Albert,

yes, if the documents are already paid, no way to change them.

You can use the report RFWT0020 but only in case the wt code rate is 0%...

I hope this can help.

Mauri

[former_member857785 · Accepted solution]

Is there a solution out there when payments are already made?  Surely my client is not the first one to have made payments and realized that the vendor is not reportable?

I thought by using these t-codes and modifying document change rules we would be able to correct this?  Someone in another thread suggested clearing out the wht base would be the solution but I can't figure out how that can be done.

[former_member207607 · Accepted solution]

Dear Albert,

yes, but the only possible solution is to reverse the wrong documents and to post them again.

If You posted the payments and the wt amounts were posted, it will not be possible to change the documents and to delete the wt amounts.

Mauri

[former_member857785 · Accepted solution]

What is the point of RFWT0010?  It doesn't seem to do anything.  RFWT0020 I tested and saw that it will update the Tax code when a change is made and it is reflected on S_P00_07000134.

[former_member207607 · Accepted solution]

The report RFWT0010 works in case You change the WT type into the vendor master data after posting the invoice. when you do the payment you can have a wt data inconsistency.

Therefore You run RFWT0010 to fix this data inconsistency. the system creates a new entry into the wt pop up with the new combination of wt type and wt code. then you can pay the invoice.

This is the rfwt0010 scope.

Mauri

[former_member857785 · Accepted solution]

Thank you Maurizio-

to correct the error, I am going to create dummy invoices and clear with payment to wipe out the withholding tax base.

thanks!

[Former Member · Accepted solution]

Hi Albert,

Withholding Tax is a chagable field . Go to each document which are having withholding Tx info and make it Zero if you do not want

Regards

Veenu

[Former Member · Accepted solution]

Hi Guys

I have the same issue and this is the scenario.

We use a custom program to display the 1099 cleared vendors. we have couple of company code for the other company code it has been working but for the 1920 company code it does not work.

when i saw the config for this company code in the withholding tax side, i have noticed that 1099 withholding tax type was not assigned to 1920.

i have corrected the config and then moved to quality after moving to quality, i have a created a one 1099 vendor, created one invoice and cleared it. Then we we executed our custom program and diplayed the desired result.

now when i moved the same configuration to Production, there were no new data but was old data (invoices and payments) then i ran this RFWT00210 to mark all the existing line items to be 1099, and then ran our custom report to display the 1099 cleared vendor list, but did not work.

any answer will be really appreciated.

regards

khurram 

[nishan_dev]

Albert,

This is the latest note - 363650, for this issue.

These two programs only run and update data if the vendor master data has changed. If you don't have access to change the Withholding Tax Data tab on a vendor record you need to find someone there who can. All they need to do is either make a vendor 1099 (when it wasn't before), delete the 1099 tax code, or change the tax type.

Let me know if I am going to wrong direction or didnot understood your query.

Best Luck,

Nishan Dev