Hello everyone,
Is there a way of working out how much income was generated through orders which have been assigned a specific source code. I can’t even seem to be able to find a list of orders relating to a specific source code as the source_code for all records in our lvs_tkt_hist table is NULL.
Many thanks for your help
Grae
Under the Campaigns and Appeals report category, try Campaign Appeal Revenue/Expense. The name is a bit misleading. For v9.0, it’s been renamed to Revenue by Source and Appeal to be a little more concise. This will report both contribution and ticketing income, but if you’ve only used the source for ticketing the number should be accurate. The Mode parameter will allow you to choose between the transactional appeal (the source assigned for each transaction) vs the Order/Contribution Appeal (source assigned to the entire order or contribution).
More help is available in the report documentation:
http://www.tessituranetwork.com/network/Learning/Documentation/Reports/Campaign%20Appeal/Campaign%20Appeal%20Revenue%20Expense.aspx
Hope that helps!
-Ryan
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Graeme Ellis Sent: Friday, May 01, 2009 8:07 AM To: Ryan Creps Subject: [Tessitura Ticketing Forum] Source code income
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.287 / Virus Database: 270.12.8/2086 - Release Date: 04/30/09 17:53:00