Report for ticket order billing?

Thanks so much Jared, this is perfect!

>>> "Jared Mollenkopf" 4/2/2014 11:59 AM >>>

Hello,
If you are just looking for constituent accounts I would try List Manager. You would need to write a manual query and it would look something like this:
Select Distinct a.customer_no



From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)




JOIN T_ORDER b (Nolock) on a.customer_no = b.customer_no



JOIN T_ORDER_SCHEDULE c (Nolock) on b.order_no = c.order_no
where

IsNull

(a.inactive, 1) = 1

and


c.due_dt = '4/1/2014'
If you need to limit the results by billing type you can add that condition to the Where clause.
If you need to respect control groups or only find payment schedules for certain packages or performances you will need to expand your search to include the system tables which include the product information.
Jared

From: Amy Aldrich
Sent: 4/1/2014 9:57:09 AM

Hello,
Just wondering if there is a way to find out if there are any constituent accounts that have a certain date set up in their billing schedule?

Thanks



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

Thanks so much Jared, this is perfect!

>>> "Jared Mollenkopf" 4/2/2014 11:59 AM >>>

Hello,
If you are just looking for constituent accounts I would try List Manager. You would need to write a manual query and it would look something like this:
Select Distinct a.customer_no



From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)




JOIN T_ORDER b (Nolock) on a.customer_no = b.customer_no



JOIN T_ORDER_SCHEDULE c (Nolock) on b.order_no = c.order_no
where

IsNull

(a.inactive, 1) = 1

and


c.due_dt = '4/1/2014'
If you need to limit the results by billing type you can add that condition to the Where clause.
If you need to respect control groups or only find payment schedules for certain packages or performances you will need to expand your search to include the system tables which include the product information.
Jared

From: Amy Aldrich
Sent: 4/1/2014 9:57:09 AM

Hello,
Just wondering if there is a way to find out if there are any constituent accounts that have a certain date set up in their billing schedule?

Thanks



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!