<![CDATA[FLEXquarters.com Limited]]> <![CDATA[[QODBC-Desktop] Troubleshooting - How to connect to QuickBooks using PDO]]> Troubleshooting - How to connect to QuickBooks using PDO

Problem Description:

We have a setup connecting a PHP application to QuickBooks with QODBC. This works correctly using odbc_connect.

However, if we try to connect using PDO instead, we get 500 Internal Errors. See the code below:

try{
$conn = new PDO ("odbc:QuickBooks Data QRemote", "", "");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$query = "SELECT * FROM Customer";
#Perform the query

$conn->beginTransaction();
$stmt = $conn->prepare($query);
$stmt->execute();
$conn->commit();
$res = $stmt->fetchAll(PDO::FETCH_ASSOC);

print_r($res);

die(json_encode(array('outcome' => true)));
}
catch(PDOException $ex){
die(json_encode(array('outcome' => false, 'message' => 'Unable to connect')));
}

 

Solution:

To resolve this issue, Please download & install QODBC's latest version, V323 or above, by clicking here.

There is a known issue with the PDO connection when connecting to QRemote using PDO; it does not return the result if you have a lot of records on the table or are fetching all columns (i.e., Select * from TableName).

So instead of selecting all columns using wildcard character *, you need to specify a limited column name & execute the query.

For Example:

Select ListID, FullName, CompanyName, Email, and Balance from the Customer

Select TxnID, CustomerRefFullName, TxnDate, RefNumber, TermsRefFullName, Subtotal, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineRate, InvoiceLineAmount FROM InvoiceLine

If your table contains a lot of data, please use the date filter in your query below.

For Example:

Select TxnID, CustomerRefFullName, TxnDate, RefNumber, TermsRefFullName, Subtotal, InvoiceLineItemRefFullName, InvoiceLineDesc, InvoiceLineQuantity, InvoiceLineRate, InvoiceLineAmount FROM InvoiceLine TxnDate >= {d'2017-06-01'} and TxnDate <= {d'2017-06-30'}

After installing the latest QODBC version, you should able to run the PDO script.

Please use below sample script.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>QODBC PHP Script To Display SQL Results</title>
</head>
<body topmargin="3" leftmargin="3" marginheight="0" marginwidth="0" bgcolor="#ffffff" link="#000066" vlink="#000000" alink="#0000ff" text="#000000">
<table border="0" border="0" bgcolor="lightgreen" bordercolor="black" cellpadding="0" cellspacing="0">
<tr>
<td>
<table border="2" bordercolor="black" bgcolor="white" cellpadding="5" cellspacing="0">
<caption align="top">QODBC PHP Script To Display SQL Results</caption>
<?php
$conn = new PDO ("odbc:QuickBooks Data QRemote", "", "");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
$query = "SELECT TxnID,CustomerRefFullName,TxnDate,RefNumber,BillAddressAddr1,BillAddressAddr2,BillAddressCity,BillAddressState,BillAddressPostalCode,TermsRefFullName,DueDate,Subtotal,InvoiceLineItemRefFullName,InvoiceLineDesc,InvoiceLineQuantity,InvoiceLineRate,InvoiceLineAmount FROM InvoiceLine";
$stmt = $conn->prepare($query);
$stmt->execute();
$colcount = $stmt->columnCount();
foreach ($stmt->fetchall(PDO::FETCH_BOTH) as $row)
{
  echo '<tr>';
  for($i = 0; $i < $colcount;  $i++ ) {
		echo '<td>';
		print_r($row["$i"]);
		echo '</td>';
  }
  echo '</tr>';
}
?>
</table>
</td>
</tr>
</table>
</body>
</html>

 

 

]]> <![CDATA[[QODBC-Desktop] Intuit Announces QuickBooks 2007]]> Intuit Announces QuickBooks 2007

New Features and Integrated Services Solve Small Businesses' Most Important Problems

MOUNTAIN VIEW, Calif.--(BUSINESS WIRE)--Intuit Inc. (Nasdaq: INTU) today announced the availability of QuickBooks® 2007. The new line of products and services focuses on what matters most to small businesses: making day-to-day tasks even easier to complete while adding deeper functionality for specialized and growing companies.

