Hello everyone, I'm trying to retrieve the text from billing address' state (note: this is a dropdown in address book) for vendor records in a FreeMarker template. The {entity.statedisplayname} currently fetches the state text from the vendor's shipping address. Does anyone have suggestions on how to obtain the text for the billing address state of the vendor? Additionally, please take note that {entity.address1}, {entity.address2}, and {entity.state} are all pulling details from the shipping address. I'm curious why NetSuite automatically takes this information from the shipping address rather than the billing address.

did you try {entity.billingaddress} ?

Thankyou @Jim Schweder. but I need the state's text which is a dropdown . {entity.billstate} returns the value of that dropdown.

Instead of WI you want Wisconsin?

yes Jim, thats correct.

think you're going to have to use a lookup. either an in-template lookup, or a custom body field =/

@David B Is correct. I remember finding from another added module a State Name custom table and I used that. If you don't have one in your instance you will need to create one. Here is an example within FreeMarker:

<#function state_name state_id>

   <#assign my_state_name = "" />
   <#if state_name = "WI">
         <#assign my_state_name  = "Wisconsin" />
   <#elseif state_name = "AZ"> 
         <#assign my_state_name  = "Arizona" />
   </#if>
 
   <#return my_state_name />
</#function>

Then call it via

${state_name("${entity.state}")}

Thankyou @David B and @Jim Schweder for your efforts in providing answers. I'll adopt this approach.