For our current FY all of our concerts are showing $0 in sales in Season Overview when we have most definitely had purchases.
Does anyone know why this might be happening? I've found a lot of documentation on why sales might be doubled on Season Overview but nothing for when there are no sales.
Thanks for your help!
Has the EIS_IMP_CHANGED_LOAD_NEW procedure been run? Here's information on the procedure from the Tessitura Help system:
Normal 0 false false false EN-US X-NONE X-NONE
The procedure has two run modes: full and incremental. In full mode, the procedure calculates figures for all performances. In incremental mode, the procedure only calculates figures for performances that have changed since the procedure was last run. The Tessitura Network recommends scheduling the procedure to run once nightly in full mode, and once every 30 to 60 minutes in incremental mode.
Thanks Terry! I think you're on to something, I spoke with our IT Department and we have a custom job that accomplishes the same task:
LP_EIS_IMP_CHANGED_LOAD_NEW 'I', @seasons
We're now thinking our custom job is not compatible with our recent upgrade to 12.1 so we are looking into how we can remedy the situation.
I appreciate everyone's help!