Adjusting Records in the 1099 A/P Worktable

Access the Adjust 1099 A/P Workfile Records form.

If you have 1099 records for suppliers that should not be included in 1099 processing, you must delete the records. To delete an entire record, you must delete each line within the record. The system deletes the record for the supplier from the 1099 A/P Worktable (F045143).

2nd TIN (second tax identification number)

Select this check box if the IRS has notified you twice within the last three years that you provided them with an incorrect TIN for this supplier. When you print the 1099 form for the supplier, the box for the 2nd TIN notice is selected.

Type Return

Enter a UDC (04/TR) that indicates the type of 1099 return and box on the return.

Valid types of 1099 return codes are:

Ax: 1099-MISC

1x: 1099-DIV

6x: 1099-INT

Fx: 1099-G

Bx: 1099-NEC

To create this return code, you combine the code for the type of return with the number of the box on the form. For example, you can set up A1, where A indicates form 1099-MISC and 1 indicates box 1 (rents).

For the G/L method, the third and fourth characters of the AAI item for 1099 returns indicate the type of return and the box associated with the amount.

Amount

Enter a number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (–) either before or after the amount.

Co (company)

Enter a code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions.

Note: You must specify the company number, do not use default value 00000.

Tax ID

Enter the identification code required by various tax authorities. This value can be a Social Security Number, federal or state corporate tax ID, sales tax number, and so on. The system verifies the number and prints the separators in the correct format, according to the value of Person/Corporation Code (TAXC). If no value exists for TAXC, the system uses the Corporate Entity.

Company Tax Id

Enter the code that is used to designate the identification code required by various tax authorities. Such codes can include Social Security Number, federal or state corporate tax IDs, sales tax number, and so on.

The system supplies the values for the Tax ID and Company Tax ID fields from the Address Book Master table (F0101).