QQube Version History - 10 | CLEARIFY

QQube Version Release Notes

QQube Version History including bug fixes, improvements, additions and changes.  Visit here for the detail history of the QQube Configuration Tool.

Version 10.0 (Build 587) [08/30/2023]

BUG FIXES

• Fixed an issue where amounts for Document Total, Document Applied, and Document Open were incorrect when discounts were present for Bill Payment Check and Bill Payment Credit Card.

ENHANCEMENTS

• The G/L has a feature in it that allows the Bill and Bill Payments to be lined up one underneath another so a user can more easily see linked transactions, and do computations for original paid, and actual paid

  However, the Discounts on a bill were not showing in this linking mechanism, thereby making the computations difficult to achieve without extra work.

Version 10.0 (Build 585) [07/11/2023]

BUG FIXES

• Fixed an issue where the class for bill payment check and bill payment credit card was missing.

Version 10.0 (Build 584) [06/22/2023]

BUG FIXES

• Fixed an issue where detail lines on a deposit had no source name in the General Ledger Detail Data Model.
• Fixed an issue where the detail lines of group items in Purchase Orders were not showing.

ENHANCEMENTS

• Added the Sales Tax Preference to our synch logs to help spot cases where Sales Tax Records might exist, but don't get extracted because the preference got turned off.
• Correct references within the code to ensure that secure (https) https://clearify.com is enforced.

SDK BUG WORKAROUNDS

• The Intuit SDK has a bug where a timestamp field in the vehicle mileage records is not in fact a timestamp.  Despite repeated requests to Intuit to fix this bug (it was a timestamp not so long ago), we have created a work around that should work in almost all cases - unless there are over 20,000 mileage records in a file.  In previous versions of QQube we could just incrementally load records based upon this timestamp, but that is no longer possible. We now will reload all records every time.

Version 10.0 (Build 580) [04/7/2023]

BUG FIXES

• Fixed an issue where sales orders were not extracted from QuickBooks 2021.  We provided a work around to recent Intuit SDK issue as explained in the announcement for Build 576.  However, we did not successfully implemented that work around.  Sales orders now properly load in QB 2021 versions.
• Fixed an issue where the license for the 10 Company Add-On would not allow more than 3 files.
• Fixed anomaly for upgrade installers, where the old Job Cost Freestyle Profit and Loss were not checked within the Legacy section, even they were checked in the old version.  We additionally automatically check the newer, more efficient, Job Cost Flexible Period Profit and Loss models to give customers immediate access to both types of models.
• Fixed issues where % of Sales was incorrect for YTD, Quarter, Year (Actual, Budget and Forecast) in the following models:  
  • profit_loss_job_flexible_period_(qqube10.x).xlsx
  • profit_loss_job_class_flexible_period_(qqube10.x).xlsx

ENHANCEMENTS

• Changed the behavior of setting the "Today" definition.  If you change it to a specific date, it will be not necessary to reload any data models to see the effect. For instance, Current Month, YTD, etc. will immediately be available with updated calculations.  This will be true for the following affected data models.
  1. All Power Pivot and Power BI examples
  2. Standard Monthly Period Financial Summary data models.
  3. Advanced Monthly Period Financial Summary data models.

• The QQube Configuration Tool > About QQube will no longer display a message that discerns between a minor and major upgrade.  Updates always contains bug fixes, and should be installed.  Major numbered upgrades generally add enhancements which may need researching before implementing.  The Release Notes is always available on that page to decide if the update is necessary now - or after it has been tested in their own environment.
• Changed the installer Icon to the QQube Icon, rather than the CLEARIFY icon for better recognition.

Version 10.0 (Build 576) [03/09/2023]

INTUIT SDK CHANGES

• In a departure from 22 years of SDK implementations, Intuit executed SDK changes for current versions of QuickBooks into previous versions e.g. 2022 and 2023 into 2021.  In doing so, they introduced a mechanism in the latest releases for all years, which will produce errors in extraction for all versions of QuickBooks 2021, 2022, 2023.

• Additionally Intuit introduced a field name which breaks even their data entry rules - and which cannot be modified.

BUG FIXES

• Fixed two DAX formula errors in the PowerPivot purchases data model:

  • Vendor - Average Purchase Quantity

  • Vendor - Average Purchase Amount

• Fixed anomaly where Profit and Loss with Actual, Budget, Forecast (and by class) where not transferred as checked, upon upgrading from earlier QQube versions where it was checked. 
• Fixed issue with serial number negative quantities not being accounted for.

