Criteria
When selecting your criteria, you will be given the option of selecting 'AND' or 'OR'. “AND” means only records where all criteria is met will return in the report, while “OR” results in records where any one of the criteria is met regardless of if the other criteria are met.
=:
Desired criteria selected will equal exactly (text or numerical value)
-
Example: Shipper City = Indianapolis or Total Due Amount = 200
>:
Desired criteria selected will be great than the value entered (numerical only)
-
Example: Billed Weight > 10
<:
Desired criteria selected will be less than value entered (numerical only)
-
Example: Actual Weight < 5
>=:
Desired criteria selected will be greater than or equal to the value entered (numerical only)
-
Example: Total Due Amount >= 500
<=:
Desired criteria selected will be less than or equal to the value entered (numerical only)
-
Example: Total Due Amount <= 500
<>:
Desired criteria will be everything not equal to value entered (text and numerical)
-
Example: Billed Weight <> 5. This will show all shipments that are not 5 lbs
In:
Desired criteria in (insert term)
-
Example: Shipper city in Indianapolis, Chicago, Los Angeles
Like:
Desired criteria will be like selected example (text)
-
Example: Receiver City like Los Angeles. This will allow for multiple variations or misspellings of the searched term
Not in:
Desired criteria in (insert term)
-
Example: Shipper city not it Indianapolis, Chicago, Los Angeles
Starts With:
Desired criteria starts with (insert term)
-
Example: GL Code starts with 4596
Ends With:
Desired criteria ends with (insert term)
-
Example: GL Code ends with 22001
Null:
Desired criteria will populate when the field selected does not have a value in it
-
Example: GL Code is null. This will produce a report for every invoice where there is no GL Code
Is not null:
Desired criteria will populate when the field selected has a value in it
-
Example: Shipper City is not null. This will produce a report for every invoice where there is a value for shipper city