Hi All,
I', trying to do a really simple saved search to pull out a list of invoices for certain subsidiaries. I need the invoice net amount and tax amount in both the system currency (USD) and also the foreign currency. I can get the invoice total in the foreign currency as well as the net, tax and gross in the system currency, but can't manage to pull out the invoice tax amount in foreign currency, even though it appears on both the line item level and in the header. Is there a way to do this? I've looked through all the available fields in the results and can't find one which gives me the tax amount in foreign currency.
Many thanks
James