MKG logo
Login

How does the 'Sales Invoice Value' dashboard work?

With the standard 'Sales Invoice Value' dashboard, you analyze the value of sales invoices within a chosen invoice period. You compare debtors, countries, items, and groups, and track the development of the invoice value over time.

 

General Function

The invoice value per week, month, or quarter in one overview? With the Sales Invoice Value dashboard, you quickly have access to the invoice data for a specific period.

 

Target Audience

  • Salespeople

 

Where in MKG?

  1. Open the Sales Dashboards module.
  2. If the dashboard is not displayed immediately: click on the hamburger icon in the top right of the button bar and select the option 'Forms' » 'Dashboard'.
  3. Click on the Views button and select Invoice Value Analysis (8003).

 

Main Components

  • Debtors and items: top 10 and total overviews with invoice value.
  • Countries: top 10, an overview with debtors, and a distribution by EU country, non-EU country, and unknown, including invoice value and share.
  • Sales groups and inventory groups: top overviews and tables with invoice value.
  • Time analyses per week, month, quarter, and year, with cumulative values and a year comparison to the same day of the year.
  • A period indication and filters for year, quarter, and month.

 

Display and Use

The chosen period is applied to the invoice date. The overviews sum the amounts of the invoice lines. Other costs, discounts, and VAT are not displayed separately.

You switch between tabs for the different analyses and can choose multiple filter values. Selections in interactive charts, tables, and country maps limit the linked overviews. The country overview supports clicking through to details. Top overviews bundle other values. Missing items, groups, and countries receive a recognizable designation.

 


 

Technical Explanation

 

Primary Data Source

  • dashboard_fctr

Indirectly Consulted Data Sources

  • Sales invoices (fcth), Debtors (debi), and Country codes (land)

Selection

The parameters DateFrom and DateTo delimit fcth_num.fcth_dat_factuur. The parameters IncludeForecast and IncludeCancelled are present but are not used in the encountered data filters or calculated fields.

Calculated Fields

  • Inventory group: makes the inventory group recognizable.
    Calculation: if 0 in vrdg_num, ‘{- No inventory group}’ is shown; otherwise _desc_vrdg_num.
  • Item: shows the item or a designation for a missing item.
    Calculation: if an empty or missing arti_code, ‘{- No item}’ is shown; otherwise the item code.
  • Sales group: makes the sales group recognizable.
    Calculation: if 0 in vrkg_num, ‘{- No sales group}’ is shown; otherwise _desc_vrkg_num.
  • Debtor: combines debtor name and number.
    Calculation: combines fcth_num.debi_num.debi_naam with fcth_num.debi_num in parentheses.
  • Date: provides the date for time analyses.
    Calculation: takes over fcth_num.fcth_dat_factuur.
  • Index: ranks the existing years from new to old.
    Calculation: determines the year of Date and assigns a rank per year using a descending competitive ranking.
  • Invoiced: provides the invoice value per line.
    Calculation: takes over fctr_bdr_tot_av.
  • Country: shows country description and code.
    Calculation: if an empty or missing fcth_num.land_code, ‘{- No country}’ is shown; otherwise fcth_num.land_code.land_oms and the country code are combined in parentheses.
  • DateFrom: provides the start date for the period indication.
    Calculation: takes over Parameters.DateFrom.
  • DateTo: provides the end date for the period indication.
    Calculation: takes over Parameters.DateTo.
  • MKGDataDashboardTitle: provides an empty text value.
    Calculation: returns an empty string.
  • EU country: describes the EU classification of the country.
    Calculation: gives ‘{Unknown}’ if EU country ID equals 99, ‘{EU country}’ if 1, and otherwise ‘{Non-EU country}’.
  • EU country ID: determines the code for EU classification.
    Calculation: gives 99 for an empty or missing fcth_num.land_code, 1 when fcth_num.land_code.land_eg is true, and otherwise 0.

Additional Measure Calculations

  • Total: aims to show a final value in the week, month, and quarter charts.
    Calculation: returns the cumulative sum of Intake only at the last position; elsewhere an empty value. Intake is not defined as a calculated field in this XML.
  • Total: provides the full invoice value in the year chart, unless it equals the value to the same day of the year.
    Calculation: compares the sum of Invoiced with the sum where the day number of Date does not exceed the current day number. An empty value is returned if equal; otherwise the full sum.
  • YTD: provides the invoice value to the same day of the year.
    Calculation: sums Invoiced for dates where the day number of DataItem6, linked to Date, does not exceed the current day number.

The week, month, and quarter charts also use a cumulative tally of Invoiced. The country maps calculate the share of Invoiced in the total.

Points of Attention in the XML

  • The text of textBoxDashboardItem4 refers to DataItem2 and DataItem3 for cancellation and forecast information. Only DataItem0 and DataItem1 are linked to this text field; the functioning of the extra references cannot be determined from the XML.
  • In the week and month charts, the second axis description is ‘Per quarter’, while the date grouping is set per week and month, respectively.

 

Add to 'My Dashboards'

Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homeage. This way, you create your own cockpit from the data in your database. How to add dashboards can be read in How to set up 'My Dashboards'