Joins across 21 objects
Customers, invoices and their lines, products, orders, purchases, warehouses, stock movements, assets and work orders, among others.
Report Builder
Today’s question, answered today.
Pick an object, add columns, join other objects, filter, group and chart. Ask things like "customers WITHOUT invoices this quarter" or "margin by category" and get the result by email every Monday.
Without MKA
- Every new report is a ticket to IT that takes weeks.
- You export three lists and match them by hand with VLOOKUP.
- Totals don’t add up because a join duplicated rows.
What you’ll measure
Active custom reports
146+38
Report requests to IT
5 / mes−17
Scheduled deliveries
64+21
CSV by email each week
Users building reports
38 %+14 pts
of back-office users
Sample indicators with illustrative data. In MKA they are computed live from your operation.
Try it right here
Find the customers who stopped buying from you.
As a sales analyst: pick Customers, join Invoices, try adding Invoice lines (the fan-out guard stops the inflated total), filter "WITHOUT invoices this quarter", group by branch, switch to chart and schedule delivery to the sales team. "Watch it run" does it for you.
Example flow
From a question to a report that arrives by itself
Step 1/6
Pick the object
Customers, invoices, products, orders, purchases, stock, assets or work orders.
Orders & shipmentsBenefits
Why Report Builder in MKA
Totals that don’t inflate
A fan-out guard stops joins that would inflate sums.
Real filters
WITH / WITHOUT cross filters ("customers without invoices") and logic like "1 AND (2 OR 3)" with NOT, injection-safe.
Exact calculated fields
Margin = line total − cost, with exact decimal math, per-group subtotals and grand total.
Charts and pivot
Bar, line, area or pie charts, and a pivot view, on the same report.
Lands in your inbox
Schedule the report as CSV to several recipients, and share it with users or in public lists.
In detail
Everything included
Building
- Base object, columns, filters, groupings and totals (sum, avg, count, min, max)
- Multi-field sort
- Save, clone and delete reports
- Calculated fields with exact decimal math
- Per-group subtotals and grand total
Joins and filters
- User-defined joins across 21 business objects
- Fan-out guard against row multiplication
- WITH / WITHOUT cross filters (EXISTS / NOT EXISTS)
- Advanced "1 AND (2 OR 3)" logic and NOT, injection-safe
Visualization
- Bar, line, area and pie charts
- Pivot view
- CSV export
Share and schedule
- Share with users, "shared with me" and public lists
- Scheduled email delivery as CSV to several recipients
- 5 fixed reports (sales by branch, customer and product, seller ranking, production summary) schedulable as PDF or CSV over a rolling window
All-in-One
Connects with
Data flows between modules on its own: no integrations, no exporting or importing.
Dashboards107 widgets you drag, resize and put on the office TV.Orders & shipmentsOrders, partial shipments and consolidated invoicing, all linked.Purchasing & suppliersFrom request to payment, with partial receptions and lots.InventoryMulti-warehouse stock with approved transfers, kardex and counts that add up.MaintenanceCalendar or usage-based preventive, work orders and failure analysis.
FAQ
What format do custom reports export to?
Custom reports export and send as CSV. The 5 fixed sales and production reports can be scheduled as PDF or CSV.
Can a user see data they shouldn’t?
Filters are built injection-safe and reports are shared explicitly with users or in public lists.
More in Analytics & strategy
See Report Builder with your data.
In 30 minutes we walk through your real flow: from sale to invoice, from stock to journal entry.