Jcurve Support Articles / Basic Accounting

Create Saved Search of Fixed Assets Without Asset Values

Written by
John David Dy
Published on
February 29, 2024 at 8:17:49 AM PST February 29, 2024 at 8:17:49 AM PSTth, February 29, 2024 at 8:17:49 AM PST

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

  1. Navigate toLists>Search>Saved Searches>New
  2. ClickFAM Asset
  3. Search Title:EnterTitle
  4. ClickCriteriatab
  5. ClickStandardsubtab
  6. Filter:
    • SelectAsset Values
      1. Asset Values:SelectAny of
      2. Select- None -
      3. ClickSet
    • Note: Add other Filters based on preferences.
  7. ClickResults
  8. 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.
  9. 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.
#saved search
#fixed asset
#empty
#Asset Values
#No Value
Jcurve Support Articles / Basic Accounting