• Fixed multiple issues with what happens when saving date options in the QQube Configuration Tool

  • Calendar Dimension Ranges - now recalculates upon saving
  • Fiscal Year Range for Standard/Advanced/Legacy Job Financials - now shows Warning Dialogue Box to load relevant data models upon saving.  I needs no calendar recalculation and that function has been removed.
  • Current Definition - now shows Warning Dialogue Box to load relevant data models upon saving.  I needs no calendar recalculation and that function has been removed.
  • Warning Dialogue Box:  

ENHANCEMENTS

• Added a cascading visible filter mechanism in Profit and Loss by Detail, so a chosen account name filter in the example would not "disappear" at the bottom of the list.   We have added account type as the visible filter, because it is universal. 

• Customers will no longer be able to accidentally attempt to install QQube updates if they are a multi-user client on a hosted environment.  The download link will be greyed out, and there will be a link to the correct procedures: Updating Existing Installations | CLEARIFY 

• The Excel Add-In now mirrors the look and feel of Excel pivot table lists.  Folders that contain fields used in the Pivot Table will now be bolded.

Version 10.0 (Build 572) [02/02/2023]

BUG FIXES

• Fix issue where the 36 period profit and loss would not load after an upgrade.

• Fix issue involving a bug in the Intuit SDK which might cause the beginning inventory balance to be incorrect.  We have determined a way around the bug, as it is a consistent type of error.

• Fix issue where estimated taxes were showing as income. 

• Fix issue where the beginning balance for G/L would not show when extracting from a particular date.

• Fix an older issue in the job cost data model where the amounts for inventory sales and COGS were correct, but the split accounts were not showing; there was only one line.  Now there are separate lines for income and COGS, where the appropriate accounts for each are listed. 

• Fix issue where subtotals were incorrectly showing as income in the job cost data model.

Version 10.0 (Build 569) [01/19/2023]

BUG FIXES

• Fix issue where ghost data models would show in the Manual Refresh area.

• Fix issue where reimbursed items on credit memo were missing from job costs.

• Fix issue where the Account dimension in Audit Trail missing detail in the Excel Add-In.

• Fixed issue in the GL Details Data Model in Power BI, where necessary measures were hidden in error.

  • Power Query now shows tables and views when accessing the two QQube Data Sources

  • SQL Server Linked Server no longer throws an error when opening a view

• Fix issue where LinkForCompanyID in Job and Customer Rep dimensions was missing.  They have been added back.

• Fix internal error where the Microsoft Access views would not be deleted when PandL by Job and Class (Legacy models) were unchecked - which caused slightly longer refresh times.

   

• Fix issue where certain upgrades to version 10 had unpopulated views.

  Updated to appropriate version of SQL Anywhere to address two Microsoft items:

• Fix multiple issues with recalculating date calendar when changes made to 52/53 tax year

OTHER FIXES

Added back two account dimensions for PowerPivot and Power BI users to allow easier upgrades from earlier versions of QQube.  Although we have created new account dimensions for our new Power Query/Pivot/BI models, it is best to leave these in for legacy purposes, and alleviate some frustration with any upgrade process..

• vd_Account_S
• vd_AccountBS_S

ENHANCEMENT

You can now use Alt-K to turn on mnemonics to allow multiple toggle choices for synch options in the QuickBooks Company List.  Use the underlined letters, along with the down arrow, to select multiple companies in quick fashion.  (Previously, you had to tediously click each one)

Version 10.0 (Build 567) [12/13/2022]

BUG FIXES

• Fix issue where an account with null value amounts on an expense line would cause a synch error representing duplicate values.
• Fix issue where adjustment of lot/serial numbers would not update properly after any subsequent synch. 
• Fix issue where prefixes of certain Document and Date Attributes may be incorrect and show GLPLTxn instead of GLTxn. 
• Fix issue where an untethered amount was showing in general ledger and payroll. Affected Pro/Premier QuickBooks desktop only. 
• Fix issue where may budget not showing in Calendar Year 2022. 
• Fix issue where payroll item and 0.00 in payroll details caused index issue. 
• Fix issue where log file would not open up in Windows 11 on latest processors. 
• Fix issue where QQube payroll for all versions of QB had the incorrect effective payroll date, which affected the ability to reconcile yearly liabilities in our example reports. 
• SDK has an Effective Liability Date - and now reflects the correct value. This will allow proper reconciliation of liabilities.
• QBE has an Effective Liability Date - and now reflects the correct value. This will allow proper reconciliation of liabilities.
• QBE dependent Payroll Data Model showed Pay Period Start Date and End Date values - and there should be none. This has been corrected.
• Result:
  • QBE only has Transaction Date (which is also Fully Paid Date) and Effective Payroll Date
  • SDK only has Transaction Date (which is also Fully Paid Date) and Effective Payroll Date