QuickBooks 2007 includes powerful new tools and services that help small businesses succeed in activities beyond accounting. For the first time, Intuit is offering customers integrated tools to market their business and attract new customers, as well as new services that extend QuickBooks' functionality - from accepting credit cards to managing timesheets and running payroll. Combined, these create a robust ecosystem of distinctive solutions to help existing and new-to-the-world businesses be successful.

"No one serves small business and accountants better than Intuit," said Brad Smith, senior vice president of Intuit's Small Business Division. "For nearly 15 years, we have remained laser-focused on ease, continuously improving the market-leading small business management platform. At the same time, we have developed a powerful mix of integrated services that our customers asked us for to help better connect them with their customers, vendors, partners, and employees."

Solutions Beyond Accounting

QuickBooks offers more than 25 products and services beyond core accounting functionality. From QuickBooks Merchant Service for Web Stores to Intuit Small Business Payroll services, customers can leverage their existing QuickBooks data to manage better and market their companies. QuickBooks also offers easy solutions to process payments, such as the QuickBooks Credit Card Processing Kit and the new QuickBooks Time Tracker to easily collect and manage employee timesheets on the Web.

The latest addition to Intuit's comprehensive small business ecosystem is a series of popular marketing tools from Google. The new integrated online tools include Google maps, Google AdWordsT, and the QuickBooks Product Listing Service, designed to solve another critical small business concern - attracting new customers online.

Customers can easily find more than 400 add-on applications that solve specific needs, from sales force automation to eBay integration, through the QuickBooks Solutions Marketplace at: http://www.marketplace.intuit.com.

"Small businesses are increasingly interested in moving from piecemeal solutions to more integrated approaches to company operations," said Merle Sandler, senior research analyst at IDC. "But this can be tricky because small firms also want resources supporting company growth but not being too expensive or difficult to use. With that in mind, Intuit's strategy of extending beyond basic accounting to build a valuable network of available capabilities will resonate with both small businesses and the accountants that serve them."

Focusing on What Matters Most - Ease

QuickBooks 2007 features numerous enhancements that simplify users' most frequent activities, helping the approximate 3.7 million small businesses using the software be more efficient:

  • Easier Setup: To help new users set up their income and expense accounts more accurately, QuickBooks 2007 features a simplified recommended Chart of Accounts. Optional accounts to suit specific business needs can easily be added. The latest version offers users the 30 most commonly-used reports for their business type - reducing the likelihood of incorrectly categorizing expenses down the road.
  • Easier Payroll: The nearly 1 million businesses that use Intuit Small Business Payroll Services can now efficiently run payroll for all their employees at once rather than one at a time. A new dashboard displays the impact of payroll across the business, showing clearly what the company needs to pay employees and the government and what forms they need to file. And a new "review, confirm and submit" process gives users the confidence their payroll is correct and ready to go.
  • Easy Data Sharing with Accountants: It is now easier than ever for accountants to change their clients' company files. At the same time, the business owner continues to work on their day-to-day business transactions without interruption. Previously, if a company needed to send files to an accountant, the business would have to stop entering data into QuickBooks to ensure version control. While the files were with the accountant, the business could not process financial information, including invoices, bills, or payroll. With the new Dividing Date functionality, QuickBooks allows accountants to edit and review all information before a specified date while allowing the company to continue business as usual. When the accountant is done with the adjustment, the business owner can quickly review and import those changes directly into QuickBooks.
  • Easier Customization: Small businesses rely on forms to communicate with customers, suppliers, and partners. On average, a small business uses 168 forms per month, including invoices, letters, and purchase orders. With QuickBooks 2007, small businesses no longer have to print their customized document, walk to the printer and look at the hard copy to see if the form meets their needs. New for this year, QuickBooks includes an auto-preview feature that makes it easy to customize layouts with color schemes, logos, and more, while showing users their changes as they are made. The software also consolidates the most commonly-used customization options all on one screen.

New "Right for Me" Solutions to Solve Specific Needs

