This is actually a WF question but I think I won’t be able to solve it with WF alone and will need scripting. On copy/create of a Transaction I want to trigger the Billing Address to source from the current value on the Customer (otherwise a previous/old address might copy over). If I try setting it via WF Set Field Value directly, it doesn’t work, I think because I actually need to set the drop-down’s value (labeled here as Agent/Broker Select) instead of the text address.

basics of addresses are that there are 2 internal ids

how would I get the ID that I’d need to put under Agent/Broker Select? In this example it is 13102

the other is the internal id of the address ( the internal id of the address join)

I’m still not sure how to get the “other” id which I think is what I need

make your customer search in the ui

I’ve done that, it’s returning nkey not id

take a look at the columns available to you in the billing address join

ahhhh

it should be in there somewhere, i forgot where it was

I’m doing most stuff in SuiteQL now, way shorter code and faster to write

i was about to say, there is a difference between the address and addressbook

yes, I knew that

but for what you actually want to do, you may want to try unsetting the address text field before you go through all the trouble of resetting fields

All I needed is a way to retrieve that ID. This seems to work

SELECT internalid from entityaddressbook WHERE entity = 16357 AND defaultbilling = 'T'