For future info - the AP_PaymentTransactionHistory file is based on how many months/days (depends on version and license) of history you choose to keep in your AP Setup Menu/AP Options.  999 days was the previous limit, before that changed in the most recent versions.  The AP_CheckHistory files are FOREVER unless you manually purge them.

For future info - the AP_PaymentTransactionHistory file is based on how many months/days (depends on version and license) of history you choose to keep in your AP Setup Menu/AP Options.  999 days was the previous limit, before that changed in the most recent versions.  The AP_CheckHistory files are FOREVER unless you manually purge them.

Yes in one location in AP Options it lists to keep invoices for 999 days and then in the history tab it says 20 years. Rather confusing.

The 999 days is for the tables (OpenInvoice + TransactionPaymentHistory) used to track balance owed (which doesn't really matter after balance = 0, other than running a back-dated Aging report), and is not intended to be used as transaction history.

Thanks. We are trying to export data and although this does not appear to be the best practice this is how they are handling the older data. Its too bad there was not an easy way to extract all data between two dates for all modules.