Item Fulfillment with Time Difference Between Picked, Packed, and Shipped Status

User wants to create a Transaction Saved Search that shows comparison of time between Picked, Packed and Shipped Status on Item Fulfillment.

Solution

1. Navigate to List > Search > Saved Searches > New
2. Select Transaction 
3. Criteria tab > Standard subtab > Filters:
4. Note: For every required filter stated below substeps, use the dropdown menu select it.
5. Select Type
6. Description: Select Item Fulfillment   
7. Select Main Line
8. Description: Select False
9. Select Shipping Line
10. Description: Select False 
11. Select Tax Line
12. Description: Select False 
13. Select Status
14. Description: Select  Item Fulfillment:Shipped, Item Fulfillment:Packed 
15. Select System Notes Fields…
16. System Notes Filter: Select Field
17. Field: -any of- Select Status

Note: You may also set a Date range filter to narrow down your search and avoid getting  timed out due to a large number of results. 

1. Click Results tab > Column subtab

 Fields:

 Note: Always click Add once Field is selected and adjust as needed. Click on Remove All button.

1. Select Field
2. Summary Type: Select Group
3. Select Name
4. Summary Type: Select Group
5. Select Type
6. Summary Type: Select Group
7. Select Document Number
8. Summary Type: Select Group
9. Select Formula (Date/Time)
10. Summary Type: Select Maximum
11. Formula: case when {systemnotes.newvalue}=’Picked’ THEN {systemnotes.date} else NULL END
12. Summary Label: Enter Time Picked
13. Select Formula (Date/Time)
14. Summary Type: Select Maximum
15. Formula: Enter case when {systemnotes.newvalue}=’Packed’ THEN {systemnotes.date} else NULL END 
16. Summary Label: Enter Time Packed
17. Select Formula (Date/Time)
18. Summary Type: Select Maximum
19. Formula: Enter case when {systemnotes.newvalue}=’Shipped’ THEN {systemnotes.date} else NULL END 
20. Summary Label: Enter Time Shipped
21. Select Formula (Numeric)
22. Summary Type: Select Maximum
23. Function: Select Number as Time
24. Formula: Enter case when {systemnotes.newvalue}=’Packed’ THEN ({systemnotes.date}-{datecreated})*24 else NULL END 
25. Summary Label: Enter Time (Picked vs. Packed)
26. Select Formula (Numeric)
27. Summary Type: Select Maximum
28. Function: Select Number as Time
29. Formula: Enter (max(decode({systemnotes.newvalue},’Shipped’,{systemnotes.date}))-max(decode({systemnotes.newvalue},’Packed’,{systemnotes.date})))*24 
30. Summary Label: Enter Time(Packed vs. Shipped)
31. Search Title: Enter Name
32. Click Save & Run