As part of Intuit's Right for Me strategy to offer QuickBooks versions for companies of different sizes and industries with specific needs, the QuickBooks 2007 line adds new capabilities for specialized businesses and growing companies:

  • Enhanced Features for Product-based Businesses: Inventory management is critical to the success of product-based businesses, but to keep an accurate record of total inventory, they must often convert products from one unit of measure to another. For example, a company that purchases a product by the case of a supplier may sell the same effect by the individual bottle to its customers. Available in select QuickBooks 2007 offerings, the new Unit of Measure feature removes the hassle of manual conversion and the risk of costly errors by automatically calculating the transformation from one unit to another in the appropriate forms, including invoices, purchase orders, and inventory reports.

"To meet the needs of large retailers, we were spending two to three hours a day manually calculating and converting quantities. We have different shipping requirements for each retailer. Any error in shipping too many or too few of any one item results in shipping error fees" said Tom Mitchell, CFO of HBH Pet Products in Springville, Utah. "QuickBooks gives us that peace of mind to know that we have shipped out what our customers want when they want it."

In addition, an improved Shipping Manager enables multi-parcel high-value shipping with FedEx, and UPS handles third-party billing. It can print labels right from QuickBooks on popular thermal printers.

  • Online Time Tracking for Professional Services Firms: Businesses can now collect and manage employee and contractor timesheets on the Web with the new QuickBooks Time Tracker service, available by subscription. Freeing managers and employees from manually entering data into QuickBooks from hand-written timesheets, Time Tracker quickly downloads data into QuickBooks saving hours of tedious work and reducing errors that can cause incorrect billing.

"Time Tracker saves us so much time when entering employee timesheets," said Leticia Zaragoza of K Page Kistler, PC in Virginia Beach, Va. "Plus, I have total control when managing these entries for billing."

  • After-the-Fact Payroll: Approximately 28 percent of the 250,000 accountants who work with QuickBooks perform after-the-fact payroll services, entering payroll data from paychecks that clients have prepared themselves. To save accountants considerable time and effort, QuickBooks Enhanced Payroll for Accountants features a new After-the-Fact Payroll spreadsheet-style data entry tool that transforms this traditionally time-intensive task into a simple process.
  • Increased List Limits for Growing Businesses: Mid-market businesses using QuickBooks Enterprise Solutions 7.0 can add a hundred thousand or more inventory items, customers, and vendors as they grow - an increase of more than 400 percent.

Pricing and Availability

QuickBooks Premier - including industry-specific editions for accountants, contractors, manufacturers and wholesalers, nonprofits, professional service firms, and retailers - is priced at USD$399.95.

QuickBooks Pro retails for USD$199.95, and QuickBooks' entry-level product, QuickBooks: Simple Start Edition, is USD$99.95. A new three-user value pack for QuickBooks Pro is USD$ 499.95, and a five-user value pack for QuickBooks Premier is USD$1,499.95.

QuickBooks 2007 products are currently available direct from Intuit at: http://www.quickbooks.com. They will be available starting on October 11, 2006, at fine retailers everywhere, including Amazon.com, Best Buy, CDW, Circuit City, CompUSA, Costco.com, Fry's Electronics, Office Depot, OfficeMax, Sam's Club, and Staples.

For mid-market companies, QuickBooks Enterprise Solutions 7.0 starts at USD$3,000 for a five-seat license and is available for up to 20 simultaneous users. The QuickBooks Enterprise price includes a 12-month full-service plan that entitles businesses to 24/7 technical support from a dedicated support engineer, product upgrades, data recovery, reporting services, interactive training tools, and automatic renewals. QuickBooks Enterprise can be purchased directly from Intuit by calling 866-379-6635 (+1 866-379-6635).

About Intuit Inc.

Intuit Inc. is a leading business and financial management solution provider for small and mid-sized businesses, consumers, and accounting professionals. Its flagship products and services, including QuickBooks®, Quicken®, and TurboTax® software, simplify small business management, payroll processing, personal finance, and tax preparation and filing. ProSeries® and Lacerte® are Intuit's leading tax preparation software suites for professional accountants.

