Sage 100 Business Insights Dashboard Error on Drill Down: Why It Breaks
The Sage 100 Business Insights Dashboard opens, the totals look right — then you drill down for the detail behind Cash and the dashboard fails. Two different errors, one broken click, and the cause is not where the messages point.
On the Sage Community Hub, “Business Insights Dashboard - error on drill down” asks exactly this. In Sage 100 Advanced 2021, click into Balance Sheet Details — Cash — and one user is stopped cold while another times out.
Two Sage 100 Dashboard Errors, One Broken Drill-Down
The first user sees “CS Workstation Activation, 1 User Limit exceeded.” The second sees “Connection failure to host.” Two messages pointing opposite ways — one like licensing, the other like a dead server — from the same click.
It Looks Like Sage 100 Permissions. It Isn't.
Both users already held General Ledger rights — bookkeeper and owner — so permissions were the first suspicion. That suspicion is the trap. When rights check out and errors still split by workstation, the problem sits below Sage 100, in how that workstation reaches the host.
The Verified Fix Was Under the Dashboard
The thread's verified answer was short: the end user needed to add inbound rules, and that fixed it. The dashboard never needed that connection to display totals — the drill-down behind them did. Which rules, and where, depend on your setup, and guessing can open more than the dashboard.
Why Self-Set Servers Hit This First
In the Hub thread, the owner had set the server up himself. A server can run Sage 100 for months and never expose this gap, because daily posting never tests what a drill-down tests. The first real test is often the owner, at month-end, clicking for the number behind the number.
Frequently Asked Questions
Why does the Sage 100 Business Insights Dashboard fail only on drill down? The dashboard can load its summary view while the follow-on connection the drill-down needs is blocked — so totals appear and detail never arrives.
Is a “1 User Limit exceeded” message a licensing problem? Not necessarily. The same drill-down produced a limit message for one user and a connection failure for another, and inbound rules — not a license change — resolved it.
What a Dashboard That Won't Drill Down Costs
A dashboard you cannot drill into is one you stop trusting. The owner asks the bookkeeper for reports, the bookkeeper falls back to exports, and a cash question that should take seconds takes a meeting. The number is on screen — never the evidence behind it.
Fix the Layer Under the Dashboard
Our free Sage 100 Health Check tests the dashboard the way owners use it — totals, drill-down, and the connection behind both. Every Digit Masters consultant is a licensed U.S. CPA, and our Sage support plans keep reporting working after the first fix. Get the drill-down checked before month-end depends on it.
Related Services
This topic connects directly to our core service areas: Sage 100 Consulting, Sage 100 Support, and our free Sage 100 Health Check. Related reading: our post on Sage 100 user permissions and cost data and our post on Sage 100 running slow diagnostics. If you're working through a similar challenge, contact us for a free consultation.
