Getting this error for some reason from this code:...
# suitescript
n
Getting this error for some reason from this code: if (configSettings.showchildinvoices == true) {                     invoicefilter.push("AND", [["customermain.internalid","is", companyid],                     "OR",                     ["customermain.parent", "is", companyid]]);                 } else {                     invoicefilter.push("AND", ["customermain.internalid","is", companyid]);                 } An nlobjSearchFilter contains an invalid join ID, or is not in proper syntax: internalid
b
is companyid valid?
n
yes it is
b
filters look nomral
i would start the normal debugging process of hardcoding the companyid
and using only one of those filters at a time
n
okay makes sense. I'll give that a try. thanks!
The fix was changing it to customer.internalid and changing "is" to "anyof"