On an Item search formula, I'm getting an unrecognized field error for my formula, "Your formula has an unrecognized field in it. Please go back and correct the formula and resubmit.". It's definitely about the {conversionrate} field reference, since I used process of elimination to make sure it wasn't the other field references in the formula. The SuiteScript records browser shows conversionrate as a valid Filter and Column, but the formula doesn't seem to like it. What can I put there that evaluates to the same thing?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the issue you're facing is related to the context in which the field is being used. In NetSuite, the context of the field matters. If you're using a field in a formula, it needs to be in the correct context. In your case, you're trying to use the

{conversionrate}

field in an Item search formula. However, the

{conversionrate}

field might not be directly accessible in the context of an Item search. One possible solution could be to use a join to access the

{conversionrate}

field. For example, if the

{conversionrate}

field is related to a transaction, you might need to use

{transaction.conversionrate}

instead of just

{conversionrate}

. Please note that the exact join you need to use will depend on the specific relationship between the Item and the

{conversionrate}

field in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******