Create Saved Search of Fixed Assets Without Asset Values
Published on
February 29th, 2024
Scenario
Asset Value records are normally generated by NetSuite upon Asset creation. User needs to find Asset records that do not have any related Asset Value records.
Solution
- Navigate toLists>Search>Saved Searches>New
- ClickFAM Asset
- Search Title:EnterTitle
- ClickCriteriatab
- ClickStandardsubtab
- Filter:
- SelectAsset Values
- Asset Values:SelectAny of
- Select- None -
- ClickSet
- Note: Add other Filters based on preferences.
- SelectAsset Values
- ClickResults
- Field:
Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.- SelectID
- SelectName
- Note: Add other Fields based on preferences.
- ClickSave & Run
Note: If Save & Run option is not visible, hover-over cursor on the down array of the Save button and click Save & Run.