MKG logo
Login

How does the 'Purchase Invoices to be Received' dashboard work?

The standard dashboard 'Purchase Invoices to be Received' provides insight into the purchase invoices to be received. It is used to verify received goods or services for which no purchase invoice has been processed yet and to monitor the financial impact.

 

General Function

The Purchase Invoices to be Received dashboard displays the purchase invoices to be received per reference period. These are invoices that have been physically received but have not yet been recorded. You can perform an analysis based on creditor, general ledger account, and purchase group.

 

Target Audience

  • Controllers
  • Management

 

Where in MKG?

  1. Open the My Company module.
  2. If the dashboard is not displayed immediately: click the hamburger icon in the top right of the button bar and select 'Forms' » 'Dashboard'.
  3. Click the Views button and select Purchase Invoices to be Received (8004).

 

Main Components

  • Overview of received but not yet invoiced purchase orders.
  • Analysis of the age of invoices to be received.
  • Filtering options on creditor, general ledger account, and purchase group.
  • Insight into amounts per receipt line.
  • Display of packing slip, order, and receipt information.

 

Display and Use

The selected reference period is displayed at the top. Additionally, you can filter by creditor, general ledger account, and purchase group. The overview shows, per received purchase order line, the creditor, order and packing slip details, receipt date, age, and the corresponding amount. This allows you to quickly determine which received performances still need to be invoiced.

 

Parameters

  • Period: the reference period on which the data is based. Possible values: 1 to 13 and 99. Default value: 12.

 

Special Features

 


 

Technical Explanation

 

Primary Data Source

  • Purchase Invoices to be Received (company_ntof)

Indirectly Consulted Data Sources

  • Creditors (cred), Purchase Orders (iorh), Purchase Order Lines (iorr), Purchase Packing Slips (ipbh), Purchase Packing Slip Lines (ipbr), Purchase Groups (inkg), General Ledger Accounts (grbk)

Data Source Filtering

  • A filter is active on the primary data source: ?Period = ?Period. This builds the dataset for the selected reference period.
  • Additionally, dashboard filters are available for creditor, general ledger account, and purchase group.

Calculated Fields

  • Period: contains the selected reference period.
    Calculation: uses parameter Period.
  • Age: displays the age of a receipt in days.
    Calculation: calculates the number of days between ipbh_dat_ontvangst and the current date.
  • Creditor: shows the creditor including creditor no.
    Calculation: combines cred_naam and cred_num into one text field.
  • MKGDataDashboardTitle: contains a dashboard title.
    Calculation: contains an empty text value.

 

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. Learn how to add dashboards in How to set up 'My Dashboards'