08 Reports
← Technical Guide

Chapter 08

Reports

Prebuilt reports function by function, an evidence page showing which records each number comes from, filters, the Explorer and scenario modes, and saved chart layouts.

Overview

Reports is the reporting area that shows the business’s measures divided into functions (Sales, Finance, Stock, HR …). The area is visible if the raporlar_alani feature is enabled for the organization; if it is not enabled, the Reports addresses redirect to the Business Health cockpit (described in Chapter 5).

When the area is enabled, Sales and Stock leave the Business Intelligence menu and are viewed under Reports; the Business Intelligence areas are described in Chapter 7.

  • Each function opens with the license and view permission of the module it belongs to (the permission keys are in the catalog table below).
  • A closed function appears in the menu but cannot be clicked; its report names are not sent to the browser at all. If its address is visited, a «closed on this account» card appears.
  • The records of a closed function are not read; it is listed by name at the bottom of the entry page, in the «Closed on this account:» line.

Report catalog

The catalog contains 13 functions and 121 prebuilt reports. Every function is listed in every organization; whether it is open or locked is determined by the user’s license and permission.

FunctionModule (license, permission)Prebuilt reportReports
SalesSales (sales_module, sales.view)13Customer lifecycle · Order ledger and promise scorecard · Brand margin and loss lines · Region target attainment · Material ABC · Period stacks · Sales summary · Customers · Declining customers · Region × brand · Monthly trend · Sales trends · Sales anomalies
Sales OSSales OS (CRM) (crm_module, crm.view)7Sales rep target attainment · Order line ABC · Period stacks · CRM trends · CRM anomalies · CRM reports · Open order delivery date aging
FinanceFinance (finance_module, finance.view)20Period stacks · Branch gross profit margin · Expense / revenue ratio · Cash outflow / inflow balance · Customer overdue rate · Debt / revenue ratio · Branch target attainment · Finance cockpit · Profitability · Cash flow · Expenses · Debt · Rolling forecast · Financial health · Impact analysis · Finance alerts · Personnel cost · Profit-and-loss scenario · Finance trends · Finance anomalies
ReceivablesFinance (finance_module, finance.view)7Receivables summary · Aging · Customer receivables · Collection coverage · Customer receivables aging · Customer receivable shares · Branch receivable shares
StockStock (stock_module, stock.view)10Stock summary · ABC analysis · Stock ABC (calculated) · Valuation check · Warehouse concentration · Turnover and coverage · Stock risk · Warehouses · Stock snapshot · Stock anomalies
HRHuman Resources (hr_module, hr.view)6KPI targets and performance distribution · HR trends · Attendance table — where the day goes · Training participation — how much of each course is completed · Compliance obligations — what is overdue · HR reports
PurchasingPurchasing (purchasing_module, purchasing.view)9Purchasing snapshot · Purchasing anomalies · Open items by supplier · Delivery date delay · Items by order status · Delayed open items (by requested date) · Items awaiting confirmation · Supplier concentration and 1 more report
ProductionProduction (manufacturing_module, manufacturing.view)7Production snapshot · Production anomalies · Machine load · Work order delivery date scorecard · OEE and the six big losses · Capacity (machine calendar) · Delivery date view
LogisticsLogistics (logistics_module, logistics.view)8Orders awaiting dispatch · Period stacks · Logistics snapshot · Delivery date scorecard · Transit time scorecard · Shipments by customer · Shipment aging · Shipment load — customer breakdown
Service & fieldService and Field (service_module, service.view)11Period stacks · Service snapshot · Age of open records · Time to close · Records by installation · Service record aging · Resolution time scorecard · Machine reliability — service load per serial number · Fault frequency — per product · Service record ↔ problem link · Service load — customer breakdown
Installed baseInstalled Base (installedbase_module, installedbase.view)8Installed base snapshot · Warranty expiry calendar · Installed base by customer · Contract expiry aging · Remaining warranty time bands · Installed base age distribution · Fault frequency — per product · Installed base — product × customer
Spare partsSpare Parts (spares_module, spares.view)6Part ledger · Spare parts stock ABC · Coverage and stock-out risk · Open purchasing aging · Data quality and matching · Stock counterpart
Problem & solutionProblems & Solution (solution_module, solution.view)9Period stacks · Problem ledger · Pain points by class · Observation trend · Pain points by customer · Problem record aging · Problem code — per product · Pain-point recurrence per machine · Pain-point map — who has the problem

Reports

The entry page shows the measures of the open functions without filters; the page states this under the title. In the «Business pulse» panel at the very top, each dot is a measure and the dots are arranged by function. The «Needs attention» strip below it receives only cards that have their own threshold: cards with a target of zero that are above zero, cards that cannot be measured, and cards whose rows could not all be read. The most severe ones stay here, the number of the remaining ones is written and they appear in their own function band; if all cards that have a threshold hold, the strip says «Nothing needs attention». An empty ledger and a closed module do not appear in this strip. On the left, the «Functions» list shows each function’s attention count.

Each function comes as a band that can be expanded and collapsed: the heading shows the attention count, the number of cards, how many of them produce a number, and the number of prebuilt reports. The link below the band leads to the function page; the filters, charts and record table are there.

