This is not as simple as it sounds. For example I can pay the Foreign Amount into my USD$ Bank Account or my Canadian $ Bank Account and the Exchange Rate would not apply to the USD$ Bank Account but it would apply to the Canadian $ Bank Account (boxed in red below)!
Foreign Currency really comes into play when a customer pays you a Foreign Amount or you pay a Foreign Amount. For example:
ACCOUNTS RECEIVEABLE SELECT TxnID, ARAccountRefFullName, DepositToAccountRefFullName, AppliedToTxnRefNumber, AppliedToTxnAmount, ExchangeRate FROM ReceivePaymentLine where CustomerRefFullName='FLEXquarters.com LLC'
ACCOUNTS PAYABLE SELECT BillLinkedTxn.TxnID, BillLinkedTxn.APAccountRefFullName, BillPaymentCheck.BankAccountRefFullName, BillLinkedTxn.RefNumber, BillPaymentCheck.Amount, BillLinkedTxn.ExchangeRate FROM BillLinkedTxn, BillPaymentCheck where BillLinkedTxn.LinkedTxnTxnID = BillPaymentCheck.TxnID and BillLinkedTxn.VendorRefFullName='Intuit'
A number of QODBC tables also contain a ExchangeRate column when used with non-USA editions of QuickBooks.
See also: How do I create an Invoice using Exchange Rates? |