https://netsuiteprofessionals.com logo
Join Slack
Powered by
```{"type":"error.SuiteScriptError","name":"SSS_IN...
# suitescript
m
Copy code
{"type":"error.SuiteScriptError","name":"SSS_INVALID_SRCH_COL","message":"An nlobjSearchColumn contains an invalid column, or is not in proper syntax: subtotal."}]
m
the column you are referencing is not a valid one for the search you are trying to perform. double check the records browser to see what columns are available https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/script/record/account.html
m
@meang Thanks for you response, I have double subtotal column exist in record browser https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/script/record/salesorder.html
a
Why are you guys using the 2016 record browser? Netsuite changed a lot since 2016 for what concern record structure...
m
@Andrea Rivetti Thanks for you info but i have checked even 2019 record browser field subtotal exist with the same name in salesorder record browser
a
Sometime it happen which specific fields are available as filter but not as column, but only in specific types/subtypes. The example I have in mind now is for example the VAT reg number which is available in a customer search but not in an entity search. So, first of all: Are you using a saved search behind which show EXTRACT that field?
Are you able to get what you want from the UI?
e
The fields on the record are not the same as the filters/columns in a search
If you are trying to retrieve Search Columns, then you need to use the Search Columns section for the record type, not the Fields
Sales Orders have a search type of 
transaction
, and 
subtotal
is not a valid Search Column for `transaction`: https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/script/record/transaction.html
a
And usually "live data" fields are never available as a search column
m
got it, Thanks Buddy.
6 Views
Open in Slack
PreviousNext
Powered by