How does the 'Inventory Progress' dashboard work?
General function
The Inventory Progress dashboard gives you insight into the origin and consumption of your inventory. It shows you from which processes inventory arises and which processes consume inventory.
Target audience
- Controllers
Where in MKG?
- Open the module My company.
- If the dashboard is not shown immediately: click the hamburger menu at the top right of the toolbar and select the option 'Forms' » 'Dashboard'.
- Click the Views button and select Inventory Progress (8021).
Main components
- Analysis of inventory bookings and unbookings.
- Insight into cash flows between transaction types and inventory groups.
- Overview of all inventory bookings per transaction type and subtype.
- Analysis of inventory transactions per inventory group.
- Financial overview per general ledger account, inventory group, and subtype.
- Filter options on transaction type, inventory group, and recorded bookings.
Display and usage
At the top, the selected period range and available filters are displayed. The 'Inventory Progress' tab shows the inventory transactions, split into bookings and unbookings. Additionally, cash flows are visually displayed per inventory group and transaction type. The 'Financial' tab shows a financial overview per general ledger account, inventory group, and subtype.
Parameters
PeriodFrom: start period of the analysis. Possible values: 1 through 13 and 99. Default value: 1.PeriodTo: end period of the analysis. Possible values: 1 through 13 and 99. Default value: 1.
Technical explanation
Primary data source
- Financial transactions (
fmut)
Indirectly consulted data sources
- Inventory groups (
vrdg), General ledger accounts (grbk), Periods (peri)
Data source filtering
- A filter is active on the primary data source:
fmut_subtype In (25,26,27,28). - Only inventory transactions within the selected period range are included:
peri_num Between(?PeriodFrom, ?PeriodTo). - The 'Bookings' section shows only transaction types 9, 16, and 17 where the financial amount is positive or zero.
- The 'Unbookings' section shows only transaction types 3, 5, and 17 where the financial amount is negative or zero.
- Filter options are available for transaction type, inventory group, and recorded bookings.
Calculated fields
MKGDataDashboardTitle: contains a dashboard title.
Calculation: contains an empty text value.PeriodFrom: contains the selected start period.
Calculation: uses parameterPeriodFrom.PeriodTo: contains the selected end period.
Calculation: uses parameterPeriodTo.Included: indicates whether a booking is recorded.
Calculation: translates the value offmut_opgenomento "Recorded bookings" or "Not recorded bookings".
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 is explained in How to set up 'My dashboards'
- Published:30 Oct 2026 11:15
- Latest update:30 Oct 2026 12:15
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar