Hi everyone - I attempting to create a sales order through a SuiteScript, and I'm encountering an error:

INVALID_NUMBER You entered "ERROR: Field 'rate2' Not Found" into a field where a numeric value was expected. Please go back and change this value to a number.

I can't find any documentation on this field or this error though. I'm not entering that message anywhere. I'm only setting item, rate, quantity, description, and taxcode for the line item in the salesorder. Only possible thought is that "rate" is a 0 value What I'm thinking is happening is another SuiteScript is running downstream of my call to

nlapiSubmitRecord

doing validation, and then incorrectly placing a string (error message) into a field that is expecting a numeric value.

@bpieslak this sounds like it could be a formula field, I'd check your custom columns and see if any have a default value of {rate2}

thanks @jmacdonald. I'm thinking that as well. It's been problematic trying to hunt down the custom column or any other custom scripts that reference "rate2"

Yeah it might be a bit of a manual process to go through your custom fields to find the reference to it. I've never come across the rate2 field before.

sandbox was refreshed recently so I'm wondering if something is "corrupt" in there. I'm going to see if I can deploy my simple test RESTlet on PROD and run it, just to compare behaviors.