The exchange rate is a field available on invoices. So yes, it's just a standard formula - multiply the two fields together. Not sure that will work. Let me give an example: So I have an invoice which is in GBP. It has a subtotal of £24,500, tax of £4,900 and a total of £29,400. The exchange rate on the invoice (under the…

Indeed there isn't a straight-up field that tell you. But, to resolve, just multiply the tax amount by the exchange rate. Thanks! However the invoices may be in multiple currencies (GBP, AUS, EUR, NZD) so I'd have to use a different exchange rate for each currency depending on what the invoice currency was. Can that be…

When I've had this problem, it's because I didn't tell the import I was using an internal id. Use the pencil to tell the import you're sending an internal and not the name. Be sure to use the internal id for both the item and the subsidiary. It resolves a lot of problems. Thanks for this. I've used exactly the same csv…

I recently did a similar for a UK customer needing to print other details depending upon the destination country and currency. I put my formula into a Do Not Store custom field on the transaction record. On the PDF layout I just displayed this field, not the content. In your formula bring in the {taxamount}. Would it work…

The line item(s) on the invoice should have the taxrate at the time of the transaction. Assuming there's only one tax rate on the line you could just grab the tax rate from the line item. [CODE] <#assign taxRate = ''> <!-- in the template block where you iterate the item sublist --> <#if !taxRate?has_content> <#assign…