Founded in 1983, Intuit had annual revenue of $2.3 billion in its fiscal year 2006. The company has nearly 7,500 employees with principal offices in 13 states across the United States and in Canada and the United Kingdom. More information can be found at: http://www.intuit.com.

Intuit, the Intuit logo, and QuickBooks, among others, are registered trademarks and registered service marks of Intuit Inc. in the United States and other countries.

 

]]> <![CDATA[[QODBC-Desktop] QuickBooks SDK 6.0 for U.S. editions of QuickBooks 2007]]> QuickBooks SDK 6.0 for U.S. editions of QuickBooks 2007

As of Date: 2006-07-13

QuickBooks SDK 6.0 Feature List  

QuickBooks SDK 6.0, scheduled to be released in the fall of 2006, will include a number of new features requested by IDN member developers. Of course, QBSDK 6.0 will also support all parts of our previous versions of the QuickBooks SDK, so software built using QBSDK 5.0 or earlier can be easily migrated to QBSDK 6.0.

Integration with Additional QuickBooks Products 

QuickBooks SDK 6.0 is expected to include the following new features for use with U.S. editions of QuickBooks 2007 and QuickBooks Enterprise Solutions 7.0:   

Enhanced Data Access -- Transactions

  • Support for BillPaymentCheckMod
  • Support for CheckMod
  • Support for CreditCardChargeMod
  • Support for CreditCardCreditMod
  • Ability to create Invoices (InvoiceAdd) from Sales Orders
  • Support for JournalEntryMod
  • Support for ReceivePaymentMod
  • Support for TimeTrackingMod
  • Ability to Query, Add and Delete Vehicle Mileage transactions
  • Ability to set and query the "IsToBeEmailed" field on Invoices & Estimates (in Query, Add, and Mod operations)
  • Support for "Other," "Other1," and "Other2" fields in all query, add & mod transactions
  • Change TimeTracking to use BillableStatus enum in place of IsBilled & IsBillable (to enable indicating that time added has already been billed)

Enhanced Data Access -- Lists

  • Support for AccountMod
  • Ability to Query, Add, Delete, and Modify Vehicle list elements.
  • Ability to query and modify the 5th address line (Notes) 
  • Support for creating special accounts (e.g., accounts payable,  accounts receivable, CostOfGoodsSold, UndepositedFunds, etc.) via a SpecialAccountAdd request
  • Support for creating special items (FinanceCharge, ReimbursableExpenseGroup, ReimbursableExpenseSubtotal) via a SpecialItemAdd request

Credit Card Transactions  (additional info available )

  • Accept only "masked" credit card numbers in SalesReceiptAdd, ReceivePaymentAdd, & ARRefundCreditCardAdd transactions
  • Enable identification of credit card present ("swipe") transactions
  • Provide a ClientTransactionID field for future use by the QBMS reconciliation feature

Documentation

The QuickBooks SDK Documentation Suite is being improved with QBSDK 6.0. In particular, we expect to include the following:

  • A  new Onscreen Reference (OSR) that simplifies the lookup for supported requests and fields for a specified QuickBooks edition or set of editions and also has complete documentation
  • Improved QBFC documentation
  • A  QuickBooks Web Connector manual

 

]]> <![CDATA[[QODBC-Desktop] QuickBooks SDK 5.0 for U.S. Editions of QuickBooks 2006]]> QuickBooks SDK 5.0 for U.S. Editions of QuickBooks 2006

As of Date: 2006-07-13

QuickBooks SDK 5.0 Feature List  

QuickBooks SDK 5.0, available to IDN members for download, includes a number of new features requested by IDN member developers. Of course, QBSDK 4.0 also supports all features of our previous versions of the QuickBooks SDK, so software built using QBSDK 4.0 or earlier can be easily migrated to QBSDK 5.0.

Integration with Additional QuickBooks Products

QuickBooks SDK 5.0 can be used to develop software that integrates with any or all of a long list of QuickBooks products, including the following, which is new for QBSDK 5.0:

