Understanding the A/B Rpt w/Tax ID Prsn/Corp Code Report

You use the A/B Rpt w/Tax ID Prsn/Corp Code report (R014032A) to verify the completeness and accuracy of your TINs. This report lists suppliers and their TINs, which are listed on the address book record of the supplier. With specific data selection and data sequencing, you can also use this report to locate duplicate or blank TINs. The information that prints on this report is more comprehensive than the information on the W-9 Exception report (R01301).

Run the A/B Rpt w/Tax ID Prsn/Corp Code report early in your preparations for 1099 processing to give you have time to contact suppliers to obtain a valid TIN. After you run the report and make any necessary corrections, continue to run the report and make corrections until the report shows no blank TINs and no duplicate TINs.

On this report, the values in column P designate the person/corporation code.

The following table lists the existing versions of this report that you can run to validate various information for your suppliers:

Version

Title

Setup

Use

XJDE0001

A/B Rpt w/Tax ID, Prsn/Crp Code

Data selection for person/corporation code of N and P.

Locate all address book records with person/corporation codes of N or P.

XJDE0002

A/B Rpt w/Tax ID (Indi and Non-Corp Entity)

Data selection for:

  • Person/corporation code of N and P

  • Search type of V and C

  • Tax ID not equal to Blank

Identify 1099 suppliers that might also be customers that have a tax ID.

XJDE0003

A/B Rpt w/Tax ID (Filtered by Foreign Payables)

Data selection for Payables Type of F

Locate foreign suppliers.

XJDE0004

A/B Rpt w/Tax ID (Legal Name & Non-Corp Entity)

Data selection for:

  • Person/corporation code of N

  • Type Code of T

Locate suppliers that are noncorporate entities and have a legal name set up in the Who's Who table.

XJDE0005

1099 Duplicate Tax ID

Duplicate Tax IDs processing option activated.

Data selection for person/corporation code of N and P.

Identify 1099 suppliers with duplicate tax IDs.