How does the 'Sales Invoice Value' dashboard work?
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?
- Open the Sales Dashboards module.
- 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'.
- 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 invrdg_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 missingarti_code, ‘{- No item}’ is shown; otherwise the item code.Sales group: makes the sales group recognizable.
Calculation: if 0 invrkg_num, ‘{- No sales group}’ is shown; otherwise_desc_vrkg_num.Debtor: combines debtor name and number.
Calculation: combinesfcth_num.debi_num.debi_naamwithfcth_num.debi_numin parentheses.Date: provides the date for time analyses.
Calculation: takes overfcth_num.fcth_dat_factuur.Index: ranks the existing years from new to old.
Calculation: determines the year ofDateand assigns a rank per year using a descending competitive ranking.Invoiced: provides the invoice value per line.
Calculation: takes overfctr_bdr_tot_av.Country: shows country description and code.
Calculation: if an empty or missingfcth_num.land_code, ‘{- No country}’ is shown; otherwisefcth_num.land_code.land_omsand the country code are combined in parentheses.DateFrom: provides the start date for the period indication.
Calculation: takes overParameters.DateFrom.DateTo: provides the end date for the period indication.
Calculation: takes overParameters.DateTo.MKGDataDashboardTitle: provides an empty text value.
Calculation: returns an empty string.EU country: describes the EU classification of the country.
Calculation: gives ‘{Unknown}’ ifEU country IDequals 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 missingfcth_num.land_code, 1 whenfcth_num.land_code.land_egis 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 ofIntakeonly at the last position; elsewhere an empty value.Intakeis 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 ofInvoicedwith the sum where the day number ofDatedoes 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: sumsInvoicedfor dates where the day number ofDataItem6, linked toDate, 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
textBoxDashboardItem4refers toDataItem2andDataItem3for cancellation and forecast information. OnlyDataItem0andDataItem1are 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'
- Published:6 Nov 2026 11:42
- Latest update:6 Nov 2026 12:42
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar