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
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