Currency description and currency code on sales invoice template

Software: MoneyWorks accounting software

It’s important to show the currency code or currency name in invoices if you are trading in multiple currencies. Showing USD100,000, EUR100,000 or S$100,000 is better than printing 100,000 alone on the sales invoice (it’s much clearer to the recipient). The default sales invoice template in MoneyWorks accounting software has the built-in formula which prints the transaction gross with a currency code in front.

Below is the formula in the default template such as Product1, which you can copy and paste it to the custom template you have created.

CurrencyFormat (Transaction.Gross, Transaction.Currency)

However, if you prefer to have a transaction gross in English on the sales invoice, you can add a calculation box field with a formula:

Lookup (Transaction.Currency, “Offledger.description”) + ” ” + NumToEnglish (Transaction.Gross) + ” Only”

this formula will print the transaction gross of USD100,000 in English as ‘UD dollars One hundred thousand Only’.

Currency name and code

You can also add a currency field on the sales invoice showing the currency (currency description) used. The formula for the calculation box is:

Lookup (Transaction.Currency, “Offledger.description”)

This formula prints the currency name such as US dollars, EURO, Malaysia Ringgit, etc. (Use the Transaction Currency field alone without any function if you prefer to show only the currency code instead of the currency description on invoice). It is good to indicate the currency used on the Sales Invoice to omit discrepancy.

 

Comments are closed.