Adding exchange rate field into the Invoice template
Software: MoneyWorks accounting software
User can use Transaction.ExchangeRate field in the Sales Invoice template to print out the exchange rate used in the Sales Invoice transaction. However, Transaction.ExchangeRate field only applied to those invoices that were posted.
For users who wanted to print out the exchange rate used in the Sales Invoice transaction for Unposted Sales Invoice transaction, you can consider to use this code in your field calculation box:
if(transaction.exchangerate = 0, CurrencyConvert (1, BaseCurrency, Currency,transdate), exchangeRate)
Preview of the invoice:
To enhance it, user can consider amending the coding to:
"1SGD : " + if(transaction.exchangerate = 0, CurrencyConvert (1, BaseCurrency, Currency,transdate), exchangeRate) +Transaction.Currency
This will give a clearer picture as to 1 Home Currency (in this case is SGD) is equal to “x” foreign currency.