how this is an invalid expression ina a saved search {locationquantityonhand} - {custitem10}

AI generated answer (using internal Slack threads):

The expression

{locationquantityonhand} - {custitem10}

is invalid in a saved search because NetSuite does not allow arithmetic operations between two fields directly in a saved search formula. In NetSuite saved searches, you can't directly subtract one field from another. You would need to use a SQL function to perform this operation. For example, you could use the

NVL

function to handle any null values and then perform the subtraction. The

NVL

function replaces null values with a specified replacement value. Here's how you could write it:

NVL({locationquantityonhand}, 0) - NVL({custitem10}, 0)

This will replace any null values in either field with 0, and then perform the subtraction. Remember, the field names must be correct and they should be numeric fields. If

{custitem10}

is not a numeric field, you will get an error. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******