Saturday, September 8, 2018

Create a report that lists customers who purchased more than one quantity of an item

1. Navigate to Lists > Search > Saved Searches > New.
2. Click Transaction.
3. On Criteria tab > Standard sub tab, set the following filters:
          - Main Line = Yes
          - Type = Sales Order
          Item on any line = specify items that you would like to pull up on the list.
4. On Criteria tab > Summary sub tab, set:
          - Field: Internal ID
          - Summary Type: Count
          - Description: greater than 1
5. On Results tab > Standard sub tab, set:
          - Field: Name
          - Summary Type: Group
6. Click Save & Run.

No comments:

Post a Comment