Thursday, June 27, 2019

Resolve Multiple Lines Result in Saved Search When join field 'Item: Inventory location' is Added

1. Navigate to Lists> Search> Save searches> New

2. Select Transactions

3. Under the Criteria tab> Select the following filters:

---Type is Purchase Order

---Location is none of -none-

---Location field is Inactive = No


---Formula (Text)

DECODE({location}, {item.inventorylocation},'1','0')

Starts with = 1

4. Under the Results tab> Add the following columns:

---Item fields is Inventory Location

---Item fields is Location On hand

5. Rename the search and hit Save and Run.

No comments:

Post a Comment