This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Random question - both of the Sales Order Billing Address and Shipping address tables have a bunch of duplicates with no way to distinguish between them, anyone seen that before?

<@U05D7P8LWEA> are you building a dataset? If yes, based on what record?

You may try and add 'default billing' and 'default shipping' columns to see if these checkboxes can eliminate duplicates

It ties to transactions on salesorder billing address

but in those tables theres like 3-10 rows per addreess

you may be getting multiple results based on the number of lines on the transaction

try adding in line id (or other fields) from the tables you're using to see if that elucidates the duplicates

a long time ago i had a weird result where it was duplicating based on languages i think

though that was likely a saved search, not a dataset

the weird thing is in the shipping/billing table

it’s just like “record owner = 11” and they’ll be 10 lines

with no way to distinguish them and they’re all the same

I just removed the duplicates but that always feels like a bandaid and not fixing the real problem

you're starting from the transactions table though right? can you share a screenshot?

but the billing/shipping address only has 1 “record owner” that duplicates