transfer order search via suitescript: "error": "A...
# ask-stanley-ai
m
transfer order search via suitescript: "error": "An nlobjSearchColumn contains an invalid column, or is not in proper syntax: quantityreceived."
c
AI 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. ******
Slack 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
Please provide your feedback on this answer.