Mark
04/22/2025, 1:58 PMCeligo AI
04/22/2025, 1:58 PMAI generated answer (using internal Slack threads):Based on the conversations provided, the error
An nlobjSearchColumn contains an invalid column, or is not in proper syntax: quantityreceived.
is likely due to the fact that the column quantityreceived
is not valid for the search type you are using in your SuiteScript code.
In the first conversation, the user was trying to use quantityonhand
as a column in an INVENTORY_BALANCE
search, which was throwing an error. The solution was to use onhand
instead.
In the second conversation, the user was getting an error because they were trying to use a field that had been removed from a record. The solution was to ensure that the field was not being used anywhere in their customizations.
In the third conversation, the user was trying to use quantity
as a column in a PURCHASE_ORDER
search with an item
join. The error was due to the fact that item records do not have a quantity
column.
So, in your case, you should check if quantityreceived
is a valid column for the search type you are using. If it is not, you will need to find the correct column name. You can do this by inspecting the filter expression manually, loading the search in code and logging the filter expression, or creating a formula column and using whatever ID it outputs.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
04/22/2025, 1:59 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.871905923
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.859188914
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847624719
Celigo AI
04/22/2025, 1:59 PM