Your team shuts down receiving, locks the warehouse doors, and spends the next two days counting everything from raw materials to half-finished production orders. When it’s over, the numbers don’t reconcile. The accounting department is waiting. Someone finds a pile of uncounted items behind a rack. The process restarts. Sound familiar?
Why Does Inventory Counting Break Down in Business Central?
The core problem is that Business Central’s built-in counting tools were designed for straightforward scenarios. The Physical Inventory Journal, which has been part of the system for years, generates a list of items, lets you fill in quantities, and posts adjustments. That works if your warehouse is simple. If it isn’t, you start running into walls quickly. Items stored across multiple shelf locations with no bins enabled cannot be counted separately by location in the standard journal. You end up manually tracking sub-totals on paper, adding them up, and entering a single figure. That is exactly the kind of manual math that introduces errors. Microsoft’s own documentation on counting, adjusting, and reclassifying inventory in Business Central acknowledges that without bins, an item can only be counted once per location, and the document-based approach still requires separate reconciliation steps for warehouse entries. These are real constraints, not workarounds.
Lot and serial number reconciliation compounds the difficulty. Business Central’s Physical Inventory Order capability adds some lot and serial tracking during counts, but it is fragile. A misconfigured line, a missing tracking entry, or an item in an unexpected bin can break the reconciliation.
Research published in the journal Production on inventory record inaccuracy in distribution centers found that inaccuracies affect picking productivity, lost sales, and warehouse capacity utilization across every warehouse category studied, and that simply implementing cycle counts is often insufficient to resolve the underlying problem. Getting the count right the first time matters. The challenge is that Business Central’s native tools make that harder than it should be, especially when multiple teams are counting simultaneously and need to enter data independently.
How Does Advanced Inventory Count Fix the Problem?
Advanced Inventory Count, from Insight Works, is an app for Dynamics 365 Business Central that replaces the manual workarounds with a structured, flexible counting framework. It installs directly from the Microsoft Marketplace and layers onto Business Central’s existing journal and posting infrastructure, so no custom development is required, and no existing workflows are disrupted.
What Does the Counting Process Actually Look Like?
The app organizes each count around an Inventory Count Card. One card typically maps to one location, though multi-location counts are supported. Within that card, you configure Count Sheets, which are essentially named batches of items. A warehouse with separate raw material and finished goods areas might define one sheet per zone, filtered by shelf range, posting group, vendor, or any item card field. This filtering flexibility means each counting team receives a list relevant to their area, nothing more. The As-of-Date field lets you generate and print sheets well before count day, while ensuring that differences are calculated against the correct transaction date. Teams can start preparing a week in advance without locking the system.
Data entry supports paper-based, scanner-based, and hybrid approaches simultaneously. Multiple users can enter counts into different sheets at the same time, which the standard Physical Inventory Journal does not handle cleanly. For warehouses using Business Central’s bin and directed put-away configuration, the app also works with the Warehouse Physical Inventory Journal, automatically populating both journals when count data is transferred. For teams using handheld scanners, Warehouse Insight and WMS Express integrate directly with the count module. WMS Express is free software; pairing it with Advanced Inventory Count gives you barcode-driven counting on a phone or dedicated scanner device. One customer cited in the demo went from a four-day serial-number-heavy count to a single day, with half a day of reconciliation.
After count entry, the Count Difference Analysis report sorts discrepancies by absolute dollar value, flagging the biggest exposures first. When recounts are needed, the Generate Recount Sheets function automatically flags items that exceed a set quantity or value threshold and creates a new recount sheet. The original count lines lock, so the audit trail is clean. Once reconciliation is complete, the Copy Count to Journals function transfers everything to the Physical Inventory Journal, with item tracking lines, lot and serial number reclassifications, and dimension values handled automatically. A pre-posting test report then checks every journal line for blocked items, missing tracking, missing posting groups, and other conditions that would otherwise cause a mid-posting failure on large batches.
Why This Matters for Partners and End Users
For end users, the payoff is measurable: shorter counts, fewer reconciliation loops, and a posting process that does not stall partway through a 10,000-line journal. For Microsoft Partners, Advanced Inventory Count addresses a gap that nearly every warehouse-heavy Business Central client hits at some point. It deploys cleanly, integrates with both basic and advanced warehouse configurations, and is demonstrably faster than the native tools. That is a straightforward value proposition to bring to a client who has just finished a two-day count and is still reconciling discrepancies on day four.
Get Started
Full product details, documentation, and a trial are available at InventoryForDynamics.com. To see Advanced Inventory Count in action within your own Business Central environment, reach out to a certified Microsoft Dynamics 365 Business Central partner. A structured demo against your actual warehouse configuration will show you quickly where the time savings are.