Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Sales order Saved search
Hi Guys,
I hope that you are ok.
I'm struggling with the following:
The task is to create Transaction Saved Search with the following parameters:
Criteria: Type is Sales Order
Main Line: False
LineField (checkbox): true.
Results:
- Internal ID
- Transaction ID
- Line ID
- Item
- LineField (checkbox)
etc.
In the results, I would like to list only the Sales orders where this LineField is checked.
If there is a Sales Order where there is a line with unchecked LineField, it shouldn't appear on the results list.
Example:
SO0001 - Should be in the results
line1 LineField = True
line2 LineFiled = True
SO002 - Should NOT be in the results
2