Skip to content
Advanced Inventory Count app iconAdvanced Inventory CountPlan the count

Physical Inventory and Cycle Counts for Microsoft Dynamics 365 Business Central

A year-end count or a weekly cycle count involves more than counting. Sheets have to be prepared, several people enter results, differences have to be found and recounted, and the adjustments have to post cleanly. Advanced Inventory Count brings data entry, reconciliation, posting, and analysis for full physical counts and cycle counts together on one inventory count card in Business Central.

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 Physical inventory and cycle counts works in Advanced Inventory Count

  1. A supervisor creates an inventory count card with a description, location, and inventory as-of date, and marks it active.
  2. The supervisor adds count sheets and generates the lines to count, for a full count or a cycle count.
  3. Teams count on printed sheets or handheld scanners, and results are entered on the count sheets.
  4. The supervisor reviews the difference reports and sends lines with large differences to a recount sheet.
  5. When the count is final, the supervisor copies it to the journals, and accounting runs the test report and posts.

Key capabilities

The inventory count card

Each count is an inventory count card with its location, inventory as-of date, count sheets, and posting settings. The count stays active while results are recorded, and it is deactivated when the count is done.

Prepare ahead of count day

The inventory as-of date is the date the count reconciles and posts as of. Count sheets can be prepared weeks before, for example for a December 31 count, without recalculating inventory the night before.

Sheets for each team

Count sheets are generated from filters, one sheet per team or area, for a full count or a cycle count.

Paper, scanners, or both

Teams can count on paper while others scan, and several users enter counts at the same time.

Reconcile and recount

Difference reports show where the count is off, and recount sheets send flagged lines back for a second count.

Post through standard journals

Copy Count to Journals fills the Business Central physical inventory journal, and the warehouse physical inventory and reclassification journals where needed. A journal test report finds errors before posting.

Count history

Archived counts keep their statistics, such as the last difference amount and quantity, so a weekly cycle count program can be compared over time.

Reuse a count setup

Duplicate a count configuration to use it again, so a recurring cycle count does not have to be set up from scratch each time.

See Physical inventory and cycle counts on screen

Real screens from Advanced Inventory Count, shown with demo data.

Details that matter on the floor

Warehouse counts, accounting posts

Warehouse staff manage counting and recounts on the count card. Copy Count to Journals hands the result to the standard journals, where an authorized person in accounting posts it, so the segregation of duties stays in place.

A record of every count

Statistics for each count, such as difference amounts and quantities and who reported and copied them, stay with the count. Past counts can be reviewed to see whether results are getting better or worse.

Who uses Physical inventory and cycle counts

Inventory managers

Plan full and cycle counts and decide when a count is final.

Warehouse supervisors

Organize teams and sheets, and manage recounts on count day.

Financial controllers

Review differences and post the adjustments through the standard journals.

Questions about Physical inventory and cycle counts

Does Advanced Inventory Count handle both full physical counts and cycle counts?

Yes. The same inventory count card runs a full physical count or a cycle count. Cycle counts can select items by count period code, by next count date, or at random.

Does Advanced Inventory Count require Warehouse Insight?

No. Advanced Inventory Count runs on its own for counts entered in Business Central. For handheld scanning, it works with Warehouse Insight or WMS Express, or another external data collection system.

Can we prepare a year-end count ahead of time?

Yes. Set the inventory as-of date to the count date and generate count sheets in advance. Reconciliation and posting use the as-of date.

Can we try it before we buy?

Yes. Advanced Inventory Count installs from Microsoft Marketplace and can be evaluated in a Business Central sandbox, so you can run a test count first.

How is Advanced Inventory Count licensed?

Licensing depends on your setup. See the licensing FAQ, or contact your Microsoft Partner.

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 Physical inventory and cycle counts?

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