When our team at GeoDataTek began working with one of our clients — a large sports-goods manufacturer — we inherited an ERP environment under serious strain. They were on the latest on-prem version of Microsoft Dynamics 365 Business Central, supporting over 400 full and limited-user accounts plus more than 300 device-user handhelds. In total, around 700 active users depended on the system daily.
As usage grew, performance degradation became painfully obvious. Everyday business routines suffered. Warehouse shipping slowed because “Post Shipment” actions froze. Invoice posting and month-end inventory valuation lagged or locked up. Heavy reports especially inventory valuation and financial reports ran for hours and blocked other users. Even handheld scan-guns used on the floor stalled under load while posting or accessing data. The database carried several years of transactional history which compounded the problem.
Departments began pointing fingers — Finance blamed Warehouse, Warehouse blamed Reporting. In reality the problem was systemic: bulk postings during business hours, heavy manual dependencies for validations (discounts, freight, contacts), concurrent background jobs competing for resources, missing SQL reindexing, database fragmentation, and device- and network-related constraints.
Our technical team spent four to six weeks deep diving into logs, workloads and usage patterns to pinpoint root causes: table locks on heavy posting tasks, unoptimized reports and queries scanning large ledger tables without indexing, background jobs overlapping with critical operations, and general resource contention.
Then we launched a structured, phased performance-improvement program:
Immediate improvements
- Reindexed major tables, cleaned up and archived old data.
- Scheduled weekly log-archiving and regular maintenance.
- Upgraded VM compute power.
- Isolated background automation jobs.
- Moved batch posting tasks to off-peak hours.
- Automated shipping document (Bill of Lading) postings to reduce manual load.
Ongoing scaling optimizations
- Introduced after-hours “ready-to-post” processing for invoices and batch jobs.
- Migrated web orders from SOAP to faster OData/API calls.
- Optimized heavy reports and removed unnecessary locking behavior in inventory valuation.
- Reworked device-to-user assignments for handhelds to improve warehouse throughput.
Strategic architecture & scalability plans (future roadmap)
- Planning microservices-based integrations for third-party systems.
- Evaluating separate environments for Warehouse and Finance to isolate load.
- Streamlining month-end close workflows.
- Automating bulk order updates and improving WMS connectivity for handhelds.
Results
- Table locks dropped by ~70 percent during peak load and heavy operations.
- Invoice posting, shipment posting, and month-end reports now run smoothly and reliably.
- Handheld scan-guns respond quickly even during high concurrency in warehouse.
- Web inventory updates reflect instantly after OData migration.
- Automation ensures round-the-clock availability without manual bottlenecks.
- Cross-team efficiency and confidence improved — Finance, Warehouse, and Operations now collaborate without waiting on the system.
Why this matters
Enterprise-scale environments on Business Central (especially on-premises) often run into performance ceilings as transactional volume, user concurrency, devices, and history grow. Without active performance tuning and architecture adjustments, even the latest version can choke under load. Performance optimization is never a one-time effort. It requires continuous measurement, proactive infrastructure management, smart scheduling of resource-intensive tasks, better indexing and data hygiene, and collaboration across teams.
This client’s journey proves that with disciplined optimization and a structured approach you can transform a struggling ERP environment — even with 700 users and heavy warehouse throughput — into a stable, scalable, future-ready platform.
