perfs associated to wrong campaing

I hit this issue in our first year on the system.  You could return all the tickets and re-reserve them, but that’s probably impractical.

The fix I landed on had to be done in SQL.  I had to isolate the t_transaction rows connected to the performances, and change the campaign on those.  Then I had to un-post and re-post all posts/batches containing those transactions.  Then, they all ended up in the right campaign and fiscal year in the posting history.

After that I made a pact with myself never to allow performances to go on sale again until I’m absolutely positive the campaign is correct.

Let me know if you want more details on my fix.

Kirk Mortensen

Database Administrator

TheatreWorks

Hi,

We've just discovered that a number of our performances were associated to the wrong campaigns.

Is there any way to move the revenue to the correct campain?

Any imput would be appreciated.

Hali

IT Director

Vancouver Opera

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!

I hit this issue in our first year on the system.  You could return all the tickets and re-reserve them, but that’s probably impractical.

The fix I landed on had to be done in SQL.  I had to isolate the t_transaction rows connected to the performances, and change the campaign on those.  Then I had to un-post and re-post all posts/batches containing those transactions.  Then, they all ended up in the right campaign and fiscal year in the posting history.

After that I made a pact with myself never to allow performances to go on sale again until I’m absolutely positive the campaign is correct.

Let me know if you want more details on my fix.

Kirk Mortensen

Database Administrator

TheatreWorks

Hi,

We've just discovered that a number of our performances were associated to the wrong campaigns.

Is there any way to move the revenue to the correct campain?

Any imput would be appreciated.

Hali

IT Director

Vancouver Opera

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!