New features

The new lineup of Stock cubes

An updated Stock cube

      To help you keep a better track of what is coming and going through your warehouses, the flex.bi team has implemented support for item history. You will now be able to see how much of your items have come and gone, where they have come from, where they have gone to and have they been sold, bought, written off as damaged, lost, are they in transit or are they being used on the production line to create something new and unique.

Goods Receipts cube

     It has never been easier to keep track of what has arrived in your warehouses until now. The freshly created Goods Receipts cube will help you analyze what kind of items have arrived at your doorstep and which supplier delivered them, what amount and at what cost.

Stock Depreciation cube

     Now you are able to have a clean overview of your depreciation of stock, of the items you have withdrawn for internal use and the stock you have written off all in one cube - the Stock Depreciation cube. Analyze the data by the reasons of why you item has found its way into stock depreciation and examine the lost quantities and monetary value of those items.

Stock Movements cube

      Ever been curious where your stock travels to? Well now you can find out with our new Stock Movements cube. This cube allows you to view and analyze where your items have traveled from, where they have traveled to and what stops they had along the way, let's not forget that you can also see the quantities and costs of the items that are traveling from location to location. 

REST API support is here

      With REST API you will now be able to directly connect to your HansaWorld server and import data into flex.bi without the need to export registers. REST API currently supports importing data for Invoices, Quotations, Sales Orders and Financials cubes.

New sample reports

      We have added a few new sample reports from our templates database to the standard sample reports that can give you an example on which you can build your own reports or modify the sample ones to your needs. The new additions include CRM reports that allow you to view customer value, a comparison with previous periods, how much time each sales person spends on a customer.  Two Financial reports that allow you to analyze data by account type and analyze profit loss in a period. And a whole bevy of Invoice reports that show sales KPIs in a period, item turnovers, the top salesman on your team, general item statistics, the most profitable items and a report for salesman targets.

Updates

Of course we haven’t forgotten about our previous work and the improvements that can always be made, so we have added a few updates and bugfixes to our previous HansaWorld data cubes

The Sales cube

            The sales cube has received a number of updates including a new register that allows the user to build dashboards that not only show the sales amounts but also the open to-date balances per customer, customer group, sales person or any other available dimension thanks to the addition of the ArVc register.

            An additional measure from the Quotations cube has been added to allow the user to view the whole sales pipeline in a single report – starting from quoted amounts and ending with made sales and open balances. With this new measure its possible to measure conversion rates, efficiency of sales staff or item groups.

            It is also worth mentioning that Invoices and Orders whose prices or amounts are empty will not be imported.

General bug fixes

• Fixed a bug where Customer Class was not working in the Sales cubeactivity types were importing incorrectly

• Fixed a bug where an “Invalid date” error was thrown, because of the wrong date seperator

• Fixed a bug where imported dashboard templates would return an error

• Changed overlapping default measures names to fix measure sharing

• Fixed a bug where Invoice measures are not removed for the same invoice if it is coming from multiple files

• Fixed a bug that caused the enable_item_class parameter to not work properlyprojects where importing incorrectly