• Fix issue where job dimension contains incorrect null value markers for job end date and job projected end date.   Corrections:
  • job end date - 21
  • job projected end date - 22
• Fix duplicate payment entry for document dates in A/R Detail. (applied in 736H)
• Fix journal entry foreign amount to match amount instead of 0.00 
• Fix issue where a bill contained an item, then the Offset Account was showing as "no account". 
• Fix issue where Minus amounts on bills were not correctly shown as being fully paid. 
• Fix issue where 0.00 bill minus line items were doubled under open amount instead of 0.00 
• Fix Issue where tax showed incorrectly as income on estimate.
• Fix issue where a positive amount on a credit memo would cause incorrect applied amounts, both for document total, and for job cost details. 
• Fix issue where the Audit Trail Total Number of Changes was incorrect.

TYPOS

• Document Paid/Open Status to Document Current Paid/Open Status in certain transformation elements.
• Shipe method to ship method for a single transaction.
• Fix value for Fixed Asset Item Purchased New/Used
• Profit and Loss Detail have improper Prefixes (e.g. GLTxn instead of correct GLPL)
• CashReq instead of OpenAR in Cash Position Document Attributes for TimeCreated and TimeModified.
• Correct spelling of Ship OR Bill Address PostalCode to Postal Code
• CashReq instead of OpenAR in Cash Position Document Attributes
• CashReqTimeCreated
• CashReqTimeModified
• Change Typo in item Receipt for Cash Position from '(A/P)' to the correct 'A/P' (Bug 133)

in AssemblyBOMSub:

• "MainAssemblyTimeCreated" is now corrected to: "SubAssemblyTimeCreated"
• "MainAssemblyTimeModified" is now corrected to: "SubAssemblyTimeModified"
• "Main Assembly Class" is now corrected to: "Sub Assembly Class"

in vd_AssemblyBOMItem:

• "ItemTimeCreated is no corrected to: "AssemblyItemTimeCreated"
• "ItemTimeModified is no corrected to: "AssemblyItemTimeModified"
• "Main Assembly Class" is now corrected to: "Assembly Item Class"

EXCEL ADD-IN MISSING FIELDS

• Item Class
• Employee and Employee HR Class
• AP Interval
• AR Interval
• Customer, Job, Vendor Classes
• Add AP Interval and AR Interval
• Period 01 Beginning Balance for Statement of Cash Flows by Class

ENCHANCEMENTS

Date and Data Control

• Control the range of data you pull in from QuickBooks
• More options for default "As Of" dates for A/R and A/P
• Decide what "Today" is - Today, End of Last Month, Yesterday, Specific Date

Data Models

• Added over 100 new fields for better reporting and visualization
• Simplified Financial Reporting Options
• New Flexible Custom Period Profit and Loss and Balance Sheet specifically designed for PowerPivot and Power BI
• EBITDA
• New Profit and Loss by Job and by Class - refresh times improved by 90%
• Vehicle Mileage has been completely rewritten
• Expansion of Billable Status fields for Vehicle Mileage, Time Tracking and Job Cost Details

EXAMPLE IMPROVEMENTS

• Tableau - data models have been rebuilt from scratch
• Power Query - same data models available for both PowerPivot and Power Query
• PowerPivot - over 5,000 DAX measures available in all data models
• Power BI - over 5,000 DAX measures available in all data models

USABILITY

Calendar Functionality

• Presentation e.g.  Month Year [Jun 2021] or Quarter-Year [Q1 2021]
• Efficient use in Power BI
• Removal of antiquated fields that served minimal, if any, function

Improved Consistency

• Fields in all included examples for Tableau, PowerPivot, Excel, and Power BI, now have the same names, and default field display.
• Fields are named to help you locate them, whether the list is in natural database order, or in alphabetical order.

Synch Logs

• Easier to read loaded data models - now follows the order of the QQube Configuration Tool
• Simplified/shortened log for multiple company files - option to remove list and transaction load details.