1. Navigate to Analysis, then click on Information library
  2. Click Add Ad-Hoc Query
  3. Select the source view of Sales Orders and click OK
  4. In the left column, select Sales Order. From the middle column, drag Transaction date into Include Records Where. Select the date or range or dates you want to filter on
  5. In the left column, select Sales Order Item. From the middle column, drag Type to Include Records Where. Set equal to Merchandise
  6. In the left column, expand Sales Order Item, expand Sales Order Item Merchandise and select Vendor. From the middle column, drag Merchandise Vendor records into Include Records Where and set equal to your vendor.
  7. To look for department: From the left-hand column Expand Sales Order Item, Expand Sales Order Item Merchandise, select department. Then from the middle column Select  Merchandise Department records  and drag it to Include Records Where using the click the magnifying glass and search for the department's record. 
  8. To look for Category: From the left-hand column Expand Sales Order Item, Expand Sales Order Item Merchandise, Select category. Then from the middle column Select  Merchandise category records  and drag it to Include Records Where using the click the magnifying glass and search for the category's record. 
  9. To include item details: From the left-hand column expand sales order item, expand sales order item merchandise, select inventory item and from the middle column select item details and move to results fields to display
  10. To include SKU:  From the left-hand column expand sales order item, expand sales order item merchandise, select inventory item and from the middle column select SKU and move to results fields to display
  11. To include the number of item sold in the order sales order: From the left-hand column select sales order item and then from the middle column move quantity to results to display.