MKG logo
Login

How does the 'Inventory List at Reference Date' dashboard work?

The standard 'Inventory List at Reference Date' dashboard provides insight into the inventory position on a chosen reference date. You use it to analyze inventory quantities, free stock, and inventory value per item, batch, and inventory group.

 

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?

  1. Open the My Company module.
  2. If the dashboard is not displayed directly: click the hamburger icon in the top right of the button bar and select 'Forms' » 'Dashboard'.
  3. 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 List overview, with an active setting of parameter EmptyInventory, 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 on arti_code and mats_num whether it is an item, ACM without item, or a text line.
  • CPS: shows the cost price system used.
    Calculation: translates the value of arti_kostprijssysteem to FTP, ATP, or ASP.
  • Active: indicates whether an item is active.
    Calculation: determines based on arti_code and arti_actief whether the status is active or inactive.
  • Batch: shows the batch no. when batch registration is applicable.
    Calculation: uses part_num when no item code is present or batch registration is active.
  • Description: shows the description of the inventory line.
    Calculation: uses oms_1 or arti_code.arti_oms_1 depending on the type of line.
  • Date: contains the chosen reference date.
    Calculation: uses parameter ReferenceDate.
  • Anonymous: shows the setting for anonymous stock.
    Calculation: translates parameter Anonymous to a textual indication.
  • CBR: indicates whether batch registration is applicable.
    Calculation: shows an indication when arti_partij = true.
  • CBR source: provides an indicator for batch registration.
    Calculation: gives value 1 when arti_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 when arti_code.arti_backflush = true.
  • Auto-reservation: indicates whether auto-reservation is allowed.
    Calculation: shows an indication when arti_code.arti_niet_autores = false.
  • EmptyInventory: shows the processing of empty inventory.
    Calculation: translates parameter EmptyInventory to 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: uses aantal_vrij when arti_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'