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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
which address to mail to?
Perplexed at NS searches - for bulk merge
I need to export a selected group of contacts for a proof for a bulk merge.
Searches return multiple addresses for the same individual, when what I want is:
1 - if contact has postal address, then pick contact postal address (label=postal - could use billing flag instead)
2 - if contact has street address then pick contact street address (label=street, could use shipping flag instead)
3 - if contact has no address, then pick company postal address (if company has postal address)
4 - if contact has no address, and company has no postal address, then pick company street address
0