Sales Order Saved Search > Duplicate Lines are shown due to Item: Location Committed field

Scenario

User wants to display all Sales Order Line Items with locations that matches the Sales Order’s Location.

• User created a transaction saved search which pulls up Sales Order line items.
• In the Results tab, user added the field Item: Location Committed.

Result: The search displayed multiple lines based on the number of locations where item is available which is by design.

Solution

To limit the results, edit the saved search and add criteria

1. Click Edit This Search

2. In the Criteria tab > Standard subtab, add the following filters:

• Formula (Text) = is 1
• Formula: CASE WHEN {LOCATION} = {ITEM} THEN 1 ELSE 0 END
• Item Fields…Location Committed = is greater than 1

3. Click Save & Run