There is a requirement to create a Custom field that will serve as an identifier if a Purchase Order is closed. To do this, we need to create a Saved Search that will check if the Item Lines of the Purchase Order is closed. Kindly follow the steps below for this setup:
Create a Saved Search
- Navigate to Reports > Saved Searches > All Saved Searches > New
- Click Transaction
- Search Title: Enter name of Saved Search
- Criteria:
- Filter: Select Type
- Description: Select Purchase Order
- Filter: Main Line
- Description: Select False
- Click Results
- Click Columns
- Field: Formula(Text)
- Summary Type: Maximum
- Formula: Enter CASE WHEN NS_CONCAT({closed}) LIKE '%F%' THEN '' ELSE 'Closed' END
- Click Save
Create a Custom Field
- Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
- Name: Enter Name of the Custom Field
- Store Value: Remove Checkmark
- Click Applies To
- Purchase: Enter Checkmark
- Click Validation & Defaulting
- Search: Select the Saved Search created in the first step
- Click Save
By doing the steps above, the Custom Field will display a blank value if the item lines in a Purchase Order is not yet closed. If all of the Item Lines are closed, the Custom Field will display Yes.
Do you have any questions? Kindly let us know!