Hello, I could use some help with a Netsuite Saved Search. I am attempting to add all addresses from the address subtab of the vendor record in a search of all active vendors. I have added columns for "Shipping" address fields and "Billing" address fields. However, when attempting to add any additional addresses, I am encountering an additional line for that vendor which has the shipping and billing address fields and then a Null value in the Additional Address fields. Then there is a line for each additional address that is not checked as default shipping and/or default billing. I have created a sample in the attachments where that particular customer has three addresses on their address subtab. One is checked as the Default Billing, another is checked as the Default Shipping, and a third address is present but not a billing or shipping address. To bring up the additional address field(s), I am using the following CASE WHEN statement: CASE WHEN {address.isdefaultbilling} = 'F' AND {address.isdefaultshipping} = 'F' THEN {address.address1} ELSE NULL END Attached are screenshots of the Saved Search Results Settings and an example of the results:

one approach would be to just use the Address as the Join which will list all the addresses. Then you could use a CASE WHEN to indicated if it is Billing, Shipping address. Then no need to use the Billing & Shipping fields. This keeps you closer to the way the actual data is stored on the Vendors.

Thank you! I was able to test with just adding one line that is Address : Address 1, a line that is Address : Default Billing Address, and Address : Default Shipping Address and actually didn't even need a CASE WHEN statement. Now I get the same iterating list of vendor record with however many addresses exist on the address tab and two columns which show whether they are default billing or shipping or both. This seems to be what the recipient wants so that totally works. Thanks again.