Understanding the Payments Exception Report

For you to report 1099 accurately and by using the G/L method, you must have accurate and complete payment information. You can print the Payments Exception Report (R04511) after you run these programs to update the Account Ledger table (F0911):

• Update BU.Obj.Sub to Journal Entry (R09806), if required.

• Update Payment Information - Receipts (R045131), if required.

• Update Payment Information (R04513).

The Payments Exception report selects all those entries in the F0911 table that are within the object account ranges defined by the AAIs, and identifies these issues:

• Vouchers with an invalid supplier number.

• Payments in the reporting year that have a date but no object account.

• Payments that are unresolved, such as partial payments and discounts taken.

The Payments Exception report shows amounts from both the AA (actual amounts) and TX (tax) ledgers in the F0911 table.

• If you ran the Update Payment Information program and set the processing option to update discounts as exceptions, the report shows payments or partial payments in which a discount has not been taken.

• If you did not run the Update Payment Information program, the report shows partial payments for the current reporting year.

The Payments Exception report does not include partial payments for the next reporting year because the unpaid amount of the voucher has an asterisk (*) in the Payment Number field and does not contain the current year in the Reporting Year field.

This report is a worksheet that you can use to write adjustment information as you resolve issues with payment records. Research the records that appear on the report, adjust entries as needed, and continue to run the report until it shows no unresolved payments.