BeyondERP.Newsletter
Menu

Setup page · Warehouse management

Cycle count thresholds

A setup page where you define cycle counting thresholds, which automatically create cycle counting work when the quantity or percentage limit of an item in a location is reached.

Used by
Field Service Integration User, Production supervisor, Process engineer and 3 more roles
Business process
Manage warehouse operations
Menu item
WHSCycleCountThreshold
Main table
WHSCycleCountThreshold
Data entity
WHSCycleCountingThresholdEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define cycle counting thresholds, which automatically create cycle counting work when the quantity or percentage limit of an item in a location is reached.
What you do hereUse this page to trigger cycle counting work automatically, choose whether it is created immediately and select the items and locations that the threshold covers.
ExampleFor example, with a threshold of 40, cycle counting work is created for a location when a pick leaves fewer than 40 items in it.
Cycle count thresholds page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage warehouse operations
Menu pathWarehouse management › Setup › Cycle counting › Cycle count thresholds
Related pagesCycle count plans Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Cycle count thresholds

Use this page to trigger cycle counting work automatically, choose whether it is created immediately and select the items and locations that the threshold covers.

Steps from Microsoft

  1. Go to Warehouse management > Setup > Cycle counting > Cycle count thresholds.
  2. On the Action Pane, select New.
  3. Enter a Cycle counting threshold ID and a Description.
  4. Set Process cycle counting immediately to Yes to create the work as soon as the threshold is reached.
  5. Select Save, then select Select locations to define which locations the threshold applies to.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Cycle counting threshold IDA unique identifier for the threshold.Microsoft Learn CycleCountThresholdId
DescriptionA description that explains what triggers the threshold.Microsoft Learn Description
Process cycle counting immediatelyYes creates the counting work as soon as the threshold is reached. No creates it the next time the threshold processing batch job runs.Microsoft Learn ImmediateCycleCount

Test checklist

  1. Create a Quantity threshold (for example 2 ea) with Process cycle counting immediately set to Yes, and select the item.
  2. Pick from a location so the on-hand drops below the threshold quantity.
  3. Check that cycle counting work is created for the location in the threshold's work pool.
  4. Process the count on the mobile device and review differences on Cycle count work pending review.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Cycle count thresholdsThresholds that trigger a count when a picking location falls to zero or below a set quantity, with Process cycle counting immediately set to Yes where the count should happen right after the pickLearn describes thresholds that automatically trigger counting work when a location becomes empty after a pick or falls below a level. With Yes the work is created as soon as the threshold is reached; with No it waits for the threshold processing batch job.Setting Process cycle counting immediately to No and not scheduling the threshold processing batch job, so no counting work is created.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Thresholds can be changed or removed at any time. Counting work already created stays until processed or cancelled. Microsoft Learn
Technical architect

6Technical

Menu itemWHSCycleCountThreshold Checked in Dynamics 365
FormWHSCycleCountThreshold Checked in Dynamics 365
TableWHSCycleCountThresholdShown as “CYCLE COUNTING THRESHOLD” in Record infoKey field: CycleCountThresholdIdChecked in Dynamics 365
Data entitiesWHSCycleCountingThresholdEntityCycle counting thresholds Microsoft data model
Who can open itPrivilegesMaintain cycle count thresholds WHSCycleCountThresholdMaintainView cycle count thresholds WHSCycleCountThresholdViewDutiesInquire into warehouse operation master WMSWarehouseOperationMasterInquireMaintain warehouse operation master WMSWarehouseOperationMasterMaintain
6 security rolesField Service Integration User FieldServiceIntegrationUserProduction supervisor ProdProductionSupervisorProcess engineer RouteProcessEngineerProcess engineering manager RouteProcessEngineeringManagerWarehouse planner WHSWarehousePlannerWarehouse manager WMSWarehouseManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itWarehouse manager WMSWarehouseManagerProcess engineer RouteProcessEngineerTo use itWarehouse planner WHSWarehousePlannerProduction supervisor ProdProductionSupervisorProcess engineering manager RouteProcessEngineeringManagerField Service Integration User FieldServiceIntegrationUserGive people one of these roles. On this system, 6 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Select items, Select locationsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=WHSCycleCountThreshold
Integrate withWHSCycleCountingThresholdEntity data entity Microsoft data model
Data migrationWHSCycleCountingThresholdEntity (Cycle counting thresholds): loaded for each company, in Microsoft's default template 400 - Warehouse management.Load order: Microsoft's default template 400 - Warehouse management loads Cycle counting thresholds at execution unit 1, level 40, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: Units, Warehouse work pools, the default templates at lower levels (System setup to dependency bands 30 to 90)Microsoft Learn
Table definitionWHSCycleCountThreshold columns and relations Microsoft data model
Everyone

8Sources