Thursday, September 13, 2018

Saved Search for Sales Order With Different Location Per Line Item


Solution:

1. Hit Edit this Search, go to Criteria tab> Summary:
o Summary Type: Sum
o Field : Formula (Numeric)
o Description : case when {location} is null then 0 else 1 end
o Formula (Numeric): greater than
o Value: 1


2. Go to Results tab:
Field Summary Type
Number Group
Name Group
Location Count

3. Hit Preview/Save & Run. Results will show only sales orders with different locations per line item

No comments:

Post a Comment