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 the Master file and click OK.
3. Select the 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

• Fully paid invoice appears on the Open Invoice Register (different Discount amounts)
• 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)
• Fully paid invoice shows an open retainage and a negative net balance in Accounts Payable

Payment and selection issues

• Fully paid invoice appears open on tasks and reports due to incorrect status
• Fully paid invoice showing in Select Invoices to Pay for $0.00 (blank distribution)
• Paid Accounts Payable invoice appears Open (status or $0.00 distribution)
• Invoice appears on the Invoices Selected for Payment report for 0.00 amount, but not in Select Invoices for Payment task
• Invoice missing from 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)
• Paid Accounts Payable invoice appears open in a task or report
• Paid Accounts Payable invoice shows as open but the payment cleared the bank

Voided Payments

• Accounts Payable still shows an invoice after voiding it without restoring
• Fully paid invoice showing as open after voiding duplicate check

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?