Cycle counting is an inventory management process used to identify discrepancies between system inventory and physical inventory. Instead of performing a full physical inventory count, companies count selected items on a regular schedule, often using ABC classifications based on value or usage.

Benefits include:

• Improved inventory accuracy
• Earlier detection of discrepancies
• Better inventory control
• Support for root cause analysis and process improvement

Setting up counting codes

Items can be assigned physical inventory counting codes that determine:

• Count frequency
• Inventory classification (A, B, C, etc.)
• Next counting period dates

For example, high-value A items may be scheduled for monthly counts.

Performing a cycle count

Before counting, inventory activity should be minimized to avoid affecting count accuracy. To create a count:

1. Open the Physical Inventory Journal.
2. Select Prepare > Calculate Counting Period.
3. Choose the items scheduled for counting.
4. Enter a posting date and document number.
5. Generate the journal.

The journal displays:

• Calculated Quantity (system quantity)
• Physical Inventory Quantity (actual count)
• Variance
• Financial impact of the adjustment

Printing count sheets

Count sheets can be printed for the counting team.

Options include:

• Blind counts that hide system quantities
• Displaying system quantities
• Including serial or lot tracking information

Counters record physical quantities and return the completed sheets for entry into Business Central.

Posting results

After counts are entered:

1. Review variances.
2. Validate quantities and costs.
3. Post the journal.

Business Central automatically updates inventory balances, creates adjustment entries, records the count date, and schedules the next count.

Reporting and analysis

Physical Inventory Ledger Entries provide a history of all cycle count activity, including:

• Positive and negative adjustments
• Counts with no variance
• Inventory accuracy metrics

This data can be exported to Excel for additional reporting and trend analysis.

Best practice: root cause analysis

Cycle counting should do more than correct inventory. Investigating why discrepancies occur helps identify process issues and improve long-term inventory accuracy.

Common areas to review include:

• Receiving errors
• Picking errors
• Inventory transactions
• Warehouse process compliance

Key takeaway

A successful cycle counting program combines regular scheduled counts, accurate inventory adjustments, and ongoing root cause analysis to improve inventory accuracy and warehouse performance.