OpenSync version 2 is a major upgrade to one of our flagship products. Our priorities for this release included increasing performance, improved reliability, support for QuickBooks 2014, and adding extendibility to the product.
On the performance side, we have implemented a proprietary multi-threaded technique to reduce the time required for the initial populate of a database by up to 50%. This is important not only for new customers but also for customers that find themselves needing to re-synchronize their database with QB after a failure. Report performance was also re-worked and large reports run up to 90% faster. In addition, large reports such as the transaction detail report can be configured to populate the data in chunks by date. This enables you to pull several years of transaction data in one operation.
Reliability has been improved by addressing the most common failures in the QuickBooks application programming interface (API). The primary enhancement in this area was a failure on large transaction tables. This was addressed by adding a configurable record block size request to all transaction tables. Other reliability enhancements include improved logging functionality and several bug fixes.
All of the new tables and fields introduced in QB 2013 and 2014 are now supported for read operations. Notable enhancements include the following:
- Multiple customer ship to addresses
- Multiple new fields in the employee table
- Vendor ship to address
- Transfer transations
- Additional notes support
- Preferred vendor and manufacturer support for item tables
- Bar code support for item tables
Enhancements for updating records back to QuickBooks include:
- Support for all 15 custom fields in all tables
- Vendor credit updates
- Item receipt updates
- Build assembly updates
- Ability to link a bill to a purchase order
- Add and update support for classes
Finally, OpenSync version 2 supports a new extensibility model that enables us to build add-ins that address custom requirements within the managed OpenSync framework. Examples of how we have used this functionality include:
- Automated FTP download of custom import files
- Posting of custom import files to QuickBooks
- Updating QB from propriety databases and vice versa