MKG logo
Login

How does the 'Revaluation List' dashboard work?

The standard 'Revaluation List' dashboard provides insight into inventory revaluations over a selected fiscal year and period range. It is used to analyze changes in inventory values per inventory group, item, and batch, including the distribution into man hours, machine costs, material costs, and outsourcing.

 

General Function

The Revaluation List dashboard shows how revaluations on material, labor, machine, and outsourcing are made based on batch mutations.

 

Target Audience

  • Controllers
  • Management

 

Where in MKG?

  1. Open the My Company module.
  2. If the dashboard is not directly displayed: click the hamburger icon in the top right of the button bar and select the 'Forms' » 'Dashboard' option.
  3. Click the Views button and select Revaluation List (8010).

 

Main Components

  • Overview of revaluations per inventory group.
  • Graphical analysis of revaluation amounts per inventory group.
  • Detailed overview of individual revaluation transactions.
  • Filters on revaluation type, inventory group, and item.
  • Analysis of financial revaluation components: man, machine, material, and outsourcing.

 

Display and Usage

The selected fiscal year and period range are displayed at the top. Additionally, you can filter by revaluation type, inventory group, and item. The first tab shows a summary per inventory group in table and chart form. The second tab contains a detailed overview of the underlying revaluation transactions, including quantities, dates, batch information, and financial amounts.

 

Parameters

  • FiscalYearFrom: fiscal year from which revaluations are selected.
  • FiscalYearTo: fiscal year up to which revaluations are selected.
  • 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: 99.

 


 

Technical Explanation

 

Primary Data Sources

  • company_pamt_hw, t_rapport_datum

Indirectly Consulted Data Sources

  • Batch Transactions (pamt), Batches (part), Items (arti), Inventory Groups (vrdg), Fiscal Years (adbj), Financial Transactions (fmut), Periods (peri)

Data Source Filtering

  • The primary data source company_pamt_hw is filtered by fiscal year and period.
  • Filter: peri_num Between(?PeriodFrom, ?PeriodTo).
  • Filter: adbj_boekjaar Between(?FiscalYearFrom, ?FiscalYearTo).
  • Dashboard filters are available for revaluation type, inventory group, and item.

Calculated Fields

  • Description: displays the description of the batch or item.
    Calculation: uses part_num.part_oms_1 when a batch is present, otherwise arti_code.arti_oms_1.
  • Spacer: used as a separator field in the detail view.
    Calculation: contains an empty value.
  • Revaluation type: classifies the type of revaluation.
    Calculation: shows "Financial" when pamt_vrd_aantal = 0, otherwise "Physical".
  • FiscalYearFrom: contains the selected start fiscal year.
    Calculation: uses parameter FiscalYearFrom.
  • FiscalYearTo: contains the selected end fiscal year.
    Calculation: uses parameter FiscalYearTo.
  • PeriodFrom: contains the selected start period.
    Calculation: uses parameter PeriodFrom.
  • PeriodTo: contains the selected end period.
    Calculation: uses parameter PeriodTo.
  • Warning: issues a warning when no fiscal year is selected.
    Calculation: displays a message when FiscalYearFrom or FiscalYearTo is empty.
  • MKGDataDashboardTitle: contains a dashboard title.
    Calculation: contains an empty text value.

 

Add to 'My Dashboards'

Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. In 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'