• Replies 4 replies
  • Subscribers 415 subscribers
  • Views 26 views
  • Users 0 members are here
Related

Single Sale Order Listing

Lea Ann Reed
$organization

Hey all -

I am trying to run the single sale order listing to show me unseated orders.  However, when I run the report for the performance date that shows unseated orders in the season manager it comes up with none.  I have set the order dates to include all possible orders for that date.  Any suggestions on how I can find out what account has the unseated order for the performance?

Lea Ann Reed
Manager of Sales
Kansas City Repertory Theater

Parents
  • $organization
    The following procedure works well, and the only variable is the performance number from Ticketing Setup
     
     

    use impresario

    go

    declare @perf_no int

    select @perf_no = #### -- insert performance number with balance here

    select o.customer_no, s.order_no, unseated_cnt = IsNull(count(*), 0),

    unseated_amt = IsNull(sum(case

    when p.price_category = 1 then b.paid_amt else 0 end), 0),

    unseated_amt_contribution = IsNull(sum(case

    when p.price_category > 1 then b.paid_amt else 0 end), 0)

    From [dbo].t_perf a (nolock)

    JOIN [dbo].t_sub_lineitem s (nolock) ON a.perf_no = s.perf_no

    JOIN [dbo].t_lineitem l (nolock) ON s.li_seq_no = l.li_seq_no

    JOIN [dbo].t_sli_detail b (nolock) ON s.sli_no = b.sli_no

    JOIN [dbo].t_pmap p (nolock) ON b.pmap_no = p.pmap_no

    JOIN [dbo].tr_price_type r ON s.price_type = r.id

    JOIN [dbo].t_order o on s.order_no = o.order_no

    Where a.perf_no = @perf_no

    and l.primary_ind = 'Y'

    and s.sli_status in (1,2,6)

    and b.paid_amt > 0

    group by o.customer_no, s.order_no

     
    Lee Schlosser
    IT/Business Manager
    Florida Studio Theatre, Inc.
    1241 North Palm Avenue
    Sarasota, FL  34236
    Phone: 941-366-9017 ext 328
    Fax: 941-955-4137
     

    Confidentiality Statement: This electronic message contains information from Florida Studio Theatre, and may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify the sender immediately by reply e-mail or telephone 941.366.9017. Please be aware that all mail sent to and from Florida Studio Theatre is subject to the public records law of Florida.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lee Ann Reed
    Sent: Monday, April 12, 2010 12:42 PM
    To: Lee Schlosser
    Subject: [Tessitura Ticketing Forum] Single Sale Order Listing

    Hey all -

    I am trying to run the single sale order listing to show me unseated orders.  However, when I run the report for the performance date that shows unseated orders in the season manager it comes up with none.  I have set the order dates to include all possible orders for that date.  Any suggestions on how I can find out what account has the unseated order for the performance?

    Lea Ann Reed
    Manager of Sales
    Kansas City Repertory Theater




    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!
Reply
  • $organization
    The following procedure works well, and the only variable is the performance number from Ticketing Setup
     
     

    use impresario

    go

    declare @perf_no int

    select @perf_no = #### -- insert performance number with balance here

    select o.customer_no, s.order_no, unseated_cnt = IsNull(count(*), 0),

    unseated_amt = IsNull(sum(case

    when p.price_category = 1 then b.paid_amt else 0 end), 0),

    unseated_amt_contribution = IsNull(sum(case

    when p.price_category > 1 then b.paid_amt else 0 end), 0)

    From [dbo].t_perf a (nolock)

    JOIN [dbo].t_sub_lineitem s (nolock) ON a.perf_no = s.perf_no

    JOIN [dbo].t_lineitem l (nolock) ON s.li_seq_no = l.li_seq_no

    JOIN [dbo].t_sli_detail b (nolock) ON s.sli_no = b.sli_no

    JOIN [dbo].t_pmap p (nolock) ON b.pmap_no = p.pmap_no

    JOIN [dbo].tr_price_type r ON s.price_type = r.id

    JOIN [dbo].t_order o on s.order_no = o.order_no

    Where a.perf_no = @perf_no

    and l.primary_ind = 'Y'

    and s.sli_status in (1,2,6)

    and b.paid_amt > 0

    group by o.customer_no, s.order_no

     
    Lee Schlosser
    IT/Business Manager
    Florida Studio Theatre, Inc.
    1241 North Palm Avenue
    Sarasota, FL  34236
    Phone: 941-366-9017 ext 328
    Fax: 941-955-4137
     

    Confidentiality Statement: This electronic message contains information from Florida Studio Theatre, and may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify the sender immediately by reply e-mail or telephone 941.366.9017. Please be aware that all mail sent to and from Florida Studio Theatre is subject to the public records law of Florida.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lee Ann Reed
    Sent: Monday, April 12, 2010 12:42 PM
    To: Lee Schlosser
    Subject: [Tessitura Ticketing Forum] Single Sale Order Listing

    Hey all -

    I am trying to run the single sale order listing to show me unseated orders.  However, when I run the report for the performance date that shows unseated orders in the season manager it comes up with none.  I have set the order dates to include all possible orders for that date.  Any suggestions on how I can find out what account has the unseated order for the performance?

    Lea Ann Reed
    Manager of Sales
    Kansas City Repertory Theater




    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!
Children
No Data