Hello all - is there anyone out there that knows how to track changes made to performances and pricing? We've recently had a string of wild occurnces with our reporting - one show in a theatre of 310 reported capacity just fine except for one day where capacity jumped to 918, then the next day was back down to the normal 310 capacity.
Just today, base prices in our inventory reports jumped $4, but are fine now when the report is re-run.
On another note, we've rescheduled our reports to run at 1AM as opposed to midnight (to prevent any timing hiccups), but other than user changes, i cannot isolate why our report has had such odd numbers, only to report normal numbers when rerun. Anyone heard of this or have any insights?
Many thanks!
There is a table called TA_AUDIT_PRICES which tracks changes to pricing within price maps. The 'alternate key' column has three values which represent the IDs of the zone map, price map, and zone_no altered.