How does the 'Revaluation List' dashboard work?
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?
- Open the My Company module.
- 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.
- 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_hwis 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: usespart_num.part_oms_1when a batch is present, otherwisearti_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" whenpamt_vrd_aantal= 0, otherwise "Physical".FiscalYearFrom: contains the selected start fiscal year.
Calculation: uses parameterFiscalYearFrom.FiscalYearTo: contains the selected end fiscal year.
Calculation: uses parameterFiscalYearTo.PeriodFrom: contains the selected start period.
Calculation: uses parameterPeriodFrom.PeriodTo: contains the selected end period.
Calculation: uses parameterPeriodTo.Warning: issues a warning when no fiscal year is selected.
Calculation: displays a message whenFiscalYearFromorFiscalYearTois 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'
- Published:27 Oct 2026 10:40
- Latest update:27 Oct 2026 11:40
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar