Where is Kevin when I need him. The field Paid Today in the AP_OpenInvoice is set to Y. There is a utility to clear the field. Let me go look for it.

Beginning with Sage 100 2021, there is a utility to correct the Paid Today field for Accounts Payable Open Invoices.

Warning: This procedure clears all check data entry information and resets the Paid Today flag. Use this procedure only if restarting check payment selection from the beginning is not a problem.

1. Make sure users are out of the following AP tasks:
   • Invoice Data Entry
   • Check and Electronic Payment Maintenance
   • Manual Check and Payment Entry.
2. In the Sage 100 Launcher, click File and select Run
3. In the Program box, type *utl and click OK
4. The "A/P Open Invoice Payments Today Utility" will be highlighted. Click OK
5. Click Proceed on the warning message, "This utility verifies that the Paid Today field is set correctly in the Accounts Payable Open Invoice file. Important: Before running this utility, everyone must exit Invoice Data Entry, Check and Electronic Payment Maintenance and Manual Check and Payment Entry."
6. The program will run quickly and return you to the AP Menu
7. Verify that the invoice(s) is now available

v2021, there is a utility in the File - Run - *UTL... menu.

In older versions the process involves re-initializing some specific tables, described in a Sage KB article.  (I don't have time to hunt it down right now).

Thank You

Don't reinitialize any files for this problem.  Use the A/P Open Invoice Payments Today Utility or change the Paid Today field to "N" for this record in the AP_OpenInvoice file.