Tuesday, July 9, 2019

Location Average Cost as a Filter on Saved Search is not working

Location Average Cost field as a filter on Saved Searches does not showcase correct result. However this can be available through formula.

The steps provided below will allow users to filter the search result based on Location Average Cost via an Item Saved Search.

    - Navigate to Transactions > Management > Saved Searches > NewItem
    - Under Criteria subtab
    - Field : Formula (Numeric) | Description : is greater than or equal to 1 | Formula : NVL({locationaveragecost},0)

No comments:

Post a Comment