How does the 'Inventory List at Reference Date' dashboard work?
General Function
The Inventory List at Reference Date dashboard shows the total inventory in the registered administration. You can select what you want to see: per inventory group, per type, or active/inactive.
Target Audience
- Controllers
- Management
Where in MKG?
- Open the My Company module.
- If the dashboard is not displayed directly: click the hamburger icon in the top right of the button bar and select 'Forms' » 'Dashboard'.
- Click the Views button and select Inventory List at Reference Date (8006).
Main Components
- Overview of inventory lines with quantities and inventory value.
- Analysis of inventory value broken down into man hours, machine costs, material costs, and outsourcing.
- Summary of inventory value per inventory group.
- Filtering options on inventory group, type, and active status.
- Insight into free stock and batch registration.
Display and Use
The chosen reference date and set inventory options are displayed at the top. You can filter by inventory group, type, and active status. The first tab shows the inventory lines with quantities, free stock, and values. The second tab provides a summary of the total inventory value per inventory group.
Parameters
ReferenceDate: reference date on which the inventory is determined.Anonymous: determines if anonymous stock is included in the overview. Default value: true.EmptyInventory: determines if inventory without quantity or value is suppressed. Default value: true.
Technical Explanation
Primary Data Source
- Inventory List at Reference Date based on Batches (
StockListOnReferenceDate)
Indirectly Consulted Data Sources
- Items (
arti), Material Types (mats), Batches (part), Inventory Groups (vrdg), Units (eenh), Material Shapes (matf)
Dashboard Filters
- Filter by inventory group via field
_desc_vrdg_num. - Filter by type via calculated field
Type. - Filter by active status via calculated field
Active. - In the
Listoverview, with an active setting of parameterEmptyInventory, only inventory for which financial quantity (aantal_fin), physical quantity (aantal_fys), free quantity (aantal_vrij), or inventory value (t_bdr_tot) deviates from 0 is shown.
Calculated Fields
Type: determines the type of inventory line.
Calculation: determines based onarti_codeandmats_numwhether it is an item, ACM without item, or a text line.CPS: shows the cost price system used.
Calculation: translates the value ofarti_kostprijssysteemto FTP, ATP, or ASP.Active: indicates whether an item is active.
Calculation: determines based onarti_codeandarti_actiefwhether the status is active or inactive.Batch: shows the batch no. when batch registration is applicable.
Calculation: usespart_numwhen no item code is present or batch registration is active.Description: shows the description of the inventory line.
Calculation: usesoms_1orarti_code.arti_oms_1depending on the type of line.Date: contains the chosen reference date.
Calculation: uses parameterReferenceDate.Anonymous: shows the setting for anonymous stock.
Calculation: translates parameterAnonymousto a textual indication.CBR: indicates whether batch registration is applicable.
Calculation: shows an indication whenarti_partij= true.CBR source: provides an indicator for batch registration.
Calculation: gives value 1 whenarti_partij= true, otherwise 0.MKGDataDashboardTitle: contains a dashboard title.
Calculation: contains an empty text value.Backflush: indicates whether backflush is allowed.
Calculation: shows an indication whenarti_code.arti_backflush= true.Auto-reservation: indicates whether auto-reservation is allowed.
Calculation: shows an indication whenarti_code.arti_niet_autores= false.EmptyInventory: shows the processing of empty inventory.
Calculation: translates parameterEmptyInventoryto a textual indication.Spacer: used as a separator field in the display.
Calculation: contains no value.Amount free: shows the free stock for batch-controlled items.
Calculation: usesaantal_vrijwhenarti_partij= true.
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'
- Published:5 Oct 2026 10:21
- Latest update:5 Oct 2026 10:21
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar