When importing Receive Payments, Transaction Pro Importer failed to find a matching Invoice in QuickBooks Desktop (QBDT) file even though the record does exist.
Error message "Could Not Find Matching Invoice to Apply Payment" displays on the Transaction Log.
First, make sure the Invoice is still in an Open status in QBDT as well as the remaining balance is equal or more the payment amount being imported.
If the above has been verified, please be aware that there is a bug in the QuickBooks Software Development Kit (QBSDK) in relation to these type of transactions. If the Invoice Reference Number exceeds the limits of an integer data type (2147483647), then Importer will be unable to import the transaction. Basically, QBDT will not return query results on any number that exceeds the limits of an integer (2147483647).
Three options exist: