QQube Version History - 4,5 | CLEARIFY

Version 5.76 (Build 364) [03/25/2016]

• Employee Target Bonus.  Previously the synch would fail if the employee target bonus field contained a percentage instead of a dollar figure.  This has been fixed to use either method.
• Financial Summary Reports.If the Financial Summary example in the QQube Configuration Tool was opened, the correct months and years did not refresh.  This has been fixed to show the proper month and year, corresponding to the 3 year period selected in the QQube Configuration Tool under the Financial Subject Area. These are:
  • Financial Statements By Class
  • Financial Statements
  • Financial Statement of Cash Flows By Class
  • Financial Statement of Cash Flows
  • Financial Trial Balance Activity By Class
  • Financial Trial Balance Activity
  • Job PandL Summary
• Credit Memo Linked Transaction Count.  The correct count of Linked Credit Memo Transaction has been fixed.  This field resides in the Linked Transaction FACT tables for Sales, Job Costing, and Inventory subject areas.
• Bank Transfers. Fix issue to accommodate a rare saving process anomaly found in earlier releases of QuickBooks.  Debit and Credit Amounts, and Summary Line designation were affected. This is now fixed.
• Trial Balance Activity - Retained Earnings Amount. Fix issue where, when not using classes in QuickBooks, Retained Earnings in the Trial Balance Activity by Class would show 0.00  The correct amount now shows.
• Trial Balance Activity and Trial Balance Activity by Class. Fix issue where journal entries that included a posting to the Retained Earnings Account in the first period of the year, would cause an incorrect Activity Signage Amount in that period.
• Job Rep DIMENSION. Fix issue where Link to Sales Rep ID was incorrect in the Job Dimension, and returning the Customer Sales Rep, instead of the Job Sales Rep.
• Price Level. Fix issue where link to Price Level ID was incorrect in the Job Dimension, and returning the Customer Price Level, instead of the Job Price Level.

Version 5.75 (Build 358) [11/11/2015]

• Line Custom Fields. Fixes issue where new Line Custom Field information recently exposed by Intuit for Bills, Checks, Vendor Credits, CC Charges and CC Credits was not getting extracted properly from QuickBooks.
• Financial Summary Numerical Field Width and Format.  Change Numerical format to (15,2) which is 15 total numerical characters including 2 decimal places to play nice with Microsoft Access.  Previously numeric fields were being ready by Access as Short Text.

Version 5.75 (Build 356) [11/06/2015]

• No Data Changes.  Fixed upgrade installation issues for Excel and certain previous versions of QQube.

Version 5.70 (Build 355) [10/27/2015]

• Job Costing. Issue fixed in QB Pro/Premiere versions where service items in payroll would not show in the Job Cost Labor Amount column.
• Job PandL Summary.  Re-worked JobPandL Summary subject to accommodate large (tens of thousands) numbers of jobs inside of QuickBooks.
• Customer Contacts. Create work around for Intuit bug, where customer contact timestamps were showing incorrectly as 00-00-00
• Financial Summary. Fix Encoding issue which would prevent QB summary financials with account numbers to not load correctly - and for strange characters to show in the PowerPivot data models using account number AND name fields.
• Microsoft PowerBI. Fix connection string errors in templates when opened from the QQube Configuration Tool.

Version 5.70 (Build 353) [9/19/2015]

• QuickBooks 2016. Support for this version is included in this release and necessary for QQube to work with 2016, as Intuit has exposed new information.
• QuickBooks Canada 2015 R7.  Support for this version is included in this release and necessary for QQube to work with Release 7 for QuickBooks Canada.  Developer features that were made available in the US version of QuickBooks 2016 were implemented in the Canada version of QuickBooks 2015 beginning with Release 7.
• New fields recently exposed by Intuit to developers.  ThesefeatureswerefirstavailableinQuickBooks in 2014, but not available to developers until now.
  • New Employee Fields.  Supervisor, Department, Description, Target Bonus, Emergency Contact Information, Part Or Full-Time, Exempt, Key Employee, Original Hire Date, Adjusted Service Date, US Citizen, Ethnicity, Disabled, Disability Desc, I-9 On File, I-9 Work Auth Expire Date, US Veteran, Military Status
  • Notes Lookup.  Added new Notes format to Customers, Employees, Vendors
  • Contact List Lookup. Added for Customers and Vendors
  • Sales Rep for Expense and Item Lines. Added Sales Rep Information for line detail from bills, checks, credit card charge, credit card credit, and vendor credit.
  • Custom Fields for Expense and Item Lines. Added Custom Fields for line detail from bills, checks, credit card charge, credit card credit, and vendor credit.
  • Addresses on Bills.  Bill City, State, Zip and Country added
