Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Customer search to find parents lacking Shipto State
I would really appreciate help with this saved search. We are heavy users of Individual- and Company-type customers, with much focus on individuals because they read/consume our subscriptions.
Many of the company records do not have addresses, but the subcustomers have addresses. With a saved search, I'm trying to identify these customers, but two factors are stopping me:
1. Parent Customer Fields > Shipping State does not exist on Criteria tab (nor does Shipping State exist from the general list of fields on Criteria tab)
2. I can't figure out how to write the formula to access the Parent's {shipstate}. None of these is working: {parent.shipstate}, {parentid.shipstate}, {parent_id.shipstate}, {childof.shipstate}, {child_of.shipstate}