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

Hey, quick question about NetSuite.
 I used to be able to join `vendor` in a `transaction` search — transactions without a vendor still showed up (with the field empty).
Now it looks like the join works as *INNER JOIN*, so those transactions are missing.
 Do you know if this is a bug or if something changed?
```search.create({
    type: "transaction",
    filters: [
        ["type","anyof","VendBill","VendCred","VendPymt","Check","Journal","VPrep"]
    ],
    columns: [
        search.createColumn({
            name: "fxbalance",
            join: "vendor"
        })
    ]
});```
 I’m not getting Journals anymore when I join `vendor` in a `transaction` search.
 It used to work before (journals showed up with empty vendor).
 Did NetSuite change something?