build a saved search of vendor shipping addresses

AI generated answer (using internal Slack threads):

To build a saved search of vendor shipping addresses in NetSuite, you can follow these steps: 1. Navigate to

Reports > Saved Searches > All Saved Searches > New

. 2. Select

Vendor

from the list. 3. In the

Criteria

tab, you can set any specific criteria you want to filter your vendors by. If you want all vendors, you don't need to set any criteria. 4. In the

Results

tab, add the following fields: -

Name

(This is the vendor name) -

Shipping Address

(This will give you the full shipping address) -

Shipping Country

,

Shipping State

,

Shipping City

,

Shipping Zip

(These will give you the individual components of the shipping address) 5. Save and run the search. This will give you a list of all vendors along with their shipping addresses. If you want to identify vendors who have their default billing address with the "Override" checkbox checked, unfortunately, this field is not directly exposed in saved searches. However, you can use a formula to compare the

Address

field with the concatenated

Addressee

,

Address 1

,

Address 2

, etc. fields. If they are not equal, it means the "Override" checkbox is checked. Please note that this method might not be 100% accurate as there could be other reasons for the

Address

and

Addressee || Address 1 || Address 2 + ...

fields to not match. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******