Start your query:
  1. Navigate to Analysis, then click on Information Library
  2. Click Add an ad-hoc query
  3. Select source view of Sales Order and click OK
Add fields to Include records where:
  1. From the middle column, drag Added by Username into Include records where. Select the user that you want to display information for.
  2. From the middle column, drag Order complete date into Include records where. You can set this to a specific date or a date range.
  3. Also drag Sales method type into Include records where. Set this to Daily Sales or Advance Sales. 
Add fields to Results fields to display:
  1. To add dollar amounts: From the middle column, drag Amount into Results fields to display.
  2. To see what they sold: From the left column, select Sales Order Item. From the middle column, drag Type into Results fields to display..
  3. To output the payment method: From the left column, select Sales Order Payment > Revenue. From the middle column, drag Sales Order Payment\Revenue\Payment method into Results fields to display.
Save your query:
  1. Click Set save options tab
  2. Name query
  3. If you will be using this query elsewhere in Altru, mark to Create a selection
  4. If you will be using this query in another query, mark to Show this Selection in the Query Designer
  5. Save and Close

Here is an example of what your final query will look like:
User-added image