To see a detailed list of items sold and the tax applied to the order, we can use an export definition to show one line per order. 

Step 1: Create a Sales Order Query to show items that have had tax applied. 
  1. From Analysis, Information Library, Click Add an ad-hoc query
  2. Choose the Source View of Sales Order
  3. On the left click Sales Order Item, from the middle drag Type to Include records where and set equal to Tax
  4. (Optional) On the left click Sales Order, from the middle drag Transaction Date to Include records where and set equal to the date you are looking to report on
  5. Navigate to the Set Save Options tab
    1. Name the Query
    2. Mark the Box 'Create a Selection'
  6. Save and Close
Step 2: Create an Export Definition to Output the fields you would like to see
  1. From Administration, Export Definitions, Click Add
  2. Choose the Source view of Sales Order
  3. From the middle drag Amount to Selected fields to see the Total Amount of the order
  4. On the left, Click sales Order Item. From the middle drag description to Selected Fields
  5. On the Export Criteria Screen, Mark the Box Selected Sales Order Item
    1. Drag Type to Include records where and set equal to Ticket
    2. Click Ok
User-added image
  1. From the middle Drag Net Amount to Selected Fields
  2. Under Selected fields  Click Sales Orders at the top
  3. On the left click Sales Order Item, From the middle Drag Net Amount to Selected Fields (This will add a second Sales Order Item node to your export allowing us to output information about the other items in the order)
  4. On the Export Criteria Screen,
    1. Adjust the Number to Export to reflect the maximum number of items that may have been in any order
    2. Mark the Box 'Selected Sales Order Item'
      1. Drag Type to Include records where and choose One of in the drop down
      2. Move any items that may have been sold in the order to the right
    3. Click Ok
User-added image
  1. From the middle Drag Description to Selected Fields
  2. (Optional) Click the fields in Selected Fields and use the Pencil to Uniquely Name each line
User-added image
  1. Use the Column Order and Set Sort Order for rows tabs to organize the output fields of the export definition
  2. On the Set Save Options Tab, Name the query
  3. Save
Step 3: Create an Export Process. This will tie your query and export definition together to process the results
  1. From Administration, Export, Click Add 
  2. Name the Export Process
  3. Choose the Export type of Export Definition
  4. Use the magnifying glass to search and select the selection we created in Step 1
  5. Use the magnifying glass to search and select the export definition we created in Step 2
  6. Save
User-added image
  1. Click the arrow to the left of the process, Click Start Process