How does the 'Outstanding Items Debtors' dashboard work?
General Function
The Outstanding Items Debtors dashboard shows outstanding items by age per debtor. Click on a debtor in the table to view all outstanding invoices for that debtor. If not zoomed in on a debtor, the most recent reminder date and the highest reminder status are displayed.
Target Audience
- Sellers
- Administrative staff
Where in MKG?
- Open the My Company module.
- If the dashboard is not shown immediately: click on the hamburger in the top right of the button bar and select the 'Forms' » 'Dashboard' option.
- Click the Views button and select Outstanding Items Debtors (8001).
Main Components
- Reference date and chosen basis for age calculation.
- KPI overview with total outstanding amount and distribution by age categories.
- Overview per debtor with outstanding amounts, paid amounts, provisions, and disputes.
- Detail overview per document with invoice date, due date, payment terms, and age.
Display and Usage
The selected reference date and the type of date used for age calculation are displayed at the top. Below that, key figures for the total outstanding amount and distribution across different age classes are shown. The debtor list shows the financial position and number of disputes per debtor. From this overview, filtering to underlying documents can be done. The detail overview then shows the individual items including dates, payment terms, outstanding amount, and any disputes.
Parameters
ReferenceDate: reference date on which outstanding items are determined.CalculatingDate: determines whether age is calculated based on invoice date or due date. Possible values: 1 (invoice date) and 2 (due date).
Technical Explanation
Primary Data Source
- Outstanding Items Debtors (
opde)
Indirectly Consulted Data Sources
- Debtors (
debi), Payment Conditions (betc)
Calculated Fields
Dispute number: determines whether an item counts as a dispute.
Calculation: assigns value 1 whenopde_dispuut= true, otherwise no value.Dispute: shows an indicator for items marked as disputes.
Calculation: displays the text "Dispute" whenopde_dispuut= true, otherwise no value.MKGDataDashboardTitle: contains a dashboard title.
Calculation: contains an empty text value.Date: determines which date is used for age determination.
Calculation: usesopde_dat_factuuroropde_dat_vervaldepending on parameterCalculatingDate.Age: calculates the age of an outstanding item.
Calculation: calculates the number of days betweenDateandReferenceDate.CalculatingDate: indicates which type of date is used for age determination.
Calculation: translates parameterCalculatingDateto invoice date or due date.Debtor: forms a combined debtor display.
Calculation: combinesdebi_num.debi_naamanddebi_numinto one text field.Outstanding: determines the outstanding amount on the reference date.
Calculation: uses the value fromt_peildatum_openstaand.Outstanding 0-30: shows the outstanding amount with an age of up to 30 days.
Calculation: includesOutstandingif the calculated age is greater than 0 and up to 30 days.Outstanding 31-60: shows the outstanding amount with an age of 31 to 60 days.
Calculation: includesOutstandingif the calculated age is greater than 30 and up to 60 days.Outstanding 61-90: shows the outstanding amount with an age of 61 to 90 days.
Calculation: includesOutstandingif the calculated age is greater than 60 and up to 90 days.Outstanding 90+: shows the outstanding amount with an age greater than 90 days.
Calculation: includesOutstandingif the calculated age is greater than 90 days.ReferenceDate: contains the chosen reference date.
Calculation: uses parameterReferenceDate.
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:29 Sep 2026 11:11
- Latest update:29 Sep 2026 11:11
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar