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 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.