June-Sept 2023:
——————
Switch to Edge/WebView2 browser for QBO login
Improved Performance, Excel window mgmt for formatted reports
Add option to append after all other SQL in query (used for OPTION())
Allow use of TLS 1.3 where supported
Re-authorize with private data setting on change company file
Update pivot connection on relink, reset active sheet after refresh all
Correct an issue with the balance sheet trend report (start date)
Correct an issue with the uploader log tables
Update inventory lot allocation to include blank lots
Added filters to Estimate w/ POs detail query
Add IsItemClosed to Purchase Order View, don’t include in open balance
Add option to Combine Inventory Sites in allocation
After 90 days, QBD requires a full reload
Add P&L Actual vs Budget vs Forecast query

Jan-June 2023:
——————
Retrieve ReceivedQuantity for QBO Purchase Orders
Corrected an issue updating COGS adjustments when cost changes but
transaction doesn’t
Added Advanced Load Option “Lookup Missing Items on Invoices”
Corrected a load issue for Fiscal Week 53 when using 13×4 periods
For uploader, QB connect failure shouldn’t force full reload
Corrected an issue with inventory-allocation by lot
Use additional database check of connection/sources before each refresh
Fix re-scan of row after empty section in formatted report
Allow YTD calendar-year selection for companies with alternate fiscal years
Populate employee name/id for QBO Payroll
Added option to check for uploader connection before starting load
Updated QBO Preferences load to use proper API version
Add RetrieveType to source-retrieve query
Improve query resets when changing templates
Add immediate-postback option for QuickBooks import
Correct a case where inventory allocation by lot was not correct
Correct an issue with trial balance trend report on P&L with non-annual
start date
Add Importer checks for in-progress uploads of large split files
Updates to cash adjustments SQL
Added unitprice field to GL
Add missing TaskScheduler file to Uploader version
Changed advanced option to “Create Additional Reporting Hierachies”,
default is now not to.
Reorganize advanced-settings screen
Apply “exclude from load ALL” to company/database groups
Updates for improved cash-basis reporting of discounts, fees, and sales tax
Update inventory in-stock calculations to better handle missing data
Added line-item description to inventory transaction view
Allow empty value (NULL) for custom price level upload
Added “/PrimaryUser” startup option
Added Workaround for QB issue with Manual Payroll setup retrieving
PayrollItem
Added Items Quantity_On_PendingBuild field
Fix an issue with auto-joins for entity selection on some templates
Use additional precision for unit-price/rate field on upload
Fix issue with custom row height not copied from template (EPPLUS)
Update list-item fullname when parent name changes
Add Customer field to Item Receipts
Don’t require importer license to add inventory adjustments
View/query updates:
Added Job_Terms, estimates with time but no $
Added Item_Account_Full_Name fields
Added Pending_Item_Receipts to revenue queries
Add default Max API Version for QBD
Add ResaleNumber to Customer import
Add Payroll-Item Fields to Time-by-Item Query
Added LogRetrieves table to config. database
Recognize “Converted” for QBO Estimate status
Correct Net-Income company filter on balance trend query
Add sales-tax item load, update view for customers
Add settings to control consolidated hierarchy generation
Added option to handle duplicate sales-tax codes for QBO
Retrieve IsProject for QBO jobs
Improve check for QB error on optional tables
Add import of additional report templates workbooks
Allow for entity item rename on Import
Updated inventory reports to handle sales after cut-off date
Add setting for max. QBD API version
Fix load of QBO BillPayment account fields & cleared status
Fix AR aging report for payments made against journal entries
Fix an issue with placement of subtotal lines on formatted report
hierarchies
Added 1099Eligable, TaxIdent fields to Vendor Directory view
Update Excel connect strings to use MSOLEDBSQL driver if available