• New Sales Rep Dimensions.  Added this capability to the following subjects: Accounts Payable, Open Purchase Orders, Job Cost and Purchasing.

Version 5.67 (Build 350) [8/11/2015]

• Fully Paid Date for zero dollar bills and invoices.  The correct date now shows in the Job Cost and Purchasing Subjects.

Version 5.67 (Build 349) [6/22/2015]

• Payroll (Australia only). Fixed issue where payroll information was not getting pulled in.

Version 5.67 (Build 348) [6/13/2015]

• Purchase Orders (Site). Fixed issue where Site was listed in header but was not showing on each line item for QQube.

Version 5.67 (Build 347) [5/11/2015]

• Updated SQL Anywhere Engine. The latest SQL Anywhere updates are included (Version 12.0.1.4231)
• General Ledger Detail. Added a separate Document Memo field to be able to mimic certain types of Detail Profit and Loss Statements. The document memo is available for each line if detail if needed.
• Sales Rep Information.  Fix issue in Sales Rep Dimension where E-mail, and several other fields from the employee rep record were not showing the correct information.
• Multi-Currency USA. Fix issue where bill payment checks, and bill payment credit cards were not showing the correct foreign amount, and exchange gain/loss.
• Inventory Transfers in Excel PowerPivot.  Fix issue with duplicate LineID's.  This would previously cause an error in Excel PowerPivot.
• Enhanced Inventory - Item Receipts.  Fix issue for incorrect values on item receipt lines where QB Enhanced Receiving is turned on, and COGS entry gets created by QB. 

Version 5.66 (Build 343) [3/2/2015]

• Purchase Orders. Fixed a bug which caused the Sync process to fail on cases where there were large numbers of historical Purchase Orders, or large number of lines per Purchase Order. The sync log would show the following error: "Arithmetic operation resulted in an overflow".
• General Ledger and Class. Fix issue with Class and associated LineIDs not showing in the General Ledger subject for the summary line of Journal Entries.
• General Ledger and PowerPivot. Fix issue with duplicate General Ledger Line IDs when multiple items are being paid, and each has a discount taken. This would previously cause an error in Excel PowerPivot.
• General Ledger Master Linking Number.  Change master linking number in Receive Payments in G/L where Payroll Liability Check is attached to Payment. If using Pro or Premiere, this feature will not be available will show as Ref Number instead of txn number.

Version 5.65 (Build 333) [10/23/2014]

• QuickBooks 2015. R1 from Intuit produced custom fields out of expected alphabetical order, and R3 produced changes in the custom field structures.  This release will restore the alphabetical list of QuickBooks custom fields, which has existed since day one of our product; and will accommodate the new custom field structures.
• Multi-Currency Intuit Bug Fix. A bug has existed for many months in the Intuit Software Development Kit regarding the General Ledger details of a special account created by Intuit for Exchange Gain/Loss of Currency.  Intuit found a workaround for us, and this has been implemented in this version of QQube.
• Multi-Currency Bug Fixes.
  
  • Fix issue with CA Multi-Currency Version where PST should be included in G/L Line item Figure for Check, Bills, and Credit Card Charges
  • Fix rounding issues where multiple linked transactions might cause the Gain/Loss to show a rounding error. This was fixed for Receive Payments, Bill Payment Checks, and Bill Payment Credit Cards.

Version 5.6 (Build 329) [8/19/2014]

