Announcement

Collapse
No announcement yet.

Declined Transactions show up as Authorized and then Credited

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • Declined Transactions show up as Authorized and then Credited

    Hi there,
    We are having an issue with declined transactions coming over to Salesforce as Received donations. I'm posting this in the Connect forum, due to the fact that I believe the solution would need to take place on Connect, rather than in Salesforce. That said, I'd be happy to work in Salesforce to apply a fix, if there's a way to do so.

    We worked with Patrick in Support on this during our Spring fund drive back in May and are trying to avoid this issue during our Fall fund drive at the end of this month.

    I've pasted the support response from Patrick below for additional context and will try to summarize the issue generally here.

    There is apparently a setting in Connect that prevents certain types of declined transactions from showing as "Declined". Instead, the declined transaction will initially show as "Authorized" in C&P and then very shortly after it will be flagged as "Credited". Our Salesforce integration is setup to sync Authorized transactions and the outcome of this scenario during our last fund drive was that we had numerous donations syncing to Salesforce, flagged as received and erroneously contributing to our fundraising total, that were actually "Credited" in C&P.

    My sense of the data flow in this scenario is:

    1.) Transaction is attempted in C&P
    2.) Transaction is initially set to "authorized" in C&P
    3.) The authorized transaction is synced to salesforce
    4.) A "bad zipcode" or some such response is received from financial institution
    5.) C&P transaction is changed to "credited"
    6.) That change in the transaction's state in C&P is not synced to salesforce

    We have our Salesforce sync set to flag Credited Donations from C&P as "Closed Lost" (see attached C P Settings Salesforce Enterprise Edition.png screenshot). This works great for any transactions that we manually issue credits on (see attached manual credit in C&P.png). However, this does work for "auto-credited" transactions. If we look at one of these auto-credited transaction in Salesforce we see that there isn't any indication of the change in state back in C&P. To see an example of this, I've attached two screenshots of transaction 36381-1705021420528185697. The C&P Transaction.png screenshot shows the transaction in C&P and the salesforce-c&p-transaction.PNG screenshot shows the "C&P data" related list for the transaction in Salesforce. As you can see, no mention of the transaction being credited made its way over to Salesforce.

    According to Patrick this has something to do with the zip code on the transaction not matching the zip code of the donor with their financial institution and I've pasted in his earlier response below.

    We're hoping that we can disable this auto-credit feature in C&P and flag all declined transactions as declined. Is that possible?

    Thanks!
    Kirk

    ------Earlier Support response with donor name obfuscated ----

    However, the reason for the “Credit Issue” or “VOID” you were seeing for these declined donations instead of the Decline, is a functionality that our Connect programmers have enabled to save the organization from paying the transaction fees that are associated with the declines.

    I ran a test donation through your Connect Form, replicating completely the information that <donor name> had provided in her 9 transactions she attempted to process through this form and shows credited on all 9 for $103.30 each.

    What I discovered, unintentionally, is with my 1st test transaction, I had entered the wrong payment information, specifically the incorrect billing street address and zip code. I did not enter the info matching the test credit card I was using. I found this out once I clicked the SUBMIT PAYMENT option and a message informed me that my payment did not go through and to contact my bank. I immediately checked my transaction in your Connect platform and this transaction showed as CREDITED (Voided), not declined.

    I attempted the test payment again, this time using the same billing info as on the test card and the transaction processed successfully with no issues. I then went back into your Connect and credited my successful test transaction manually.

    You will see both of my Test Transactions as “CREDITED”, although only the 2nd attempt should actually show this status. The 1st attempt should show declined with a “Decline Reason”.

    The explanation for the 9 CREDITED transactions for <donor name>, based off of my testing, is some info she had entered for her billing/card information was not matching, which gave her the message that her payment had not processed successfully, just as I received for my 1st test transaction. She tried again, with the same result and message and continued with the attempts, using 3 different credit cards during the process. This resulted in the 9 CREDITED transactions.

    RESOLUTION:
    I have reached out to my CONNECT Programmers/Developers and provided this information to research.

    It appears that the system is instantaneously Issuing a Credit, which VOIDS the payment because it’s same day, instead of processing/showing them as Declined and providing us with the Decline Reason. I believe this is to prevent the $0.35 transaction fee that a declined transaction would normally be charged. A VOIDED transaction has NO Transaction Fee. I will know for sure when I hear back from the Developers.
    Attached Files
    Last edited by kirk; 10-06-2017, 10:10 AM.

  • #2
    Good day @kirk

    Would you please share couple of order numbers of declined transactions which you think it posted as Authorized to your Salesforce instance?

    It cannot possibly happen but it might be due to the triggers and workflows you or your team has been written.

    If you please grant us login access to your Salesforce account and share the couple of order numbers so that we can investigate the issue.

    Looking forward to hearing back from you.
    Regards,
    Click & Pledge Support Department

    On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

    Join us @ the educational webinars: https://clickandpledge.com/webinars/
    Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
    Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

    Comment


    • #3
      Thanks for the response.

      The issue is not that declined transactions are syncing to Salesforce as authorized.

      The issue is that we have transactions in C&P that were flagged as "Credited" that came over to Salesforce as Authorized. Transaction Number 36381-1705021420528185697 (as referenced above along with screenshots) is an example. Please let me know if that helps clarify.

      Thanks again,
      Kirk

      Comment


      • #4
        Good day @kirk

        Would you please grant us login access to your Salesforce account (OrgID: 00D36000000onxh) so that we can review whats going on?

        Looking forward to hearing back from you.
        Regards,
        Click & Pledge Support Department

        On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

        Join us @ the educational webinars: https://clickandpledge.com/webinars/
        Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
        Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

        Comment


        • #5
          Sure thing. I've granted 1 month of access.

          As a follow-up example, the transaction record at https://cnp-paas.na30.visual.force.c...6000003pJwfEAE was manually credited using the admin interface in Connect. The transaction record at https://cnp-paas.na30.visual.force.c...6000002GqcZEAS was automatically set to credited.

          Thanks for your help!

          Comment


          • #6
            Hi there,
            I wanted to confirm you all have the necessary access to our SF instance and if so, if you've had a chance to review these 2 transaction.

            Thanks,
            Kirk

            Comment


            • #7
              Good day @kirk

              In some cases if the transaction credited on the same date or time of it processed, in the version you are at we don't handle the status for credited transaction. In the latest release, we are handling such cases. If you allow us we will upgrade your instance and will update the above record.
              Regards,
              Click & Pledge Support Department

              On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

              Join us @ the educational webinars: https://clickandpledge.com/webinars/
              Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
              Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

              Comment


              • #8
                That's great news! Yes, please if you all can proceed with the upgrade that would be a huge help!

                Comment


                • #9
                  Good day @kirk

                  We have upgraded your instance and updated the record in the question.

                  Please check and let us know if we can be of any further assistance.
                  Regards,
                  Click & Pledge Support Department

                  On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

                  Join us @ the educational webinars: https://clickandpledge.com/webinars/
                  Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
                  Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

                  Comment


                  • #10
                    Thanks! Is there any way to submit one of these auto-credited donations to test? I just made a donation using the wrong State and Zipcode for my Credit Card which I thought would trigger the error, but my donation went through.

                    Comment


                    • #11
                      Good day @kirk

                      Please note that, we NEVER auto-credit the transaction. It has to do it manually. Due to invalid billing information the Card WON"T decline. These are the following information should be correct to Authorize the transaction:

                      Name on Card
                      Card Number
                      CVV

                      Hope that answers your question. Let us know if we can be of any further assistance.
                      Regards,
                      Click & Pledge Support Department

                      On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

                      Join us @ the educational webinars: https://clickandpledge.com/webinars/
                      Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
                      Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

                      Comment


                      • #12
                        That is not true in the case of Transaction Number 36381-1705021420528185697 and many others that we received last spring. No administrator intervened to manually credit the transaction. They were credited at the same time that they were attempted, or very shortly thereafter. Can you please clarify how Transaction Number 36381-1705021420528185697 was set to "Credited" without admin intervention? Patrick in support also observed transactions to be auto-credited and his initial explanation was as follows:

                        ------
                        The explanation for the 9 CREDITED transactions for <donor name>, based off of my testing, is some info she had entered for her billing/card information was not matching, which gave her the message that her payment had not processed successfully, just as I received for my 1st test transaction. She tried again, with the same result and message and continued with the attempts, using 3 different credit cards during the process. This resulted in the 9 CREDITED transactions.
                        ------


                        Thanks,
                        Kirk

                        Comment


                        • #13
                          In case it helps with further troubleshooting, below are the Order Numbers of 30 other transactions that came in as auto-credited. These all have a payment status of credited and no admin ever issued a credit for these transactions:

                          36381-1704292302419818046
                          36381-1704292303361388046
                          36381-1704292304011708046
                          36381-1704292305428918046
                          36381-1704292340467894392
                          36381-1704292341437754392
                          36381-1704292342013814392
                          36381-1705021415420450816
                          36381-1705021416199960816
                          36381-1705021416422180816
                          36381-1705021418276520816
                          36381-1705021419074706590
                          36381-1705021419521266590
                          36381-1705021420528185697
                          36381-1705021421492015697
                          36381-1705021426557505697
                          36381-1705021608074460602
                          36381-1705021613185760602
                          36381-1705031347389150444
                          36381-1705031949067969647
                          36381-1705031949198439647
                          36381-1705031950010009647
                          36381-1705031952160779647
                          36381-1705040949433984019
                          36381-1705041303556620868
                          36381-1705041318545273012
                          36381-1705051605594512984
                          36381-1705051959474055494
                          36381-1705052004208105494
                          36381-1705052004454985494

                          Comment


                          • #14
                            Good day @kirk

                            We have investigated the issue and found that the reason for showing Authorized and immediately changing the status to Void/Credited is because of the custom Fraud profile you have assigned to the respective Campaign. Based on the custom Fraud profile settings, until bank approve the transaction it appears to be Authorized and immediately upon getting status from bank it changed to Void/Credited.

                            Click image for larger version

Name:	Fraud Profile at Campaign.jpg
Views:	63
Size:	42.8 KB
ID:	35649

                            Hope that answers your question. Please check and let us know if we can be of any further assistance.
                            Regards,
                            Click & Pledge Support Department

                            On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

                            Join us @ the educational webinars: https://clickandpledge.com/webinars/
                            Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
                            Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

                            Comment


                            • #15
                              Thanks for the clarification!

                              One follow-up on this. We created our custom fraud profile by copying the Default Fraud Profile and the only change we made to the custom profile was to white-list the IP address for our station to prevent transactions being processed there from triggering a fraud alert.

                              The AVS and CVV2 settings are identical between our custom profile and the default profile (see attached). Is there a specific setting we can change in our custom profile to prevent this auto-credit behavior, of is this behavior an inevitable outcome of using a custom profile? If the former, could you please let us know what setting to change? If the latter, would changing back to the Default Fraud profile avoid this behavior?

                              Thanks again!
                              Attached Files

                              Comment

                              Working...
                              X
                              😀
                              🥰
                              🤢
                              😎
                              😡
                              👍
                              👎