QuickBooks SDK 5.0 includes the following new features (unless otherwise noted, features unique to QBSDK 5.0 can be used only with U.S. editions of QuickBooks 2006* and QuickBooks Enterprise Solutions 6.0*):   

Credit Card Transactions 

  • Support for credit card refunds (ARRefundCreditCard Add/Query)
  • Support for credit card payment data in SalesReceiptAdd and ReceivePaymentAdd requests (using QuickBooks 2005 R5 and later)

Performance Improvements (additional info available)

  • New iterator functionality for queries that makes it easy to walk through large amounts of returned query data in “chunk” sizes that you specify.
  • Enable significantly improved performance when adding custom fields online items using InvoiceAddRq.
  • Improved filtering on RefNum.

Additional Data Access

  • Support for BuildAssembly: BuildAssemblyAdd/Mod/Query
  • Ability to modify sales receipts: SalesReceiptMod
  • Ability to specify which QuickBooks editions your application supports using a new QBAuthPreferences method (PutAuthFlags).

Support for Web-Based Applications

  • The QuickBooks Web Connector provides a simplified mechanism for web server-based applications to communicate with QuickBooks via the QuickBooks SDK. This mechanism can be used with any version of QuickBooks that supports the QBSDK. (It can also work with QuickBooks POS via the QBPOS SDK.)

Events and Time Modified Support for Custom Fields and Private Data Extensions

  • Events are generated for custom fields and private data extensions. Notice that data written to the custom field (via UI or SDK) or personal data extensions cause the Time Modified value for the parent object to be updated. (for more information, click here)

Improved Documentation

  • The QuickBooks SDK Documentation Suite has been significantly improved with QBSDK 5.0.

* Notes on QuickBooks 2006 and QuickBooks Enterprise Solutions 6.0 :

With the release of QuickBooks 2006 and QuickBooks Enterprise Solutions 6.0, the file-based structure used for the company file in earlier versions of QuickBooks has been replaced with an industry-standard database. This is expected to enable future enhancements regarding storage, performance, and improved multi-user interactions. The QuickBooks SDK will continue to provide the only programmatic interface to QuickBooks; integrated applications written using the QuickBooks SDK will not need to change. 

The QuickBooks Enterprise Solutions 6.0 product includes a QODBC Driver for QuickBooks; this will enable read-only access to the QuickBooks data using standard SQL queries, which QODBC converts to QuickBooks SDK queries.

 

 

]]> <![CDATA[[QODBC-Desktop] Microsoft Windows Vista, Versions of QuickBooks Prior to 2007, and QODBC]]> Microsoft Windows Vista, Versions of QuickBooks Before 2007, and QODBC

As of Date: 2006-12-16

IMPORTANT NOTE: To see how to install QODBC and connect to QuickBooks for the first time using Microsoft Vista, click here: How do I install and connect QODBC using Microsoft Vista? 

With Microsoft's release of Windows Vista, we wanted to ensure that our developers are informed about Intuit's plans for versions of QuickBooks before QuickBooks 2007 on vista. First and foremost, USA versions of QuickBooks 2006 and earlier will not be supported on Windows Vista.

Thanks to the Windows Vista compatibility "shims" from Microsoft, these versions of QuickBooks will successfully run, and many functions will behave normally. The user will be alerted that they are running in an unsupported configuration with wording similar to the following:

"When running QuickBooks 2006 or earlier on Windows Vista, you will likely experience instability and unreliable behavior, even though these problems may not appear immediately." 

One area we know will not work is that SDK-based applications, such as QODBC, will fail in BeginSession with an internal error due to an inability for shimmed applications to see each other or even other un-shimmed applications on vista. If you have a QODBC customer contemplating an upgrade to view, tell them they must update to v7.00.00.214 (or later)!

QODBC Version 7.00.00.207 contained what we had hoped the final piece would be vista compliant. The main changes were to move the ODBCINST.INI to "C:\Documents and Settings\All Users\Application Data\QODBC Driver for QuickBooks\ODBCINST.INI." All users should be able to read and write from there. All that is used for the global settings for QODBC.

