I have the following 2 questions regarding 1099s. One has to do with the fact that I read somewhere that after you have added tax number information to a vendor (s), that there is a program that you need to run so that SAP will flag the appropriate previously recorded payment information so that it will be reported on the vendors 1099. Can someone please tell me what the program name is?
Second question has to do with the Payers (company code) name, address, and tax identification number that appears on the 1099.. Where is this entered into the system. When I print out my 1099s for 2007, this information is blank (I have the recipients information but not the payers). I am sure that there is some configuration type setting or master data that I have failed to enter. I would appreciate it if someone would tell me where I need to enter this information.
Thanks in advance for your assistance.
Greg Brown
FI/CO consultant
Everyting Rau said was correct. I've just finished up working with our A/P department on getting our 1099s out. The RFWT0020 program is a life saver. We assigned a Tcode to this so our A/P group could run this as needed. The program documentation in the Information (I) button on this program is quite good.
Also our A/P department occasionally had added tax via the above where it was not warranted and we had to remove this tax information from the individual documents on FB02. We had to open up config to be able to change the whtax info after the invoice cleared.
As for the Payer information, when you run the RFIDYYWT (transaction S_P00_07000134) program, it will pop up with a window for Additional selection for US (also available via the Country Specific Selection button). In this area there is a section almost to the bottom titled Payer/Transfer Agent.
You need to fill this information out and it will then print on the 1099 forms. We also had to fill in the $600 limit in this area as well.
Hope this helps, let me know if you need more info.
Laurie
Hi Greg,
Below is the sequence of steps to process the 1099 (SAP term Withholding Tax) vendor invoice
1. Enter WT tax type, WT tax code and check mark liable box in the vendor master.
2. Enter only those relevant tax types and tax codes that are really applicable to that vendor master. Entering additional/non-relevant tax type and code in vendor master do not do any good instead it will increase additional work at the time of recording vendor invoice.
3. At the time of recording vendor invoice, WT types and codes information moves from vendor master to the transaction screen and per configuration full invoice value will be assumed subject to 1099 information.
4. If the vendor master has multiple lines of WT types and codes then at the time recording vendor invoice go to WT tab and enter $0.00 to those lines that are not applicable. If the full amount invoice is not subject to 1099 information but only part of the invoice amount then enter only that $ amount in the column WT base column. For example vendor invoice is entered for repayment of principle amount + accrued interest then enter only interest amount in appropriate WT line. Repayment of capital amount is not subject to 1099 reporting.
5. If the invoice is entered with WT code that requires withhold back tax and pay to IRS the tax amount e.g. tax code D2 that has 31% back tax, then at the time payment of invoice, using t.code F110 or F-58, system will calculate back tax automatically. Invoice will be paid less by back tax. Back tax amount will be recorded in GL.
6. Incase vendor invoice is to be paid though manual check or wire transfer (over the telephone and not system generated) and subsequent recording is to be done through t.code F.53 then calculate the WT manually and pay the remainder of the amount. On the open item screen of t.code F.53 payable will show net of back tax and on saving of document it will trigger the automatic entry to GL for back tax.
7. Execute program RFWT0020 after step 8 to populate WT information to already posted/paid invoices and verify the correctness.
8. Please work with program RFIDYYWT to generate electronic file for yearly IRS reporting. On this please stay with SAP delivered standard WT tax codes and type that will ease in 1099 reporting.
Important OSS note in this are 363650 and 649417.
If this is usefull,please assign points.
Thanks,
Rau
Hello Laurie:
Were you able to print 1099 forms for Vendor mailout with RFIDYYWT? We are trying to use this program to print 1099 form for vendors, but i keep getting no selections made. However, I can generate report with RSUK0030 - older program even though we are on ECC 6.0. Any ideas?
If you are filing electronically be aware that the payee street addresses are being concatentated together without spaces (e.g. 54MAPLEST instead of 54 MAPLE ST). I beleive this is flaw in the DMEE format for 1099 (only options (atom handling per SAP terminology) are concatenate (w/o spaces) or fixed position assembly). The format also does not remove the special characters such as commas and periods in the various address strings. The IRS Pub 1220 states that these should be removed. I maintained DMEE format IDWTFILE_US_1099 and changed the conversion routines for these fields to CLU RM from CLU so that it would remove the special characters automatically.
Another problem I found was when you try to create a electronic file for multiple cocodes that share a single filing TIN. RFIDYYWT will produce a non-IRS compliant file. Instead of combining the records by filing TIN it creates another T and F record envelope and appends it to the bottom the file. IRS will reject any files with multiple T and F records.
I am trying to confirm with IRS that we can file multiple original files for the same TIN (i.e. run RFIDYYWT once per company code even though they share the same TIN).
Add a comment