Invoice Receivables - Upcoming Due Dates

I would love to have this as well.

We kept our invoice procedure simple in that all our scheduled payment are run on the 15^th of the month. I track the final payment through lists/extractions with a criteria of Final Payment Date which is in the Custom Data tab of the order. There’s a lot of room for error though: if the invoice is paid in full prior to the Final Payment Date and the Custom Data field isn’t updated, etc.

Please update your records to include my new e-mail address: KDiche@SCFTA.org

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

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!