Hi,
I was wondering if there is a way to bulk add 'Sales Notes' (which trigger the 'Info' button within an order) to a 'Production Season' instead of adding them individually to each item at the 'Performance' level.
We often have 50-60 performances within each 'Production Season' and it would take a significant amount of time to add them individually to each performance within each 'Production Season', within each yearly season.
The idea is that this button could be a quick-access home to information such as performance length, cast, warnings, etc.
Hope you can help!
Thanks,
Adam Walsh, Melbourne Theatre Company
Hi Adam,
My take is that you create a content type in TR_INV_CONTENT in System Tables, then add this at the Production Season level, entering whatever you want to be added in the performance Sales Notes.
Your DBA can then create a job in SSMS (run nightly/weekly etc.) where this content is copied (from TX_INV_CONTENT) to the Sales Notes field of performances attached to that Production Season (T_PERF). If changes are made to the content in the Production Season, they will be copied to Sales Notes when the job is run.
Once this job is created, it can be left to run then all you need to do is add more content at Production Season level for future production builds.
Cheers,
Kevin