New SDK v7.0 Features have been added to QODBC for QuickBooks 2008 (USA Edition)
- Added WorkersCompCode and WorkersCompCodeRateHistory history tables
- Added Unit of Measure in Estimate, SalesOrder, CreditMemo, ReceivePayment, PurchaseOrder, Bill, ItemReceipt, VendorCredit, Check, CreditCardCharge, and CreditCardCredit
- Added ManufacturePart to PurchaseOrder
- Added PriceLevel and ShipAddress to Estimate
- Added new CreditCard fields in SalesReceipt, CreditMemo, ARRefundCreditCard and ReceivePayment
- Added ability to modify a Deposit
- Added MarkPendingIfRequired to BuildAssembly table
- Added SubscribedServices to Company table
The following fixes have also be applied to 8.00.00.235:
- Added support for pass through of most date and time functions when using multiple tables (QSupport Ticket ID#BR00000070). This query returned 161 rows in seconds:
SELECT BillPaymentCheckLine.TxnDate as Date, BillPaymentCheckLine.RefNumber as Number, BillPaymentCheckLine.AppliedToTxnAmount as Payment, BillPaymentCheckLine.AppliedToTxnDiscountAmount as Discount FROM Bill , BillPaymentCheckLine Where Bill.TxnID=BillPaymentCheckLine.AppliedToTxnTXNID
but when I added current time to prove how fast things now run using the new BillPaymentCheckLine_FQSPECIAL06 optimizer index, this query took nearly three minutes:
SELECT {fn CURTIME()} AS "RowTime", BillPaymentCheckLine.TxnDate as Date, BillPaymentCheckLine.RefNumber as Number, BillPaymentCheckLine.AppliedToTxnAmount as Payment, BillPaymentCheckLine.AppliedToTxnDiscountAmount as Discount FROM Bill , BillPaymentCheckLine Where Bill.TxnID=BillPaymentCheckLine.AppliedToTxnTXNID
Adding {fn CURTIME()} chokes v8.00.00.234, but is now fixed with 235.
- Added CheckApplyCheckToTxn table to allow a check to be applied to a CreditMemo
- Fixed issue with Item, Entity and Terms table when iterators are not used in non-USA versions of QuickBooks. QODBC will now turn off chunking when iterators are not used on these tables only (QSupport Ticket ID#BR00000071). See: Item Table Truncated by default CHUNK value
- Corrected an issue with MS Access and too many indexes on some tables. The function SQLStatistics is now limited to returning 32 segements which is all Access can handle. These tables had too many indexes:
CreditMemoLine CreditMemoLinkedTxn EstimateLine InvoiceLine InvoiceLInkedTxn PurchaseOrderLine Sales SalesLine SalesOrderLine SalesOrderLInkedTxn SalesReceiptLine
To get the correct index information use the sp_statistics tablename stored procedure instead (QSupport Ticket ID#BR00000072). See: Too Many Indexes Error , Access 2007 linked tables and Access 2007 link tables crash.
|