QQube Version History including bug fixes, improvements, additions and changes. Visit here for the detail history of the QQube Configuration Tool.
BUG FIXES
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.
SDK BUG WORKAROUNDS
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.
Fixed two DAX formula errors in the PowerPivot purchases data model:
Vendor - Average Purchase Quantity
Vendor - Average Purchase Amount
Fixed multiple issues with what happens when saving date options in the QQube Configuration Tool
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.
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.
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.
Updated to appropriate version of SQL Anywhere to address two Microsoft items:
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..
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)
TYPOS
in AssemblyBOMSub:
in vd_AssemblyBOMItem:
EXCEL ADD-IN MISSING FIELDS
ENCHANCEMENTS
Date and Data Control
Data Models
EXAMPLE IMPROVEMENTS
USABILITY
Calendar Functionality
Improved Consistency
Synch Logs
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/6195/qqube-version-history-10
Your session has expired. You are being logged out.