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.
Find Shipping Addresses with multiple Sales Orders
Maybe I'm trying too hard at this one, but I'm trying to identify any Sales Orders where we have shipped to the address more than twice.
My current criteria is:
Custom Form: is any of VPOS Sales Order (Portals), VPOS SO (Portals-No RMA)
Date: is on or after start of last fiscal year
Tax Item: is none
Service Provider # (Main) (Custom Body): is not empty
Source: is not CSV
Summary criteria is:
Count Shipping Address is greater than 2
I can't seem to get a clean version of this without it including Sales Orders where we've only shipped once to an address. Any help would be greatly appreciated!
0