All 2022 Updates
—————-
Change all framework targets to .NET 4.7.2
Added Post-back for Price Level Lists, additional Item Sub-Types
Added option to improve tracking of reimbursed expenses on invoices
Upgrade Excel reader/writer to improve handling of formatting templates
Added import of PKG files to main application with import feature
Fixed an issue with invalid excel names on templates (EPPLUS)
Fixed an issue with @total on pivoted reports
Allow “_” in company id for importer
Fix handling of optional tables for uploader (e.g. Payroll)
When replacing an existing Excel worksheet, keep its name
Added “bsstart1” variable to allow Bal. Sheet trend to work with calendar months
Add Calendar Month Number to time
Corrected an issue with updating cogs adjustments
Updates to Importer for status tracking through config. database
Correct an issue with using “spread across columns” with a joined filter table
Correct an issue with CreditMemo returns in inventory purchase/sale calculation
Added support for Item Receipts and linking to PO to importer
Add InventoryTransfer to importer
Add zLoad_Check_Status to QB Online
Added logging for data row load error
Correct and enhance Inventory Needed for Orders query
Enable import of data extensions for imported list items
Add advanced setting “Use Load Cutoff Time” for transactions
Fix reporting of child-class name in GL for QBO
Fix an issue with updated parent transactions on incremental load
Adjust AR aging report to use home currency for all transactions
Populate Sales-Tax items in the GL
Added QB Desktop sales tax reports
Ignore “end of file” character on data file loads
Added /LOADUSERTABLES startup option to load data tables only
Check for first data row when using @pivoton with sparse data
For annual fiscal years, start counting fiscal week from day 1 of first month
Insure schedule settings are properly saved so they can be reviewed
Add customer/billing email field for QBO invoices, TaxCode field to invoicelineitems
Corrected invoice tax code and added discount/shipping fields to importer using special item names
Ignore cash-only adjustments in AR reports
Added Customer.ItemSalesTaxRef to importer
Don’t include Cogs in Item Directory vItemSales queries
Support multiple JoinSelect clauses in queries
Use BULK INSERT for detail records during incremental load
Added ItemDescMap table to lookup missing items by description
For Importer modify, don’t send null Qty, Rate for update
Correct query conflict between type filter and pivot column
Added TABLEDATA1 file type to load individual rows
Added Job_Customer_Type field to job view
Fix subtotals on reports with columns added after pivot
Enable subtotal grouping with subtotals below data lines on reports
Insure memo/descr field updated for bill, check line items
When employee private data requested, use “required” instead of “optional” setting in QB
Updates for hide/row columns during report build
Allow @rowfilter and @rowgroup to be used at the same time
Fix an issue with COGS adjustments on reloaded transactions
Add Filterable TreeView to entity selection screen
Add query filter by entity type
Fix an issue with Save & Upload in Excel with QBO-only Purchases
Update import for QBO Deposits, Transfers
Update import to allow “NULL” string value in non-string fields
Retrieve ShipFromAddr from QBO sales transactions when available
Include check class on status load
Improvements to linked txn tracking, update links for QBO
Retrieve department/location for QBO Journal Entry Lines
Allow refnumber to be used with Deposits, load from transaction table
Use version “14” setting for Excel pivot tables
Importer updates:
Allow TxnID to be used for modify with posted transactions
Dont send blank fields on transaction modify (e.g. Memo)
Improve sparse-updates for importer, ignore unused fields
Query updates:
Added “Bills and Applied Payments Detail”
Added “PO Detail with Bills & Payments”
Added “Directory of Customers with Sales Data”
Update query for acct. activity summary to use Net as Delta
Fixed an error in “Bill Payments Allocation (QBO)”
Include Item Receipts in AP aging report
Correct an issue with Net Income on cash flow report
Allow a variance calculation for moved fiscal year
Added “@addednotes” function to preserve entered data on refresh of formatted reports
Improve checks for invalid QB transaction data
Add upload of custom fields for entities, upload for employees, correct item update
Add Trans_ExchangeRate to sales, purchases views
Add support for multiple non-QB companies
When CustomerType.name changes, update customers
Allow for switch between time and field pivot on saved queries
Add load option for transactions table
Updates to cash adjustments SQL
Create user Install-Check subkey if needed
Fix Net field value sign in vBalSheetNetIncome view
Updates for QBO Vendor Credit AP reporting, match to Bill Payments in QBO
Enhance cash-basis adjustments, add settings and “exact match to QB” option
Correct and issue saving and reusing @rowfilter value on reports
Corrected an issue with loading customer type when CustomerData also loaded
Adjusted definition of “Amount” field to account for changed account-type
Added Custom Field update (DataExtMod) for transaction headers to importer
Improve handling of white space in/after acct descriptions when loading from reports
Include payroll checks in cleared status load
Fix table check in Continue Failed or Cancelled Reload
When startyear used, reload starting balances if transactions found before that
Added option to skip load of general Transactions table (in test only)
Include non-QuickBooks Inventory Adjustments in inventory report views
Retrieve Purchases & Payments Cleared status from QBO Transaction report
Include QBO BillPayments in AP report adjustments
Fixed query issue after clearing custom pivot columns
Add better message for duplicate custom field values
Insure updated queries resaved on Relink
Add support for credit memos on fixed asset items
Include “FinJinniPro_011422.exe” to use prior QB Authorization certificate.
Change shipping package to include SQL Express 2019, replacing 2016
Added startup option /OnlyIncremental to only allow incremental loads
Add load for additional vendor contacts & notes
Correct a missing update for the vItemPrices view
Don’t update failed license info for “secondary” users
When replacing table definitions for custom ones, keep same table index
Don’t include ALL company selection in logged count
Fix Pivot Date Range for calendar year w/ zero suppress checked
Added /Company, /TabName, /FormatReport and /ReportTemplate options to query builder app.
Added Created_Date to item views
Added custom setup to retrieve QBO invoice payment link
Allow creation of additional (e.g. non-posting) accounts
Added logging option for QBO headers
Post COGS adjustments to proper customer when billed item is billable
Improvements to the Balance Sheet Balance Trend report.
Modified date-update to reset “Current Year” and added Query_Year_Start
excel variable to use with “Current Year” updates.
Added /EXLIST cmd option to retrieve multiple companies using a list file
Added fiscal-year definition table for use in reports (zFiscalYears)
Add unique index for custom fields to prevent duplicates
Added “:unique” option to @repeat function on reports
Added option to Save Shared Query (to shared copy of Saved Queries file)
Add check for invalid transaction dates from QB (outside allowed range of 1970-2037)
Add custom filter-columns to drill-down detail
Improvements to @rowstyle directive, add @rowstyledata to format only data columns
Added support for optional invoicelink field (QBO)
Add db support for nvarchar fields
Add Right Networks support to stand-alone Query Builder app.
Allow table RUNcmds to be replaced using TABLEOPTIONS
Added QBO retrieve of Invoice payment link (custom configuration field)

