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.
Create a Saved Search to Display Sales Orders Containing Only One Line Item Regardless of Quantity.
Hello,
I am having difficulty creating a saved search to display Sales Orders containing only one line item, regardless of quantity. The search should return Sales Orders that contain a single line item only, even if the quantity on that line is greater than one.
I have tried several different approaches, but in every case the search still includes orders with multiple lines. It seems like the solution may require a condition similar to “Distinct Item Count = 1,” but I am not sure where or how to apply it within the search.
Any suggestions would be greatly appreciated!
Tagged:
0