SSIS Integration Toolkit for QuickBooks

Version 24.1 - June 12, 2024

The following are the updates and enhancements made for each group of components:

• Update: We have introduced a newly designed exception message window for better usability.
• Enhancement: Some additional DPI display optimizations to various forms.

Version 23.2 - September 7, 2023

• New: We have added support for DiscountDays, DueDays fields when working with the Term object.
• Enhancement: We have some updates to the License Manager program UI to make it more responsive to changes made to the license installation in the background.
  
• Update: We have removed SSIS 2008 (Including SQL Server 2008 R2) support.

Version 23.1 - March 17, 2023

This release comes with the following updates - Note that this will be our last version that supports SSIS 2008 (SQL Server 2008):

• New: We added QuickBooks SDK v16.0 support when working with QuickBooks Desktop. In order for the new QBFC version to work, you would need to manually install the QBFC16_0Installer file which is available in the Kingswaysoft toolkit installation path.
  
• New: Updated metadata for Customer and Invoice objects when working with QuickBooks online.
• Update: The auto-update form now displays a warning message about required maintenance for software upgrade.
• Update: We have removed the dependency on Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll assembly.
• Fixed: KingswaySoft License Manager might report an incorrect grace period when the license is running under the grace terms.
• Some other general updates.

Version 22.1 - October 19, 2022

This release comes with the following updates:

• New: We have added support for SQL Server 2022 (SSIS 2022).
• New: QuickBooks Source component now supports reading InvoiceLink data from Invoice object when working with QuickBooks online connection.
• New: We added "ClassRef" metadata fields to Item object when working with QuickBooks online environment.
• Enhancement: We have updated the license manager program to make it more resilient in obtaining new license files or renewals should there be intermittent networking issues. The enhancement mainly applies to unattended license requests or updates using command line via Windows script, it is particularly helpful when you run our software on Azure SSIS IR as it involves license activation requests each time when the instance is started or restarted.
  
• Update: The entire program has received some major branding updates in various UI elements.
• Fixed: Uploading Excel file as Attachable file may not work properly in QuickBooks Destination component with QuickBooks online connection.

Version 21.2 - November 11, 2021

This release comes with the following updates:

• New: We added a new action button in the KingswaySoft License Manager which makes it easy to request a free trial.
• New: We added limited password attempts feature to Connection Managers that use OAuth token file. When the limit is reached, access_token and refresh_token values will be deleted from the token file, this is to protect the file from unauthorized use.
• New: We added QuickBooks SDK v15.0 support when working with QuickBooks Desktop. In order for the new QBFC version to work, you may need to manual install the QBFC15_0Installer file which is available in the Kingswaysoft toolkit installation path.
• New: QuickBooks Source and Destination components now support outputting intuit_tid value in error message when working with QuickBooks online environment. Information reported in this column can be helpful when requesting technical support from QuickBooks team.
  
• Fixed: You may run into "Request has invalid or unsupported property" error when working with Payment lines in QuickBooks Destination that uses a QuickBooks online connection.
• Fixed: In some rare cases, you may get error "System.Runtime.InteropServices.COMException: No value has been set" in QuickBooks Source that uses a QuickBooks desktop connection. 

Version 21.1 - May 28, 2021

This release comes with the following updates and enhancements:

• New: QuickBooks Desktop Gateway now supports QBFC options when opening the connection.
• New: We added QuickBooks SDK v14.0 support when working with QuickBooks Desktop. In order for the new QBFC version to work, you may need to manual install the QBFC14_0Installer file which is available in the Kingswaysoft toolkit installation path.
• New: QuickBooks Destination component now supports a new "Enable Child Outputs" option when working with QuickBooks Desktop.
• New: We now ship a new console version of KingswaySoft License Manager program which is designed to work more reliably in a container environment.
• New: KingswaySoft License Manager program now always uses a secure service endpoint for activation and deactivation requests.

Version 20.2 - November 4, 2020

This release comes with the following updates and enhancements:

• New: KingswaySoft License Manager now includes the ability to show and copy the LicenseId within the program which can be used for renewal purposes without having to reveal the full license key details, for instance, if a third-party reseller or agent is involved.
• New: KingswaySoft License Manager program now offers a link in the UI to help renew license maintenance or subscription with one single click.
• New: QuickBooks Destination component now supports a new Upload Attachable action when working with QuickBooks Online.
• New: QuickBooks Destination component now has support for a new "Enable Child Outputs" option when working with QuickBooks Online.
• New: QuickBooks Destination component now supports returning newly created line ids when working with QuickBooks Online objects that have lines such as Invoice and CreditMemo.
• New: QuickBooks Source component supports downloading file content when reading from QuickBooks Online Attachable object.
  
