(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
Hi Bob,
The details of the billing schedule are in T_ORDER_SCHEDULE.
The due dates and the amounts due are all there. The order_no field in this table is populated with either the order number or the invoice number depending on whether the billing scheduled is associated to either a ticket order or an invoice.
Jared