Shown on the cardMeaning
NumberMeasured. Clicking the number opens the «Reports — Where Did This Number Come From?» page.
No records in this ledgerNo row matching the definition was found. The ledger may be empty or the user may not be authorized to see these records; the screen cannot tell the two apart.
No snapshot dated up to todayThe ledger holds only records dated after today; the card does not display a number.
The full set of rows could not be readThe ledger exceeded the read limit; no number is displayed from a ledger that was read incompletely.
This ledger is not enabled for youThe ledger the card reads belongs to a module that is closed to the user. The ledger is not read, and there is no evidence link.
Not measurableNo number could be produced; the reason is written on the card.

Reports — Function

Shows all the measures of a function together. At the top are summary indicators, below them three tabs: Summary (charts and other measures), Measures (all cards) and Records (the record table). The filters on the left apply to the cards, charts and table together; therefore both the chart’s total and the table’s total equal the card’s number. At the end of the page is the function’s «Prebuilt reports» list.

  • Date shortcuts: All time, This month, Last 3 months, This year, Last year and Custom range. A range whose end is left empty is read as «up to the latest record». «Today» is the day in the organization’s own time zone.
  • A value that does not exist in the ledger is not applied as a filter; its chip says so.
  • The Records tab is shown in pages of 100.
  • For functions that have an Explorer, the «Open Explorer» and «Scenario» buttons are shown. «Copy link» copies the address together with the filters; the person who opens the link sees the same view.
  • No records are entered on this page; data entry and import remain in the source module.
FunctionFilter axesDate axis
SalesRegion, BrandDocument date
Sales OSOrder status, Sales rep, BrandOrder date
FinanceRegion, Expense itemDocument date
ReceivablesCurrency, Branchno date range
StockWarehouse, ABC class, Brandno date range
HRLocation, Level, Attendance status, Training record status, Compliance statusDate
PurchasingOrder statusOrder / requested delivery date
ProductionWork order status, Product codePlanned end
Logistics—Dispatch date
Service & fieldRecord status, Record typeOpening date
Installed baseProvince, Contract type, Installation statusCommissioning
Spare partsCriticality, WarehouseSales / requested delivery date
Problem & solutionPriority, Record statusObservation date

Reports — Report

Opens a prebuilt report. The report modes are selected at the top of the page: Report, Explorer, Scenario. Report mode builds the report’s own page (e.g. ABC, aging, concentration, ratio, target or scorecard); if the report’s entry cannot be found, the page is not produced and says so. Explorer mode opens the function’s Explorer; if the report has a defined prebuilt breakdown, the Explorer starts with that breakdown. Scenario mode opens the Explorer with the scenario panel open. Some reports open only in the Explorer. Others are only a link: it says that the screen opens in its own module and provides the «Open» link.

Export is in Explorer mode: «Download data as CSV» and «Download chart as PNG». The Explorer’s other controls (chart types, sorting, filters) are described in Chapter 7.

Reports — Where Did This Number Come From?

It opens when a card’s number is clicked and shows the records that make up that number. At the top are indicators (including the date of the last record). The «Why is this number the way it is?» section lists findings for the card’s number. Tabs: Summary (the values that carry 80% of the number, and the top 5 by record count), Breakdown and Records. Pressing a value filters the list to that value.

  • Records are shown in pages of 200; the count and the bottom total are calculated from all the rows, not from the page. A multi-page list has a «Go to page» box.
  • «Columns» selects the columns visible in the table.
  • On a card that is a ratio, the numerator and denominator open separately: «Numerator» and «Denominator».
  • While a field filter is active, the number at the top is the number of remaining rows; how many rows were filtered out and the unfiltered form of the number are written separately. The «Why is this number the way it is?» list is not affected by the filter.
  • There is no export on this page.

Saved chart layouts

On pages that carry charts (the Summary tab of the function page and prebuilt reports with charts), «Edit» hides charts one by one and «Show all» brings them all back. The layout you set up stays in the page’s address: if the link is shared, the other party sees the same screen, but if it is not saved, it is lost when the tab is closed.

  • When a layout is given a name and «Save» is pressed, the layout is written to the user’s account (rapor_duzenleri); the same list is visible on every device, and other users do not see it.
  • If a layout with the same name exists, the button becomes «Overwrite». Saved layouts are opened and deleted from the «Saved layouts:» row.
  • A name can be at most 40 characters; at most 12 layouts are saved per page.

Date of the data (freshness ribbon)

At the top of the function, report and evidence pages there is a ribbon that states which dates the data covers. The sentence varies with the type of the ledger:

Ledger typeWhat the ribbon says
Dated events (invoice, order …)The date range the data covers and the number of records; if there are future-dated records, their number is written separately.
A snapshot of a single day (e.g. receivables aging)The date of the snapshot and the number of records in the snapshot; if the snapshot is dated after today, it indicates this.
Period-based recordThe periods the data covers and the number of records.
Ledger that holds no business dateThe date the ledger was last updated and the number of records.
  • The ribbon also shows the time of the last write to the ledger. This is not an import date: an edit made inside the application also advances this time, whereas re-importing the same record may not advance it.
  • If no records are visible in the ledger, the ribbon says so and states that it cannot be distinguished from here whether the ledger is empty or closed to the user. If the ledger contains only snapshots dated after today, it says «No snapshot dated up to today».
  • If the date could not be measured, it says «not measurable» and the reason.

Personal data protection

In concentration reports built from HR ledgers, each row is measured by the number of distinct people behind it (not by the number of records). Rows based on fewer than 5 people are dropped from the list and the denominator. If only one row has been dropped, one more row is dropped so that it cannot be back-calculated from the total. The page always states the threshold applied and how many rows were dropped; dropped rows are not zero, they are not published.