Today, I learned for the first time that there is a limit to the number of EFT Check invoices that can be included in a single EFT file that gets uploaded to our bank. Not until our February bank reconciliation did we discover that 6 invoices were left out of our 2/28/2024 EFT file. To confound matters, all six invoices were marked as paid. Unless you actually open the cryptic text of the EFT file itself, you would never know.
I contacted support and was told that 11 invoices is the limit for NXT. In database view, the limit is much higher, so it is really an issue exclusive to NXT. Support indicated that if you try to process more than 11 invoices in a single EFT file, you run the risk of the file not generating at all or that some invoices will be excluded from your EFT file, all while the invoices still get marked paid, and no error message or alert is shown to the user. They recommended that I create an idea in the Idea Bank to increase this limitation.
If this is an idea that would benefit you, I encourage you to please vote for:
"Currently, in Financial Edge NXT, a run of EFT Checks is limited to 11 invoices. If you try to pay more than that at a single time, there is a very high risk that your invoices will be marked paid but the EFT file generated for the bank doesn't include all of your invoices. This is often not discovered until bank reconciliation. Blackbaud Support Case 019656188 verified that this is a known current limit for NXT. Such a limit does not exist in database view but is present in NXT. Unfortunately, there is no error screen to alert the user that the limit has been exceeded or that his/her EFT file is incomplete. The invoices are marked paid as if everything worked fine.
Please expand the number of EFT Check invoices that can be included in each run. At the very least, an error message should alert the user that the limit has been exceeded or those invoices that were excluded should be left "unpaid" so that they could be sent in a separate EFT file."
