{"id":11104,"date":"2025-01-21T05:28:56","date_gmt":"2025-01-21T05:28:56","guid":{"rendered":"https:\/\/www.trustedhosting.in\/blog\/?p=11104"},"modified":"2025-01-21T05:28:56","modified_gmt":"2025-01-21T05:28:56","slug":"troubleshoot-paypal-invoice-not-found","status":"publish","type":"post","link":"https:\/\/www.webystrata.com\/blog\/troubleshoot-paypal-invoice-not-found\/","title":{"rendered":"Troubleshooting PayPal ‘Invoice Not Found’ error with Subscriptions starting with ‘S-‘"},"content":{"rendered":"

\"Troubleshooting<\/a><\/h1>\n

Troubleshooting PayPal ‘Invoice Not Found’ error with Subscriptions starting with ‘S-‘<\/h1>\n
\n

Introduction<\/h2>\n<\/div>\n
\n
\n

At the time of this writing (15 November, 2018), we have become aware of a change to legacy-styled PayPal Subscriptions (IDs starting with ‘S-‘) that impacts the method by which subscription payments are associated with unpaid invoices. This may result in some PayPal subscription payments not being applied to invoices.<\/p>\n

The WHMCS Development Team is introducing an automated migration path in the upcoming 7.7 release. PayPal have set a 2 month window for migration, but we have raised the possibility of extending this.<\/p>\n

To resolve this matter, we will need to identify the New Subscription ID Paypal is sending and update the affected Service’s Subscription ID to use the value PayPal is now providing.<\/strong><\/p>\n<\/div>\n<\/div>\n

\n

Cause<\/h2>\n
\n
\n

At the end of October 2018, PayPal made an undocumented and unannounced change to the format of IPN data. This is the notification sent from PayPal to your WHMCS installation notifying it when a payment is received.<\/p>\n

This change converts old ‘S-‘ formatted subscription IDs to the new ‘I-‘ style. During this transition, PayPal has begun supplying both the old and new subscription values, but has replaced the value WHMCS utilizes with the new value.<\/p>\n

As a result, when WHMCS receives an IPN for a payment, and attempts to look up the service using the subscription_id value, it does not match the stored value.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n

Troubleshooting<\/h2>\n<\/div>\n
\n
\n

Firstly, we need to review the Gateway Log to obtain the\u00a0old_subscr_id<\/em>\u00a0value. This is the value that WHMCS is aware of in a Product\/Service and is what we will need to replace later on.<\/p>\n

To open the Gateway Log, navigate to\u00a0Billing >> Gateway Log<\/strong>\u00a0as shown below.<\/p>\n

\"\"<\/p>\n

From here we need to look at the logs to identify affected payments. An example of an entry is shown below:<\/p>\n

\"\"<\/p>\n

If we scroll down in the Debug Data box, we can see that an\u00a0old_subscr_id<\/em>\u00a0is provided, in addition to the expected\u00a0subscr_id<\/em>. In this case, you can see the\u00a0old_subscr_id<\/em>\u00a0does start with an\u00a0S-<\/strong>\u00a0and this is the cause of our issue.<\/p>\n

\"\"<\/p>\n

\n

Resolution<\/h2>\n<\/div>\n
\n
\n

To resolve this issue, we will need to locate the customer’s specific product that is affected. The simplest way to do this is to use our Intelligent Search to look for a “known variable”. In this case, we will search for the customer’s name which is referenced in the Debug Data.<\/p>\n

\"\"<\/p>\n

Once the customer is opened, we can navigate to the\u00a0Products\/Services<\/strong>\u00a0tab to locate the affected item. We are looking for the\u00a0Subscription ID<\/strong>\u00a0field that matches the\u00a0old_subscr_id<\/em>\u00a0value located in the Debug Data we found earlier.<\/p>\n

\"\"<\/p>\n

Once this is located, we simply need to “swap” out that value for the new\u00a0subscr_id<\/em>\u00a0that starts with an\u00a0I-<\/strong>\u00a0as shown below. Once swapped out, simply click\u00a0Save Changes<\/strong>\u00a0and you are all set going forward!<\/p>\n

\"\"<\/p>\n

\n

Important Notes<\/h2>\n<\/div>\n
\n
\n

You may need to manually apply the invoice payment to the outstanding invoice. You will want to check if the customer has any outstanding Credit Balance. If WHMCS was able to match the transaction to the customer, an account credit will be applied. If WHMCS was not able to match the customer, the payment is not applied at all and will need to be manually applied. Please see our documentation referenced below on how to perform these tasks:<\/p>\n

How to Manually Apply a Payment to an Invoice<\/p>\n

Handling Credits in WHMCS<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Troubleshooting PayPal ‘Invoice Not Found’ error with Subscriptions starting with ‘S-‘ Introduction At the time of this writing (15 November,…<\/p>\n","protected":false},"author":1,"featured_media":11005,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-11104","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-whmcs"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=11104"}],"version-history":[{"count":2,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11104\/revisions"}],"predecessor-version":[{"id":11112,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/11104\/revisions\/11112"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/11005"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=11104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=11104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=11104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}