• Replies 2 replies
  • Subscribers 961 subscribers
  • Views 82 views
  • Users 0 members are here
Related

Orders with multiple/split payments

Anna Simmons
$organization

Hello hive mind!

The rock stars in our our patron services team have discovered that, due to our refund process being a bit complicated, any orders that were originally paid off with split payments/multiple payment methods should really be handled by a manager when it comes to processing the refund. So I would like to help them out by pulling a list of all order numbers that contain multiple payments with trn_type 32 (ticket purchase), but I'm having trouble with the SQL script. I wonder if anyone has already written this script, or is there a report I'm not thinking of that could help me find this data? 

  • $organization

    Hi Anna,

    A quick way to get at these Order IDs in Analytics would be with something like this...

    • New Dashboard in Finance cube
    • Dashboard filters
      • Season or Season Fiscal Year
      • Transaction Type = Ticket Purchase
      • Payment Method <> (none) - not sure if you also need to filter out (Change) types
    • Add a Pivot widget with
      • Order ID on Rows
      • Unique Count of Payment Method ID as the Value, and filtered for > 1

    Apply that and download the widget to CSV or Excel to provide to the patron services manager.

    Best,
    Chris

  • $organization in reply to Chris Wallingford

    Thanks so much, Chris! I was able to make progress with SQL this morning as well but wasn't certain how accurate it was so this was a great way to proof it.

    I did have better luck using Count Unique Transaction ID rather than Payment Method ID....I assume that is because a patron might use the same payment method for their multiple payments? I also didn't have luck filtering that count unique formula for >1 but was able to easily sort and remove 1's when I downloaded it to CSV. 

    Thanks again!