Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Release 8.0.0.235 FixesSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Updates and Bug Fixes

 New Topic 
 
 Post Reply 
[1]  
 Release 8.0.0.235 Fixes 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-13 10:53:05

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. 
 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-13 11:13:18
A new fix revision is now available for immediate download, see: Release 8.0.0.236 Fixes for more information. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to