Understanding Versions of the Build A/P Workfile Program

If you use the Category Code 07 field to identify vouchers for 1099 processing, and you process multiple types of 1099s, create a separate version of the Build A/P Workfile program (R04514FP) for each type of return and box on the return that you process. For each version, set up the Type of Return processing option with one of the UDC codes from 04/TR UDC that you process. Then, set up the data selection for Category Code - Address Book 07 to match the type of return that you specified in the processing option.

This table shows an example of how you set up the processing option and the data selection if you use the Category Code 07 field to identify vouchers for 1099 processing, and you have multiple types of returns and multiple boxes:

Type of Return Processing Option

Data Selection for Category Code - Address Book 07

1099 Return and Box

Type of return equals A1

Category Code 07 equals A1

1099–Misc box 1 (Rents)

Type of return equals A2

Category Code 07 equals A2

1099–Misc box 2 (Royalties)

Type of return equals 13

Category Code 07 equals 13

1099–DIV box 13 (Total Capital gain distribution)

If you use the 1099 Flag field to identify vouchers for 1099 processing, and you report information about only one type of return, you can set up one version of the R04514FP program with the Type of Return processing option set to the type of return that you process, and with data selection set to include vouchers with a 1 in the 1099 Flag field.

This table shows an example of how you would set up the processing options and the data selection if you use the 1099 Flag field and you process only 1099 returns for rents:

Type of Return Processing Option

Data Selection for Category Code - Address Book 07

1099 Return and Box

Type of return equals A1

1099 Flag equals 1

1099–MISC box 1 (Rents)

Note: Oracle recommends that each year after you apply the ESU for 1099 processing, you delete old versions of the R04514FP program and create new ones.

To ensure that you include each type of return that you process, you must run the Build A/P Workfile program multiple times (without clearing the F045143 worktable).

Note:

If you made payments to suppliers for whom you do not have tax ID numbers (TINs), you are required to have withheld a certain percentage of payments to those suppliers. The 1099 for those suppliers must reflect the amount that you withheld.

Specify 14 (DIV), 64 (INT), A4 (MISC), F4 (G)or B4 (NEC) for federal income tax withheld in the processing option for the type of return. Use data selection to include payments with backup withholding based on the tax authority. Set the payee address number equal to the address book number of the tax authority.