• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 124 views
  • Users 0 members are here
Related

Refund Date in T_PAYMENT / Payment Details for Refunds report

Frances O'Connell
$organization

Hi everyone,

An industrious colleague of mine in the Finance department stumbled across the report Payment Details for Refunds and came to me with hopes it would help her keep track of credit card refunds processed in the Box Office.

In looking into the report, I discovered it has never been used for it's intended purposes of adding a refund date to T_PAYMENT.  Every single refund_dt field is  NULL in our environment.  The report seems somewhat circular- run it to add a refund date, and then run it to view the refunds.. you just created?

So a couple of questions:

- Do any of your orgs use this report, whether to update Refund Date, or to track credits in other ways?

- Can anyone confirm that this is the only method of adding or updating a refund_dt to T_PAYMENT as of 12.1 / 12.5? (We are in 12.1 now but plan to upgrade in the next month.)

- I see in system documentation that there is a Refund Prior Payments button added to the Payments window in 12.5.  By any chance does using this make changes to refund_dt in T_PAYMENT?

Thanks,

Frannie

Parents
  • $organization

    Hi Frances,

    This report utility can be used to track pending and fulfilled refunds. For example, let's say that a school group has reserved a large number of tickets for a total of $1,000. When they arrive, they have fewer people than they originally reserved for, so the adjusted order is only due $800, but they have a check for $1,000 which cannot be changed. So rather than give them a $200 cash refund, the Box Office accepts the check with a $1,000 payment to a Check payment method, and then refunds the excess $200 to a payment method like "Check Refund Request." 

    Then the next week, the Finance department runs the Payment Details for Refunds report in Preview mode and sees a pending refund. So they run the report again in Update mode, and then use the report details (constituent name, address, etc.) to cut the school a refund check outside of Tessitura. It doesn't actually process money, as you've discovered, it only updates the Refund Date column.

    Hope that helps,

    Michael Wilcox, Tessitura Network

Reply
  • $organization

    Hi Frances,

    This report utility can be used to track pending and fulfilled refunds. For example, let's say that a school group has reserved a large number of tickets for a total of $1,000. When they arrive, they have fewer people than they originally reserved for, so the adjusted order is only due $800, but they have a check for $1,000 which cannot be changed. So rather than give them a $200 cash refund, the Box Office accepts the check with a $1,000 payment to a Check payment method, and then refunds the excess $200 to a payment method like "Check Refund Request." 

    Then the next week, the Finance department runs the Payment Details for Refunds report in Preview mode and sees a pending refund. So they run the report again in Update mode, and then use the report details (constituent name, address, etc.) to cut the school a refund check outside of Tessitura. It doesn't actually process money, as you've discovered, it only updates the Refund Date column.

    Hope that helps,

    Michael Wilcox, Tessitura Network

Children
No Data