Friday, December 7, 2018

Saved Transaction Search > Type is Item Fulfillment > result is dropping the first letter/number of the Item Name/Number

1.    Navigate to: Reports > Saved Searches > All Saved Searches > New

2.    Click Transaction

3.    Rename the Search Title for easy reference in the future.

4.    Under Criteria tab > Standard sub tab > set preferred Filters for the search.

5.    Under Results tab > Columns sub tab > set preferred Fields the search should pull up.

6.    Then add the field > Formula (Text)

7.     Under the Formula column > copy and paste below formula:ltrim(regexp_substr({item},'[^:]*$'))

8.     Under the Custom Label column > you may set the label to 'Item Name/Number'

9.    Click on Save & Run button.

No comments:

Post a Comment