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.234 FixesSearch Forum

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

 New Topic 
 
 Post Reply 
 Release 8.0.0.234 Fixes 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-24 23:24:12

QODBC Release 8.0 now supports QuickBooks 2008 for USA and UK, and the QuickBooks SDK version 7.0 and includes the following new features and fixes:

  • New table AccountTaxLineInfo
  • PaymentMethodType added to PaymentMethod table.
  • New tables UnitOfMeasureSet, UnitOfMeasureSetRelatedUnit and UnitOfMeasureSetDefaultUnit.
  • UnitOfMeasure in Invoice, and Item tables.
  • ManufacturerPartNumber in item tables

     

  • Added support fields for sp_reports that included SUMMARIZE_ROWS_BY. These new fields only contain data when a specific SUMMARIZE_ROWS_BY item is selected. But these new fields relate to other tables.
  • Corrected some licensing issues regarding requiring Enterprise Version when either licensed or running Remote Connector. (QSupport Ticket ID#BR00000067, see: Problem Scheduling Package in SQL 2005  and Error: "Only Licensed for use with Enterprise Version" )
  • Modified how SQLStatistics returned index information. Added sp_statistics tableaname stored procedure so can be run from VBDemo32. (QSupport Ticket ID#ER00000017, see: BillExpenseLine Query taking a very long time )

    Using sp_statistics BillPaymentCheckLine we can see that there is now a special QODBC optimized index to use for the AppliedToTxnTxnID lookups for bill payments:

  • UK schema and licensing corrections for version 2008.
  • Added the column INSERT_ONLY to the sp_tables stored procedures. This column indicates if the table is used for inserts only.
  • Added the column ON_WHEN_SUMMARIZE_ROWS_BY to the sp_column stored procedure. This column lists what value SummarizeRowsBy must be for the column not to return NULLs.
  • Changed the Nag screen for reminding users of Version 2008 and 2009 to upgrade.
  • Removed sending a Z on date formats where GMT offset was not available.
  • Corrected an issue with sp_reports and ReportModifiedDateRangeFilter being spelled incorrectly (QSupport Ticket ID:BR00000068, see: possible bug "sp_report CustomTxnDetail" ModifiedDateFrom and ModifiedDateTo )
 

  Top 
 New Topic 
 
 Post Reply 

Jump to