At Qvinci, we listen to your input, resolve issues, and regularly enhance our platform’s capabilities to provide a more powerful, productive, and profitable solution for our customers. – Actionable financial insights everyone understands!

December 2023

Bug Fixes / Feature or Functionality Enhancements

ATTENTION: For all Non-Sunday Aligned General Ledger-Based Reporting entries below, please note that the P&L GL Weekly Reporting with Non-Sunday Aligned Weekly Reporting and Customizable Accounting Calendars functionality is in BETA and scheduled for a Q2 release.

• Improved overall performance of the current GL pipeline processing by modifying the resync timer to 30 mins instead of 5.
• Improved GL Weekly Reporting by refactoring GL Weekly QBO By Class Queries to account for potential corner cases when users change the names of their classes after initial link and sync.
• Revised to all Date Ranges support a calendar with a 6 week twelfth period for GL Weekly users.
• Fixed issue where a Client/Company with a short Accounting Calendar running a P&L GL Weekly report would fail with a "Something went wrong" HTTP 500 error with no further explanation. The message "Your Accounting Calendar start date does not go back far enough..." now correctly identifies the error instead of "Non-static method requires a target" and this message appears in the UI after the "Something went wrong" message.” This change affected only the By Period frequency.
• Fixed issue where running a GL Weekly report with offsets, if the offset caused the start date to go back beyond the beginning of the franchise Accounting Calendar, a telemetry email error was sent with no reason in the UI. Now, the standard Short Accounting calendar message, "Your Accounting Calendar start date does not go back far enough...," appears in the UI and the email when this error is caused by an offset.
• Improved usability by revising so users are unable to change the Accounting Calendar periods via an Accounting Calendar upload.
• Fixed issue of bug in QBO by class causing data issues in the QBO By Class GL Weekly reports. Now, the correct date range and data are returned for users of 13 Period Accounting Calendar Last 24 Period by Total. (QDC-18292)
• Fixed GL data issues related to trailing white space in Account Names coming from QuickBooks.
• Fixed GL report click through issue where clicking through on a MAPPED P&L or Balance Sheet still returned the entire Account Type for File GL viewers. Now, filters down per selected account.
• Created new Balance Sheet report with Elimination, enabled by ticking checkbox "Enable Elimination" in Report Editor > Column Chooser when eliminations are enabled.
• Revised so eliminations data only displays for the correct AOD / Date range combo for Eliminations reporting users.
• Revised so the debit / credit balance of the elimination is taken into consideration instead of always being subtracted from the Total Before Consolidations for Eliminations reporting users.
• Revised so that Eliminations Entry page users no longer see extra numbers in front of their Account names in Account Name field.
• Revised so that when user selects a Company/Client in a subsequent row, the Entities dropdown for other rows no longer changes to the Entities for the most recently selected Company/Client.
• Fixed issue of Entity list not populating on page load and not only on Company dropdown change in Edit Elimination page.
• Fixed issue of Entity dropdown populating data irrespective of whether Company dropdown has a selected value or not for a given row. Now, Entity dropdown data is dependent on whether Company is selected for the same row and will not populate independently in subsequent rows.
• Enhanced customer service by providing an Admin Portal page for CS/Qvinci Staff to review the percentage of accounts mapped by Franchise/Organization. Data is downloadable to Excel, sortable, and can be paged or filtered for the purpose of easily accessing actionable data to help customers improve their results.
• Enhanced customer service by ensuring that the basic report runs that are part of the sync process are not included when Qvinci staff uses BASIC report run metrics. Now, staff can accurately measure TRUE Basic Report runs to better serve customers.
• Upgraded Qvinci’s previous XE data feed to the most recent and more robust version of the XE.Com API.
• Revised by adding a link in the Gallery Tab of the Libraries pointing to the Qvinci Zendesk legends article, which helps Gallery users find the report they need per their naming convention.
• Revised so MAPPED account click throughs consistently and accurately filter the GL Activity report for File GL viewers.
• Fixed an issue when syncing multiple QuickBooks Desktop classes, where data from a class would merge into the wrong entity when one of the class names was a proper subset of another class name in the same file. Now, Class data is processed into two separate classes.
• Qvinci Report Editor enhancements available with the nee v 16.2.6 version of spreadJS:
  • Import and export encrypted Excel files using SpreadJS Designer.
  • The display of frozen rows and columns is enhanced to have the same behavior as in Excel.
  • Added support to copy Excel styles and data of cells from Qvinci to Excel properly.
  • The SUMIFS formula now generates the same result as Excel.
  • SUM and AVERAGE functions now generate consistent results in both Qvinci and Excel.
  • The search behavior logic is now consistent with Excel
