Here's a sample Saved Search which lists any Sales Orders that even just one of these Criteria is met regarding its Billing Address.
- The field length of the Bill To Addressee is more than xx characters or left blank
- The field length of the Bill To Address 1 is more than xx characters or left blank
- The field length of the Bill To Address 2 is more than xx characters or left blank
- The field length of the Bill To Zip Code is xx digit or left blank
- Navigate to Lists > Search > Saved Searches > New
- Select Transaction
- Rename the Saved Search
- Under the Criteria tab, mark Use Expressions checkbox
- Still under the Criteria tab, add the following filters:
Formula 1: case when LENGTH{billaddressee} > xx or {billaddressee} is null then 1 else 0 end
Formula 2: case when LENGTH{billaddress1} > xx or {billaddress1} is null then 1 else 0 end
Formula 3: case when LENGTH{billaddress2} > xx then 1 else 0 end
Formula 4: case when LENGTH{billzip} = xx or {billzip} is null then 1 else 0 end
Note: Replace xx by the number of characters.
Note: If you want all the Criteria to be met before the Sales Order will display, you can unmark the Use Expressions checkbox and just add the Formulas on the filters.
- Under the Results tab, add the following fields:
- Document Number
- Name
- Billing Address
- Billing Addressee
- Billing Address 1
- Billing Address 2
- Billing Zip
- Note: Add other fields as necessary.
- Click Save & Run
I hope this helps! ❤ Feel free to share your own tips and tricks under NetSuite Admin Corner to help other members as well. Thank you very much! 😊