Inventory Count Reconciliation for Microsoft Dynamics 365 Business Central
Once the counts are in, the question is whether the count is any good, and where it went wrong. Scanning a long journal line by line does not answer that. Advanced Inventory Count adds a count difference summary page and a physical inventory differences report that rank differences by amount, so the largest problems come first.
Reporting also helps identify obsolete inventory and items with improper planning parameters, along with the financial impact of those issues. Advanced Inventory Count runs on its own for counts entered in Business Central, and works with Warehouse Insight or WMS Express, Insight Works' mobile warehouse apps, for counting on handheld barcode scanners.
How Inventory count reconciliation works in Advanced Inventory Count
- After entry, the supervisor runs the physical inventory differences report, sorted by amount.
- The supervisor reviews the largest differences and the absolute difference total.
- Lines that need checking are opened on the count difference summary page, with lot detail.
- Lines with large differences are sent to a recount sheet.
- When the differences are explained, the count moves to posting.

Key capabilities
Count difference summary
A page lists differences by item and bin with the amount, quantity, and percentage, with lot-level detail for the selected line. It can be filtered, analyzed, and exported to Excel.
Physical inventory differences report
The report sorts items by the size of their difference, so the largest shortages and overages appear first.
Net and absolute totals
The report totals both the net difference and the absolute difference. The absolute difference shows how far off the count really was, even when shortages and overages cancel out.
Zero differences left out
Lines with no difference can be excluded, so the report shows only what needs attention.
Lot and serial detail
Lot number shortages and extras appear under each tracked item. See Lot and Serial Count Reconciliation.
Count statistics
The inventory count card keeps statistics such as the last difference amount and quantity, the absolute difference, and the difference percentage, with who ran the reconciliation report and when.
Obsolete stock and planning parameters
Reporting helps identify obsolete inventory and items with improper planning parameters, and the financial impact of those issues.
See Inventory count reconciliation on screen
Real screens from Advanced Inventory Count, shown with demo data.
Details that matter on the floor
Why the absolute difference matters
If one item is short by a certain value and another is over by the same value, the net difference is zero and the count looks perfect. The absolute difference is twice that value, which is the figure that shows how accurate the count was.
Biggest problems first
Sorting by amount puts the costly differences at the top, so recount effort goes where it changes the valuation most.
Who uses Inventory count reconciliation
Inventory managers
Judge how good the count was and decide what to recount.
Financial controllers
Review the financial impact of count differences before adjustments post.
Supply chain analysts
Look for obsolete stock and planning parameters that need attention.
Questions about Inventory count reconciliation
How do we find the biggest count errors?
Run the physical inventory differences report sorted by amount. Items are listed from the largest absolute difference down.
Why look at absolute difference instead of net difference?
Shortages and overages can cancel each other out in the net figure. The absolute difference adds them together, which shows how far off the count really was.
Can count differences be exported to Excel?
Yes. The count difference summary page can be exported to Excel for further analysis.
Does the report show lot and serial differences?
Yes. Lot number shortages and extras are listed under each tracked item.
Related Advanced Inventory Count features
All Advanced Inventory Count features →Part of Advanced Inventory Count
Finish inventory and cycle counts sooner in Business Central with barcodes and multi-user entry.
Have a question about Inventory count reconciliation?
Send us a note and the Advanced Inventory Count team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