• Revised to ensure SQL Query Store remains active after publishing updates, in order to continually record database query information for optimization and performance improvements.

*****************************************************************************************************

November 2023

Bug Fixes / Feature or Functionality Enhancements

ATTENTION: For all Non-Sunday Aligned General Ledger-Based Reporting entries below, please note that the P&L GL Weekly Reporting with Non-Sunday Aligned Weekly Reporting and Customizable Accounting Calendars functionality is in BETA and scheduled for a Q2 release.

• Enhanced performance by modifying MergeGL Process to split the import.gl table on a daily basis in order to reduce space and processing time for syncs that did not complete.
• Enhanced performance by modifying the Admin Portal UI to allow CS to choose between generating a 12 Period calendar or a 13 Period calendar for a given Company/Client.
• Revised to provide dynamic filtering of Relative Date Ranges for P&L GL Weekly Basic Reports, to prevent users from running reports with incompatible options.
• Enhanced usability by revising so users assigned to the Manager role can now view Accounting Calendar properties, and can export or import Accounting Calendars.
• Expanded the GL Weekly Accounting Calendar Unit Tests run for continuous integration, to include testing a 13 period calendar.
• Fixed issue of Weekly Roll Up Sproc not accounting for Corner Case Dates. Now, only Roll Ups with valid dates are added.
• Fixed issue of by Quarter date ranges not accurately reporting for P&L GL Weekly report users. Now, by Quarter date ranges work with offsets for accurate reporting.
• Fixed issue that was causing data irregularities in GL weekly data when both By Location and By Class entities were synced from the same QBO files. Now, such transactions are not included in P&L GL Weekly rollups.
• Fixed GL Data issue related to trailing white space in Account Names coming from QuickBooks. Now, accounts in the GL service match their corresponding summary accounts (that have whitespace at the end of them).
• Created a query that provides metrics for showing the number of accounts mapped vs not mapped, showing the percentage of mapped accounts for a company/client.
• Added initial infrastructure for Eliminations. Eliminations can be enabled/ disabled on Network level in the database. This allows Qvinci to have an Eliminations Beta launch when it's ready for beta and to turn Eliminations off for a customer that does not want the feature.
• Revised by adding a new Eliminations Entry and List pages, similar to how Journal Entries work. The new page is accessed from Manage > Eliminations if access is enabled on Network level.
• Revised so P&L Styled Reports can show Eliminations in new Debits and Credits columns, if selected from Column Chooser (by enabling Elimination checkbox) and if Eliminations are enabled.
• Revised by removing $ Diff or % Diff options for future budget users as they will always be against 0 data.
• Fixed issue of Period over Period frequency Reports using future budget date ranges missing financial data. Now, all the available data comes back for all available columns for accurate reporting.
• Upgraded the Advanced Installer used to build the Sync Client from version 20.9.1 to the latest version 21.1.0.
• Performed quarterly server, storage, and security maintenance 2023 Q4.
• Fixed issue where some Excel exports were missing styles and formatting. Now, new Ranking Reports have relevant styles and formatting.
• Fixed inserting sync history records into the database to reduce table contention.
• Fixed issue of Excel Exports from Preview sometimes exporting a very-hidden linkref sheet for GL drill down. Now, GL clickthrough reference sheets are prevented from being exported to Excel from Previews.

*****************************************************************************************************

October 2023

Bug Fixes / Feature or Functionality Enhancements

ATTENTION: For all Non-Sunday Aligned General Ledger-Based Reporting entries below, please note that the P&L GL Weekly Reporting with Non-Sunday Aligned Weekly Reporting and Customizable Accounting Calendars functionality is in BETA and scheduled for a Q2 release.

