Sales reports not matching

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?      

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?