ANS-1357 · PURCHASE & VENDOR MANAGEMENT
How to Customize Vendor Address Display on NetSuite Bill Payments
NetSuite users can customize transaction body fields to display vendor address details directly on purchase transactions, enhancing visibility.
Short answer
To display vendor address information on NetSuite purchase transactions, create custom transaction body fields. Configure these fields to source data from the vendor record, potentially for individual address lines or a combined address. This workaround provides visibility into vendor addresses directly on transaction forms, addressing the need for readily accessible address details.
Scenario
Users often require vendor address details to be visible directly on NetSuite purchase transactions, such as vendor bills or bill payments. The standard NetSuite interface may not always expose specific address components or a consolidated address field on these forms, leading to a need for customization to enhance data accessibility and operational efficiency.
Solution
While direct exposure of an 'Address' tab on 'Enter Bills' transactions, similar to sales orders, may not be straightforward due to how address data is now handled in NetSuite (often via sublists and subrecords), a common workaround involves creating custom transaction body fields to display vendor address information. This approach provides visibility into vendor addresses directly on transaction forms. Option 1: Displaying Individual Address Lines To display individual address components (e.g., Address 1, Address 2, City, State, Zip), create separate custom transaction body fields:
Navigate to
Setup > Customization > Transaction Body Fields > New.Set 'Applies To' to
Purchases.On the 'Display' tab, select the desired 'Subtab' where the field should appear.
On the 'Sourcing and Filtering' tab, set 'Source List' to
Vendor. Note: Directly sourcing individual address lines (e.g., 'Address 1', 'Address 2', 'City', 'State', 'Zip') as simple 'Source From' options may require advanced configuration or scripting due to address data being stored as subrecords. 5.Savethe custom field. Repeat this process for each address component (Address 2, City, State, and Zip) you wish to display. Option 2: Displaying the Entire Bill To / Ship To Address To display a consolidated 'Bill To / Ship To' address, create a custom transaction body field of type 'Text Area':Navigate to
Setup > Customization > Transaction Body Fields > New.Set 'Type' to
Text Area.Set 'Applies To' to
Purchases.On the 'Display' tab, select the desired 'Subtab' where the field should appear.
On the 'Sourcing and Filtering' tab, set 'Source List' to
Vendor. Note: Directly sourcing a combined 'Bill To/Ship To' address as a simple 'Source From' option may require advanced configuration or scripting due to address data being stored as subrecords. 6.Savethe custom field.
Expert NetSuite Support
Need help with this NetSuite issue?
Purchase & Vendor Management consulting and configuration support