Hi,
Is anyone regularly using payment schedules for ticket orders, and if so how are you keeping track of which customers have a payment schedule running?
We have a music school with fees paid through TNEW. Customers can pay the full amount up front, or they can select a weekly or monthly payment schedule. Our problem is knowing when a customer has selected a payment schedule, and what the payment dates and amounts are. We need to provide this info to an outside organisation so can't give them access to the application; we need a report that shows the dates and amounts for all payment schedules (past and future) for a specified Production Season or Performance.
Any ideas?
Brian
Hi, Brian! We use it for our Education and Outreach workshops above a certain value also. I confess I've wrestled with this before and don't really have an elegant solution. The first reason for that is that payment schedules aren't tied to Production Seasons or Performances in the database - they can be applied against anything in an order. It's only TNEW that restricts whether a customer is presented with a payment schedule or not.I can tell you that dates, order numbers and amounts due are held in the table T_ORDER_SCHEDULE, and that I've usually managed to find what I need directly from SQL with a quick query here and there. I don't know if you have access to SQL, or whether there's someone at BH Live who might be able to write something for you?C.//X.
Hi Chris,
Thanks for the feedback. I've used SQL for ad hoc queries but it's a manual process to get that data into a user friendly form and email it out. I only have Read Only access to SSMS at the moment so can't creat stored procedures. It may be this is the answer.
Hi Brian,
I don't have an out-of-the-box solution for you, but this idea might like your vote and comments for your specific needs.
community.tessituranetwork.com/.../add-future-payments-to-the-analytics-finance-cube