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

If someone want to double check and in the process help my sanity:
• Transaction Search, Type Sales Order, Main Line = True.
• If you try to filter by Billing Address...(join) Internal ID or Custom Field on the Address record it does not work.
• If you try to return as a result Billing Address...(join) Custom Field or Internal ID it does not return anything(empty column).

```require(["N/search"], function (search) {
  var searchResult = search
    .create({
      type: "transaction",
      filters: [
        ["mainline", "is", "T"],
        "AND",
        ["type", "is", "SalesOrd"],
        "AND",
        ["billingaddress.internalid", "is", "616"],
      ],
      columns: [{ join: "billingaddress", name: "internalid" }],
    })
    .run()
    .getRange({ start: 0, end: 1000 })[0];

  log.debug('searchResult', searchResult);
});```

<@U5TF1GQ20> Test that in the UI or an actual script and let me know, I assume is a bug and it does not work for me...

Maybe specific bug to the account I'm using.

only minor change to the logging:
```console.debug('searchResult', searchResult.toJSON());```