• Utilities Orders Pages
  • Utilities Orders-Query Select Page
  • Utilities Orders-Order Invoice Page
  • Utilities Orders-Order Update Page
  • Utilities Orders-Order Marketing Page
• Performing Orders Batch Processes
  • Printing Order Invoices in a Batch
  • Updating Orders in a Batch
    • Searching for Orders to Update in a Batch
    • Updating Order Details in a Batch
    • Adding Gifts to Orders in a Batch
    • Adding Miscellaneous Items to Orders in a Batch
    • Deleting Performances or Bundles from Orders in a Batch
  • Updating Order Marketing Data in a Batch

The Utilities application Offers|Query Select page provides a list of all saved queries that are used to batch create offers for customers. By default this page contains the General Invoice, General Order Marketing and General Order Update queries. If you hover over the query name a short description will be displayed in the description section below.

Criteria for the displayed queries are created in the Business Intelligence and Reports application and saved in the appropriate Invoice, Order Marketing or Order Update folder. Business Intelligence allows you to create custom queries to target the specific orders.

To create specific queries for your customer's orders, refer to refer to Business Intelligence and Reports Business Intelligence.

Information Order ID is required as a result member in any BI that is used to invoice or update orders.

The following image illustrates the Utilities application Orders|Query Select page:

Default Pre-Loaded Queries in the Order|Query Select Page

Default Queries

The General Invoice query allows you to search for orders that you want to generate invoices for. For more information, refer to Utilities Orders-Order Invoice Page.

The General Order Marketing query allows you to search for orders that you want to update 'marketing data' fields for. For more information, refer to Utilities Orders-Order Update Page.

The General Order Update query allows you to search for orders that you want to update. For more information, refer to Utilities Orders-Order Marketing Page.

By default, all three of the general queries allows you to search for a range of database order IDs, order numbers, created on dates, contact first names, contact last names, first performance start dates, first series names, amounts due, roles and total amounts.