Yes—you can filter NetSuite records in ExtendInsights based on fields that have no value (null or blank).
This is useful when you want to identify incomplete records, such as transactions missing a location, department, or other required or expected fields.
How to Filter for Fields with No Value
When creating a Data Filter (rule) in ExtendInsights, you can explicitly filter for empty values by using a special keyword.
Use This Value
[[@NONE@]]
This tells ExtendInsights to retrieve records where the selected field is null or blank in NetSuite.
Step-by-Step Example
Example Use Case
Retrieve Vendor Bills where the Location field is empty.
Start Search and Download (with or without an existing template).
Turn on Apply Filters and choose Using Rules.
Add a filter rule:
Field: Location
Value:
[[@NONE@]]
(Do not select a value from the dropdown.)
Click Save.
Click Download Data.
Records pulled are those vendors bills with null or blank Location at the header.
Common Use Cases
Find transactions missing required fields
Identify records that need cleanup
Prepare targeted updates using ExtendInsights templates
Need Help?
If filtering doesn’t return the expected results:
Confirm the field exists on the selected record type
Verify whether the field is header-level or line-level
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat
✉️ Email cloudextend-support@celigo.com
📎 Include the record type and field name when contacting Support.