• Revised for GL P&L Weekly users by adding support for 13 periods per year via the Accounting Calendar. The Accounting Calendar can now be customized to place the 13th period in any quarter or to customize the weeks per period.
• Enhanced user experience by revising UX for the Accounting Calendar to show the number of Periods per Year instead of the Period Pattern.
• Enhanced user experience by revising overall GLMerge process so when performing a GLMerge sync, users gets their results as fast as possible.
• to automatically purge stale record from the GL Import Table to reduce the probability of dataset deadlocks and improve performance of overnight GL syncs.
• Improved overnight QBO and Xero sync performance by increasing the number of merge threads in the IS from 8 to 16.
• Improved GL merge performance and efficiency by removing GL Import table deletes from the NodeJS service.
• Fixed issue of QBO By Class GL Weekly transactions being reported twice if the transaction reported on a Location/Department name that also matched the class name. Now, GL Weekly Rollups create only 1 transaction regarding said criteria.
• Fixed issue in the GL Weekly column chooser wherein date ranges reported incorrectly, and no values showed, for the Total selection, Next Fiscal Year, and the Next Calendar Year column chooser selections. Now, the date ranges are correct and values show.
• Revised GL Rollup job scheduler so it retries GL rollups that fail to complete due to timeouts.
• Fixed issue with by Quarter and by Year frequency reports erroring out when using future budget “Next Fiscal Year” and “Next Calendar Year” date ranges. Now, now longer errors out regarding this criteria.
• Fixed an “internal server error” when generating the Qvinci Budget template from an essentially empty QB / QBO file containing only a small number of transactions and account types. Now, the Qvinci Budget template generates without issue.
• Fixed issue where an Entity Syncer who canceled linking QBO or QBO by Class file from the Intuit handshake screen generated an error instead of remaining on the UX for the Entity they were working with. Now, Manage > Entities loads for the specific Entity so the user can mange the Entity moving forward.
• Fixed issue where a QBO / QBO by Class Entity Syncer was being taken to the Budget tab after linking and syncing rather than staying on the File tab. Now, the user stays on the File tab when they initially link and sync their file instead of being taken to the Budget tab.
• Revised for Budget Entity Syncers so the correct Zendesk URL populates in their Qvinci Budget template so they can easily find guided help.
• Fixed issue of header rows missing for key account types for Budget Developers. Now, the Qvinci Budget template includes all key account types and account rows even when they do not yet exist in the QuickBooks file, ensuring header rows remain present.
• Revised by changed login process to prevent multiple users from logging in concurrently with the same user id during overtake from admin portal.
• Improved customer service by creating a metric to capture the number of executions of gallery reports and packages to better understand what reports our customers use the most and least. Now, Qvinci can focus efforts on the styled reports having the most impact, and so we can help customers who are currently underutilizing styled reports use them better.
• Updated the Metrics Build Active Customers table to handle potentially bad data/conversions issues.
• Updated the V2 Styled Report Service, removing workarounds, outdated, and obsolete code to increase report loading and hydrations (preview) performance.
• Deprecated obsolete code used for Package Downloads to speed up Package Generation for Reporting Service Optimization Developers.
• Optimized export to Excel from Report Editor to reduce the amount of time spent by the user waiting for the exports.
• Optimized PDF Exports from the Report Editor and Previews to reduce the time it takes the user to receive their PDF.
• Enhanced user experience by adding File GL Viewers to the list of users who can use GL click throughs from styled reports into the General Ledger
• Fixed issue of user getting no data on successive exports to excel when exporting large data set for new ranking report. Now, the user now gets relevant data.
• Fixed issue of the GL drill down sometimes not showing transactions for P&L, due to confusion between "- Other" account names. Now, GL drill down shows all relevant transactions for P&L.

*****************************************************************************************************

September 2023

Bug Fixes / Feature or Functionality Enhancements 

ATTENTION: For all GL Weekly entries below, please note that the GL Weekly reporting functionality is scheduled for a late Q3 or early Q4 release.

• Revised so QuickBooks Desktop no longer displays a Certificate Revoked message when trying to link or sync with the 3.124.1 Qvinci Sync Client.
• Upgraded the Sync Client installer software from Advanced Installation 9.0.1 to 20.9.1 in order to utilize the DigiCert code signing service associated with the new code signing certification process.
• Enhanced Customer Success performance by revising so that automatic updates to the new Sync Client version are staggered to minimize potential support calls if all customers update their sync clients at once.
• Enhanced Customer Success performance by adding the end of the sync file detail page in the Admin Portal so CSM knows the Qvinci Sync Client version being used and its IP address when troubleshooting.
• Enhanced user experience for QuickBooks by Location users by listing Location on GL Activity summary and revising so generates P&L Weekly rollup reports.
• Fixed issue of GL validation producing erratic results by revising to properly validate P&L GL Weekly accounts ending in “-Other” for QuickBooks Online files to ensure they produce consistently accurate results with QBO.
• Enhanced Customer Success performance by revising so telemetry emails are sent when customers use an incomplete Accounting Calendar during report generation so CS can quickly help fill in the missing Calendar dates.
• Fixed issue of the GL Rollup Service dying off and going into a stopped state by catching and logging exceptions related to reporting errors.
• Enhanced usability for GL Weekly Reports users by revising so Libraries and Basic reports and packages run even when one of the user’s entities has a disconnected file, instead of erroring out.
• Fixed issue for Qvinci Web Admins of the previously removed P&L GL Weekly checkbox submitting behind the scenes in Manage > Company/Client > Accounting which inadvertently turned off P&L GL Weekly reporting capabilities.
• Improved usability for QBO Future Budget users by revising so that Next FY Budget from QBO no longer remains mapped when using Qvinci Budgeting.
• Improved usability for Budget users by revising so:
  • Can filter Tools > Sync Activity by Qvinci Budget type similar to filtering for other file types.
  • Entities budget selection reverts back to QuickBooks or QuickBooks Online option after disconnecting and relinking an Entity.
  • Q-Budget last sync date/time updates after importing a new Q-Budget into QBO and QBO By Class Entities.
  • Budget upload confirmation displays Entity to which user is syncing.
  • Sync confirmation time on Manage > Entities > Budgets tab adjusts for UTC.