• New: QuickBook Online Invoice object now comes with support for the GroupLineDetails child entity.
• New: QuickBooks Token Manager now provides the ability to export multiple registry tokens to token files at one time.
• Enhancement: QuickBooks Source component now provides the ability to quickly toggle string fields to different lengths in the component's UI.
• Fixed: "UnitPrice" and "PriceLevelRef" fields were missing in the Purchase Order object when working with QuickBooks Online.

Version 20.1 - June 5, 2020

This release comes with the following updates and enhancements:

• New: We have introduced support for Change Data Capture in the QuickBooks source component.
• New: We added Minor Version support when working with QuickBooks Online in QuickBooks Source/Destination component.
• New: QuickBooks Source component now automatically populate the necessary QBXML query when child entity is enabled while working with QuickBooks Desktop.
• New: We added API Throttling Rate support in QuickBooks Connection Manager.
• Enhancement: Hardened security in terms of how connection information is saved for QuickBooks connection manager.
• Enhancement: QuickBooks Destination component now supports working with duplicate column names from upstream components as long as the columns are coming from different sources.
• Enhancement: We have made some minor improvements in our retry implementation on intermittent errors.
• Enhancement: Improved UI performance with select/unselect all output columns in QuickBooks Source component.
• Update: We have adopted a new versioning strategy in this release. From this point on, all future releases will be versioned as YY.ReleaseWave.ServiceReleaseNumber.BuildNumber, where YY is the year in two digits. This helps simplify our communications with partners and clients in terms of a particular toolkit installation's maintenance status among many other benefits. This is implemented across the board for all of our SSIS toolkits including SSIS Productivity Pack. All our current releases should have the same version number of v20.1.0 with a revision number between 1561 and 1565.
  
• Update: We have introduced a new branding panel in our UI forms to distinguish our components from those out-of-box ones.
• Update: Hardened security in terms of how connection information is saved for QuickBooks connection manager.
• Update: We have switched to use token files instead of relying on Windows registry for better security and easier deployment.
• Update: We updated .NET framework requirement to v4.6.1 for SSIS 2012 and above.
• Update: Our license manager program now requires .NET Framework 4.0 or above.
  
• Fixed: QuickBooks Source component didn't output Budget Details values correctly when working with QuickBooks Online Budget object.
• Fixed: You might get "Invalid query" error at runtime when using SSIS variable in source query in QuickBooks Source component.
• Fixed: You may run into KeynotFoundException error in QuickBooks Source component when executed in optimized mode and not all outputs were attached.
• Fixed: QuickBooks Components created by version 2.0 or earlier may not work if upgraded to v4.1.

Version 5.2 - November 15, 2019

This release comes with the following updates and enhancements:

• Enhancement: QuickBooks Source component now handles invalid emun values better when working with QuickBooks Desktop objects.
• Fixed: Login to QuickBooks Online may fail in QuickBooks Connection Manager, the Sign In page may redirect back to itself after login.
• Fixed: QuickBooks Connection Manager may report a "400 (Bad Request)" error after user has provided the consent of using the OAuth App when authenticating to QuickBooks Online.
• Fixed: When working with QuickBooks Desktop, Delete/Void actions in QuickBooks Destination component may not work porperly if the upstream pipeline has more than one input column.

Version 5.1 - October 3, 2019

This release comes with the following updates and enhancements:

• Enhancement: There are some updates to the License Manager program that provide better tracking of license installation and easier license management by our client services team.
• Enhancement: Improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.
• Fixed: You may get "Exception from HRESULT: 0x80040302" error in QuickBooks Source component when reading from Customer object and the Enum type field contains an invalid value while working with QuickBooks Desktop.
  

Version 5.0 - February 21, 2019

This release comes with the following updates and enhancements:

• New: We have added support for SSIS 2019.
  
• New: QuickBooks Connection Manager is now using OAuth 2 by default when connecting to QuickBooks Online.
  
• Enhancement: We have added support for reading child objects over a QuickBooks Online Connection Manager and using a QBO query.
• Enhancement: We have improved the quality of metadata for QuickBooks components using a QuickBooks Online Connection Manager.
• Enhancement: Various UI enhancements and performance improvements.
• Fixed: The QuickBooks Source component may not refresh correctly when the 'Refresh Component' button is clicked.
• Fixed: The QuickBooks Destination component may fail to send child object data.
• Deprecation: We removed support for SQL Server 2005.

Version 4.1 - August 26, 2018

