Hi,
We have been playing with reconciling our custom daily sales reports with our dashboards and t-stats and have realized that the $$ that is reported in both includes reserved income and an embedded fee ($2.00/ticket). This requires us to keep separate excel reports with these items filtered out and it seems so silly to do this, especially since dashboards is so user friendly.
Now, with the fee, I use the term 'embedded' because it is built into the ticket price when the house zone maps and price maps are set up at the beginning of the season.
Has anyone else had any experience with needing to filter an embedded fee? It is tied to a unique GL, so I'm assuming that its possible...
thanks!
Hi Tiffany,
We have several reports with a parameter of "Ticket Price Only" which filters report to on the Price Category recorded on the Price Map. Price Category 1 is "Ticket Price". When the parameter is set to "Yes" the report shows only money from T_SLI_DETAIL where the category of the price map is 1. If set to "No" shows all lines from T_SLI_DETAIL, but it presents them as two lines in the report. One for Ticket Price and one for all other categories.
That is the route I would suggest.
- Levi