Changelog
Release history and version notes.
v0.2.27
July 2026Fixed
- ~ Behind-the-scenes improvements that let our support team see which version you are running when you reach out for help, so issues get diagnosed faster.
v0.2.26
July 2026Fixed
- ~ Improvements to license handling. Changes to your license, such as activating a key or upgrading a plan, now apply immediately, without restarting the app or reconnecting your ODBC clients.
v0.2.25
July 2026Added
- + Bills, item receipts, vendor credits, checks, and credit card charges/credits now support editing and adding lines with SQL through the expense_lines and item_lines tables. You can update an existing line in place, append new lines with a plain INSERT, or do both in one statement, and every line you did not touch is preserved exactly as it was.
- + Item lines can now be linked to a purchase order line when they are added, so a bill or item receipt entered through SQL counts against the purchase order and updates its received quantities, just like receiving against the PO inside QuickBooks.
Fixed
- ~ Fixed the app crashing when a graphics driver updated or the GPU reset while it was running (for example, during an automatic NVIDIA driver rollout). The interface now recovers on its own and your connections and queries keep working throughout.
v0.2.24
July 2026Added
- + You can now add a line to an existing transaction with a plain INSERT into its line table (for example, INSERT INTO invoice_lines with the parent's txn_id). The new line is appended to the end of the document and every existing line is preserved. Available on invoices, credit memos, estimates, sales orders, purchase orders, and sales receipts.
Fixed
- ~ Fixed a serious bug where updating a single line of a multi-line transaction (for example, changing the quantity on one invoice line) deleted every other line on that transaction. Line updates now keep all other lines exactly as they were, and updating several lines of the same transaction in one statement is applied together as a single change in QuickBooks. Transactions containing group items are safely refused rather than modified incorrectly.
v0.2.23
July 2026Fixed
- ~ Fixed a case where converting a sales order into an invoice could fail when one of its lines had been moved or reordered on the sales order (for example, an item added later and then moved higher up the list). The conversion now succeeds and the new invoice stays linked to the sales order.
v0.2.22
June 2026Added
- + Purchase order lines now report a received quantity, so you can see how much of each ordered item has already been received against a purchase order.
Fixed
- ~ Fixed an error that could stop a sales order from converting into an invoice when one of its lines specified an item. The conversion now succeeds, and the new invoice stays linked to the original sales order so it is correctly tracked as invoiced.
v0.2.21
June 2026Added
- + Added two cache commands you can run from SQL. `CALL qb_sync_table('table_name')` forces an immediate refresh of a single cached table, and `CALL qb_rebuild_all()` rebuilds the entire local cache in the background while your queries keep working. Both were previously listed in the docs but are now fully functional.
Fixed
- ~ The Status screen now counts cached tables and live-read tables (QuickBooks Enterprise direct-read) separately, instead of combining them into a single number that could look stuck or incomplete. The cached-table count now reflects only the tables that are actually cached.
- ~ Tables served by live reads no longer show as an error on the Tables screen. They are now clearly marked as served live.
v0.2.20
June 2026Fixed
- ~ Fixed the subtotal on invoices, sales orders, and credit memos being wrong on transactions that use group or assembly items - it could come back as zero. The subtotal now always matches the document total minus tax.
- ~ Fixed the balance and paid amount on invoices. Open invoices could show a zero balance as if they were already paid; the open balance, paid amount, and per-invoice accounts receivable now reflect what is actually owed, including partially paid invoices.
v0.2.18
June 2026Fixed
- ~ Fixed accented and special characters (such as those in address lines, customer and vendor names, and item descriptions) coming back blank when reading data from QuickBooks. These values now return correctly and exactly as stored.
v0.2.17
June 2026Added
- + Sales order line items now include a line sequence value, so you can sort the lines of a sales order in the same order they appear on the document.
Fixed
- ~ Fixed date and timestamp filters (for example, a WHERE clause that limits results to a date range) sometimes being ignored or returning incorrect results. Date-based queries now apply correctly and return only the matching rows.
v0.2.16
June 2026Fixed
- ~ Fixed a licensing issue where an activated installation could revert to the trial / license prompt about a week after activation, even though the license was still valid. The app now renews its license automatically in the background (at startup and once a day), and an installation that misses a renewal recovers on its own the next time it is online - no need to re-enter the license key.
v0.2.15
June 2026Fixed
- ~ Removed a background console window that could appear when connecting to older QuickBooks Desktop versions (2018 through 2021). The connection now runs quietly, with its activity recorded in the app log as usual.
v0.2.14
June 2026Fixed
- ~ Fixed an issue where the SQL service could fail to start after connecting to QuickBooks if the local data store had been damaged by a previous unexpected shutdown. The service now starts reliably and recovers on its own, so SQL access stays available.
v0.2.13
June 2026Added
- + Added support for older QuickBooks Desktop versions (2018 through 2021). On these versions the driver previously could not connect; it now connects automatically with no extra setup, and continues to work as before on QuickBooks 2022 and later.
v0.2.12
June 2026Fixed
- ~ Resolved sales order and invoice posting failures caused by "smart quotes" (curly apostrophes and quotation marks), accented letters, and other special characters in item descriptions, memos, and names - the kind that come from copying text out of Word, Excel, or a web page. These previously caused QuickBooks to reject the entire transaction. The driver now sends these characters in a form QuickBooks accepts, with no change to how the text is stored.
v0.2.11
June 2026Fixed
- ~ Fixed a crash that could happen when your display setup changed while the app was running - for example, reconnecting over Remote Desktop, changing screen resolution, or a monitor going to sleep and waking. The app now handles these display changes gracefully and keeps running.
v0.2.9
May 2026Added
- + License tab now shows when your subscription renews (or when a trial ends, or when a grace period must be resolved), so you can see the date at a glance without opening the billing portal.
v0.2.8
May 2026Fixed
- ~ Resolved sales order and invoice posting failures triggered by line breaks or tab characters inside item descriptions, memos, and other text fields. These previously caused QuickBooks to reject the entire transaction. The driver now collapses these characters to a space before sending the record.
v0.2.7
May 2026Fixed
- ~ Text-field reliability improvements for sales orders, invoices, and other transaction writes - hidden characters in pasted memo, description, and customer name fields are now cleaned before the record is sent to QuickBooks.
v0.2.4
May 2026Added
- + Buy Standard and Buy Pro buttons in the GUI now open a checkout session tied to your install, so the purchase activates this machine automatically.
v0.2.3
April 2026Fixed
- ~ Improved compatibility with SQL client libraries that use parameterized (prepared) queries.
- ~ INSERT ... RETURNING now works correctly when used with placeholder values ($1, $2, ...).
- ~ Resolved a result-format mismatch that affected some Go and Java clients on prepared SELECT queries.
v0.2.2
April 2026Added
- + Ship-to address support on sales orders, invoices, and related transactions.
Fixed
- ~ Licensing and entitlement reliability improvements.
v0.2.1
April 2026Added
- + Sales rep references on transactions that support them.
- + Rolling GUI log viewer with size limits so logs no longer grow unbounded.
Fixed
- ~ INSERT field ordering now matches QuickBooks SDK requirements, eliminating sporadic write rejections.
- ~ Delete tracking now respects entity filters, reducing noise in change feeds.
v0.2.0
April 2026Added
- + Multi-line INSERT support for transactions with line items (invoices, bills, sales orders, etc.) in a single statement.
- + Auto-discovery and write support for QuickBooks custom fields.
- + Unified write path for transaction types that share line shapes (bills / item receipts / checks / credit card transactions / vendor credits).
v0.1.0
February 2026Added
- + Initial release of Syntra ODBC
- + 120+ queryable QuickBooks Desktop tables
- + Built-in SQL server (port 5433)
- + Smart local cache with incremental sync
- + Adaptive polling tiers (Hot/Warm/Cold/Frozen)
- + Full SQL support (JOINs, CTEs, subqueries, aggregates, window functions)
- + INSERT/UPDATE/DELETE write operations
- + Auto-discovered custom fields (custom_* prefix)
- + ODBC driver (64-bit & 32-bit)
- + Syntra Query Explorer (built-in SQL client)
- + Windows Service mode
- + TLS encryption support
- + Live reads on QuickBooks Enterprise
- + CALL qb_void() and CALL qb_rebuild_all() commands
- + SET QB_MAX_STALENESS per-session cache control
- + information_schema compatibility
- + Prepared statements