The QODBCLOG.TXT Log file has been moved to C:\Documents and Settings\useraname\Application Data\QODBC Driver for QuickBooks (per user).

The new default for the optimizer file is "%UserProfile%\QODBC Driver for QuickBooks\Optimizer." New users will get that. Old users can change their path to that. With the %UserProfile% in the way, the optimizer .opt files will be saved in the user's folder (C:\Documents and Settings\useraname\Application Data\QODBC Driver for QuickBooks).

The last changes were to disable the Test Connection and Optimizer sync buttons when EditQDSN is started in elevated mode. (The Intuit qbXML SDK cannot be called from a formal application under vista) A help link has been added to explain why.

And lastly, a helper .exe called FQQBVSAV.EXE was added to allow a non-admin user to save settings to the System DSN after prompting for elevation.

Full vista compliance was scheduled for R4 since Intuit needed final vista bits to make the final preparations for QuickBooks '07. R5 will be slipstreamed to QuickBooks '07 users by Intuit before vista is available to the public. R5 can be found on Intuit's website under QuickBooks Product Updates at: http://www.quickbooks.com/support/index/ndxw_16_update.html.

QuickBooks qbXML SDK/Windows Vista Compatibility and QODBC

On the released version of Windows Vista, applications built with any version of the QuickBooks SDK (like QODBC) should work correctly with QuickBooks 2007 R5 and QuickBooks Enterprise Solutions 7.0 R5 (the latest available update releases of each), with the following caveats:

  • The Vista user account must have its User Account Control (UAC) set to On (as recommended by Microsoft).
  • QuickBooks and the QODBC application accessing the SDK should be run with standard user permissions (NOT elevated to run as administrator).
  • Subscribing to custom menu events (UI extension events) does not work correctly in the current release.
  • QuickBooks Web Connector 1.0 and QuickBooks Remote Data Sharing 3.0 are not supported on vista; new versions of each that work on view will be released soon.

Additionally, QuickBooks Point of Sale 6.0 will work on Windows Vista. However, if you are upgrading the operating system of a computer with Point of Sale software installed, you may need to reinstall Point of Sale to ensure it will launch correctly.

Please note that QuickBooks 2006 and earlier, as well as QuickBooks Point of Sale 5.0 and earlier, may not work correctly on Vista and that Intuit will not support those products on view.

For further information about Microsoft Windows Vista, QuickBooks, and the QuickBooks SDK, see this article on the IDN website.

Because of the SDK release's limitations in QuickBooks outside the USA, QODBC cannot be used under the Microsoft Vista operating system. Note: For QuickBooks users outside of the USA, this will mean that users will not be able to run QuickBooks and QODBC on Vista until further notice. We recommend that you keep using Windows XP in the meantime and hope that Intuit will rectify this issue in 2008.

You can view the QuickBooks announcements made regarding vista outside the USA at:

Australia/New Zealand/Singapore:
http://www.quicken.com.au/support/vistaUpdate.aspx
 
United Kingdom (UK):
http://www.quickbooks.co.uk/store/en/quickbooks/vista_faq.jsp?pd=vista
 
Canada:
http://support.intuit.ca/quickbooks/vista_faqs.php?pd=vista

 

]]> <![CDATA[[QODBC-Desktop] QuickBooks SDK 4.0 for U.S. Editions of QuickBooks 2005]]> QuickBooks SDK 4.0 for U.S. Editions of QuickBooks 2005

QuickBooks SDK 4.0 Feature List  

QuickBooks SDK 4.0 includes a number of new features requested by IDN member developers. Of course, SDK 4.0 also supports all parts of our previous versions of the QuickBooks SDK, so software built using SDK 3.0 can be easily migrated to SDK 4.0.

QuickBooks SDK 4.0 can be used to develop software that integrates with a long list of QuickBooks Financial Software products. Features new to SDK 4.0 can be used with U.S. editions of QuickBooks 2005 and QuickBooks Enterprise Solutions 5.0 and/or with QuickBooks Online Edition.   

