Fully paid Accounts Payable invoice shows as open on task or report

Fully paid Accounts Payable invoices show Open in Tasks or on Reports in Sage 300 CRE.

Verify cause

Determine what is causing the invoice to appear open.

1. Go to Accounts Payable, Inquiry, Invoice Inquiries, Invoice Register.
2. Select Master file and click OK.
3. Select Register file and click OK.
4. Double-click the Vendor ID.
5. Add the following columns.
   • Status
   • Retainage
   • Retainage Held
   • Retainage Paid
   • Discount Offered
   • Discount Taken
   • Discount Lost
   • Tax
   • Tax Paid
6. Review the information and select an article below.

Possible solutions

Invoice Status

• I changed a fully paid Accounts Payable invoice and now it's showing as open.

Discounts

• A fully paid invoice appears on the Open Invoice Register (Difference in Discount Offered and Discount Lost or Discount Taken)
• AP fully paid invoice still has an Open status after recording a payment and taking a partial discount
• AP paid invoices show open, discount amounts in wrong fields

Taxes

• A paid AP invoice appears open in a task or report (Tax vs Tax Paid)
• A paid invoice appears open in Accounts Payable (0.00 distribution with unaccounted Tax Liability)

Retainage

• Fully paid invoice appearing on the Accounts Payable Invoice Aging report. (Retainage)
• A paid invoice shows an open amount in Accounts Payable (Retainage and Retainage Paid don't match)
• Invoice Aging report shows an invoice that doesn't appear in Select Invoices to Pay (Unpaid Retainage)
• A fully paid invoice shows an open retainage amount and a negative net balance on the Open Invoice report in Accounts Payable

Payment and selection issues

• A fully paid Accounts Payable invoice appears open on tasks and reports because the status wasn't updated when the invoice was paid.
• Fully paid invoice showing in Select Invoices to Pay for $0.00 (blank distribution)
• A paid Accounts Payable invoice appears open if the invoice status is Open but there's no open amount (open or $0.00 Distributions)
• An invoice appears on the Invoices Selected for Payment report for 0.00 amount but doesn't appear in the Select Invoices for Payment task
• An invoice appears in the Invoices Selected for Payment inquiry or report but doesn't show selected in the Select Invoices to Pay task
• I changed a credit invoice or distribution to 0.00 and/or deleted after we paid it in Accounts Payable
• Invoice in Select Invoices to Pay for $0.00 Fully paid distribution showing as open
• An AP invoice keeps auto selecting for payment for zero dollars and uses up a check number
• Print Checks creates 0.00 checks for fully paid invoices in Accounts Payable
• Fully paid invoice or Open invoice with distribution showing in Select Invoices to Pay for $0.00 (Include for Pmt marked on paid invoice/distribution)
• A paid Accounts Payable invoice appears open in a task or report when there's a penny difference between the amount and payments
• Why is a paid Accounts Payable invoice showing as open and the check that paid the invoice has cleared the bank?

Voided Payments

• Why does Accounts Payable still show my invoice after I voided a check and didn't restore my invoice?
• Fully paid invoice showing as open after voiding duplicate check.
• Duplicate checks printed for one invoice in Accounts Payable

Reports

• Why do paid invoices show as open or as a credit on the Period End report for AP Accounts?
• A fully paid invoice shows an open retainage amount and a negative net balance on the Open Invoice report in Accounts Payable
• Accounts Payable Invoice Aging by Property w/cut off report displaying incorrect amounts
• Invoice Aging report includes invoices entered after the aging date and excludes invoices we paid after the aging date in Accounts Payable
• Why does a paid invoice appear as open on the Open Invoices w/Cut-off Date report in Accounts Payable?