• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 45 views
  • Users 0 members are here
Related

Single Sale Order Listing

Richard Jackson (Past Member)
$organization

Our marketing dept wants to look at sales for a particular promo code, but want's constituent detail on the orders in question.  So the appeal reports don't work in this situation.  The only thing I could think of was the Single Sale Order Listing report run againt a list, however:

This only pulled 6 of the 250+ orders.  A cursory pull in SQL confirmed that we had 250+ seats sold, but only 6 showing on the report.  I looked T_LINEITEM and saw that the bulk of the orders had a LI_NO of 0 and the 6 that pulled in the report had a populated LI_NO.

What would cause the LI_NO to be set to zero - it appears to only be occuring on web orders but I'll reconfirm that.  Any ideas are helpful. 

Thanks all!

RJ

Parents
  • $organization

    Thanks Dale – so I’ll continue investigation of why they don’t appear on the Single Sale Order Order Listing report.  If this report is the only way (outside a custom SSRS) report to get customer details by source number, looks like the troubleshooting continues.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: Tuesday, November 27, 2012 3:30 PM
    To: Richard Jackson
    Subject: Re: [Tessitura Technical Forum] Single Sale Order Listing

     

    Richard,

    This is from the Tessitura Table Structures documentation:

    li_no points to the master line for this set of order lines. That is if this line is an upgrade or alternate this field points to the original line that is being upgraded. These master lines point at themselves too.

    Dale 

    From: Richard Jackson <bounce-richardjackson6492@tessituranetwork.com>
    Sent: 11/27/2012 2:28:46 PM

    Our marketing dept wants to look at sales for a particular promo code, but want's constituent detail on the orders in question.  So the appeal reports don't work in this situation.  The only thing I could think of was the Single Sale Order Listing report run againt a list, however:

    This only pulled 6 of the 250+ orders.  A cursory pull in SQL confirmed that we had 250+ seats sold, but only 6 showing on the report.  I looked T_LINEITEM and saw that the bulk of the orders had a LI_NO of 0 and the 6 that pulled in the report had a populated LI_NO.

    What would cause the LI_NO to be set to zero - it appears to only be occuring on web orders but I'll reconfirm that.  Any ideas are helpful. 

    Thanks all!

    RJ




    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!

Reply
  • $organization

    Thanks Dale – so I’ll continue investigation of why they don’t appear on the Single Sale Order Order Listing report.  If this report is the only way (outside a custom SSRS) report to get customer details by source number, looks like the troubleshooting continues.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: Tuesday, November 27, 2012 3:30 PM
    To: Richard Jackson
    Subject: Re: [Tessitura Technical Forum] Single Sale Order Listing

     

    Richard,

    This is from the Tessitura Table Structures documentation:

    li_no points to the master line for this set of order lines. That is if this line is an upgrade or alternate this field points to the original line that is being upgraded. These master lines point at themselves too.

    Dale 

    From: Richard Jackson <bounce-richardjackson6492@tessituranetwork.com>
    Sent: 11/27/2012 2:28:46 PM

    Our marketing dept wants to look at sales for a particular promo code, but want's constituent detail on the orders in question.  So the appeal reports don't work in this situation.  The only thing I could think of was the Single Sale Order Listing report run againt a list, however:

    This only pulled 6 of the 250+ orders.  A cursory pull in SQL confirmed that we had 250+ seats sold, but only 6 showing on the report.  I looked T_LINEITEM and saw that the bulk of the orders had a LI_NO of 0 and the 6 that pulled in the report had a populated LI_NO.

    What would cause the LI_NO to be set to zero - it appears to only be occuring on web orders but I'll reconfirm that.  Any ideas are helpful. 

    Thanks all!

    RJ




    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!

Children
No Data