MKG logo
Login

How does the 'Delivered Not Invoiced' dashboard work?

The standard dashboard 'Delivered Not Invoiced' provides insight into deliveries that have already been made but have not yet been invoiced. It is used to monitor outstanding revenue, identify billing delays, and see which amounts still need to be invoiced.

 

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?

  1. Open the module My Company.
  2. If the dashboard is not displayed directly: click the hamburger
    in the top right of the button bar and select the option 'Forms' » 'Dashboard'.
  3. 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 debtors section only shows the 10 debtors with the highest amount in t_bedrag_te_factureren. Other debtors are combined into a residual category.

Calculated Fields

  • Debtor: shows the debtor including debtor number.
    Calculation: combines vorh_num.debi_num.debi_naam with vorh_num.debi_num into one text field.
  • Age: shows the age of the delivery in days.
    Calculation: calculates the number of days between t_pkbh_dat_aflever and 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" when vorr_num.vorr_op_nacalculatie = true.
  • Installment invoicing: indicates whether installment invoicing applies.
    Calculation: shows the text "Installment invoicing" when vorr_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'