When creating VAT mappings in the InvoiceConnect, it is helpful to use a conditional similar to the following:
where 48 refers to the ordinal number from the extract that displays the VAT amount. Without the LineNumber conditional, the connector will display the VAT amount for every line item on that invoice, thereby multiplying the VAT tax that is recorded.
If a client has more than one ordinal displaying VAT amounts, you can use the addition function to add all the fields together such as this:
I once had to do this for a Canadian client who had GST, PST, and HST that all needed to be accounted for.