Announcement

Collapse
No announcement yet.

Voided transactions showing everything twice in Connect report

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Voided transactions showing everything twice in Connect report

    We have a custom report in Connect that we use for reconciling each month, and this month I noticed something changed and wonder if I can update the report to account for this.

    There were a few transactions that were credited last month, and in the report, all the line items of the transaction are listed 2 times. This doesn't make sense. Is there a field/column I should remove from the report to prevent that? (The two order numbers functioning this way are 27814-210105130349089 and 27814-210105111746246.)

    Thanks!

  • #2
    Hi jillifoss, You didn't mention which report you were referring to, but yes, if you add any of the Item fields, you will see multiple lines for each transaction on your report.

    On the Monthly Transaction Report 2, you would need to remove:
    • Item
    • SKU
    • Quantity
    • Unit Price
    • Unit Tax
    • Unit Discount
    and I would suggest removing Convenience Fee as well, as convenience fee is mostly a deprecated - I think the only transactions that would still show a convenience fee would be from the legacy platform.


    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
      Oh I'm used to seeing multiple line items, but they are listed twice for the voided transactions. For example:
      Click image for larger version

Name:	Screen Shot 2021-02-12 at 11.34.56 AM.png
Views:	27
Size:	39.0 KB
ID:	57329

      That is all for one transaction, but everything is listed twice. In the past, there would have been 5 rows for this transaction, but for this one there are 10 rows, including the transaction amount being listed twice. Does that make sense?

      Comment


      • #4
        From the bank's point of view, there are two transactions - one when the transaction was authorized, and the second when the transaction was voided.
        The per transaction fee is charged both for the authorization and for the credit. But when the original transaction is credited, the values for the original transaction are updated to reflect that - so it's hard to distinguish which are from the original transaction and which are from the credit.

        You will be able to see the difference in the settlement fields, particularly Fund Date. I added Fund Date to the report - and you can see which transaction values are from the initial charge, and which are from the refund. You could add Refund Date to the report, but the refund date is populated for both, so it is not particularly helpful as it does not consolidate your rows.

        Click image for larger version  Name:	2021-02-11_FRM 27814.jpg Views:	0 Size:	191.2 KB ID:	57373


        Make sense?
        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
          Yes, thank you!

          Comment

          Working...
          X