Language:


KPIs

KPIs are Key Performance Indicators, visible in the bottom right-hand corner of the Master Control panel. KPIs summarise the activity of the company in specified areas during the current week, month or year, and compare that activity with the previous period. By default, KPI figures will be updated automatically every hour, to keep you up-to date.

Depending on how an individual KPI has been configured, you may be able to click on it in your Master Control panel and be taken to a web page. A useful web page might be your HansaWorld SmartView page where you can analyse the statistics in more detail. Please refer to your local HansaWorld representative for more information about HansaWorld SmartView. If no web page has been assigned to a KPI, clicking on it will open a report showing how the KPI figure has been calculated. For example, clicking on a "Sales Excluding VAT" or "Sales Including VAT" KPI will cause an Invoice Journal report covering the relevant period to be opened.

You can configure your company's KPIs so that different ones will be seen by different users. So, if someone else logs in to Enterprise by HansaWorld on your machine using the [Login] button in the Master Control panel, your KPIs will disappear, to be replaced with theirs.

Use the KPIs setting to configure the Key Performance Indicators that will be shown in each user's Master Control panel. To work with this setting, follow these steps:

  1. The KPI feature is an extra-cost addition to the standard Enterprise by HansaWorld system. The first step is therefore to specify the number of KPIs you have purchased in the field on the 'Basic' card of the Configuration setting in the System module:

  2. The second step is to configure your KPIs. Remaining in the System module, open the KPIs setting and create a new record:

    Complete the record as follows:

    Header

    No.
    The unique identifier for the KPI record, generated automatically.

    User
    Paste Special    Person register, System module
    Specify here the Person in whose Personal Desktop the KPI is to appear. You can enter more than one Person, separated by commas.

    If you need to use 'Paste Special' to enter several Persons, type the comma or colon before opening the 'Paste Special' list. This will cause the next Person to be added to those already entered. Otherwise, the previous Person will be overwritten.

    If you enter more than one Person, this will cause the KPI record to take up more than one of your KPI "slots". For example, if you have purchased 100 KPIs and you enter a KPI record containing three Persons in its User field, this KPI record will occupy three of those 100 KPIs.

    Type
    Paste Special    Choices of possible entries
    Use this field to specify the figure that will be monitored by the KPI. The following options are available:
    Activities Cost Time
    The total Cost (Time) from Time Activities with Start Dates falling within the period. A Time Activity is one where the Task Type is Calendar and the Calendar Type is Time. If an Activity has more than Person, it will be included in the KPI figure once for each Person. Clicking the KPI in the Master Control panel will open the Activities, Persons report.
    Cost of Sales
    The total cost of sales from approved Invoices dated during the period. Clicking the KPI will not open a report.

    GP%
    The gross margin of approved Invoices dated during the period. Clicking the KPI will open the GP, Invoices report.

    No. of Activities
    The number of Time Activities with Start Dates falling within the period. If an Activity has more than Person, it will be included in the KPI figure once for each Person. Clicking the KPI will open the Activities, Persons report.

    No. of Orders
    The number of Sales Orders dated during the period. Closed Orders are not included. Clicking the KPI will open the Order Journal report.

    No. of Quotations
    The number of Quotations dated during the period. Closed and Rejected Quotations are not included. Clicking the KPI will open the Quotation Journal report.

    Outstanding Orders
    The value excluding VAT of Sales Orders dated during the period. Invoiced and Closed Orders are not included. Clicking the KPI will open the Outstanding Orders report (this report doesn't have a period selection so the figures it shows will not match the KPI figures).

    Outstanding Quotations
    The value excluding VAT of Quotations dated during the period. Closed and Rejected Quotations are not included. Clicking the KPI will open the Pipeline report (this report doesn't have a period selection so the figures it shows will not match the KPI figures).

    P/L Due
    The outstanding total from unpaid Purchase Invoices that have exceeded their Payment Terms (i.e. whose Due Date has passed). This figure can also be seen at the bottom of the Purchase Ledger report. Clicking the KPI will open the Purchase Ledger report.

    P/L On Acc.
    The On Account balance in the Purchase Ledger, including open On Account Payments and open Prepayments for all Suppliers. This figure can also be seen at the bottom of the Purchase Ledger report. Clicking the KPI will open the Purchase Ledger report using the Only On Account option.

    Receipts
    The value of Receipts taken during the period. Clicking the KPI will not open a report.

    Sales Excluding VAT
    The value excluding VAT of approved Invoices dated during the period. Clicking the KPI will open the Invoice Journal report.

    Sales Including VAT
    The value including VAT of approved Invoices dated during the period. Clicking the KPI will open the Invoice Journal report.

    S/L Due excluding Disputed Invoices
    The outstanding total from unpaid Invoices that have exceeded their Payment Terms (i.e. whose Due Date has passed) and that have not been marked as Disputed. Clicking the KPI will open the Sales Ledger report using the Exclude Disputed option.

    S/L Due
    The outstanding total from unpaid Invoices that have exceeded their Payment Terms (i.e. whose Due Date has passed). This figure can also be seen at the bottom of the Sales Ledger report. Clicking the KPI will open the Sales Ledger report.

    S/L On Acc.
    The On Account balance in the Sales Ledger, including open On Account Receipts and open Prepayments for all Customers. This figure can also be seen at the bottom of the Sales Ledger report. Clicking the KPI will open the Sales Ledger report using the Only On Account option.
    Sorting
    Use this field to control the order in which the KPIs will be listed in the User's Personal Desktop. For example, a KPI with "1" in its Sorting field will be listed above a KPI whose Sorting is "2". You should only enter whole numbers in this field.
    Definitions Card

    Period Type
    Paste Special    Choices of possible entries
    The KPI display in the User's Personal Desktop includes figures for a Previous period (in the column headed "Prev.") and for the Current period (in the column headed "Current").

    This field controls how the Prev. and Current periods relate to each other. For example, if the current date is 10 June, the Period Length (below) is "Month" and the Number of Units is 1, the Prev. and Current figures will be calculated as follows, depending on the option in this field:
    -
    Current: 10 June - 10 June

    Previous: 10 June - 10 June

    Until Current Date
    Current: 11 May - 10 June

    Previous: 11 April - 10 May

    Current Full Unit
    Current: 1 June - 30 June

    Previous: 1 May - 31 May

    Current Unit, Until Current Date
    Current: 1 June - 10 June

    Previous: 1 May - 10 May
    Period Unit
    Paste Special    Choices of possible entries
    Use this field to specify whether the KPI will display weekly, monthly or yearly figures.

    URL
    If you want the User to be taken to a web page when they click the KPI in their Personal Desktop, specify the URL of that web page here. A useful URL might be your HansaWorld SmartView page where you can analyse the statistics in more detail. Please refer to your local HansaWorld representative for more information about HansaWorld SmartView.

    You must include the http:// or https:// in the URL that you enter in this field.

    If you leave this field empty, clicking the KPI will open a report showing how the KPI figure has been calculated. The reports that will be opened from each KPI Type are included in the descriptions of the Type options above.

    Own Title
    Specify the name of the KPI, to be shown in the KPI Display in the Personal Desktop.

    Reverse Arrow
    This check box controls the arrow that is shown in the Trend column in the Personal Desktop. By default, if the Current figure is larger than the Prev. figure, the Trend column will contain an upward-pointing arrow. This will be appropriate if the KPI is one where a larger Current figure is a positive trend (e.g. "No. of Quotations" or "Sales Including VAT"). In some cases, however, a larger Current figure is a negative trend (e.g. "S/L Due") and therefore a downward-pointing arrow is more appropriate. Use the Reverse Arrow option in these cases.

    Number of Units
    This field is related to the Period Unit field above: use it to specify how many Period Units are to be included in the Current and Prev. in the KPI Display.

    For example, if the Period Type is "Month" and you enter "3" in this field, the Current period will cover the current quarter and the Prev. period will cover the previous quarter.

    Open
    Paste Special    Choices of possible entries
    If you have specified a URL in the field on the left and the User clicks the KPI in their Personal Desktop, they will be taken to the relevant web page. If you enter "Inline" here, the web page will be opened in a new window inside Enterprise by HansaWorld. If you enter "External" here, the web page will be opened in the User's default browser.

    Recalculate Every
    By default, the KPI figures in the User's Personal Desktop will be updated once an hour. If you would like them to be updated more (or less) often, specify here the time between updates that you need. Use the format hh:mm:ss.

    If you need an immediate update of the KPIs in your Personal Desktop, click the following button at the top of the list (Mac OS X only):

    Person
    Paste Special    Person register, System module
    Use this field if you need KPI figures to be calculated for a particular Person or Persons.

    For example, if the Type is "No. of Orders", leaving this field empty will mean the KPI will display the total number of Orders created during the period and the previous period. If you enter a Person's Signature, the KPI will display the number of Orders created by that Person.

    Unless the Type is "Activities Cost Time" or "No. of Activities", you can enter more than one Person, separated by commas. If you need to use 'Paste Special' to enter several Persons, type the comma or colon before opening the 'Paste Special' list. This will cause the next Person to be added to those already entered. Otherwise, the previous Person will be overwritten.

    For the following Types, the KPI figure will be calculated from Sales Invoices where the specified Person (or one of the specified Persons) is the Salesman:

    • Cost of Sales

    • Sales Excluding VAT

    • Sales Including VAT

    • S/L Due

    • S/L Due excluding Disputed Invoices

    • GP%

    For the following Types, the KPI figure will be calculated from Purchase Invoices where the specified Person (or one of the specified Persons) is the Salesman:

    • P/L Due

    For the following Types, the KPI figure will be calculated from Quotations where the specified Person (or one of the specified Persons) is the Salesman:

    • No. of Quotations

    • Outstanding Quotations

    For the following Types, the KPI figure will be calculated from Sales Orders where the specified Person (or one of the specified Persons) is the Salesman:

    • No. of Orders

    • Outstanding Orders

    For the following Types, the KPI figure will be calculated for Customers and Suppliers in whose Contact records the specified Person (or one of the specified Persons) is the Salesman:

    • P/L on Acc.

    • S/L on Acc.

    For the following Types, the KPI figure will be calculated from Time Activities where the specified Person is included in the Persons field. You should not specify more than one Person in the KPI: if you do, the KPI figure will be zero:

    • Activities Cost Time

    • No. of Activities
    Sales Card

    Item
    Paste Special    Item register
    Use this field if you need KPI figures to be calculated for a particular Item.

    For example, if the Type is "No. of Orders", leaving this field empty will mean the KPI will display the total number of Orders created during the period and the previous period. If you enter an Item Number, the KPI will display the number of Orders containing that Item.

    You can use this field with the following KPI Types:

    • Cost of Sales

    • GP %

    • No. of Orders

    • No. of Quotations

    • Outstanding Orders

    • Outstanding Quotations

    • Sales Excluding VAT

    • Sales Including VAT

    Classification
    Paste Special    Item Classifications setting, Sales Ledger
    Use this field if you need KPI figures to be calculated for Items belonging to a particular Classification. It operates in the same manner as the Item field described immediately above, and can be used with the same KPI Types.

    If you enter a number of Classifications separated by commas, KPI figures will be calculated for the Items belonging to all the Classifications listed.

    Group
    Paste Special    Item Group register, Sales Ledger
    Use this field if you need KPI figures to be calculated for Items belonging to a particular Item Group. It operates in the same manner as the Item field described immediately above, and can be used with the same KPI Types.
    CRM Card

    Act. Type
    Paste Special    Activity Types setting, CRM module
    Use this field if you need KPI figures to be calculated for a particular Activity Type.

    For example, if the Type is "No. of Activities", leaving this field empty will mean the KPI will display the total number of Activities created during the period and the previous period. If you enter an Activity Type, the KPI will display the number of Activities with that Activity Type.

    You can use this field with the following KPI Types:

    • Activities Cost Time

    • No. of Activities

    Act. Type Class.
    Paste Special    Activity Classes setting, CRM module
    Use this field if you need KPI figures to be calculated for Activities with Activity Types belonging to a particular Activity Class. It operates in the same manner as the Act. Type field described immediately above, and can be used with the same KPI Types.
  3. Save the KPI record. As soon as you do so the KPI will be added to the User's Personal Desktop:

By default, KPI figures will be updated once an hour. If you would like to update them immediately, click the button to the right of the Trend column (this button is only available if you are using Mac OS X).

---

Settings in the System module:

Download:
Go back to: