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.
I just wanted to interject that the fiscal year of a source doesn’t generally matter when you are selling a performance, package, or fee. The fiscal year for the corresponding GL transactions comes from the campaign to which the performance, package, or fee is assigned not from the campaign associated with the appeal to which the source is associated. The campaign associated with an appeal is practically meaningless. If you use a source report that is based on campaign, the campaign is only selecting the products included in the report. Any source used to sell the selected products is going to be listed on the report. If you use a source report that is based on season, again any source used to sell selected products will be listed on the report.
All of this is meant to say that it may not be necessary to go to the trouble of changing the sources on these sales unless the marketing department really wants to distinguish between this year’s default web source and next year’s web source for some business reason (as opposed to because they worry it will mess things up from a Tessitura perspective, which it shouldn’t).
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com