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

I would like to multiply the "amount" field with "multibook bla bla exchange rate" field but I'm not sure what the exact formula should be since {amount}*{exchange rate} returns Invalid Expression. Any ideas?

Remove the space between exchange and rate and I think you should be good.  No NS field references will have spaces.

Also if you want to pull the FX rate from the Multibook join, you'll need to go get the joined field via pulling the ... fields at the bottom of the field list.  So your formula will look something like {amount}*{accountingbook.exchangerate}.  Note that's probably not right.  You'll have to get the proper accounting book join.  that was off the top of my head.