The Movement report provides information pertaining to paid and unpaid admissions within a particular time-frame. You can use this report to obtain the following information:
-
Total sales to date of paid, unpaid and complimentary tickets
-
Total sales of paid, unpaid, and complimentary tickets within a particular time frame
-
Total number of unsold tickets and their projected value
-
Percentage of sold tickets
Movement Report Criteria
The following table describes this report’s criteria:
Criteria |
Description |
Venue |
Enables you to filter the report by one or more venue selections.
To select more than one venue, hold CTRL or SHIFT while making your selections. |
Series |
Enables you to filter the report by the selected series.
Enter the series name or click to search for the series. For more information, refer to The Find Series Dialog Box. |
Performance Code |
Enables you to filter the report by a specific performance.
Enter the performance code or click to search for the performance. For more information, refer to The Find Performances Dialog Box. |
Sales Date Format |
Specifies the date to use for the report:
-
Date Range
-
Previous 7 Days - This does not include today.
-
Today
-
Yesterday
This is the date that the item on the order was sold, modified or deleted.
|
Sales From |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date.
Any value entered into this field will only apply if Date Range is used.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using a Calendar to Add a Date and Using Relative Dates and Times. |
Sales To |
If you are entering a date range, this is the date to which data will be included in the report. This date is inclusive where the end time will be up to 23:59:59 on the selected date.
Any value entered into this field will only apply if Date Range is used.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using a Calendar to Add a Date and Using Relative Dates and Times. |
Report On |
Enables you to report on:
-
Performance
-
Performance Short Description
-
Price Type
-
Price Type Group
-
Series
-
User name
-
User Role Group
-
User Role Name
|
Display Values |
Enables you to specify what values to display:
-
Net: Displays net values (excluding taxes and service charges)
-
Total: Displays total values (including taxes and service charges). When selecting this option, the report includes a separate column for taxes.
|
Advanced Section
The following criteria is available in the advanced section:
Criteria |
Description |
Performance Date Format |
Enables you to filter the report by:
-
Advanced Sales: Filters for allocated tickets for performances that occur after today’s date.
-
Past Sales: Filters for allocated tickets for performances that have occurred on or before today’s date.
-
Performance Range: Filters for performances occurring between the date range entered in the From Performance and To Performance fields.
|
Performances From |
Enables you to filter for those performances that occur on or after the date entered.
Any value entered into this field will only apply if the Performance Range date format is used.
The application will ignore your entry if you do not enter a value for Performances To date.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using a Calendar to Add a Date and Using Relative Dates and Times. |
Performances To |
Enables you to filter for those performances that occur on or before the date entered.
Any value entered into this field will only apply if Performance Range date format is used.
The application will ignore your entry if you do not enter a value for Performances From date.
Enter a date or relative date into the field or click or to select the date or relative date.
For more information, refer to Using a Calendar to Add a Date and Using Relative Dates and Times. |
User Name |
Enables you to filter by the selected users.
Enter the user name or click to search for the user(s). For more information on searching for a user, refer to The Find Users Dialog Box.
This is the user who last updated the order. |
User Role |
Enables you to filter by the selected user roles.
This is the user who last updated the order.
To select more than one user role, hold CTRL or SHIFT while making your selections. |
User Role Group |
Enables you to filter by the selected user role groups.
This is the user who last updated the order.
To select more than one user role group, hold CTRL or SHIFT while making your selections. |
Report on Opens or Holds |
Enables you to filter the report by:
-
Open Seats and Holds:
-
If no options are selected from the 'Hold Types' field, open seats and all holds will be returned within the reports results.
-
If options are selected from the 'Hold Types' field and Exclude Holds is selected from the 'Include or Exclude Selected Holds' dropdown, open seats and all holds except the selected holds will be returned within the report's results.
-
If options are selected from the 'Hold Types' field and Include Holds is selected from the 'Include or Exclude Selected Holds' dropdown, open seats and only the selected holds will be returned within the report's results.
-
Open Seats Only: Regardless of the option selected from the 'Include or Exclude Selected Holds' dropdown, or the options selected from the 'Hold Types' field, only open seats will be returned within the report's results.
-
Holds Only:
-
If no options are selected from the 'Hold Types' field, all of the holds (and only holds) will be returned within the report's results.
-
If options are selected from the 'Hold Types' field and Exclude Holds is selected from the 'Include or Exclude Selected Holds' dropdown, all holds except the selected holds will be returned within the report's results.
-
If options are selected from the 'Hold Types' field and Include Holds is selected from the 'Include or Exclude Selected Holds' dropdown, only the selected holds will be returned within the report's results.
|
Include or Exclude Selected Holds |
Enables you to choose whether or not to include the holds selected from the 'Hold Type' field in the report's results:
-
Exclude Selected Holds: Excludes all of the options selected from the 'Hold Type' field from the report's results.
-
Include Selected Holds: Includes only the options selected from the 'Hold Type' field from the report's results.
|
Hold Type |
Enables you to filter the report by the selected hold types.
To select more than one hold type, hold CTRL or SHIFT while making your selections. |
Movement Report Output
The following image illustrates a sample report:
Movement Results
-
Projected Value (Proj. Value): Projected values are calculated using the highest price from the performance’s default pricing model. If there is no default price model, the 'Projected Value' will be calculated as the total 'Paid' plus the total 'Unpaid'.
-
Percentage Sold (% Sold): The percentage of sold tickets is the total number of sold seats divided by the told number of available seats.
-
Unpaid: The value reported for unpaid admissions is the value of the admission.
-
Paid: The value reported for paid admissions is the amount allocated to those admissions, which may be less than the admission value if some admissions are partially paid.