(Note: This was re-posted from the Next Generation Forum)
I've been asked to create a report that shows the upcoming due dates for unpaid ticket invoices. After spending most of today trying to extract that info from Tessitura, I've now come here, hat in hand. While it is fairly easy to extract invoice payment information (via queries like AP_AGED_RECEIVABLE_REPORT (aka the Invoice Detail report), as well as finding which invoices are not fully paid, extracting future Due Dates and payment amounts (which appear in Constituents->View Invoices->Invoice List->Invoice Payment Schedule) seems to be a more arcane matter. Or so it seems to me. The other possibility is that I'm just blind. Anybody here have experience doing this?
Many thanks in advance for any suggestions and help!
Bob Thomas
Jared!
AhHa - I see! It was that either/or thing in the order_no field that had me flummoxed. A JOIN on T_Order_Schedule.order_no = T_Payment.payment_no gave me what I was looking for.
Thank you so much for pointing me in the right direction. You've saved me hours of head-scratching!
Bob
Hi Bob,
Can I see the code that you wrote for this? I am trying to create a report that shows all invoice receivables that are due in a particular month.