Skip to content
Advanced Inventory Count app iconAdvanced Inventory CountReconcile and post

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

  1. After entry, the supervisor runs the physical inventory differences report, sorted by amount.
  2. The supervisor reviews the largest differences and the absolute difference total.
  3. Lines that need checking are opened on the count difference summary page, with lot detail.
  4. Lines with large differences are sent to a recount sheet.
  5. When the differences are explained, the count moves to posting.
Video thumbnail: Run an inventory count from setup to posting in Advanced Inventory Count
Run an inventory count from setup to posting in Advanced Inventory Count For warehouse and inventory managers preparing a full physical count or cycle counts who want to count by scanner or on paper and reconcile before anything posts. Transcript and details →

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.

Advanced Inventory Count app icon

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.

Ask a product question

Product Questions