How to get addressee and addrphone from an address record?

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
Rookie Asked on January 20, 2023 in SuiteScript.
Add Comment
8 Answer(s)

Are you looking to get this from the Shipping Address on the item fulfilment itself?

Intermediate Answered on January 24, 2023.
Add Comment

At this point I don’t care how I get it. I’ve tried everything. From the shipping address on the IF would be simplest but it doesn’t work.

Rookie Answered on January 24, 2023.
Add Comment

I’m seeing values when I include this in my IF search:

      search.createColumn({
         name: "addressee",
         join: "shippingAddress"
      }),
      search.createColumn({
         name: "phone",
         join: "shippingAddress"
      })

Are you getting inconsistent results with Saved Search too?

Intermediate Answered on January 24, 2023.
Add Comment

Your code was what I tried first.

The same data is missing in saved searches.

Rookie Answered on January 24, 2023.
Add Comment

Are you seeing those fields on the address that’s shown on the IF in question or on the customer record?

Intermediate Answered on January 24, 2023.
Add Comment

Both on the IF and on the customer

Rookie Answered on January 24, 2023.
Add Comment

I’m drawing a bit of a blank if address and phone are populated but not shown in your saved search.

The only other thing I can think is whether a SuiteAnalytics dataset / SuiteQL might get you what you need?

Intermediate Answered on January 24, 2023.
Add Comment

Good ideas…

 

Rookie Answered on January 24, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor