How does the 'Delivered Not Invoiced' dashboard work?
General Function
The Delivered Not Invoiced dashboard provides insight into all sales order lines that have been delivered but not yet invoiced. The assessment is based on the set threshold values.
Target Audience
- Sellers
- Administrative staff
Where in MKG?
- Open the module My Company.
- If the dashboard is not displayed directly: click the hamburger in the top right of the button bar and select the option 'Forms' » 'Dashboard'.
- Click the Views button and select Delivered Not Invoiced (8009).
Main Components
- Total overview of amounts yet to be invoiced.
- Top 10 debtors based on revenue yet to be invoiced.
- Detailed overview of delivered but not yet invoiced lines.
- Analysis of age since delivery.
- Filter options per debtor.
Display and Use
At the top, you can filter by debtor. Additionally, the total amount to be invoiced is displayed along with an overview of the 10 largest debtors with outstanding invoices. In the detailed overview, you see per delivery the delivery date, age, sales order, packing slip, item, description, any installment invoicing, and the amount yet to be invoiced.
Parameters
ThresholdWarning: threshold value for warnings. Default value: 5. This parameter is not visible to users.
Technical Explanation
Primary Data Source
company_pkbr_factureren
Indirectly Consulted Data Sources
- Debtors (
debi), Sales Orders (vorh), Sales Order Lines (vorr), Items (arti), Sales Packing Slip Lines (pkbr), Sales Packing Slips (pkbh)
Dashboard Filters
- Filter by debtor via calculated field
Debtor. - The
Top 10 debtorssection only shows the 10 debtors with the highest amount int_bedrag_te_factureren. Other debtors are combined into a residual category.
Calculated Fields
Debtor: shows the debtor including debtor number.
Calculation: combinesvorh_num.debi_num.debi_naamwithvorh_num.debi_numinto one text field.Age: shows the age of the delivery in days.
Calculation: calculates the number of days betweent_pkbh_dat_afleverand the current date.MKGDataDashboardTitle: contains a dashboard title.
Calculation: contains an empty text value.On AC: indicates whether a sales order line is subject to actual costs.
Calculation: shows the text "On AC" whenvorr_num.vorr_op_nacalculatie= true.Installment invoicing: indicates whether installment invoicing applies.
Calculation: shows the text "Installment invoicing" whenvorr_termijn_fact= true.
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 is explained in How to set up 'My Dashboards'
- Published:27 Oct 2026 09:01
- Latest update:27 Oct 2026 10:01
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar