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

Inventory Count Sheets for Microsoft Dynamics 365 Business Central

Every warehouse divides a count its own way: by team, by aisle or shelf, by item group, or by vendor. When count sheets cannot follow that split, supervisors end up cutting lists apart by hand. Advanced Inventory Count generates count sheets from the filters set on each sheet, by bin, shelf, item, or a custom filter, so each team gets exactly the lines it should count.

A count sheet is the list of items one team counts, much like a journal batch 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 Inventory count sheets works in Advanced Inventory Count

  1. A supervisor adds count sheets to the inventory count card and sets the filters for each one.
  2. The supervisor runs Generate Count Sheets and chooses the inventory options, or the cycle count options for a cycle count.
  3. Advanced Inventory Count fills each sheet with the lines that match its filters, including expected lot and serial numbers where the setup allows.
  4. Sheets are printed for paper counting, or opened on handhelds for scanning.
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

Sheets by team

Add a count sheet for each team or area on the inventory count card, such as Team 1 for shelves A to D and Team 2 for shelves E onward. Each team works its own sheet.

Filters on each sheet

Each sheet has filters for bin, shelf number, item, and more, plus a custom filter on any field of the item card or stockkeeping unit card, such as only raw materials by posting group, or only one vendor's items.

What goes on the count

Include everything Business Central shows in stock, bins that were emptied within an activity period you set, and items with no stock but a recent transaction. Inactive items can be included when a count needs them.

Cycle count selection

Restrict a count to a physical inventory counting period code, such as fast, normal, or slow movers, or use the next counting period dates on the item or stockkeeping unit card. Those dates are updated when the count posts.

Random cycle counts

Ask for a set number of random items that have not been counted since a date you choose, grouped by item or by item and bin. The next run picks a different set, because it checks when each item was last counted.

Count period codes

A count period code page groups items as fast, normal, or slow movers by percentage of cost, with a count frequency for each group.

Printed sheets

Print count sheets with the layout chosen in setup, including a custom layout. Each sheet carries a barcode that opens it on the handheld, tag numbers for tag-based counts, and blank pages for items found that are not on the list.

See Inventory count sheets on screen

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

Details that matter on the floor

Size sheets for the people counting

Very large counts are supported, but for scanner counting Insight Works recommends keeping each count sheet to a few hundred lines, which keeps each team's work manageable.

Random counts that move on

A random cycle count looks at when each item was last counted, so running it each week works through the items instead of drawing the same ones again.

Who uses Inventory count sheets

Inventory managers

Design count sheets around how the warehouse is organized, and plan cycle count selection.

Warehouse supervisors

Assign sheets to teams and print or load them for count day.

Warehouse staff

Count from a sheet that covers only their area.

Questions about Inventory count sheets

Can count sheets be split by team or area?

Yes. Each count sheet has its own filters, such as a range of bins or shelf numbers, so each team gets a separate sheet for its area.

Can we filter count sheets by vendor or posting group?

Yes. Use the custom filter on any field of the item card or stockkeeping unit card, or the posting group filter.

How does random cycle counting work?

Choose Use Random Items, set the maximum number of items and a not-counted-since date, and group by item or by item and bin. Advanced Inventory Count picks that many items that have not been counted since the date.

Can cycle counts use our ABC classes?

Yes. Restrict the count to a physical inventory counting period code, such as fast, normal, or slow movers, or to items due by their next counting period.

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 sheets?

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