Sales reports not matching

I guess I should settle the debate.  There is not a document that details why certain reports don’t match.   Both of these reports have documents available in the help system though, so I would read the explanations of what they do and that will probably point out the differences between the reports.  As Boann said, I suspect it has something to do with unpaid seats.  Also be sure that the parameters you select match when you are comparing two different reports (which may not always be possible if the parameters are too different).

Kevin Sheehan

Documentation & Learning Resources Specialist

Tessitura Network

1 888 643 5778 ext 329 Office

ksheehan@tessituranetwork.com

I have also had problems with these reports not matching based on donated seats (benevolent returns).  Do you allow patrons to donate their seats back to your organization and then use the “Donate for Resale” option? 

Elizabeth Carlock

Director, Ticketing Services

The Granada

Hi - I believe there is a list or a document somewhere explaining why certain sales reports don't match up - can someone either point me in the direction of this, or just let me know why the Performance Sales Analysis and the Performance Sales Summary might differ?

Thanks

Siobhan

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!

Unfortunately there is no documentation on Season Overview at this time.

Kevin Sheehan

Documentation & Learning Resources Specialist

Tessitura Network

1 888 643 5778 ext 329 Office

ksheehan@tessituranetwork.com

A few things to note about Season Overview and the Performance Summary in the Product Guide (both use the same data):

n  All of the ticket revenue amounts summarize ONLY “Ticket Price” (price category = 1) except for the “Other Income” column which totals all other price categories.

n  The EIS_IMP_CHANGED_LOAD_NEW procedure accepts a parameter @include_resold_seats, which can optionally include resold seats (‘Y’) in the totals.  By default this is set to ‘N’ (No).

n  By default, the results displayed separate sales by Fixed Packages, Non-Fixed Packages, Single Sales, and Sold at Discount.  Single Sales will include exchanges made to package sales, as they are no longer considered part of the package.

o   An Alternate view may be used in both Performance Summary and Season Overview, displaying sales by Price Type Category (Single, Sub, Discount) by changing EIS_ORIGINAL_MODE to “No” in T_DEFAULTS.  This is by default set to “Yes”.  (this can be organization specific for consortiums)

o   Note that in the Price Type Category view, price type categories > 5 will NOT be reported.

n  The EIS_IMP_CHANGED_LOAD_NEW procedure runs in two modes, Full and Incremental.  The incremental mode can be run periodically throughout the day to get more recent results.  Both modes should be run as separate scheduled jobs on the SQL Server.  The incremental mode can be run as frequently as every 15 minutes if you wish.

Hope that helps, Mrs. Siobhan Parker!

-Ryan

PS, congratulations on your recent nuptials!

Thanks for this. I've actually been misinformed - it's actually a difference between the Performance Sales Analysis and the Performance Summary that appears through Season Manager. Is there a document that will tell me what this screen is showing?      

Just a quick clarification here:

The seat_status and sli_status should be in sync for orders and the seat map.  What you are saying is a disconnect in the order/seat map, but should not be a problem with the report.  If so, I would recommend running TP_CHECK_SEAT_STATUS to verify the status of these.  There is more information about this procedure in the SQL Server Scheduled Jobs documentation found here:

http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/SQL%20Server%20Scheduled%20Jobs.aspx

TP_CHECK_SEAT_STATUS with @fix_problems = ‘Y’ should find and/or correct any inconsistencies.  If you have further issues, please open a support ticket.

The Performance Sales Summary does not inherently report voided sublineitems.  However, it does rely on seat_status (as you note) for categorizing sales.

-Ryan

Siobhan Parker:

or just let me know why the Performance Sales Analysis and the Performance Sales Summary might differ?

I don't know if code has changed, but in late '08 we stopped using the "Performance Sales Summary" report because we found that it overstated income by adding the due_amt from voided sli order lines to its "$" columns because it was considering seat_status but not sli_status for those rows. YMMV.