This release comes with the following updates and enhancements:

• New: We added support for "Orphaned Children Error Output" output in the QuickBooks Destination component. This is a breaking change, as a prior version (v4.0 or earlier) would not be able to process an SSIS package that contains a QuickBooks Destination component with the "Orphaned Children Error Output" output enabled.
• Enhancement: We have updated the license manager program to now report details of distinct connections in use.
• Fixed: Our software may report a connection metering related error during runtime for some specific system environments.
• Fixed: QuickBooks Desktop Gateway program may crash after clicking the Start button when using v4.0.

Version 4.0 - April 26, 2018

This release comes with the following updates and enhancements:

• New: We added support for Azure-SSIS Integration Runtime (IR) deployment and licensing.
• New: Standard use licensing model, this limits the number of distinct connections to 8 per connection type within a 24 hour period at runtime.
• Update: We have an updated version of License Agreement that covers the new Azure-SSIS IR licensing model along with many other revisions - the new agreement becomes effective as of today (April 26, 2018).
• Enhancement: Updated metadata.
• Enhancement: We added command line support for QuickBooks Token Manager program.
• Enhancement: We added command line support for QuickBooks Desktop Gateway program.
• Fixed: You may run into error "Input string was not in a correct format" when working with a number type field in QuickBooks Destination component.
• Fixed: You may get "Index out of range" error when Error Output is enabled in QuickBooks Destination component.

Version 3.1 - December 14, 2017

This release comes with the following updates and enhancements:

• Fixed: QuickBooks Destination Components created by version 2.0 or earlier may not work if upgraded to v3.0 when the component works with child objects. This fix introduces a new SSIS metadata upgrade, in order to work with our v3.0 capabilities. This fix should be considered a breaking change, as any packages will be silently upgraded once opened with v3.1 (or above), and the package will not work with a prior version after the upgrade is completed.
• Fixed: QuickBooks Destination component might send incorrect JSON requests when working with QuickBooks Online instance when the batch size is 1.
• Fixed: We have removed some redundant metadata for QuickBooks Online, you may want to click the “Refresh Component” button for each QuickBooks component to get the latest metadata.
• Fixed: You may run into "Specified cast is not valid" error when writing the QuickBooks Online using the QuickBooks Destination component.
• Fixed: QuickBooks Desktop Gateway did not properly support certificates.
• Fixed: When working with QuickBooks Online instance, the QuickBooks Destination component always tries to retrieve the sync token even one may have already been specified.
• Enhancement: Improved high-DPI support.
• Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 3.0 - October 6, 2017

This release comes with the following updates and enhancements:

• New: We added support for QuickBooks on-premises desktop.
• New: We added a documentation generation button to all SSIS components that can be used to generate a Word document which describes the component's metadata including relevant mapping, and so on.
• New: Connections to QuickBooks are now made with the latest and greatest TLS protocol whenever possible.
• New: Source component supports output timezone conversion.
• New: Destination component supports input timezone conversion.
• Enhancement: Some performance tuning and refactoring.
• Update: Some updates to the licensing component.

Version 2.0 - July 7, 2017

This release comes with the following updates and enhancements:

• New: We added support for SQL Server 2017.
• New: We added an expression button in QuickBooks source component.
• New: We added an expression button in QuickBooks destination component.
• Enhancement: Improved high-DPI support.
• Enhancement: Some minor GUI improvements.
• Enhancement: We added command line support for License Manager program.
• Update: We upgraded the JSON library (Newtonsoft.Json.dll) to a more recent version (v10.0.2)
• Update: We no longer deploy Newtonsoft.Json.dll assembly to Windows GAC.

Version 1.1 - May 5, 2016

This release comes with the following updates and enhancements:

• New: We added support of reading line attribute from QuickBooks.
• New: We added support for a few more entities.
• Enhancement: Updated support for the latest SQL Server 2016 release candidate builds.
  
• Enhancement: Running the 32-bit installation package on a 64-bit operating system is now blocked, as doing so makes our connection manager unrecognizable in 64-bit runtime.
• Enhancement: We removed the requirement of .NET Framework 3.5 SP1 for SSIS 2012 and later.

Version 1.0 - January 22, 2016

This is our first official release of SSIS Integration Toolkit for QuickBooks software.

• Three main components and application
  
  • QuickBooks Connection Manager
  • QuickBooks Source Component
  • QuickBooks Destination Component
• Support for SSIS 2016, 2014, 2012, 2008R2, 2008, or 2005
• Support for the following four actions in QuickBooks destination component
  • Create
  • Update
  • Hard Delete
  • Soft Delete