1099 Report Questions

This table lists frequently asked questions about reports for 1099 processing and their answers:

Question

Answer

How can I suppress printing of the country code on the W-9 Exception Report (R01301)?

Access the Country Constants Revisions program (P0070), locate the country that you want, and clear the option for Print Country Code.

When I run the W-9 Exception Report, I get a list of invalid address numbers. These numbers exist in both the Address Book Master (F0101) and Supplier Master (F0401) tables. Why do I get invalid address numbers?

The person/corporation code for the supplier contains the value C (corporation). Change the code to P (individual) or N (non-corporate entity) for suppliers.

Why is the company tax ID missing on the W-9 Exception Report?

The company was not set up as an address book record or the company tax ID for the address book record was omitted. Make sure that the company has an address book record with a company tax ID.

Why is the wrong value printing in the Company Tax ID field on the W-9 Exception Report?

This error normally occurs when the address book number for a company does not equal the company number, and it is not cross-referenced in the Company Constants table (F0010).

To correct this problem, perform one of these tasks:

  • Enter the correct tax ID in the address book record for the company. Depending on where you are in the 1099 process, you might need to rebuild the worktable. (Remember to clear it first if you use the A/P Ledger method.) If you clear the 1099 A/P Worktable (F045143), you will lose all adjustments that you entered by using the Enter A/P Workfile Adjustment program (P04510FP).

  • Manually correct the record by clearing the Company Tax ID field in the Enter A/P Workfile Adjustment program. When the Company Tax ID field is blank, the system updates the field with the default value from the address book record.

When I run the 1099 A/P Register (R04512FA) and 1099 A/P - G/L Combined Register (R04512FB), additional entries exist. Why?

If you use the A/P Ledger method, you probably have data in the F045143 table from the previous year, or you entered test data this year. You must first clear the F045143 table by using the Clear A/P Workfile program (R04CLRFP). Rerun the Build A/P Workfile program (R04514FP). Then, enter any adjustments again that you entered previously by using the Enter A/P Workfile Adjustments program.

If you used the G/L method last year but are using the A/P Ledger method this year, you will have records in the 1099 G/L Worktable (F045141) from last year. To remove those records, run the Clear G/L Workfile program (R04CLRGL). Then, rerun the 1099 A/P - G/L Combined Register.