View accounts payable invoices paid to vendors that requested 1099 forms - Report 1099 [RP1099]

View accounts payable invoices paid to vendors that requested 1099 forms

Use the Report 1099 page to generate report of all AP invoices which have been paid in a given time period for Vendors flagged as ‘Send 1099’. This can be used to compute totals to be filled out on 1099 forms. Suggested usage would be to run this report to an Excel spreadsheet with ‘Output’ option being set to file. The spreadsheet can then be analyzed, deleting any items that should not be included on the 1099 form.

By default, generic filters are available to generate this report. You can use Advanced Filters to customize or expand your filter criteria. This report does not include Advanced Filters feature.

To generate ‘Report 1099’ report

1. Open the Report 1099 (RP1099) page.

   • Select Financial Management > Financial Reports > Accounts Payable > Report 1099.

   Or

   • Search for RP1099 or Item Master in the Navigation box and then select Report 1099.

   The Report 1099 (RP1099) page appears.

2. From the Selection box, select the information you want to view.

3. In the Sort Order area, select how to sort the report. The Sort Order field is populated based on the type of report selected in the Selection field.

4. In the Layout area, select the layout in which you want to view the report.

The Layout field is populated based on the type of report selected in the Selection field.

5. Select the Summary check box to obtain a high level data report.

6. In the Date Range area, type/select the date range for the report to be generated. You can select the date in the From and To fields only if the Custom option is selected in the Fill Dates area.

The Date On field is populated based on the type of report selected in the Selection field.

To include the entire time frame, leave the date fields blank.

In the Fill Dates list, you can select from the predefined date ranges. They are:

• Custom: Select this option to enable the From and To fields in the Date Range area.

• Calendar Year: Select this option to display the Calendar Year list. You can select any of the predefined calendar year formats from the list.

• GL Periods: Select this option to display the GL Periods list. You can select any of the predefined GL period formats from the list.

7. In the Sort Range area, you can sort the information. The Sort On field is populated based on the type of report selected in the Selec- tion field.

The available sort ranges are:

• Single: Select this option to include only one item. Selecting this option enables the From field. Do one of the following:

  • Type the item reference in the From field.

  • Click the lookup reference and select the sort item from the Lookup for From. Highlight the required sort item and click Select.

• Range: Select this option to include a range of items to sort from. Selecting this option enables the From and To fields. Do one of the following:

  • Type the first and last values of the range in the From and To fields.

  • Click the lookup reference (if available) and select the sort item from the Lookup. Highlight the required sort item and click Select.

• All: Select this to include all available items.

8. Click Run Report on the Toolbar to generate the report. Select Open now to open the report in a new tab or select Notify when Com- plete to get notification. You can open the downloaded report from My Reports page.