[QODBC-Desktop] Foreign Currency and Exchange Rates
Posted by brad waddell on 12 March 2009 05:21 PM
Instructions for Foreign Currency
Foreign currency is supported in versions of QuickBooks that support it. The stored procedure reports in QODBC "sp_report" shows the foreign currency type in the "Account" column. For example, in this report :
An Example of Seeing Exchange Rate in Foreign Currency Transaction
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 would apply to the Canadian $ Bank Account (boxed in red below)!
Foreign currency comes into play when a customer pays you a Foreign Amount, or you pay a Foreign Amount. For example (here take accounts receivable and accounts payable as an example):
SELECT TxnID, ARAccountRefFullName, DepositToAccountRefFullName,
SELECT BillLinkedTxn.TxnID, BillLinkedTxn.APAccountRefFullName,
Note: A number of QODBC tables contain an ExchangeRate column when used with non-USA editions of QuickBooks.
See an example of how to create an invoice using exchange rates below.
An example of Creating an Invoice Using Exchange Rates
Note: When using Exchange Rates, you always need to use the same table for all inserts. In other words, the final insert should be InvoiceLine without the FQSaveToCache or with FQSaveToCache set to false. You cannot use both InvoiceLine and Invoice.
Query in QODBC
For example, this insert created an Invoice using the exchange rate of 1.4222 specified:
INSERT INTO InvoiceLine (CustomerRefListID, InvoiceLineItemRefListID, InvoiceLineDesc,
Result in QuickBooks