Hi all,
I feel as though I'm asking a lot of questions these days, and if you know me at all, you'll know how much I REALLY dislike needing help. But nevertheless, here we are.
I am trying to report on refunds that have been processed, which seems easy enough. However, anything I try only shows orders that contain line items of returned tickets, but not transactions that occur solely in the payment window - for example, returning your On Account funds and processing a refund to your Visa card. The second layer of challenge for me is being able to determine which fiscal year these transactions belong to now that we have cancelled performances in two FYs.
Thanks to you all for being smart. I hope to be smart too when I grow up!
Be well,
Lesley
Have you tried the Performance Transaction Detail report? I use that a lot to find and report on things.....
Hi Lesley,
I've found the Finance cube in Analytics useful for this sort of thing. There are elements for ticket refund, fee refund, payment methods, etc.
Hope that helps!Sheela
Thanks Kimberly. I was not familiar with the report, but it is still not pulling the transactions without line items.
Hi Sheela,
I am spending a lot of time in Analytics, but still have not quite found the magic combination. Thanks though!
I need to be able to find the Zero Adjustment transactions like this:
I'm doing that exact thing in Analytics using the Finance cube. My widget filters are Payment Method - just the On Account method selected; and Transaction Type - just Zero Adjustment selected. I'm using a pivot table visualization with Payment Method as my rows, Total Transaction Amount as my value, and Transaction Type as my columns.
This shows me how much money has been refunded from On Account funds.
Feel free to email me at ssur@Publictheater.org if you want some screenshots or more info.
Best,
Sheela
Lesley,
I have an old custom report that I wrote called Payments by Solicitor that might work for you in this case. It does not exactly find the "zero adjustment" transactions, but it instead finds all transactions of a certain payment type when run against the parameters.
Also, it is an InfoMaker report that, while we use it often, has not been updated recently, so it would take me a bit to get it into a form that could be sent to you; probably not until next week at the earliest. (Though I should probably get it into SSRS at some point in the not too distant future myself.)
Here is a screenshot of the report output (with parameters), to see if it would even be worthwhile for you.
John
I've run into the same problem for refunding after applying $ from an on account payment method. If you know the GL's used for refunds, you can use Transactins by Posting report and filter by Transaction Type (Zero Adjustment, Ticket Refund and Fee Refund) and select the specific GL's you want to look at. You can also specify the FY you want as well.
Thank you all for your help. The magic words were "Zero Adjustments" for transaction types. You've all been a great help!