New Features Applicable to Multiple Types of Lists or Transactions:

  • Ability to limit response data returned from Add, Modify, and Query operations to specified field(s) or aggregates. This could eliminate time spent handling unwanted data and decrease memory requirements. (additional info available here and here)
  • Ability to get an approximate count of items returned in response to a query, with or without the returned objects.
  • A new generic transaction query that returns data common to all transaction types, such as TxnID, style, time created, time modified, ListID, account referenced, etc. (The SDK equivalent of QuickBooks' "Advanced Find" function.)(additional info available)
  • Significant performance improvements for single RefNumber transaction queries, speeding searches for specific transactions.

Accounts Payable Transactions (additional info available)

  • Ability to add and modify Item Receipts.
  • Ability to create a bill or an Item Receipt from a Purchase Order.
  • Ability to link lines in new Bills or Item Receipts with lines in Purchase Orders.

Additional Data Integration

  • Ability to add, modify, query, and delete Price Levels, which will be used by default in sales transactions added by the SDK unless a specific rate is supplied in a line item. (additional info available)
  • Ability to use a "PaidStatus" filter with the ChargeQuery request.

Events and User Interface Integration

  • Ability to specify that an application does not receive subscribed-to events generated by itself.
  • The ability for UI Extension events to contain context data from the current QuickBooks form.
  • Ability to use ListDisplayAdd/Mod requests to display Account and Item forms in QuickBooks.
  • Ability to pre-fill specific data in TxnDisplayAdd requests, enabling an application to have QuickBooks enter a particular customer, vendor, etc., when opening a new transaction form.
  • Ability to launch QuickBooks in the foreground (i.e., showing its User Interface) with a specific company file.
  • Ability to filter transactions based on pay status (which enables applications to find which transactions are payable for a given customer).

Enhancements to the Integrated Application Approval Process (additional info available)

  • Allow an application to request read-only access to a QuickBooks company file and notify the user that the application will only have read access to the data.
  • Allow the user to set up unattended mode as part of the authorization dialog.
  • Allow an application to require access to personal data during the application authorization process to avoid user errors.

QuickBooks Online Edition (QBOE)

  • The ability of desktop applications to access QBOE using the same COM interface used with desktop QuickBooks reducesthe effort required to port an application to QBOE. (additional info available here and here)
  • SDK support for discount, sales tax, and shipping information

  • Entity and date filters for all transaction queries (i.e., InvoiceQuery)

For additional details on QBSDK 4.0 (including changes between QBSDK 3.0 and 4.0), see the QBSDK 4.0 Release Notes.

Next: Read about the features introduced with SDK version 3.0.

 

 

]]> <![CDATA[[QODBC-Desktop] Troubleshooting - QODBC no longer licensed for this Reckon version]]> Troubleshooting - QODBC is no longer licensed for this Reckon version

Problem Description:

We have been using QODBC without problems with our current QuickBooks version for months. Suddenly QODBC has stopped working on all our computers.

I have tried a few different QODBC versions, including the latest, but none work.

QODBC users are faced with a QODBC message that "QODBC is no longer licensed for this Reckon version."

Reinstalling and/or upgrading to v322 doesn't help. Some users are still on v321, and the same message is coming up.

 

Solution:

QODBC Read Only edition was free with Reckon Pro/Premier/Enterprise until Oct 26, 2017.

The contract for free use by Reckon Accounts users ended/terminated on the above date.

To continue using QODBC for Reckon Accounts, Please purchase a QODBC License.

You can purchase a QODBC License for Reckon Accounts by Clicking here or Visiting http://qodbc.com/order.htm and then clicking "Asia Pacific"

Or contact your local dealer (Australia/New Zealand/Southeast Asia). Visit http://qodbc.com/contact.htm.

 

 

]]> <![CDATA[[QODBC-Desktop] Troubleshooting - How do I know which version of QuickBooks my QODBC license works with?]]> Troubleshooting - How do I know which version of QuickBooks my QODBC license works with?

Problem Description:

How do I know which version of QuickBooks my QODBC license works with?  

Solution:

To find out which version of QuickBooks with your QODBC license works, please follow the below steps:

1. Click Start > All Programs > QODBC Driver for use with QuickBooks
2. Click QODBC Setup Screen
3. Click the About tab


