MKG logo
Login

How does the 'Subadministrations' dashboard work?

The standard dashboard 'Subadministrations' provides insight into the financial flows between subadministrations. It is used to analyze how financial amounts move through inventory, work in progress, cost price, and other subadministrations within the financial administration.

 

General Function

With the Subadministrations dashboard, you can gain insight into the financial flows within your company. The dashboard can be run monthly and shows the inflows and outflows of your work in progress and inventory and how your cost price is structured.

 

Target Audience

  • Controllers
  • Financial staff

 

Where in MKG?

  1. Open the module My Company.
  2. If the dashboard is not displayed immediately: click on the hamburger
    at the top right of the button bar and select the option 'Forms' » 'Dashboard'.
  3. Click on the Views
    button and select Subadministrations (8019).

 

Main Components

  • Graphical representation of financial flows between source and target.
  • Analysis of subadministrations by category.
  • Overview of involved process groups.
  • Analysis of financial transactions per general ledger account.
  • Period filter and category filter.

 

Display and Usage

The selected period range and chosen category are displayed at the top. The dashboard shows a flowchart that tracks financial amounts from a source to a target. Additionally, overviews of process groups, general ledger accounts, and the underlying source and target relationships are available, providing insight into the origin and destination of financial transactions.

 

Parameters

  • PeriodFrom: start period of the analysis. Possible values: 1 to 13 and 99. Default value: 1.
  • PeriodTo: end period of the analysis. Possible values: 1 to 13 and 99. Default value: 12.

 


 

Technical Explanation

 

Primary Data Source

  • Financial transactions (fmut)

Indirectly Consulted Data Sources

  • Production groups (prdg), Inventory groups (vrdg), Sales groups (vrkg)

Data Source Filtering

  • The primary data source is filtered by period via peri_num Between(?PeriodFrom, ?PeriodTo).
  • Only transactions with subtype 10, 11, 14, 15, 25, 26, 27, 28, 47, 48, 49, and 50 are included.
  • Dashboard filter is available via category (Category).

Calculated Fields

  • Target: determines the target of a financial flow.
    Calculation: uses the description of the transaction type or transaction subtype depending on the sign of fmut_bedrag_fin.
  • Source: determines the source of a financial flow.
    Calculation: uses the description of the transaction type or transaction subtype depending on the sign of fmut_bedrag_fin.
  • MKGDataDashboardTitle: contains a dashboard title.
    Calculation: contains an empty text value.
  • PeriodFrom: contains the selected start period.
    Calculation: uses parameter PeriodFrom.
  • PeriodTo: contains the selected end period.
    Calculation: uses parameter PeriodTo.
  • Category: classifies transactions by main category.
    Calculation: determines based on fmut_subtype whether the mutation belongs to "Work in Progress", "Inventory", "Cost price" or "Other".
  • Group: determines the process group associated with a transaction.
    Calculation: uses a production group, inventory group, sales group, or the value "Other" depending on fmut_subtype.
  • Group type: classifies the process group.
    Calculation: determines based on fmut_subtype whether it is "Production", "Inventory", "Sales" or "Other".

 

Add to 'My Dashboards'

Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. This way, you create your own cockpit from the data in your database. How to add dashboards can be read in How to set up 'My Dashboards'