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

CASE WHEN {currency} is CAD THEN {customer.balance} ELSE {{customer.balance}}/{exchangerate} END



can this sort of a statement be used??

probably requires a bit of work and troubleshooting, but something like that could probably be done

should note - that the main concept is flawed though.

the primary issue you're going to encounter is "what" exchange rate you use - if you use the transaction exchange rate, it's not a reflection of the current date and what is outstanding.

<@UER9Q3SGM> thanks - I am able to work the logic with the exchange rate by itself. however when I add the statement it says invalid expression.

you also might want to dump the currency field in a formula text to see what it spits out.

thanks for the ideas <@UER9Q3SGM>. this is what worked


`CASE`
  `WHEN {currency} = 'CAD'`
  `THEN {customer.balance}`
  `ELSE {customer.balance}/NULLIF({exchangerate}, 0)`
`END`