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 4 days ago.
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 4 days ago.
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 4 days ago.
Add Comment

Your code was what I tried first.

The same data is missing in saved searches.

Rookie Answered 4 days ago.
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 3 days ago.
Add Comment

Both on the IF and on the customer

Rookie Answered 3 days ago.
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 3 days ago.
Add Comment

Good ideas…

 

Rookie Answered 3 days ago.
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