Our marketing folks want to go out with a pre-sale open to the public on our first show of next season, which is obviously in a different fiscal year than what we're selling now. We use different source codes (based on season/FY) for the relevant entry in T_DEFAULTS, and as far as I know there is not a way in Tess to send different sources to the API to send back in an order.
Assuming that's correct, the harebrained scheme I'm thinking of involves changing the web source in T_DEFAULTS to that which we'll use for FY11, and run an Update statement on the orders containing the remaining FY10 perfs which changes the number in T_ORDER.source_no to reflect the older web source (making it the correct one relevant to the season.
My question is, are there any ramifications to changing source_no? Does that element get populated to anything else that would throw a firecracker into financial reporting or the like?
Thanks to all.
We have a few source codes that (arbitrarily) expire on May 31, 2020.
Lucie
______________________________ Lucie Spieler IT Development and Training Manager
Say Yes! to Opera, South Florida 8390 NW 25th Street Miami, FL 33122
Direct Line: 305.403.3291 Switchboard: 305.854.1643 x 1521 Box Office: 800.741.1010 To Give a Gift: 305.403.3320 www.FGO.org
_______________________________________________________ 2015-16 | 75th SEASON | SUBSCRIPTIONS AVAILABLE! THE BARBER OF SEVILLE | NORMA | THE PASSENGER | DON PASQUALE
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kelley cole Sent: Friday, July 03, 2015 4:23 PM To: Lucie Spieler Subject: Re: [Tessitura Technical Forum] Web sales and their default source
Can a source code expiration date be used over more than one fiscal year, having the campaign and appeal from the previous fiscal year....or do I have to build all new source codes every year?
From: Amanda Freeman <bounce-amandafreeman5080@tessituranetwork.com> Sent: 7/2/2010 11:39:38 AM
The source associated with the transaction would still be the future season/campaign's source, even if you changed the source on the order. Of course, you could change the source on the transactions as well when you update the orders' sources. I am assuming in this scenario that you'd be running some sort of scheduled job that'd make the change regularly enough that you wouldn't be undoing any potential later, intentional change to the source that should not affect the source on the initial transactions. Subsequent transactions in the orders (after changing the order's source) I believe would use whatever source the order has at the time of the transaction. So it wouldn't require future upkeep after the initial fix.
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!