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)

adding exchange rate field
Preview of the invoice:

Preview of invoice

To enhance it, user can consider amending the coding to:

"1SGD : " + if(transaction.exchangerate = 0, CurrencyConvert (1, BaseCurrency, Currency,transdate), exchangeRate) +Transaction.Currency

Preview of invoice
This will give a clearer picture as to 1 Home Currency (in this case is SGD) is equal to “x” foreign currency.

 

 

Comments are closed.