Level 2

Convert Home Currency to Foreign Currency

Hi, I need to run reporting for a foreign company  in the foreign currency (CAD). I have the foreign currency set up and we download rates. I even understand home currency adjustments. I have no problem converting to USD when the item is paid or received in CAD. My problem is that we have some expenses that we pay in USD (home currency) and need to convert that USD number to CAD for reporting purposes. I just cannot figure out how to report the other way around. When I run a general ledger showing "foreign amount", "foreign balance", "currency" and "exchange rate" columns, anything that was paid in USD, has an exchange rate of "1" instead of the rate from USD to CAD, and is calculated as such. Of course, the CAD items show the correct CAD to USD rate and are calculated as such.  Thanks!