i have a saved search that shows all of the vendor invoices and their respective amounts. The problem I am having is that if the vendor invoice is in CAD (ie. foreign currency) it is showing the amount in USD. How can I fix this? In my vendor invoice the item amount column is showing the correct amount (in CAD). Also, the invoice is for a subsidiary that is in CAD.

Use

Amount (Foreign Currency)

instead of

Amount

perfect! thanks!