• Improved usability for QBO and Q-Budget Entity syncers by revising so QBO financial file no longer syncs when syncing Q-Budget.
• For Qvinci users without P&L GL Weekly enabled, improved buying access by revising so will receive friendly option-to-purchase message when trying to Preview or Download a Package containing a P&L GL Weekly Report.
• Enhanced user experience by revising so that the helpful error message in Qvinci Report Template Preview has clear instructions and a clickable link to contact Qvinci Support.
• Enhanced user experience by revising so that when running a Balance Sheet Peer Benchmarking report, the user gets “Peer Benchmarking reports must be mapped” message when running unmapped Benchmarking Balance Sheet reports.
• Enhanced user experience by revising so that when running P&L Peer Benchmarking reports, user gets a friendly “Peer Benchmarking reports must be run mapped” message when running an unmapped Benchmarking P&L report.
• Enhanced user experience for Report users by revising so they get friendly error messages for unsupported entity or report combinations when running Template Reviews or Downloads.
• Enhanced user experience by revising so that when using Report Preview for Cash Flow / Trial Balance / AR & AP Aging with file types tied to Entities in the Filter, the user gets “report not available for…” message that’s relevant to user’s intention.

*****************************************************************************************************

August 2023

Bug Fixes / Feature or Functionality Enhancements 

ATTENTION: For all GL Weekly entries below, please note that the GL Weekly reporting functionality is scheduled for a late Q3 or early Q4 release.

• Enhanced usability by enabling users to import budgets from .xls into Qvinci.
• Enhanced usability for Budget users by lifting restriction that limited YTE and Custom Date ranges to only run to the end of the current year.
• Enhanced usability by revising so that Future Budget users have “Next Fiscal Year” and “Next Calendar Year” date ranges available for future budget planning.
• Enhanced Customer Success capabilities by revising so that accounts that have no email address for admin have structures deleted and the account set to inactive.
• Enhanced user experience by revising so that the prorated portion of a customer’s Entity Slot purchase looks like the discount from the purchase (in brackets) rather than an addition.
• Revised Discrepancy Type issue wherein GL account did not match any summary account email recipient by adding the name of the missing account to the GL Weekly invalid report telemetry emails used for GL Weekly validation analysis.
• Revised by removing the Group By clause from GL syncing to prevent transaction lines from being dropped in the GL Activity Report, which then also affected P&L GL Weekly.
• Fixed issue of Admin, Leader, and Account Staff users appearing twice in the User search from Manage > Entities.
• Revised for Account Staff users doing a report clickthrough on a MAPPED report so that returning accounts in GL filter down to correct set.
• Enhanced usability so Database Admins can optimize against users and user roles to minimize conflicts/deadlocks in the database.
• Enhanced usability by revising so Database users can add “File GL Viewer” and “Entity Mapper” Permission to the Enumeration table in the database.
• Since QBD files depend on a client being in a file, revised to merge QBD files before QBO or Xero files.

*****************************************************************************************************

July 2023

Bug Fixes / Feature or Functionality Enhancements 

ATTENTION: For all GL Weekly entries below, please note that the GL Weekly reporting functionality is scheduled for a late Q3 or early Q4 release.

• Implemented automated onboarding billing for all SKUs, applied when customers purchase Entities.
• Revised so that Qvinci Admin setting up new Company/Client can see updated SKU selection options that include new Customer Success fees.
• Revised to provide GL Validation to Qvinci developers to properly handle when a row in the GL Weekly Report lacks a corresponding row in the Legacy Weekly Summary Report.
• Enhanced user experience for P&L GL Weekly users by removing GL Weekly information from Manage > Client/Company > Accounting Edit as it already exists in Manage > Accounting Calendar, thus eliminating confusion.
• Revised for GL Validation users so the “(None)” GL Discrepancy validation emails are no longer sent from the Live environment as they are no longer necessary.
• Revised for multi-syncing QuickBooks or QuickBooks Online file users by providing P&L GL Weekly rollups for each Client/Company to eliminate interference with one another.
• Enhanced usability by revising so the “Schedule an Appointment” link in Help > Help Topics goes straight to the appointment setup workflow instead of Zendesk article on the topic.
• Enhanced usability by revising so when Company/Client staff are doing a GL report click-through on a MAPPED report, the account in the GL now filters down to the correct set with no non-relevant accounts shown.
• Revised to enhance usability for Admin Portal takeover users deleting Companies/Clients so the “request delete Company/Client” step is not lost within Delete Company/Client, regardless of whether the account is NOT self-delete enabled or otherwise.
• Improved Customer Success by revising so Qvinci DevOps receives a notification when a user chooses to run a package with more than the recommended number of Locations so that any subsequent server or database timeouts can be dismissed.
• Enhanced user experience for Report Editor Page Layout users by revising so the Page Setup button and the “Sunsetting” message no longer appear in the left sidebar.

