Currently as part of the advanced PDF invoice template that we use, there is a invoice summary at the bottom of the invoice which lists the subtotal, VAT amount, grand total etc. On the VAT line of this summary, we have some hardcoded text which states the tax rate applied to the invoice. This is hardcoded but based on the bill to country of the customer. So for example if the invoice relates to a UK address, the text that appears next to the VAT line is 'VAT (20%)'.
Now the VAT rate has recently changed in South Africa from 14% to 15% as of 1st April. Therefore there will still be invoices that need to have the VAT stated as 14% and some where it will be stated as 15%. Is there a way to dynamically link the PDF form to the invoice so that it picks up the rate from within the actual invoice rather than based on the bill to currency? I'm not concerned about the actual amount on the invoice, but the text which appears on the VAT line in the summary.
Currently the code on the template is:
<!-- If billing country is South Africa then VAT registration is in process -->
<#elseif record.billcountry = "ZA">
<td align="right" rowspan="2" colspan="4">We are currently registering for VAT. Once issued with our Registration Number, we will issue a TAX INVOICE and charge VAT at the prevailing rate on the above net balance.<br/></td>
<td align="right"><b>VAT (14%)</b></td>
I'd like to change the part that has VAT (14%) to a link to the rate within the invoice. Only issue I can see is that the invoice may have multiple lines on it. Only other way I can see would be to have the code look atthe invoice date, and if that was prior to 1st April 2018, state 'VAT (14%)' and if the date is after 1st April 2018, state 'VAT (15%)'. If so, how would that code look?
Many thanks in advance!
James