Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit. when i add this RIGHT({inventorynumber},2) for the inventorynumer.inventorynumber

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the users are having issues with their formulas in NetSuite. The errors could be due to syntax errors, incorrect use of functions, or datatype mismatches. In the first conversation, the user was getting an invalid formula error. The other users suggested testing the subtraction in another formula and using SQL functions to convert the data if necessary. They also suggested using the

TO_CHAR

or

TO_NUMBER

functions to convert the data, and the

NVL

function instead of the

CASE

statement. In the second conversation, the user was getting an error with their item saved search formula. The other users pointed out that there was a missing closing quote in the formula and suggested using the

NVL

function if fixing the quote didn't solve the problem. They also suggested using brackets to make the AND and OR operations clearer. In the third conversation, the user was trying to find the quantity on hand for 3 locations but was getting an error. The other users pointed out that the user was using parentheses without a function and suggested doing an inventory item search and setting filters to the 3 inventory locations. They also suggested adding the inventory location quantity column and an internal id column, grouping by internal id, and summing the quantity column. The user was also advised to use a formula to show the location quantity on hand when the inventory location is a certain value, otherwise show 0. Remember to always double-check your formulas for syntax errors, ensure you're using the correct functions, and make sure your data types match to avoid errors. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******