PayPal Pro Reference Payments - update token
Problem: Paypal Pro reference payments does not update client token (tblclients.gatewayid) to most recent transaction token (invoice.transactionid), and fails after 365 days (the maximum length paypal will allow a token to be used).
Expected result: Each time a transaction is made, client token (tblclients.gatewayid) should be updated to most recent token (invoice.transactionid).
Actual result:(tblclients.gatewayid) is only set on the original transaction and used for all future transactions, until the token expires after 365 days and all future transactions are declined.
This solution was recommend to me by Paypal staff and tested in production by manually updating (tblclients.gatewayid) with the most recent (invoice.transactionid).
This will enable expected functionality of PayPal Pro Reference Payments - which is to do indefinite recurring billing.