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!
You'll probably have better luck asking this over on the tech forum rather than the next gen one...
Good luck, and don't ruin your hat!
Heather
Thank you, Heather.
I'll re-post it over there . . . .
Bob