- QODBC Driver
- QODBC for POS
- QODBC for Online
- Buy Now
FlexNews October 2016
Welcome to FlexNews - October 2016 Edition
Welcome to the latest edition of our FLEXquarters.com newsletter! We have been working hard for you these past few weeks since the last newsletter, and have some exciting newsto share with you, including the release of two completely new products. Enjoy!
QXL Desktop and QXL Online Are Here!
QXL is by far the easiest and most painless way to quickly export your QuickBooks Desktop and QuickBooks Online data to Excel spreadsheets with just one click!
QXL creates one spreadsheet for each table in your QuickBooks company file with all of the records included. Alternately it can be set export all the tables into one spreadsheet file with multiple sheets.
Once your data is in Excel you can use all of your spreadsheet expertise to easily embed the QuickBooks data into your own custom reports and sheets with no database gymnastics, and when you update your QuickBooks data with QXL with just one click, all of the reports you have created are automatically updated!
Best of all, it works with all versions of QuickBooks and Reckon (for Australia and New Zealand), including QuickBooks Online! As with all our products, you can test the application for 30 days at no cost before you make a purchase decision.
New! QODBC for QuickBooks 2017 Has Been Released!
QODBC is a fully functional ODBC driver for reading and writing QuickBooks 2017-2002 accounting data files by using standard SQL queries. It requires an ODBC compliant front-end application such as Microsoft Word, Microsoft Excel, Microsoft Access, Visual Basic, PowerBuilder, Delphi, Python, C#, .NET, ASP, ASP.NET, PHP, Crystal Reports, Jitterbit, QlikView and many popular report writers and tools. Once installed, it will allow these applications to read and write QuickBooks Accounting files in the same fashion as other file formats installed on your computer. Using the official QuickBooks SDK interface, we are able to offer our customers total compatibility with all QuickBooks file formats.
New Features in QODBC Version 17
New Optimizer System
The data optimizer system in QODBC has been completely replaced with a new speedy data engine to bring QuickBooks data into a fast, fully encrypted local data store to offer maximum speed when using QODBC. The data store is kept up to date with QuickBooks data on every query. Issues with optimizer rebuilding and corruption have been eliminated with this major upgrade.
New Table and Field Additions
With each new major release of QuickBooks, Intuit adds features/enhancements to QuickBooks that users have been asking for. The database enhancements are passed on to us, and we pass them on to you! Here are some of the new tables and fields that have been added in QODBC version 17:
- Added the SerialOrLotNumber field to all the GeneralDetailReport and CustomDetailReport reports
- Added the following fields the in the Employee table for QODBC USA version: SupervisorRefListID, SupervisorRefFullName, Description, Department, PartOrFullTime, Exempt, OriginalHireDate, AdjustedServiceDate, KeyEmployee, USCitizen, Ethnicity, Disabled, DisabilityDesc, OnFile, WorkAuthExpireDate, USVeteran and MilitaryStatus
- Added the new tables CustomerContact and CustomerAdditionalNote under the master table Customer
- Added the new table EntityContact under the master table Entity
- Added the new table VendorContact under the master table Vendor
- Added the new table Employee Contact under the master table Employee
- Added the new tables InventorySite, TransferInventory, Sales, SalesLine in QODBC CA and UK versions.
Included in QuickBooks Enterprise Editions
The basic features of the read-only desktop edition of QODBC have again been chosen to be included in QuickBooks Enterprise Edition 2017. You will find them under the File -> Utilities menu. If you need a read-only edition of QODBC and have this version of QuickBooks, you are ready to go, no purchase required! QODBC read-only desktop is also included in QuickBooks Enterprise Editions in Canada, as well as all versions of Reckon Accounts Desktop in Australia.
QODBC POS V15.00.00.318 is Available for Download
For those of you using QuickBooks POS, an update for version 15 of QODBC for POS is available for download. QODBC Driver for QuickBooks Point Of Sale supports USA versions of POS, including Version 12 (2015), Version 2013, QBPOS 10 (2010) and all the way back to Version 5. The current version of QODBC Driver for QuickBooks Point Of Sale is 15.00.00.318. See our README document for changes in the latest version. We recommend that all current users upgrade to this version as soon as possible. The release notes for the current version of QODBC can always be viewed on the product page. If you need to purchase a license for QODBC or if you need to upgrade your existing version...
Success Stories Wanted! $100 Amazon Gift Card Reward!
Occasionally our customers take time out of their busy schedules to drop us a line and let us know how QODBC has helped them with the needs of their business. We would love to hear of ways you have saved time and money, and been able to be more effective and efficient with our products. As our way of saying thank you, we will send you a $100 Amazon Gift Card if we use your story in our newsletter. Click here to submit your story.
Tech Tip From the Support Desk
The #1 reason why customers contact our Support Desk is to report that QODBC stops working after installing a new or upgraded version of QuickBooks. It is important to remember that when you purchase a CD-Key to activate QODBC, you are purchasing a license for the version of QODBC supporting the current version of QuickBooks available at that time, and back to the earliest version listed on the web site and the help system.
For example, if you bought QODBC for QuickBooks 2016, it will work with that version of QuickBooks, as well as the previous ones listed on our web site. If you upgrade to QuickBooks 2017, QODBC will no longer work and you will have to purchase a CD-Key for QODBC for QuickBooks 2017.
Because Intuit adds new features, tables, fields and reports to QuickBooks whenever they release a major upgrade, FLEXquarters puts in a significant amount of work to update QODBC to match. When you upgrade to a new version of QuickBooks, you must also purchase a CD-Key for the matching version of QODBC to bring it up to date.
Pass it along!
If you know someone who could benefit from this newsletter, feel free to pass it on! Anyone is welcome to subscribe by clicking here.