*****************************************************************************************************

June 2023

Bug Fixes / Feature or Functionality Enhancements 

ATTENTION: For all GL Weekly entries below, please note that the GL Weekly reporting functionality is scheduled for a late Q3 or early Q4 release.

• Enhanced user experience by initiating a Zendesk ticket to notify Qvinci Customer Success Managers when an Entity Delete has been requested.
• Enabled Qvinci Admins to complete Entity delete requests or reverse Entity delete requests in Manage Entities when they appropriate user control.
• Added “Entities Requested for Deletion” to the Client/Company page for Qvinci Admins.
• Revised so the file tab in Manage > Entities shows the Qvinci Admin that the Entity has been requested for deletion and who requested the deletion.
• Revised so the Companies/Clients “Display Request for Delete Only” button also shows the Qvinci Customer Success Manager the Company/Clients that have pending Entity deletes under them.
• Revised so Qvinci customers requesting to delete a Company/Client are required to fill out a survey system asking WHY they are requesting deletion of the Client/Company before the deletion request is submitted.
• Revised so the user deleting Entities must complete the newly implemented delete request survey if 10 Entity deletes have been requested in the Company/Client in the past 24 hours.
• Revised to implement strict appropriation protection that prevents Qvinci Admin from cross-appropriating leading to running operations on the wrong customer, company/client, entity, user, etc.
• Implemented a Stored Procedure for Qvinci Budget Developers to obtain Budget Data imported using Qvinci Budget rather than QuickBooks budget to allow users to view their data.
• Added a column to the Organizations Table to prevent syncing of QuickBooks’ Budget data overriding the Imported Excel Budget. Now, schema updates support Qvinci Budget.
• Resolved issue of top-level accounts with no children not reporting correctly for by Class P&L GL Weekly users.
• Updated the GL Roll up timeout to line up with the scheduler timeout so they sync up with each other.
• Added a check to ensure financial syncs have been recently finished before running the GL weekly report auto validation.
• Added the GL Weekly report type to the database enumerations table for data Analyst.
• Resolved issue of GL Validation Timeouts not correctly comparing sync times.
• Blocked the GL auto validation when the Accounting Calendar does not match the Legacy P&L Weekly for the Last Fiscal Year.
• Increased the GL auto validation time window for recently synced files to better align when the GL auto validation runs relative to summary and GL syncing.
• Revised to enable the data Analyst to track the GLWeekly report type.
• Enhanced usability by revising so the Qvinci Admin Portal Companies/Clients page uses front-end terminology which is easier for users to understand.
• Changed to new XE SSL URL so currency conversion feed operates accurately and seamlessly.
• Enhanced user experience by revising so the left navigation bar sections remain open when user clicks on a sub-option in that section, ensuring the UX navigation experience is consistent for QATF 06 Libraries suite users, the QATF 06 Basic suite users, the QATF 05.01 suite users, and the QATF 01 suite users.
• Performed quarterly Server and Security Maintenance Updates 2023 Q2 (Apr-Jun 2023).
• Performed quarterly AWS and Security Updates of the GL/JE NodeJS EBS Services in Live.

*****************************************************************************************************

May 2023

Bug Fixes / Feature or Functionality Enhancements 

ATTENTION: For all GL Weekly entries below, please note that the GL Weekly reporting functionality is scheduled for a late Q3 or early Q4 release.

