Changelog

Added Account dimension in Stock cube

Added State and Zip Code properties for Supplier dimension

Added Customer closed and Customer no-mailing calculated members in Quotations cube

Fixed a bug that caused an error when creating importing a property from custom fields in the Customer dimension

Created a new measure In stock WA value in the Stock cube.

Fixed a bug that prevented (none) member creation in the Item Group hierarchy of the Item dimension.

Fixed a bug that caused wrong New customer count values after data reimport.

Job Costing cube has to be emptied and reimported.

Implemented a feature for counting new customers in HansaWorld cubes.

Added new measures in the Sales Orders cube for open gross profit and not invoiced gross profit and quantity.

Fixed a bug that caused wrong data after invalidating an already imported invoice.

Fixed a bug that caused empty Invoice to Customer Code and Invoice to Customer Name properties.

Added additional information on the Plans page.

Implemented flex.bi colors schema as the default setting for new report creation

Fixed a bug that caused Financials cube import error when no profit account was defined.

Fixed a bug that caused Invoices cube import error when importing custom country codes.

Fixed a bug that caused wrong request url logging for incremental import.

Introduced Planned delivery date support in Sales Orders and Purchase Orders cube.

Created a new subscription payment method - Invoice. 

Extended the Custom fields functionality to all HansaWorld registers.

Conditional cell formatting improvements – new exact value and regular expression conditions, top/bottom, and heatmap formatting, custom formulas.

Change report height in dashboards – specify either fixed or dynamic report height.

Add sparklines in table reports and gauge charts.

Show Markdown, HTML, plain text, and date measures in gauge charts.

Improved gauge width calculation to enable showing of more gauge items in one row.

HTML and plain text formatting for calculated measures.

Improved calculated member formatting selection drop-down.

Remember the last used Analyze tab view (grid or list) and sorting criteria.

Support for MySQL 8 database and JDBC driver.

Improved row filter validation for regular expressions.

Added endless scroll to large table reports in dashboards.

Use size formatting suffixes (KB, MB, GB) in cell formatting conditions.

Implemented Show Key functionality that allows changing between dimension item key and name display in report rows.

Removed Zendesk chat option from the mobile devices, to enhance report readability.

Created a new login screen.

Implemented a solution for enabling incremental import for the supported registers by default.

Perform automatic vacuum on PostgreSQL tables after each import to reduce table size and improve query performance.

Fixed the issue that caused different color schema being used by default, when creating new reports reports.

Fixed the issue that prevented plan change from Trial to Business when Advanced Settings were defined.

Fixed the issue that caused HansaWorld authorization error message being shown for other source applications.

Fixed the issue causing geocoding error message being displayed when there is no Suppliers dimension in the data cube.

Fixed the placeholder for the HansaWorld REST API import refresh period.

Fixed the placeholder for the HansaWorld REST API default import start date.

Fixed the issue that caused underscores being used in the cube custom fields section title.

Implemented unique customer/supplier count measures in all relevant cubes.

Changed Quotation Count measure datatype to integer.

Added an option to enable Custom Hierarchy creation for consolidated accounts

Fixed compatibility issues with PostgreSQL database server

Fixed the issue that caused incomplete PDF exports

Fixed the issue that caused Geocoding request failures

Fixed FIFO Value import in Stock Depreciations cube

Fixed the issue with error handling for Google Spreadsheet import

Fixed the issue with import error handling that caused clutter in the log files

Fixed the issue that caused a deadlock when importing consolidated data

Fixed the issue that prevented dashboard embedding

Define report specific calculated measures

View calculated member usage in reports and other calculated member formulas

Show a warning when navigating away from an unsaved modified report in the Analyze tab

Markdown formatting for calculated measures

Support for PostgreSQL versions 11 and 12

Custom property hierarchies in Customer, Person, Item, Account, Supplier dimensions

Now for Consolidated accounts there is an extra hierarchy that combines members with the same name from different companies

Purchase Invoice measures are now shared in Invoices cube

Hansaworld imports now retry import several times when receiving Unauthorised error

In usage statistics more detailed information now is available for HansaWorld imports

Several fixes in additional data import column mapping validations and import

Allow deletion of custom data cube dimensions

Budget import in financials cube now works with consolidation

Import only selected companies in Companies dimension for consolidated accounts

Fixed a bug where consolidated accounts with companies that had characters in their code would fail to import objects

Fixed a bug where custom fields would not import

Fixed a bug where Good Receipts import would fail if they contained information in Best Before property

Fixed a bug that caused a timeout when consolidating 90 companies

Fixed a bug that caused client/supplier category name and item group name removal with incremental import

Fixed a bug that caused a data validation error when using incremental import

Fixed a bug that caused the Week day dimension breakdown on consolidated import

Now all the companies are available for selection for consolidation in import options application setup step

Added Budgets and Revised budgets for Financials cube

Editing HansaWorld source application works faster now

Added Week Day dimension

New user interface with a lighter and brighter look. The new larger color palette for charts, lighter headers for table reports, new icons, and improved navigation.

Additional standard calculations – cumulative sum including empty values, many "time ago" calculations, empty as 0.

Freeze row headers (in addition to column headers) in table reports.

Show All member names in gauge charts when other members used from the same dimension.

Added hours, minutes, seconds formatter for usage statistics duration measures.

Fixed a incorrect "There is no active subscription for this account" message in HansaWorld application setup

Fixed some incremental import interrupt issues

Fixed a bug with breaking the cube structure when selecting and deselecting cubes for import and having source files linked to then

Fixed a bug that showed incorrect error message in Source Data section when creating a Trial account

Fixed the issue that caused Rest API authorization failure for any company other than the 1st.

Fixed the issue that caused extra dimension selection drop-down menus not being updated after selecting different company.

Added consolidation support for all cubes

Fixed gross profit base amount not being imported correctly with multiple currencies

Fixed error message after successful payment with credit card

Fixed a bug where a new application with no selected cube would count as another cube selected

Fixed a bug where it was only possible to add one less user then the actual account limit

Fixed a bug where emptying or deleting one cube would cause all the other cubes to be re-imported from start as well

Fixed a bug where "Authorize URL" and "Token URL" fields where not filled when switching from file

Fixed an incorrect error message when embedded dashboard was not available anymore

Fixed the issue that caused wrong error messages appearing in the Source Application section.

Fixed the issue that caused error messages with missing translations.

Fixed the issue that prevented users from resetting their passwords.

Added the All Accounts section for administrators.

Added a procedure for deleting old accounts.

Removed unnecessary code for the dark theme.

Added automatic tests for Purchase Invoices cube.

Fixed the compatibility issue with MySQL-java connector v8.0.

Fixed the issue that caused duplicate import initialization after server restart.

Fixed customer and supplier classification issue in Purchase Invoices un Purchase Orders cubes.

Fixed the issue with a wrong account unlock link sent to the user.