Hi!
I was wondering if anyone had a report they were willing to share to track billing schedules and invoice billing schedules? I'm trying to:
- check whether unpaid orders or invoices have or don't have a scheduled payment
- check if it is scheduled correctly
- check if the correct billing option was selected
- checks if a credit card is attached
Currently, we just use the Invoice Detail report and manually check each order, or use a custom report that checks for some of the above. I'm hoping to automate this a little bit.
Thanks in advance!
Karen Diche
Manager, Season Tickets
Segerstrom Center For the Arts
I have an invoice I drafted with our SQL guy for Education. The script relies heavily on custom data in our Ticketing Setup though, but if you strip that away you'll be left with invoice info
http://www.tessituranetwork.com/Community/members/sarahparker6350/files/TW+Education+Invoice/default.aspx
Thanks for sharing Sarah! I'll have our SQL person take a look at this and hopefully we can adjust it to suit our needs.