How does the 'Purchase Invoices to be Received' dashboard work?
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?
- Open the My Company module.
- If the dashboard is not displayed immediately: click the hamburger icon in the top right of the button bar and select 'Forms' » 'Dashboard'.
- 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
- If the financial setup is configured to make an entry 'At Goods Receipt', this list should align with the general ledger accounts shown in the list. Learn more about the financial setup of MKG.
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 parameterPeriod.Age: displays the age of a receipt in days.
Calculation: calculates the number of days betweenipbh_dat_ontvangstand the current date.Creditor: shows the creditor including creditor no.
Calculation: combinescred_naamandcred_numinto 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'
- Published:5 Oct 2026 08:16
- Latest update:5 Oct 2026 08:16
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar