We need to send Quotes for one of our business lin...
# general
b
We need to send Quotes for one of our business lines at a gross amount. All of our transaction amounts are at net. We don't use the Netsuite discounting. I created two custom fields - one line and one body - that are calculations of the amount.line and amount fields. I'm trying to populate them with a workflow. I've been successful with the custom.line field but not the custom.body field. Both are stored fields. I'm getting the error when saving the quote.
Copy code
You have entered an Invalid Field Value ERROR: Field 'amount' Not Found for the following field: custbody_che_agency_gross_trx
The formula I'm using in the WF is: {amount}/.85. It's the {amount} field that it doesn't like - I've tried just {amount} and it errors. I've hard coded a value in the formula and it works. Do I need to change the custom body field to non-stored and use a saved search and WF to calculate it? I thought since {amount} was a standard field that already summed the line items, I could use it. Any help is appreciated. Thanks.