4. In the middle of the About Tab window, you will see a hyperlink that says, "Check website for updates" just below this, you will see your Serial Number in the format X00X12345678.

The first character in the Serial Number indicates the type of license you have. R indicates Read Only, W indicates Read Write, and S indicates the Server edition of QODBC.

The second and third characters indicate the QuickBooks year number (e.g., 13 is for 2013 and earlier, 12 is for 2012 and earlier) that your QODBC license is compatible with.

The fourth character is "U" for the USA, "O" for Australia/New Zealand/South-East Asia, and "K" for UK/Europe, Middle-East, and Africa editions of QuickBooks. Other letters are for different regions.

The remaining characters are from the rest of your serial number.

So if you have a Serial Number of W16U12345678, your QODBC license is a Read Write version compatible with QuickBooks 2016 US edition and earlier.

If you are using QODBC Read Only, which comes with QuickBooks Enterprise, you will notice Licensed To QuickBooks Enterprise User in the About Tab below the "Check website for updates."

Licensing FAQ:

Question 1:

How can I know for which year and QuickBooks my QODBC license is valid? Can you install a higher QODBC version with the lower license?

Answer 1:

QODBC license is licensed for QuickBooks Version(Year). E.g., If you have QODBC Licensed for 2015, You can use QODBC with QuickBooks 2015,2014,2013, and so on, but not with QuickBooks 2016.

You can install QODBC v15 and v16 with no upgrade cost. Upgrade cost is only applicable when your license does not match the year.

For Example:
If you have QODBC licensed for 2015 & you are using QODBC v15 & QuickBooks 2015, you can install QODBC v16 and use it with QuickBooks 2015.

Question 2:

How do I know what is my CD KEY??

Answer 2:

You can get your CD KEY from the purchase email from your registered email ID. If you have deleted/lost your email, please raise a support ticket with "Sales - Registration - Activation Department" Click Here to submit a support ticket.

Question 3:

I need to download QODBC for QuickBooks 2016 Desktop; I have changed my computer, can't find it on the site. Will the current one work?

Answer 3:

Each new edition of QODBC also contains the last builds we did of the previous editions. So you can also use the latest QODBC Version with the previous edition of QuickBooks. Your CDKey will unlock the latest QODBC version of the version you were licensed for.

Also, Refer:

QODBC Licensing Information
QODBC with QRemote Licensing Information
How to activate QODBC
How to deactivate QODBC and How to transfer license to a new computer
To purchase QODBC License click here

 

]]> <![CDATA[[QODBC-Desktop] QODBC Evaluation Period Expired after upgrade to Intuit Enterprise.]]> QODBC Evaluation Period Expired after upgrade to Intuit Enterprise.

Problem Description:

An older trial installation of QODBC (from before QuickBooks Enterprise and long expired) was once on this computer.

How do I proceed to install the QODBC driver included with QuickBooks Enterprise, and what (if anything) do I need to do to clean up or remove the expired trial edition?

When we try to connect, the QODBC driver says, "[QODBC] Evaluation license has expired" and requires an activation key in order to continue.

Solution:

To resolve this issue, You need to download the latest QODBC version.

You can get QODBC's latest version by clicking "Check website for updates" from QODBC Setup Screen About >> tab.

By clicking "Check website for updates," you will be redirected to the below page on the QODBC website. You can download QODBC latest released version by clicking on the Click to Run QODBC Installer version hyperlink.

After installation of QODBC, you first need to uninstall the old QODBC version. You can uninstall QODBC from the following:

Start >> All Programs >> QODBC Driver for use with QuickBooks >> Uninstall QODBC

Click "Yes" to proceed with the uninstallation.

Click "Next" & "Finish" to complete the uninstallation process.

Now Install QODBC Latest version on your machine. Restart the machine after the new version is installed (if prompted).

Refer: QODBC Installation Steps

After installation of QODBC, You will be able to connect to QuickBooks Enterprise.

Keywords: QuickBooks enterprise upgrade, qodbc enterprise troubleshooting

 

]]>