S_P00_ Create 1099-Misc w/h Tax Report-Forms and Test IRS File

(1)

Purpose

Use this procedure to create a 1099-MISC report, a print spool of 1099-MISC forms and an electronic file that can be submitted to the IRS.

Trigger

Perform this procedure when a 1099-MISC report is required for review, to generate the 1099-MISC forms, or to generate the electronic file to be submitted to the IRS.

Prerequisites

Payments with 1099 withholding tax information exist.

Menu Path

Use the following menu path to begin this transaction:

N/A

Transaction Code

S_P00_07000134

Helpful Hints

 R/O/C column in tables represents Required, Optional, or Conditional entry

 For 2009 tax reporting use variants 1099MISCFE2009 (1099 Miscellaneous 2009),

1099GG12009 (1099 G 2009), 1099INT2009 (1099INT II IT 2009) to generate reports, print spools for the 1099 forms, and the electronic files

o The three variants are set up with the Test File checked in the Country Specific Selections. A Test File can be submitted to the IRS for validation prior to submitting the final version. This field should be unchecked before generating the final

electronic file

o The variants are currently configured to use SAP smart forms

o The fourth variant 1099SFS2009 (1009S FS 2009 Data) will generate a report with any payment using withholding tax type FS and withholding tax code 03

(2)

Procedure

1.

Start the transaction using the menu path or transaction code. The Generic Withholding Tax

Reporting screen displays.

Generic Withholding Tax Reporting

(3)

Find Variant

3.

_{Click Created by field} _.

4.

Press "Delete" key to remove the name in the Created by field.

5.

_{Click Execute} _.

ABAP: Variant Directory of Program RFIDYYWT

(4)

Use Variant 1099MICFE2009; 1099GG12009; 1099INT2009 or 1099FS2009

7.

_{Click Choose} _.

8.

Use the scroll bar to scroll down to the Files section .

9.

_{Scroll up to locate the General Selections section button} _.

(5)

10.

_{Click General Selections} _{. The Country specific selection}

button displays.

11.

_{Click Country specific selection} _{. The Additional selection}

for US dialog box displays.

Additional selection for US

12.

_{Click Continue} _.

Confirm the Country Specific settings. If the settings are incorrect, contact the EBS support team.

(6)

13.

Scroll up to locate the Extended Withholding Tax Code field .

(7)

Multiple Selection for Extended WH Tax Code

15.

_{Scroll down to ensure all withholding codes are represented} _.

16.

_{Click Copy} _.

(8)

(9)

Additional selection for US

(10)

Print:

19.

_{Click Print} _.

The system displays the message, "Form IDWTCERT_US_1099MISC generated".

After clicking "Print" contact the EBS Support team. The print spool must be converted to a pdf and then stored where P&D can access it for printing.

(11)

20.

_{Scroll down to the FI Document Line Item section} _.

21.

Click List from the main menu . A drop-down list displays.

The screen report can be exported to Excel for review.

(12)

(13)

Save list in file...

24.

_{Click Spreadsheet radio button} _.

25.

_{Click Continue} _.

26.

_{Click Generate} _.

The "Directory" field displays where the report is saved to your local drive. Change this destination, if necessary.

(14)

27.

_{Click Back} _.

28.

_{Click Back} _.

(15)

Result

You have created a 1099 report that can be exported as a spreadsheet, created a print spool for 1099 forms, and created an 1099 electronic test file