This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How on earth do I get the values of the addressee and addrphone fields from an address record?

I'm starting from an item fulfillment record. I can't see how to get it from that, by either N/search or N/record. So I loaded the shipping address record from the IF record but that
• returns addressee some of the time and not others, even when I can see that addressee is has a value
• never returns addrphone

Create the search in the UI and export it. <https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp>

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4069251582.html>

Your second link is SS1. I'll look for an SS2 equivalent

The search in NS returns the same data as my script does. The only places where both fields are always populated correctly are on the address record in the UI and in the SuiteTalk SOAP response to a search on the item fulfillment

<@U5TF1GQ20> A mess! Littered with the debris of all the approaches I've tried

I have a couple of weeks now before I need to resolve this and will try to tidy up my code to show what I've done soon