Thursday, March 14, 2019

Determine Sales Orders with More Than A Certain Quantity of any One Item Line

1. Navigate to Lists > Search > Saved Searches > New

2. Click Transaction Search Type

3. For future reference, please provide for the saved search name by filling up "Search Title" field

4. Under the Criteria tab, please key-in the following:

FILTER                     DESCRIPTION

Type                         is Sales Order
Main Line                  is false
Quantity                   is greater than "key-in the quantity"
Item                         on any Line any of (Highlight all of the items on your list)

5. Under the Results tab, just add the Quantity

6. Click Save & Run

No comments:

Post a Comment