Query
How to find the Default customer address in transaction search, which is shown in the customer body level.
As of now if we add the address then the search will show all the addresses from the customer record.
Solution
To get the default customer address, adding the normal address field from a customer join inner transaction search is not possible. So for the same we need to navigate to the customer join and then. See there is a field Callers default billing address. Yeah, you yes or no. So we need to build a new skill formula such a way that the default billing addresses yes, then show the customer address. If we use that formula then it will show only the customer address which is the default one and in NetSuite by default the body address will be shown. So that is the client requirement and by using this SQL statement we will be able to pull this address in this and we may need to group the server such depending upon the requirement.