JCurve Solutions Support Hub

Inventory Status Change Saved Search

Scenario:

User wants to create a saved search on Inventory Status Change and expose the Previous Status and Revised Status fields.

Solution:

Go to Lists > Search > Saved Searches > New
Select Transaction
Search Title: Enter Title
Click Criteria
Filter:
- Select Type
  - Select Inventory Status Change
Click Results
Field:
- Select Internal ID
  - Summary Type: Select Group
- Select Date
  - Summary Type: Select Group
- Select Document Number
  - Summary Type: Select Group
- Select Location
  - Summary Type: Select Group
- Select Formula (Text)
  - Formula: Enter CASE WHEN {linesequencenumber}=1 THEN {inventorydetail.status} ELSE NULL END
  - Summary Type: Select Maximum
  - Summary Label: Enter Previous Status
- Select Formula (Text)
  - Formula: Enter CASE WHEN {linesequencenumber}=2 THEN {inventorydetail.status} ELSE NULL END
  - Summary Type: Select Maximum
  - Summary Label: Enter Revised Status
Click Add
Click Save & Run

Looking for something else? Search here...