This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

except pulling the correct internal id for the shipping cost field you're trying to get

<@UAC8528QK> Tried it and a couple other simple variations like 0-{shippingcost}. But I think there must be some other required syntax because I keep getting the same error: "You have entered an Invalid Field Value ERROR: Invalid Expression for the following field: discountrate". I've even simply entered {shippingcost} alone into the formula field and got this same error. (That is the correct internal id, by the way!)

I think that's what I need help formulating. I'm trying to pull the value from my {shippingcost} field and use it to populate my discount rate field, but negative.

invalid expression usually means 1 of 2 things, either invalid sql or invalid value for a field

none of the solutions offered to you are invalid sql, which suggests invalid value

what is the value of the shipping cost on the record you are testing

The workflow works when I pull the value from the specified field... except that it's positive.

So I'm trying to pull that same field value and make it negative, via a formula.

tried it out myself, couldn't get it to work

It may be a negative number issue. I don’t have it open in front of me but I believe a positive discount amount is required to reduce the cost of the invoice. 

<@UFEGE2TV1> I thought this too but when I was pulling the the positive discount amount it was increasing the invoice, essentially doubling the freight amount instead of washing it out.

at this point, i would say writing a script, or at least a workflow action script