(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
Good to hear! You’re very welcome.
Bob
P: 503-445-3726
C: 530-401-4518
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Terry StevensSent: Friday, March 02, 2012 11:30 AMTo: Bob ThomasSubject: RE: [Tessitura Technical Forum] Invoice Receivables - Future Due Dates
Bob,
Thank you so much you saved me hours of time and it works beautifully!
From: Bob Thomas <bounce-bobthomas7245@tessituranetwork.com>Sent: 3/2/2012 12:02:42 PM
One more thing:
If you want to narrow the final results to just the invoices due within the period in question, you can use this as the second WHERE clause:
WHERE
t.payment <> 0 AND os.due_dt between @start_dt and @end_dt
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!