All 2021 Updates
—————-
Fix an issue with parsing QB account reports when account description is included on the report
Include site/bin names in GL tables/views
Fix re-sort of company-file list when file display used
Added Excel-Formula evaluation to custom defined query columns
Allow calculated columns to be used in custom pivot list
Added ReceivedPayments and BillPayments to importer
Allow Query_Company_ID to be “*”
Added formatted report @rowfilter function to filter data by a column value
Allow non-pivot columns to be used before pivot columns on reports
Prevent Excel from formatting column names as numbers when formula used
Enhance drill-down to recognize mtd/ytd value
Updated saved query definition on re-link when not refreshing
Additional support for distinct selects, fixed issue with Item Price Level report
Fixed retrieve of additional customer custom fields when additional notes are present
Add support for a shared “Saved Queries” file
Add some additional error logging for file access problems
Added a 64-bit application version to better support QB 2022
Fixed an issue with QBO report error when report is too large to retrieve
Fixed an issue with subtotal below children on reports
Fixed a starting-balance issue with RE postings when a start-year is specified
Fixed err on PO linked to deposit in QBD
Fixed edit-as-new for custom pivot cols
Implement function for rename of company ID
Added company file list import/export to dwutility
Added logging options for diagnosing company-list
Fix error on the trial balance comparative by company report
Fix handling of sales transactions for fixed asset items
Corrected TB validation report when RE account is zeroed out with a JE
Fix queries with dependent joins on “alias” columns
Fix daily balance load for accts with unparseable descriptions
Update assembly views/queries, add item group view
Fixes & improvements for reporting in Federated Databases
Change QuickBooks Online connect button per Intuit new reqs
Move “Select Multiple” to top of company list on query screen
Allow multiple company hierarchies, don’t clear hierarchies on full reload
Fixed HIDEROW/HIDECOLUMN functions in certain Excel versions
Allow reports to merge header columns when using @pivoton
Fix balance-sheet trend report when Cash basis selected
Preserve and restore last query screen size
Added excel VBA function FJ.EXECSQL to execute a stored procedure
Added /CHECKQB option to pre-check QuickBooks desktop version
Added /EXFILTER option to filter retrieved companies
Merge company hierarchies in federated databases
Fix issue with loading multiple custom fields on Employees
Fix manual hierarchy update (unreleased feature)
Fix load of extra budget year
Fix “Account Activity Summary” query
Added “Item Order Quantities” query
Allow transaction custom fields on detail reports to come from either line item or parent
Fix issue using @pivoton for formatted reports with hierarchies and multiple values
Allow non-QB equity accounts (placeholder) to be added
View updates for inventory sites
Add Paid_Amount for invoices to sales view/queries
Fix query handling of Fiscal Month value using month name
Allow custom column list with formatted month name
Correct Vendor_Company_Name in views/queries
Enhancements to budget load for multiple budget types
Allow full joins to be used in custom queries
Added Amount_Due (line item) to invoice payment allocation query
Corrected an issue with subtotals on formatted reports
Added user-permissions to access companies in a database,
including row-level data security in SQL Server
Added Income and Expense values to P&L views to separate by account type
Added Location fields to payment queries
Corrected build of formatted reports with subtotals below
Corrected incremental loads of placeholder (non-QB) data files
Corrected QBO queries for time zones in GMT+
Added options to maintain balance sheet by class or department (aka location)
Added 5-4-4 fiscal-year choice
For Excel, allow direct entry of database name if database list is restricted
Correct issue with modifying QB entities that already exist with only partial fields specified
Added option to authorize QB company file without full application or database access
Add support for Importing Items into QB
Add report option for hierarchy subtotals below children
Fixed an issue with queries saving & refreshing non-annual fiscal years
Fixed an issue importing some extra customer/vendor fields into QB
Use Ctrl-Up/Down to reorder the query column list
Add loading company address and legal address in Company Info.
Allow custom definitions to replace standard table definitions
Support account numbers with hyphens for data uploads
Switch to new version of EPPLUS to improve formatted report templates (e.g. conditional formatting)
Don’t include pending (non-posting) or voided transactions in reports
New security certificate forces QB to reauthorize

