MKG logo
Login

How does the 'Outstanding Items Debtors' dashboard work?

The standard Items 'Outstanding Items Debtors' dashboard provides insight into outstanding items debtors on a chosen reference date. It is used to analyze outstanding amounts, disputes, and the aging structure of claims.

 

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?

  1. Open the My Company module.
  2. 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.
  3. 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 when opde_dispuut = true, otherwise no value.
  • Dispute: shows an indicator for items marked as disputes.
    Calculation: displays the text "Dispute" when opde_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: uses opde_dat_factuur or opde_dat_verval depending on parameter CalculatingDate.
  • Age: calculates the age of an outstanding item.
    Calculation: calculates the number of days between Date and ReferenceDate.
  • CalculatingDate: indicates which type of date is used for age determination.
    Calculation: translates parameter CalculatingDate to invoice date or due date.
  • Debtor: forms a combined debtor display.
    Calculation: combines debi_num.debi_naam and debi_num into one text field.
  • Outstanding: determines the outstanding amount on the reference date.
    Calculation: uses the value from t_peildatum_openstaand.
  • Outstanding 0-30: shows the outstanding amount with an age of up to 30 days.
    Calculation: includes Outstanding if 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: includes Outstanding if 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: includes Outstanding if 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: includes Outstanding if the calculated age is greater than 90 days.
  • ReferenceDate: contains the chosen reference date.
    Calculation: uses parameter ReferenceDate.

 

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'