Skip to content

Blog · Webinar question

Can Advanced Inventory Count assign ABC classes to items automatically for cycle counting?

Insight Works · · 2 min read

This question was asked during the webinar Beyond the physical inventory journal: Accurate counts in Business Central. Watch the recording for the full demo.

On this page

ABC cycle counting means counting your most important items more often. The hard part is keeping the classes current. Item activity changes, and a class assigned two years ago may no longer match how an item moves. In Microsoft Dynamics 365 Business Central, the class is usually stored in the physical inventory count period code on the item.

Automatic classification in Advanced Inventory Count

An attendee asked about automatic classification. Advanced Inventory Count includes a physical inventory count period calculation for this.

It looks at the movement of your items by dollar amount and assigns the appropriate physical inventory count period code based on your configuration. For example, you can set your top 10 percent as A items, your next 30 percent as B items, and the rest as C items. The calculation does the sorting for you.

There is a knowledge base article on how to set it up and use it.

Using the classes in a cycle count

Once items carry a count period code, you can use it when you generate count sheets. Advanced Inventory Count supports the standard Business Central cycle count fields:

The physical inventory count period code, such as A, B, or C.

The next count period, which Business Central sets each time you post a physical inventory journal. It works out when an item is next due, such as counting some items six times a year.

Random item counts

There is another option the presenter preferred for cycle counts: random items. You ask for a set number of random items not counted in a period you choose, by item or by item and bin. Advanced Inventory Count finds items that haven’t been counted recently and builds the count sheet.

Other count sheet options

Cycle count sheets can use the same options as full counts. You can include items in stock, recently active items with zero on hand, and recently emptied bins to confirm they are empty. Filters by zone, bin, item, or any item field let you split the work between teams.

Reviewing cycle counts

For cycle counts, create a baseline sheet so the count has something to compare against. Then review differences by value, send items to recount sheets if needed, and transfer the count to the Business Central journals. Posting through Advanced Inventory Count creates physical inventory ledger entries, which Business Central uses for things like updating count period information.

Relevant Tools

Advanced Inventory Count is the main tool for this question. It calculates ABC classes from item movement, generates cycle count sheets, and reconciles and posts the results.

Warehouse Insight and WMS Express let people count cycle count sheets on handheld devices. WMS Express is free for up to five devices.

More questions from this webinar

Watch the webinar recording