When using Exchange Rates, you always need to use the same table for all inserts. In other words the final Insert should be to InvoiceLine without the FQSaveToCache or with FQSaveToCache set to false. You cannot use both InvoiceLine and Invoice.
For example, this insert created a invoice using the exchange rate of 1.4222 I specified:
INSERT INTO InvoiceLine (CustomerRefListID, InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineRate, InvoiceLineClassRefListID, InvoiceLineAmount, InvoiceLineTaxCodeRefListID, ExchangeRate, FQSaveToCache) VALUES ('2E0000-1197674120','2B0000-1197674351', 'QODBC v7 Driver for QuickBooks 2007', 1, 199, '30000-1045538607', 199, '70000-1045536338', 1.4222, 0)
|