• Job Cost. Added two new dimensions: Customer Rep, and Job Rep.  Customers who use these fields for supervisor, inspector etc. will now be able to classify their jobs according to one or both dimensions.
• Time Tracking. Added Service Item Rate, and a calculated field for hours x Item Rate for easier reporting in Excel Pivot tables.  This was in addition to the previously existing Billing Rate, and/or Price Level Rate.
• Time Tracking. Added Source Name Dimension to encapsulate both Vendors, Employees in one field
• Tableau.  Added out of the box support for Tableau 8.2 users (https://tableau.com)
• PowerPivot Examples. Added enhanced examples for Inventory Forecasting, Inventory with Sites/Lots, Profit and Loss with General Ledger Detail.
• PowerPivot Enhancements.
  • Added hierarchies for automatic date drill down: e.g. year-month-date, year-quarter-period-date for 5253Tax Year, etc.
  • Days of the week, Month names now come out in proper order - not alphabetically.
  • Rate fields will default summarize as AVG, not SUM.
  • You can choose the default date ranges to use in QQube e.g. 5 years of data instead of the default 25.  This will exponentially speed up the PowerPivot reports.

Version 5.5 (Build 295) [1/23/2014]

• Trial Balance by Class - Long awaited feature which shows Ending and Beginning Balances, period activity and budget
• Cash Flow Activity by Class - Statement of Cash Flows by month, by class
• Multi-Currency - Exchange Rate Detail, and Currency Dimension available for each subject
• Support for CA and UK - QuickBooks CA and UK 2013 versions and above are supported, including all available sakes tax rekated fields e.g. PST, GST for Canada, and VAT for UK.
• Additional UofM Fields for QuickBooks Enterprise Users - Users can now show both the quantity based upon the base UofM - OR - show the printed quantity and UofM for each line detail of a particular transaction.  Added UofM dimension for the following subjects:  Sales, Purchases, Job Cost, Inventory, OpenSO, OpenPO, Requires Enterprise 11 and above.
• Speed Improvements to Balance Sheet by Class - For users with hundreds of classes, the load time is up to 90% faster in this version.
• Fiscal Year Support for Job Costing - Users can analyze job costs based upon non-calendar fiscal years.
• Job Costing WIP - Price Level or Billing Rate Calculations added to Job Costing for those wanting job cost valuation, and comparisons to actual billing.
• Purchasing Discounts - Suggested and Actual disccount amounts now available in the following subjects: Cash Requirements, A/P, Inventory, Job Cost, Purchasing  
• Additiona Lists - All lists are now available.
• Simpler Company Setup Subject.  New company setup subject loads all lists, custom fields, preferences, Price Level by Customer, Billing Rate by Entity.  Price Levels, and Billing Rates were previously listed as separate subjects. 
• BOM Subject Changes - BOM is now a separate subject underneath inventory.
• Inventory Transfer Amounts - due to limitations in the Intuit SDK, Inventory Transfer Amounts were previously not available.  They are now available for Enterprise Users.
• OLAP Cube Support for SQL Server Analytic Services - Customers can either create their own multi-dimensional cubes, or purchase the pre-built SQL Server cubes. SQL Server Analytic Services for 2008 and above are required.
• Tableau Support - Users can create their own shells, or purchase the pre-built templates for Tableau 8.0 and later.
• Over 100 Fields Added - The additional functionality means more information options to report on or analyze.
• Financial Statement Auto-Format - One button formatting for Profit and Loss, and Balance Sheet Financial Statements.
• PowerPivot - One button formatting for Financial Statements - including PandL from G/L detail - now available.
• Financial Summary Periods now have Labels - Using the Excel Add-In will now show proper year and month for each period.  What previously showed as Period 01, now shows as Jan 2013.
• More Examples - New reports, and additional measures for PowerPivot examples now included.
• Better Formatting -  9pt font for crisper readability for first time users.
• Open A/R - fixed issue where sales tax items as line items in invoices and credit memos were not showing.
• Job Costing - fixed issue where Markup Amount was not calculated when markup % was used.
• Time Tracking - fixed issue where price level rate was incorrect.
• Invoices (All subjects) - fixed issue where quantity wsa null, percenetage > 0 and total line amount > 0 would show null quantity instead of 1 (as QuickBooks does).
• Internal Configuration Changes - Changes to create better handling of initial loads and logic.
• 5.5 Patch information

Version 5.1 (Build 243) [3/26/2013]

• Vastly Improved Refresh Times from 5.0 - New algorithms and indexes improve speed by up to 90% in certain instances.  Our fastest, most efficient release to date.
• Source Name - Source Name Dimension has been added to mirror QuickBooks report functionality.  Available in Job Cost and GL Detail Subjects.
• Auto Number Format for G/L Detail - One button push to properly reverse the sign for income and other income when creating a P&L Fiscal, Calendar, 52/53 Profit and Loss - with details
• One-Step PowerPivot Refresh - PowerPivot tables typically require five manual steps. The QQube ribbon contains an icon that will peform both steps at once.
• Abort Option - Users can now use this button to properly stop the refresh operation.  Previously it would require ending multiple processes in the task manager. 
• Audit Trail Date Load Option - Added option to load data 'since'
• List Lookups - Complete list information without transaction detail for Accounts, Classes, Customer, Job, Vendor, Employee, Employee HR, Vendor, Other Names, Sales Reps, Templates.
• Synch Log Mass update - New button will allow user to update all logs as 'read' 
• Easily Move or Update QQube Database - Added right click one-step options to create new database, rename existing database, or move existing database
• Accounts Receivable - Fixed the following missing A/R elements:  Unapplied CCRefunds adn Check refunds, CC Charge and Credit.  Also fix bug where certain invoices were not showing.
• Sales Tax- Fixed diivision by 0 error. Fixed issue where taxable/non-taxable amounts were not calculating correctly when %discounts where preceeded by groups. Fixed abnormal refresh times.
• Audit Trail - Fixed truncation error. Fixed issue where refresh was hanging. Sample files will only load data from 12/15 of the appropriate year for the QB sample file
• Job Cost -  UofM dimension has been restored
• Classes- Fix issue where an extra row of null values appeared.
• Payroll - Fix error where certain payroll adjustments would not show if there was no employee assigned to the payroll item
• General Ledger - Fixed the following issues: Summary/Detail Line Stats and Summary Account in Journal Entries; overstatement of overpayments in the G/L Detail when combined with payment discounts; sales tax items not showing up; debit entry on G/L detail was showing up as negative credit.
• Inventory - Fixed issue with bin locations and inventory transfers; and blank assemblies and adjustments; incorrect open so when serial#/lots present
• Other Names - Log would show 'Unique Index' Error, and not finish the refresh.
• Scheduler - Advanced Scheduling Options were not working properly.  This has been fixed.
• Trial Balance Option Missing - Fixed issue where current Trial Balance was not showing when selecting Cash Requirement options
• 1099 - Fixed error where 1099 information would not load due to 1099 Printing Preference set to no.
• Configuration Tool Status line - Fixed issue where 'Qube is ready for use' would appear incorrectly.
• Error when unchecking last field - Fixed issue where if last field in subject details folder was unchecked, user would receive error.
• Adding Manual Filter using MSQuery returned error - Fixed issue where advanced users would use MSQuery to create a manual filter, and when returnd to Excel would get an error.
• Hide Rows Function (Balance Sheet Summary) - Fixed issue where additional rows would cause incorrect row hiding - and then QQube not auto-fixing this anomaly when invoked on ribbon. Re-invoking the hide function works as expected now.
• PowerPivot 2013 - Added PowerPivot 2013 examples in the community file section.
• 5.1 Patch Information

Version 5.0 (Build 240) [3/13/2013]

• Added Audit Trail, Balance Sheet by Class, and Sales Tax Subjects
• Add Line Sequence Number to Open SO and Sales Subjects
• Fix error in Account BS Grouping where long term liabilites were mislabeled
• Fix Percentage fields in Terms
• Add Job Cost Open Credits
• Fix issue where signage of credit memo sales tax was reveresed
• Fix case where null value was showing for job cost amount
• Fix Taxable status for Customer and Item Dimensions
• Add holidy, weekend fields to job cost trip start/end date dimensions
• Fix Naming of TimeCreate/TimeModofied fields for Inventory, sales, OpenSO, Sales Consumption
• Correct Typo in Line 4 of all list addresses
• Correct date formatting for single date field in JobFACT for job start, end, projected end dates
• Fix issue with sales receipt item tax code
• Fix issue where Payroll End Start Date Dimensiosn different in Payroll vs Job Cost
• Create Inventory field called inventory Document Forecast Type  for easier viewing of on hand, openSO, openPO
• Consolidate custom fields, preferences, all lookups to Company Setup subject
• Fix issue where some items with no parents were showing as null
• Create single link relationships links between FACT and DIMENSION - for PowerPivot, SQL Server
• Add 2013 Fields:  Bin Location, entity information
• Add Company DIMENSION to BSClass Subject
• Fix First Period of Trial Balance Activity
• Add Site and Bin location to Sales Subject
• Add Sales Tax Item DIMENSION to work with the following subjects: Open SO, Sales, Open A/R, CashRequirements, GL Detail, Sales Consumption, Extended D/L Detail, Audit Trail.
• Fix issue with vendor credits not showing associated jobs on expense lines
• Add LinkToPriceLevelID to both Customer and Job; Add LinkToBillingRateID to Vendor, Employee easier theoretical billing rate reports (link to LOOKUP for billing rate or Price level)
• Fix issue where invoices were not geting loaded into open SO subject
• Fix issues with Linked PO Txn where linked Checks and CCCharge were not showing amounts
• Fix issue with open and paid line and document amounts for credit memos in Sales Subject
• Add Sales Tax Code Dimension for Customer and Items

Version 4.1 (Build 190) [7/8/2012]

• Fix issue with Inventory Account ID and Amount showing as null where COGS was generated by QuickBooks in Assembly Build
• Fix issue where if first listed account number in string of account full name is also a segment of subsequent account numbers in the row data string, then parsing would not work.

Version 4.1 (Build 187)

• Fix bug where budget and forecast information not showing up properly in G/L Detail subject
• Fix issue with linked transactions:  Statement Charge, Credit Memo and Bill Payment Check

Version 4.1 (Build 184)

• Added Employee Birth Date, Type, Gender, Hire Date, Release Date
• Fix bug where Employee ID were missing from G/L FACT table

Version 4.1 (Build 182)

• Re-architected to rectify speed issues with respect to updates and refreshes
• Added field called 'initial Invoiced Quantity' to calculate Fill Rate
• Added Serial Number Fulfillment to Open Sales Order Subject
• Added Site information to Open Sales Order Subject
• Improved data extracton algorithms for build assemblies, open PO,and bank transfers
• Job costs in the Job Cost Subject now account for items posted to balance sheet accounts
• Fixed bug regarding item receipts and converted bills
• Fixed Document PO Number missing in Job Cost Subject
• Fixed Bug in A/R and A/P where payments applied to bills dated after the payment were showing incorrectly

Version 4 

• Added Lots and Serial Numbers - Individual Line Detail
• Open SO includes Assembly Components
• U of M Dimension available for Enterprise Users
• Custom Fields for Vendors (on Purchase Orders) now available for inventory subject
• Added 52/53 Week Tax Year
• Added group linked transactions in G/L Detail (Master Number connects invoices & payments, applied credits, etc.)
• Added Trial Balance Activity - 36 periods. Can peform: Prev Balance, Current Activity, Current Budget, Ending Balance
• Added Statement of Cash Activity
• Added ability for Forecast, Budget and Actuals in same report
• Added Profit and Loss by Job Summary (36 Periods) with % Sales Columns
• Added Payroll item and payment Method Dimensions to G/L Detail
• Added Account Category Filter:  P&L or BS
• Added calculated columns for Est/Actual Job Cost Labor Amount (based upon Service Items only) and Est/Actual Job Cost Material Amount (based upon non-inventory, inventory and assembly items only)
• Added Class Grouping Mechanisms - similar to Account, Customer'/Job and Item multi-level groupings
• Added BOM LOOKUP Subject
• Added Custom Field LOOKUP Subject - easier to determine Custom Field Names