Single Sale Order Listing

Richard, it sounds as though what you may be seeing is that orders from web modes of sale are not appearing on the Single Sales Order Listing report.  If this is the case, it may be that the Web API Servername does not exist in the TX_MACHINE_LOCATION and TX_MACHINE_LOCATION_HIST tables.  Here’s a link to a Knowledgebase article on this topic: http://www.tessituranetwork.com/network/Learning/Tessitura%20Knowledgebase/Reports/Standard%20Tessitura%20Report%20Issue/16127.aspx

Hope this helps but if not, please submit a TASK ticket so we can investigate with you.

Bob

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.

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 

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!

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!

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!

Richard, it sounds as though what you may be seeing is that orders from web modes of sale are not appearing on the Single Sales Order Listing report.  If this is the case, it may be that the Web API Servername does not exist in the TX_MACHINE_LOCATION and TX_MACHINE_LOCATION_HIST tables.  Here’s a link to a Knowledgebase article on this topic: http://www.tessituranetwork.com/network/Learning/Tessitura%20Knowledgebase/Reports/Standard%20Tessitura%20Report%20Issue/16127.aspx

Hope this helps but if not, please submit a TASK ticket so we can investigate with you.

Bob

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.

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 

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!

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!

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!