How does the 'Outstanding Items Creditors' dashboard work?

Target Audience

• Purchasers
• Administrative staff

Where in MKG?

1. Open the My Company module.
2. If the dashboard is not displayed directly: click on the hamburger icon in the top right of the button bar and select the 'Forms' » 'Dashboard' option.
3. Click the Views button and select Outstanding Items Creditors (8002).

Main Components

• Reference date and chosen basis for the aging calculation.
• KPI overview with total outstanding amount and distribution by age categories.
• Overview per creditor with outstanding amounts, paid amounts, amounts in transit, and disputes.
• Detail overview per document with invoice date, due date, payment condition, and age.

Display and Usage

The selected reference date and the type of date used for the aging calculation are displayed at the top. Below that, key figures are shown for the total outstanding amount and distribution across different age classes. The creditors overview shows the financial position per creditor and the number of disputes. From this overview, you can filter to underlying documents. The detail overview then shows the individual items including dates, payment condition, outstanding amount, and any disputes.

Parameters

• ReferenceDate: the 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 Creditors (opcr)

Indirectly Consulted Data Sources

• Creditors (cred), Payment Conditions (betc)

Data Source Filtering

• No filter is defined on the primary data source.
• The parameters ReferenceDate and CalculatingDate are used in calculated fields for reference date and age determination, but do not filter the data source.
• The 'Creditors' and 'Documents' dashboard screens do not contain a data source filter.

Calculated Fields

• MKGDataDashboardTitle: contains a dashboard title.
  Calculation: contains an empty text value.
• CalculatingDate: indicates which type of date is used for age determination.
  Calculation: translates parameter CalculatingDate to invoice date or due date.
• Date: determines which date is used for age determination.
  Calculation: uses opcr_dat_factuur or opcr_dat_verval depending on parameter CalculatingDate.
• Creditor: forms a combined creditor view.
  Calculation: combines cred_num.cred_naam and cred_num into one text field.
• Dispute: shows an indicator for items marked as disputed.
  Calculation: displays the text "Dispute" when opcr_dispuut = true, otherwise no value.
• Dispute number: determines whether an item counts as a dispute.
  Calculation: gives value 1 when opcr_dispuut = true, otherwise no value.
• 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.
• Age: calculates the age of an outstanding item.
  Calculation: calculates the number of days between Date and ReferenceDate.