All 2020 Updates
—————-
Added support for a “federated” (consolidated by views) database
Added Excel Upload check for app. moved to relocated folder, always show Upload button
Added menu selection for immediate post-back to QuickBooks
Added price-level column to customer views
Improved post-back data loads for “mixed” row settings (e.g. some revised, some not)
On formatted reports, substitute blanks for missing columns
Added /postbackonly command-line option
Added IsPending, IsPaid flags to Invoice import
Removed background task scheduling option for QB Desktop (see support document)
Added custom trans. fields to additional queries, customer/vendor message where applicable
Added item lot/serial/unitprice to inventory transactions views/queries
Added Invoiced_Quantity to sales order views
Added empty budget name to GL views to allow custom filtering
Add delay before Excel close when running unattended report generation/refresh
Added /NEWfile option to automatic query generation
Add /SecondaryUser command option to allow refresh but not changing company list
When running unattended try to close a QB desktop modal dialog
Corrected port specification for email server
Corrected company selection on invoice payment queries
Corrected an issue with importing modified Deposit transactions into QB
Allow Excel refresh to use worksheet-specific names for Query_Start_Date and Query_End_Date
Added entry of custom number format for query columns
Use default $ number format for Cost and Price columns
Remove “_” prefix on column name when formatting report (allows for blank)
Improvements for custom column list w/ expressions (e.g. total)
Added address line 4 and 5 fields
Replace blank worksheet when using automated query
Customer views were returning customertype instead of jobtype for jobs
Allow 2 accounts with same name if one on Balance Sheet and other on P&L
Fix issue with QB Online deleted transactions still showing on the GL
Added display of query/report identification information in Excel (“- Info” on ribbon bar)
Enhance Purchase-Order queries, updates for Vendor Info and Open Balance
Added option “Show Only Active” for Query Builder entity filters
Added query “Profit & Loss Summary by Job End Date”
Added employee filter selection to queries
Added load of Customer Additional Contacts and Notes
When shared folder used for custom queries, use that folder for report templates and saved queries as well
Fix issue with cash allocations when Invoice has Total Amount = 0
Fix handling of special chars for Excel db login
Enhanced queries that use joined table to allow custom/calculated summary fields
Allow for formatted reports with more than 702 columns
Correct certain cases of refreshing with hidden query-data tabs
Add cash-basis option to various comparative reports that didn’t have it
Allow cash option to be selected on query update (“- Options” button)
Fix issue with parent account names > 100 chars
Clear database-specific settings in a query when the database is relinked
Add @calculate function to formatted reports
Fix handling of refund-linked txns (for custom reports)
Fix certain outer-select query building (for custom reports)
Add check to ignore invalid transactions from QBD (creation dates pre-1970)
Added Item_Class_ fields
Added Item_Preferred_Vendor_Type
Use Chrome browser instead of Windows built-in IE11 for QBO Login
Add Tracking_Number field for invoices & sales-receipts (QBO)
Add upload support for QBO custom fields
For QBO time activity w/o duration, calculate from start/end times
Improvements for loading partial months with large QBO companies
Added Customer Ship-to-Address Item Table (QBD)
Fix Uploader handling incremental loads with skipped dates
Fix Excel Save & Upload for payroll-item custom fields
Fix default column reset on query screen
Created independent data-import utility
Add additional key column support to user-table load
Always add {sourcefiscalmonth} substitution to SQL processes
Added reverse option to pivot for reports
Add CustomerTypes load for QB Online
Allow multiple files for user-table load
Added “@rowstyle” function to set row styles on subtotal or data lines
Allow custom column to be used for pivot field
Improve pivot queries for custom queries that use sql instead of view
Add retrieve of Credit Card Payments for QBO
Add retrieve of Stmt Charges for QBD
Fix missing class name on Bill:Total (AP account on parent transaction)
Fix uploading of revised TimeActivity in QBO
Use “unallocated income” account if item is sold and there is no account set for it
Added improvements to user-table-file load
Allow for custom formula on subtotal lines when using SUM
Added handling of optional tables with latest FinJinni SAAS and older uploader versions
Improve handling of GROUP BY using custom column expressions
Improve handling for multiple accounts with same account number or name
Increase value range allowed for Items.taxrate
Fixed handling of zero-amount invoices/bills subsequently modified
Fixed auto-loading of currency data with QBO multi-currency
Added custom fields to payroll items
Added payroll summary query
Fix vPayroll view when combining multiple companies
Fix handling of FY setting “Define by end of year”
Added “nosort” option to @pivoton for reports
Added inventory-adjustment data-file load (company_Inventory.csv)
Added last 3- and 6- month choices to date queries, with update on refresh
Fix AR reports to back-out payments before cut-off date applied to invoices after
Added ARRefundCreditCard transactions
Reorganized AR queries, placed under “Customer & Receivable” to match “Vendor & Payable”
Allow variable substitutions in query custom filter expressions
+ add “{excel,name,default}” to custom filter expressions
Added additional information fields to company information (e.g. tax id)
Fixed handling of QB error messages with more than 255 characters
Added maintenance query for items set up w/o accounts
Fixed problem with saved queries losing joined tables
Excel query/report enhancements:
Add special column definitions to subtotal rows (using “+total”)
Add option for bold font and increased size to subtotal rows
Add check for “Current Year To” on date update to keep start date
Add @allowmissingcolumn option for formatting reports
Added @definename function to define an Excel named range on formatted reports
Preserve report worksheet index and tab color on rebuild/refresh
Refresh non-FinJinni pivot tables on Refresh All
Allow use of Fiscal Month number with drill-down detail
General query enhancements:
Add support for SQL functions as query “views”
Enhanced AP queries to use As Of Date
Add Service_Date field to GL for QBO
Fix modification of existing transaction line items for QBO uploading w/ Revised=1
Allow command options to be specified in a Startup.ini file
Add /AppData cmd option for data folder location
Added _Amount data field to file loads for alias
Add option to restrict query templates for client (Excel) users
Allow multiple subtotal columns in queries (ctrl-select)
Added “rowgroup” function to formatted queries to group rows in sections
Fixed handling of Inventory Adjustments in QB Online
Fix fiscal prior-year start date for queries
Added option to run automatic query with specific date range
Added “no-load” source option for placeholder to load data files only (.noq file)
Portal/Server: Allow refresh request for non-QBO company (or placeholder)
Add “insert” option for pivoton function in reports
Corrected load of balance-sheet budget
Fixed load of “Payment” Items in QBD, transactions to Deposit-Account
Added option to include bin-location in inventory lot allocation
Added button to inventory settings to run allocation immediately
Include ALL Employee/Vendor custom fields in Salesrep custom view
Fixed calculation of fiscal year+week for 13×4 fiscal years in 2020
Fix retrieve of job_type field from QB
Fix load of item description for SalesOrPurchase items
Added Terms table retrieve for QB Online
Added MarkupRate and MarkupRatePercent to estimate uploads
Added “Fiscal Week Number” to query pivot choices (omits year)