How does the 'Sales Analysis Financial' dashboard work?
General Function
The Sales Analysis Financial dashboard provides an analysis of the sales bookings for the selected periods from the registered fiscal year based on the financial mutations.
|
Note! |
Target Audience
- Controllers
- Salespeople
Where in MKG?
- Open the module My Company.
- If the dashboard is not displayed directly: click on the hamburger in the top right of the button bar and select the option 'Forms' » 'Dashboard'.
- Click on the Views button and select Sales Analysis Financial (8014).
Main Components
- Analysis of revenue, cost price, margin, and added value.
- Top 10 debtors based on revenue.
- Overview of sales groups, debtors, and debtor groups.
- Analysis of transaction types and transaction subtypes.
- Overviews for Balance, Profit & Loss, Sales, and Invoices.
- Insight into financial transactions per general ledger account.
Display and Use
At the top, the fiscal year and selected periods are displayed. Additionally, you can filter by recorded status, sales group, and debtor. The dashboard consists of multiple tabs that allow financial data to be viewed from different perspectives. In addition to tables, the dashboard includes a graphical analysis of the main debtors, including revenue, cost price, margin, and added value.
Parameters
PeriodFrom: start period of the analysis. Default value: 1.PeriodTo: end period of the analysis. Default value: 12.
Technical Explanation
Primary Data Source
- Financial mutations (
fmut)
Indirectly Consulted Data Sources
- General ledger accounts (
grbk), Sales invoices (fcth), Sales invoice lines (fctr), Debtors (debi), Debtor groups (degr), Sales groups (vrkg), Sales orders (vorh), Sales order lines (vorr), Fiscal years (adbj), Periods (peri), Batches (part), Items (arti)
Data Source Filtering
- The primary data source is filtered by periods via
peri_num >= ?PeriodFromandperi_num <= ?PeriodTo. - Only financial mutations with types
2,3,4,10, and14are included. - Dashboard filters are available for recorded status, sales group, and debtor.
- The Top 10 debtor chart shows only the 10 debtors with the highest revenue and groups other debtors into a residual category.
Calculated Fields
Mutation subtype: shows the description of the transaction subtype.
Calculation: uses_desc_fmut_subtype.Mutation type: shows the description of the transaction type.
Calculation: uses_desc_fmut_type.Included: indicates whether a mutation is included.
Calculation: translatesfmut_opgenomento "Included" or "Not included".Process: classifies the transaction by process.
Calculation: determines based onfmut_typewhether it concerns "Sales", "Purchase", "Production", "Revaluation", or "Other financial".Ledger type: determines the type of general ledger account.
Calculation: usesgrbk_num.grbk_soortand shows "Balance" or "P&L".Item/Batch: shows item or batch.
Calculation: usespart_numwhen present, otherwisearti_code.Cost price material: determines the material part of the cost price.
Calculation: usesfmut_bedrag_finwhenfmut_subtype= 47.Cost price man: determines the man-hour part of the cost price.
Calculation: usesfmut_bedrag_finwhenfmut_subtype= 48.Cost price machine: determines the machine part of the cost price.
Calculation: usesfmut_bedrag_finwhenfmut_subtype= 49.Cost price outsourcing: determines the outsourcing part of the cost price.
Calculation: usesfmut_bedrag_finwhenfmut_subtype= 50.Revenue: determines the revenue.
Calculation: usesfmut_bedrag_finwith reversed sign whenfmut_subtype= 2.Cost price total: calculates the total cost price.
Calculation: addsCost price material,Cost price man,Cost price machine, andCost price outsourcing.Margin: calculates the margin.
Calculation: subtractsCost price totalfromRevenue.Added value: calculates the added value.
Calculation: subtractsCost price materialandCost price outsourcingfromRevenue.Added value %: calculates the percentage of added value.
Calculation: divides the sum ofAdded valueby the sum ofRevenue.Margin %: calculates the margin percentage.
Calculation: divides the sum ofMarginby the sum ofRevenue.Debtor: shows the debtor including debtor number.
Calculation: combinesfcth_num.debi_num.debi_naamwithfcth_num.debi_num.Sales group description: shows the description of the sales group.
Calculation: usesvrkg_num.vrkg_omsor a default value when no sales group is present.Debtor group description: shows the description of the debtor group.
Calculation: usesfcth_num.debi_num.degr_num.degr_omsor a default value when no debtor group is present.Sales group: shows the sales group including code.
Calculation: combinesvrkg_num.vrkg_omsandvrkg_num.
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 you can read in How to set up 'My Dashboards'
- Published:30 Oct 2026 08:07
- Latest update:30 Oct 2026 09:10
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar