Hi All,
I'm making some amendments to our Invoice PDF templates in relation to our APAC subsidiary. The subsidiary currency is USD. Currently when the invoices are produced the Finance team add a section to the invoice which converts the USD totals on the invoice to SGD and also states the exchange rate, as follows:
Subtotal (SGD) 82,676.36
GST @ 7% (SGD) 5,787.34
Total (SGD) 88,463.70
Exchange rate 1.3456
I'd like to automate this and include this within the actual PDF template so that it's not a manual task. However because the subsidiary is in USD, the exchange rate doesn't currently appear anywhere on the invoice. Therefore I feel I have two options.
1. Try to pull in the exchange rate (the rate as of the invoice date) into the PDF template and then use that to calculate the SGD values as above.
2. Add an additional field to the invoice form which is populated with the exchange rate via script, and then this can be used for calculations and to populate on the PDF template.
So basically my question is, is it possible to access the exchange rate tables directly from the PDF template, and pull in the correct daily value into the template so that I can state it on the printed invoice and use it to calculate the correct SGD amounts?
Many thanks for any help!