MKG logo
Login

How does the 'Outstanding Items by Reference Period' dashboard work?

The standard dashboard 'Outstanding Items by Reference Period' provides insight into outstanding items for a selected reference period. You use it to analyze which outstanding debtor and creditor items are still present and how they are distributed across general ledger accounts.

 

General Function

The Outstanding Items by Reference Period dashboard displays the outstanding debtor and creditor items based on the specified fiscal year and period. The purpose of this dashboard is to provide insight into the outstanding items by reference period to verify the financial reconciliation with the general ledger.

 

Target Audience

  • Controllers

 

Where in MKG?

  1. Open the My Company module.
  2. If the dashboard is not displayed immediately: click the hamburger icon in the upper right of the toolbar and select the option 'Forms' » 'Dashboard'.
  3. Click the Views button and select Outstanding Items by Reference Period (8017).

 

Main Components

  • Overview of outstanding sales invoices.
  • Overview of outstanding purchase invoices.
  • Analysis of outstanding amounts per general ledger account.
  • Insight into debtor, creditor, and transaction document data.
  • Selection by reference period.

 

Display and Usage

The selected reference period is displayed at the top. The dashboard consists of the tabs 'Debtors' and 'Creditors'. Each tab shows both the outstanding items and the corresponding general ledger accounts. This allows you to easily check which items are still outstanding for the selected reference period and on which general ledger accounts they have been posted.

 

Parameters

  • ReferencePeriod: the reference period on which the outstanding items are determined. Default value: 99.

 


 

Technical Explanation

 

Primary Data Sources

  • Outstanding creditor items by reference period (company_opcr_period), Outstanding debtor items by reference period (company_opde_period)

Indirectly Consulted Data Sources

  • Creditors (cred), Debtors (debi), General Ledger Accounts (grbk)

Calculated Fields

  • MKGDataDashboardTitle: contains a dashboard title.
    Calculation: contains an empty text value.
  • ReferencePeriod: contains the selected reference period.
    Calculation: uses the parameter ReferencePeriod.

 

Adding 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'