A fully paid invoice shows an open retainage amount and a negative net balance on the Open Invoice report in Accounts Payable
Description
  • A fully paid invoice shows an open retainage amount and a negative net balance on the Open Invoice report in Accounts Payable
  • AP Retainage does not equal Retainage Paid and the retainage amount needs to show as paid
Cause

The final payment or check on the invoice paid the amount as non-retainage instead of retainage.

You can verify this in Accounts Payable Inquiry, Other, AP Transactions. Drill down on the vendor and invoice. Add a column for the Dist Seq. Notice that the last check or payment transaction on the distribution is missing the Retainage amount.

You may also see the following:

Accounts Payable Inquiry, Invoice Inquiries, Invoice Register add columns for Retainage, Retainage Held, and Retainage Paid on the invoice and distribution levels. The Retainage and Retainage Held match, the Original Amount and Amount Paid match, but the Retainage Paid is less than Retainage and Retainage Held.

This can happen when selecting multiple invoices for payment (i.e. selecting all the invoices for a vendor at the Vendor level or all the invoices for a job at the Job level) and one of the first invoices in the group has no retainage. Or an invoice with multiple distributions is selected and there's a distribution with no retainage before the distributions with retainage.

Resolution

Option 1:

Note: This option will only work for invoices/distributions that are a positive amount. Invoices/distributions that are a negative amount will have to use Option 2 instead.

  1. Change the invoice and increase the Amount by the amount of the unpaid retainage at both the invoice level and on the affected distribution. Keep the Retainage amount the same as it was.
  2. Enter a new invoice as a negative amount for the unpaid retainage. Enter the unpaid retainage amount as a negative in the invoice Amount and distribution Amount and nothing in the Retainage amount. Enter the distribution to the same job information as the original invoice.
  3. Record a 0.00 payment to pay the original invoice and credit invoice together.

Option 2: Void the payment or check then re-enter the payment in TasksRecord Manual/Print Quick Checks. When recording the payment, verify on the distributions that Retainage Held is 0.00.

TIP: To avoid this problem in the future, when selecting invoices for payment where there is a mix of non-retainage and retainage to be paid, in the Select Invoices to Pay window, click the Other button and select Show Totals to verify that it shows the correct Pay Now amount under the Retainage section. If it is incorrect, mark the Retainage Invoices Only check box to select the invoices/distributions with retainage, then unmark the box to select the invoices/distributions without retainage, then use the Show Totals again to verify.



[BCB:156:Chat 300 CRE US:ECB]
Steps to duplicate
Related Solutions

How do I void an Accounts Payable check or payment?
Fully paid Accounts Payable invoice shows as open on task or report