Hello everyone
Does anyone use the Ticket Sales By Period Report and or Ticketing Fee Revenue Report for financial reconciliations. If so; every order must have a mode of sale and a sales channel for the above reports to capture all the transactions.
However, in the order input stage; the mode of sale is a mandatory item; BUT the sales channel is not. Therefore orders can exist without a sales channel. These specific orders without a sales channel will not be inclusive in the Ticket Sales By Period Report or the Ticketing Fee Revenue Report. If orders exist without the sales channel, the must be identified and populated with a sales channel in order to use these transactional based reports for reconciliation.
With the support of other Financial users or anyone who does reconciliation of Ticket Sales and or Handling Fees based on Transaction Date; I suggest we request Tessitura to make the sales channel a mandatory item during the order input stage and without, the order cannot be completed.
Please reply to acknowledge your support to my suggestion.
Thank you in advance for you support
Demitrios Prevenas
Hi Demitrios,
The Sales Channel field actually is required. The documentation says, "Channel is a required field, and orders cannot be saved until a sales channel has been selected." (In the Help System under Ticket Order Processing > Order Details Tab > Order Header.)
Are your orders are being saved with the (unknown) channel option?
Otherwise, if your database is allowing orders to be saved without a channel, there might be an error happening.
-Michael
thank you for your response Michael.
It seems as thought the Web application allows orders to be competed without a sales channel attached. Thank you for making that information known to me.
Demitrios
TR_SALES_CHANNEL has a row with an ID of 0 (unknown) which is used for orders without a sales channel required (set by MOS rules) and/or orders created by system processes without a predefined default (by MOS or set in batch).
If you are not seeing this default being used in the order creation process, I would suggest that you open a support ticket so we can assist you in troubleshooting.
Thank you Ryan for you input; we are currently conducting some testing in our environment. Will update the forum with any new information.
Once again thank you everyone for your input