• Enhanced usability for GL & P&L Weekly report users by revising so that column headers are “MMM DD, YYYY – MMM DD, YYY” per the “activity” based rules of P&L Statements so they are consistent and easily interpreted in Excel.
• Enhanced usability for P&L GL Weekly users by ensuring that by Year, This Fiscal YTD with Offset ROMs return correct header date range when Offsets are used.
• Enhanced usability for Tables and Slicers users by ensuring that applied and saved slicers in the Report Editor are reflected in exports from the Report Editor, Previews and Package Downloads.
• Enhanced user experience by revising so the older Qvinci Page Setup Sidebar Dialog is replaced by the native Page Layout Ribbon Menu from GrapeCity that is more Excel-like.
• Improved user experience by revising so Qvinci Page Layout users are notified of the sunsetted Sidebar button when attempting to use the Qvinci Page Layout button on the Sidebar so users now know how to edit their page layout.
• Resolved issue of there being extra pages in the PDF when Report Editor Users Export to PDF from Preview on a Report that has no Print Area set.
• Resolved issue of Print Areas automatically being set and saved when Report Editor users export to PDF followed by a save from the Report Editor.
• Resolved issue of Help like taking Manage > Entities users to a dead link in Zendesk. Now, users are taken to a live, relevant Zendesk page.
• Resolved issue of Offset not being remembered when Report Editor users select Column Chooser by Property with a Month (or more) Offset.
• Enhanced user experience for Report Editor non-author users by revising so the sidebar buttons are consistent across owners, authors, and users of reports instead of stacked differently.
• Resolved issue of Lookup Chooser in Report Editor not loading Lookups with HTML tags for Report Editor users.

*****************************************************************************************************

April 2023

Bug Fixes / Feature or Functionality Enhancements 

ATTENTION: For all GL Weekly entries below, please note that the GL Weekly reporting functionality is scheduled for a late Q3 or early Q4 release.

• Updated GrapeCity SpreadJS from v15.1.2 to v16.0.4 and updated GrapeCity Documents for Excel from v5.2.2 to v6.0.3.
• Enabled Export to Excel to retain “first page number” for Report Editor/Preview users.
• Enhanced usability by ensuring the Report History Button remains available in the Report Editor when bad json gets saved in the database so the editor is now always able to recover a previously saved good json from the history table.
• Resolved issue of nothing happening when WIV2 users “preview” Use > Export to PDF. Now consistently functions properly.
• Ensured the GL Weekly P&L Report works for QuickBooks Desktop and QuickBooks Online by Class for GL P&L Weekly users.
• Added GL Weekly By Class parameters to the existing GL Weekly Report Workflow so reports fit seamlessly.
• Added columns to Monalisa to support Weekly Roll Up By Class.
• Resolved issue of inability to publish GL database to Stage or Live due to existing schema conflicts. Now publishing is seamless and works consistently.
• Enhanced customer service capabilities by revising so the Admin Portal audit log tells Customer Success when and who created/updated a GL Accounting Calendar.
• Revised for P&L GL Weekly basic report users so the report options load for a new P&L GL Weekly only Company/Client that never had Legacy P&L Weekly turned on.
• Revised for P&L GL Weekly basic report users so the report options load even if the Accounting Calendar doesn’t contain future weeks.
• Enhanced functionality by ensuring the GL Validation reports run with the user ID of the current network admin so they properly validate all data.
• Resolved the issue of Entity Filter users seeing Deleted Properties of unused Property options displayed in the filter options when selecting “more.”
• Enhanced UX navigation consistency by ensuring the left navigation bar sections remain open when user clicks on a sub option in that section.
• Enhanced usability for Admin Portal users by adding a user table index, as such providing protection from locking up the database when running an empty query on the Users search.
• Enhanced usability for Admin Portal users by removing unused/old features from the Franchise/Companies page to reduce clutter and avoid enabling obsolete functionality.
• Enhanced usability for Admin Portal users by removing unused/old features from the Account Admin page to reduce clutter and avoid enabling obsolete functionality.
• Enhanced usability for Admin Portal users by removing the “Sync Multiple Currencies” AKA “Blended Sync” option from Company/Client page now that currency “conversion” is enabled and currency “blending” is deprecated.
• Revised to enable users of Manage > My Users page to be able to see users that have been assigned as a File GL Viewer or Entity Viewer permissions to a managed Entity

*****************************************************************************************************

March 2023

Bug Fixes / Feature or Functionality Enhancements 

ATTENTION: For all GL Weekly entries below, please note that the GL Weekly reporting functionality is scheduled for a late Q3 or early Q4 release.

• Enhanced usability for Period Over Period (All Periods) Balance Sheet users by revising so all report headers reflect the end of the date range (point in time based).
• Enhanced usability for Period Over Period (All Period) report users by revising so the reports return only relevant data for This Fiscal Quarter when the As Of Date splits the date range.
• For extended sync users, resolved the issue of Report Previews missing individual line items for years before the default 3 years for QBO by Location.
• Enhanced usability by blocking P&L GL Weekly Accounting Calendar users from modifying “Week Starting” cells to prevent invalid Accounting Calendars.
• Enhanced usability for Accounting Calendar template users by adding an instructions tab in the template that houses/shows the full Zendesk URL in case the user has an environment that blocks clicking out from within Excel. Now users can easily copy/past link into their browser.
• Enhanced usability for GL Weekly P&L users by revising the UI so it tells when the Accounting Calendar has expired (i.e., that the date range specified for the report is out of range of the Accounting Calendar).
• Enhanced usability for GL P&L Weekly users by revising so the Custom Date Range options reflect Sunday and non-Sunday aligned Accounting Calendars.
• Enhanced usability for P&L GL Weekly users by revising so the GL validation compares the last fiscal year rather than the last 13 weeks, so more GL validation data is included.
• Enhanced usability for Report Editor users by revising so the Cash Flow report is “blendable” with the other “blendable” report types.
• Resolved the issue of the Report Libraries page altering visually when the user clicks from the Financial Portal to the Report Libraries.
• Enhanced usability for Manage > SCoA users by revising the Add Child UI so it opens directly below the account user when attempting to create a child instead of at the bottom of the account’s list of children, where visibility is impaired.
• Resolved the issue of List Property users seeing generic 500-page error when attempting to create a duplicate list property name. Now, the user sees a message explaining what was done wrong.
• Enhanced usability for Period Over Period (All Periods) P&L Monthly users by revising so the report header reflects the full date range (activity based) so the user always has the start and end dates available for date formatting.
• Simplified date parsing in templates for PoP-A Report authors by revising so the Column Headers in the P&L Monthly with Period Over Period – All Periods frequency contain spaces around the ‘-‘ while taking Leap Year into Consideration.
• For Qvinci Customer Success Managers, revised so provides access to fiscal month per Entity/File report so CSMs can quickly identify the fiscal starting month of all files in a Franchise/Client/Company to help find the one that’s different from the others.
• Enhanced usability for GL Activity users by revising to reflect extended syncing years in the Custom Date Range options.
• Enhanced usability for Comparison Report authors by revising so a frequency runs Period Over Period reports that are agnostic to the number of syncing years and iterates through all available years for the P&L Monthly and Balance Sheet Column & Chart Chooser.
• Enhanced usability for Multi-Syncing QBD and QBO mixed Extended Sync Years fill users by revising so the file always syncs the GL per the deepest number of years.
• Enhanced usability for GL Extended Sync users by revising so the GL Activity Report handles the “All X” date ranges properly.
• For QA purposes, renamed the 05 Test Suite to 0.01, added all numbers of syncing years, and verified each “All X” date range for each frequency (where available) in all Basic Reports.
• For QA purposes, implemented QATF Test Suite 05.02 that covers 3 & 7 years of syncing, verifies that each “All X” date range for frequency (where available) is in the Report Editor Column Chooser, and that “All X’ NOT is available for Pop & Pop (All).
• Enhanced usability for GL Weekly P&L users by revising so the mapped GL Weekly report works correctly for QBD and QBO.
• Resolved the issue of GL Weekly P&L users getting a “Something went wrong” error on Previews for the GL Weekly P&L when using the by Property frequency.
• Enhanced usability for GL Weekly P&L users by revising so the Chart Chooser works with the Accounting Calendar dates and GL based accounts.
• Enhanced usability for GL Weekly P&L users by implementing an account filter in the Account Chooser.
• Enhanced usability for Basic Report users by revising so new descriptions appear under the report types to help the users better understand and select the report they choose to run.
• Enhanced usability for Accounting Calendar users by renaming the “Week Date” column to “Week Starting” to clarify that it’s the start of the week.
• Enhanced usability for GL Weekly Report Editor users by revising so the user’s report runs with offsets.
• Enhanced usability for GL Weekly Basic & Report Editor users by enabling the users to run the By Entity frequency on more than one Entity.
• Enhanced usability for Profit & Loss (GL Weekly) users by revising so the user is only able to choose date ranges / frequency combos that are reportable and removed the user’s ability to mistakenly choose a combination of report options that cannot be run.
• Enhanced usability for Profit & Loss GL Weekly users by removing the “…YTE” date ranges as those are irrelevant to the Weekly reporting COLUMN CHOOSERs and Weekly reporting CHART CHOOSERs.
• Optimized and sped up the Weekly Roll Up Deletion of previous GL Weekly rollups.
• Resolved the issue of the leading white space on account names in QBD BL causing duplicate account listings when run in conjunction with QBO.
• Resolved the issue of the GI Weekly Rollup missing aggregation weeks on some week boundaries.
• Resolved the issue of GL Weekly Reporting showing 500 error “StartDate is greater than EndDate” when a date range traverses a fiscal year.
• Fixed bugs and resolved issues in the GL Weekly Rollup database scripts and the GIRollupRunner.
• Enhanced usability for P&L GL Weekly report authors by revising so:
  • the user reports hydrate data for their non-January aligned entities.
  • the weekly offsets report as Weeks and not Month(s).
  • this Fiscal YTD and the Last Two Fiscal YTD reports the correct data for the By Year frequency reports.
• Enhanced user experience by revising the text in the Sync app from saying the process should only take 15-45 seconds to more accurately say it should take 5-10 minutes.
• Enhanced Customer Success capabilities by revising the warnings in the Admin Portal -> Update SCoA upload section to help CS managers prevent accidental overwrites of the SCoA with unintended changes.
• Enhanced usability for Report Library users by implementing an “Are you sure” pop-up when trying to un-Pin an Asset from the Pinned tab of Libraries to prevent accidentally unpinning anything relevant by mis-clicking their mouse.
• Resolved issue of broken Last Sync column ascending and descending sort.
• Resolved the issue of the user’s browser displaying a wrong name when the Account Management service is opened directly.
• Revised BluSynergy Account Adapter by replacing the “Suite 475” with “Suite D350” when it sends an address to BluSynergy.
• Refreshed the SSL Security Certificates, including those in the Sync Client.
• Performed quarterly server security and maintenance updates to the Windows Servers and the SQL Server.

*****************************************************************************************************

January 2023

Bug Fixes / Feature or Functionality Enhancements 

ATTENTION: For all GL Weekly entries below, please note that the GL Weekly reporting functionality is scheduled for a late Q3 or early Q4 release.

• Resolved the issue of the GL Weekly non-Sunday aligned “Last Fiscal Year” report returning inaccurate dates. Now it returns relevant and accurate dates as designed.
• Resolved the issue of the “Last 24 Periods” and “Last 12 Periods” not returning correct data. Both options now return correct data for GL Weekly users.
• Resolved the issue of the Cash Flow report in the Report Editor displaying a “GL Weekly” option in the Report Type drop-down. This is not an option, so it no longer appears.
• Resolved the issue of the By Period Last 2 Fiscal TYD returning too many periods. Now it returns only the previous 2 fiscal years and the current fiscal YTD.
• Resolved the issue of the GL Weekly Basic and Libraries Report timing out on the Frequency By Year, Date Range Last Two Fiscal YTD for Thursday Aligned Company. Corrected the issue by adding years by weeks instead of the standard MS DateTime AddYears method.
• Resolved the issue of the By Period ROM not returning GL Weekly by Period data when used in the same reports as the Legacy P&L Weekly by Period ROM when hydrated.
• Resolved the issue of Bulk sync in the Sync Client containing text referencing QBW32.exe. Altered the text in the bulk sync tab of the Sync Client to include QBW.exe.
• Enhanced user experience by limiting the number of new Gallery templates that need to be created for extended sync and allowed the ROMs to be agnostic to each Client’s/Company’s number of syncing years.
• Implemented test suites that check the Basic Reports to assure the date ranges for 3, 4, 5, 6, and 7 year clients all have appropriate selections available in the Basic Reports UX dropdown selection list.
• Revised the P&L Weekly for Week Freq so it will work without being cut off at 230 columns for extended data sync Basic Report Builder authors and users.
• Resolved the issue of report type Offsets not taking the number of syncing years into consideration with how many years were offered in the 4Chart Chooser or Column Chooser. Now it displays the correct week-based offsets for the frequencies that use week-based offsets with the GL Weekly report.
• Enhanced user experience by revising to throw the friendly error message “This combo is not supported” for the Basic Report, Report Editor Preview, and Package Download for invalid file types that don’t yet support GL weekly reporting.
• Revised so the GL Weekly basic report loads for GL P&L Weekly users when Legacy P&L Weekly is not enabled.
• Revised the Totals Frequency for This Fiscal YTD date range to have the correct end date for Thursday aligned GL Weekly clients.
• Revised the by Week, by Total, by Entity, Period Over Period, and by Property frequency offsets to reflect weeks, not months, for GL Weekly Report Type Column Chooser users.
• Added a link to the cancellation policy to the Onboarding and Add Company/Client Pages, and updated the pages with the new 2023 prices.
• Improved user experience by removing the “Settings” link on the Manage > SCOA page that took users back to the top of the page.
• Resolved the issue of Advanced Permission users getting a 500 error when they try to delete an Advanced Permission.
• Resolved the issue of Preview > Excel Exports & Package Excel assets requiring a repair and losing slicers and charts when using the “&” symbol in a slicer.
• Ensured QB Desktop by Class allows for Extended Sync.
• Ensured QB Desktop full file users have access to Extended Sync.
• Ensured the GL Activity syncs for Extended Sync users.
• Ensured that changes the user makes to the Sync Client are backwards compatible with the current sync and GL services.
• Ensured QBO user data syncs for the maximum years available.
• Resolved the issue of the By Entity frequency throwing a “Something went wrong” error on Previews for the GL Weekly P&L.

*****************************************************************************************************