QQube 7.0 fixes all bugs reported since version 6.38 (Build 449 on 5/24/2018) and focuses on improvements in the following areas:
The biggest new feature, however is the data dictionary which describes each field and folder used in QQube. This will help both QuickBooks experts - and those who are skilled with report writing and databases, but not with QuickBooks.
Financial Statements
Example: "Earned Revenue: Audiology: Hearing Aids: Adjustments: Contractual"
Payroll Analytic
Fiscal Years
52/53 Tax Year Dimension
Multi-Company Files
Excel Add-In
Excel now contains bubble text to show information about two areas: The folders, and the individual fields within the folder.
FOLDER BUBBLE TEXT:
FIELD BUBBLE TEXT:
Job Cost
Purchasing
General Ledger
Accounts Receivable
Financial Summary (Enterprise Only) - Profit and Loss with Actual/Budget/Forecast (and by class)
Cash Requirements
If you change one of the refresh options in the QQube Add-In to something other than the top prompt, then save, and then re-open, the change would not show.
Requirements
.NET Framework 4.7.2 will be the new requirement.
Database Update
Using Release components 17.09.4838
Installation
Users will no longer have the option to "install for all users", as this created a problem for multi-user server installations. It allowed every person to become a potential synch user, creating a multitude of errors in scheduled synch situations.
The ODBC drivers are installed "for all users" as System DSN.
If you install the Multi-User Version (Server portion) or the Single-User version, the database engine, associated permissions, and the synchronizer will be assigned to the current user it is being installed to - and nobody else.
.VSTO Installation (Installer)
We located an issue with adodb.dll which is a Microsoft dll allowing us to talk with Microsoft Query with the Excel Add-In. Microsoft introduced the same version, but with a different date (they admitted their error) - causing the installer to stall.
This has now been changed, as we have just compiled this dll into the .VSTO itself, thereby eliminating any chance of this happening again.
Program Shortcuts
Shortcuts to running the QQube Configuration Tool will originate from the specific user, instead of the public/all users directories.
The auto startup links will launch from:
The icon link will launch from:
Configuration Tool - Title
Easier to Identify what type of user is engaged when logged into to the server.
Configuration Tool - Available Analytic Areas
Analytic Areas have been re-arranged to:
The current schema information on our website already reflects this change.
Configuration Tool - Available Financial Statement Analytics
All individual pieces of the Financial Statements and Financial Statements by Class will now show in the QQube Configuration Tool. There will be one 'parent' check box that will auto check all dependent analytics.
This is a change from previous versions so that you can see what actually gets loaded.
Fiscal and 52/53 Tax Year Options
We have moved these options under advanced options for simplification. Given the new Available Analytic Groupings, it made little sense to have the same option in 4 or 5 different places.
Configuration Tool - Advanced Options
Multi-User Version (Server Portion) or Single-User Version
Multi-User Version (Client Portion)
We eliminated options that were no longer needed in the current Sybase technologies.
Note that the synchronizer and database manager options are no longer able to be checked or unchecked.
Configuration Tool - Data Synch - Scheduler
We removed the Run Now button from the Scheduler Page to reduce possible confusion with the values in the Logs>Refresh Type column.
Manual Refresh Load Options
We have reworked the list of analytics to be loaded to resemble the hierarchy of available analytics to assimilate congruency and less confusion.
Configuration Tool - Data Synch - Synch Logs
We have reworked this screen to give more pertinent and readable information for the end user.
Actual log.
Also contains previous log summary information.
Example Files are Read Only
Examples are now read only, except for Microsoft Access which writes in real-time. Applications like Excel can have auto save options, which overwrite the initial examples. This will prevent that.
Example Files Open When Loaded
Examples for unloaded analytics will be grayed out in the example section of the QQube Configuration Tool. You can also alphabetize each column in the example area.
Manual Client Connection
In cases where it is necessary to put in the host:2638 information in the connection box in the multi-user client, you will only be allowed to put in ip addresses. e.g. 190.170.120.100:2638
IF DSN is configured incorrectly on a network, and you use the host name, it can can cause slowdown in opening up Excel files.
Your entry now look something like this:
Wizard
The wizard will display choices that more closely resemble their business and how they use QuickBooks
BUSINESS WIZARD PORTION
FISCAL YEAR WIZARD PORTION
Please enable JavaScript to use file uploader.
Your session has expired. You are being logged out.