How does the 'Debtor Revenue Last 3 Years' dashboard work?
General Function
The Debtor Revenue Last 3 Years dashboard shows which debtor was responsible for the most revenue over the past 3 years. The top 5 debtors are displayed per year up to 3 years back. The second tab shows which debtors contribute the most to revenue in the current fiscal year.
Target Audience
- Salespeople
- Managers
Where in MKG?
- Open the My Company module.
- If the dashboard is not displayed directly: click the hamburger in the top right of the toolbar and select the option 'Forms' » 'Dashboard'.
- Click the Views button and select Debtor Revenue Last 3 Years (8016).
Main Components
- Detailed analysis of revenue, budget, and debtor position.
- Comparison of revenue over the current year and the 3 preceding years.
- Top 5 debtor overviews per fiscal year.
- Pareto or ABC analysis of debtor revenue.
- Comparison between budget and realized revenue.
Display and Usage
The dashboard consists of 3 tabs. On the 'Detailed Analysis' tab, you see revenue figures, budgets, positions, and differences per debtor compared to previous years. On the 'Revenue Analysis' tab, revenue developments are displayed, including top 5 overviews per fiscal year. On the ABC analysis tab, revenue is divided according to the Pareto principle, making it visible which debtors have the largest share in revenue.
Technical Explanation
Primary Data Source
- Debtors (
debi)
Indirectly Consulted Data Sources
- Debtor Budgets (
debg), Sales Invoices (fcth), Sales Invoice Lines (fctr)
Dashboard Filters
- The Pareto analysis uses the filter
Debtor has revenue= 1, which only includes debtors with revenue. - The Top 5 overviews show only the debtors with the highest revenue within the respective fiscal year.
Calculated Fields
CurrentDay: determines the current day number within the calendar year.
Calculation: calculates the day number of the current date.BudgetCorr: calculates a time-proportional budget up to the current day.
Calculation: multipliest_debi_debg_totalbyCurrentDayand divides by 365.CurrentDateTime; displays the date and time of the last data refresh.
Calculation: combines fixed text with the value ofMKGDataCreatedOn.Total: calculates the total revenue over 4 years.
Calculation: sumst_debi_fcth_amount,t_debi_fctr_amount_min1,t_debi_fctr_amount_min2, andt_debi_fctr_amount_min3.Spacer: used as a separator in the display.
Calculation: contains an empty text value.Debtor has revenue: indicates whether a debtor has generated revenue.
Calculation: returns value 1 whent_debi_fctr_amountis greater than 0, otherwise 0.MKGDataCreatedOn: contains a date and time value for data refresh.
Calculation: contains an empty text value.
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 can be read in How to set up 'My Dashboards'
- Published:30 Oct 2026 08:55
- Latest update:30 Oct 2026 09:55
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar