Happy 2024 Solver users! Our first update of this year brings a big update that includes several new features and plenty of bug fixes. This month also brings the public availability of our Solver Data API which allows users to extract their data from the Data Warehouse. While some users may have used the Solver External API before to work with Power BI or Tableau, this feature requires a different set of URLs to use. Those who were using the beta version of this feature (v1.0) will not be required to update to the version being released this month (v1.1). For more information on this update, see below.

We are also happy to announce that there will be a new version of Report Designer (v5.2.61218.1621) coming with this release which will be a mandatory update. Please install this update before the March monthly cloud update(March 21, 2024). See your company’s IT professional to complete this upgrade. There will be more updates to the Solver portal in March that will require users to have the latest Report Designer version.

Google Analytics users: There will be a mandatory update coming this summer for the Google Analytics connector. The Solver team will be in contact with you soon if you qualify for this update.

New Features and Enhancements

Reporting

The below Reporting features require an update to Report Designer:

• Added support for Solver opening Excel when users have FIPS enabled.
• Added the ability for dropdown parameter types to show code and description.

Data Warehouse

• Added the ability for users to freeze the code and description panes on the Dimension list for a better experience. This UI change allows for the code and description columns to always be visible on tables with many columns. This is similar to the freeze pane Excel feature.
  

• Improved the visibility of the edit and delete buttons on the integration and jobs pages.
• Added the ability for QuickStart for Business Central users to map the Remaining Amount field to Value2 in Accounts Payable.
• Added the ability for QuickStart for Business Central users to map the Remaining Amount field to Value2 in Accounts Receivable.
• Added a pop-up error message for users who are attempting to add a dimension code that already exists.
  
• Added v1.1 of Solver API. Users can continue to use v1
  • Version 1.1 added uses the System Labels to handle cases where there are spaces, numeric values, and special characters in the friendly labels.
  • This update fixed an issue where the API would fail to query the period dimension. (Applicable for v1.0 and v1.1)
  • For more information on the new version of Solvers API see this article.
    
• Added a new version of Generic Inquiries for Acumatica.
  • Users will need to update this manually by clicking the link found in the connector description in the integration marketplace.
  • For more information on installing Generic Inquiries, see this article.
    

Administration

• Updated and improved Italian translations.
• Added a notification for customer administrators when there is an update to their subscription.

Bug Fixes

Planning

• Fixes an issue in Workflow where assignments were being completed when a user tried to cancel the completion of an assignment.

Reporting

• Fixes a minor UI issue in Ad Hoc.
• Fixes several issues with date and time in Ad Hoc including:
  • Datetimes in the report are now in local time, with the time part removed.
  • Hovering over the datetime entry will display the local time and the UTC time.
  • Exports from Ad Hoc Reporting will now output datetime in UTC.
• Fixes an issue where reports that utilized sheets per value were showing tabs that had no transactions.

The below Reporting fixes require an update to Report Designer:

• Fixes an issue where users were experiencing errors when tab names have an apostrophe when using the planning storage feature.
• Fixes an issue that was not allowing users to utilize the Lookup Edit Style parameter with default values for dates.
• Fixes an issue where a user’s selected budgeting attribute was not being retained in Report Designer.

Data Warehouse

• Updated an error message related to custom attribute character amounts to show the correct character limit.
• Fixes an issue where users were able to edit dimension codes when they should not be able to.
• Fixes a display issue with dimension codes being duplicated when filtering, The underlying data was not duplicated, only the display.
• Fixes an issue where rules were being run multiple times when being executed instead of running once.
• Fixes an issue where some users were unable to save changes being made to custom fields in task mapping.
• Fixes an issue in the Data Warehouse where the run icon displayed incorrectly when the application was processing an integration or job.
• Fixes an issue where applying filters on the Rate Type Configuration page did not properly filter rate type details.