Address Book Category Code 01/07

The codes in UDC table 01/07 (1099 Reporting Code) identify the different types of 1099 forms and specify the box on the form that corresponds to each type. This category code, which is stored in the address book record of the supplier in the Address Book Master table (F0101), is the only category code that is written to the Accounts Payable Ledger table (F0411).

If you use Address Book category code 07 for 1099 processing, you must set values in UDC table 01/07. When you set the values, consider these guidelines:

  • For consistency, set up the same values for UDC table 01/07 that are in UDC table 04/TR (Type of Return - 1099s).

    Set up only those values that you will use, and associate the values directly with the form and box numbers of the 1099 forms that you plan to produce, such as A1 (IRS form 1099-MISC, Box 1), 61 (IRS form 1099-DIV, Box 1), or B1 (IRS form 1099-NEC, Box 1). This association will ensure that the values in UDC table 01/07 are consistent with those in UDC table 04/TR.

  • Set up a category code 07 value of EX (exempt) if a part of the supplier payments, such as freight, is exempt from 1099 reporting.

    When you enter a voucher for a supplier that is eligible for 1099 reporting to override the category code 07 value for any pay item that is exempt from 1099 reporting, use EX.