Invoice Aging report shows an invoice that does not appear in Select Invoices to Pay (Unpaid Retainage)
Description
Cause

Invoice is showing on the report because there is unpaid retainage. Retainage is equal to Retainage Held and Retainage Paid is 0.00. Retainage cannot be removed because there is an amount in the Retainage Held field. Retainage must be paid for the invoice status to change to Fully paid and not show on the report.

The invoice will not show in the select to pay because there is zero amount to pay (Amount and Amount Paid on the invoice match).

Resolution
  1. Print Preview the AP Invoice Aging report and range on the vendor to review the information on the report and get the invoice number.
  2. Use Inquiry, Invoice Inquiry, Invoice Register, select the vendor and invoice, verify the Amount and Amount paid are equal.
  3. Add columns to the inquiry for Retainage, Retainage Held, and Retainage Paid.
  4. If there are amounts in the Retainage and Retainage Held then Retainage cannot be removed and will need to be paid.

Two options to remove the invoice from the report:

Option I: Place a condition on the reports to exclude that vendor and invoice

Option II: Change the invoice

  1. If there is a job and commitment on the distribution line with the retainage that has been closed, you will need to open the job and the commitment. 
  2. In Tasks, Change Invoices, select the invoice.
  3. If the invoice is for a closed accounting period, you may need to change the date.
  4. On the distribution, increase the Amount by the amount of the retainage.
  5. Add a new distribution line, coded to the same job cost information, and enter the amount as a negative to reverse the amount of the increase. This create a net zero change on the invoice.
  6. Accept invoice. If you changed the accounting date, select the Revised date for the reversing entry.
  7. Pay the invoice with a zero (0.00) check to update the distributions and invoice to a fully paid status.
DocLink: Fully paid Accounts Payable invoice shows as open on task or report
Defect ID
Steps to duplicate
Related Articles