Cycle Counting

Cycle Counting

Cycle Counting is an inventory auditing procedure, which falls under inventory management, where a small subset of inventory, in a specific location, is counted on a specified day.

Cycle counting is different from traditional physical inventory counting, because that requires a counting of alle items at one time. This usually forces the operations to stop and requires heavy workforce.

Benefits

Cycle counts can be done during daily operations, and are therefore more efficient. It also keeps the inventory accuracy at better level because there’s always measurement ongoing.

Not all items need to be counted at the same frequency, since there’s difference in items with high value, movement volume or items which are critical to the business processes. Therefore items should be classified (fast, normal, slow movers, or a,b,c etc).

By smartly planning Cycle Counting you can make analyzes of your inventory and make comparisons over the years. It also ensures that you are flexible and can consciously make choices in the when and how often counting season products.

Challenges

Cycle Counting also faces some challenges:

  • It requires preparation from the office to make assignments for the employees who carry out the work. This takes time during the year, since every month, week or day something has to be prepared.
  • The accuracy of Cycle Counting can be a bit lower than an integral count. In order to maintain a reliable stock position, it is possible to opt for an integral count once every two or three years in order to be able to implement a correct stock position at the same time.
  • It is often chosen to carry out the Cycle Counts during the day. This has the major disadvantage that the customer can receive less help or that the employee chooses to help the customer so that he does not know exactly where he or she stayed with the count . In addition, products that have already been counted can be sold before the count has been processed (depending weather you keep count on paper or by Handheld)

Setting up Cycle Counting in Business Central

Cycle Counting can be done easy with Dynamics 365 Business Central. A few settings need to be done first to get this functionality working. This article describes Cycle Counting.

The following process describes the necessary settings and the Cycle Counting process.

Click the Search Button, and search for Physical Inventory in the Search bar.



2. In the Item Card, Warehouse Tab, define the Counting Period.




Tips
Cycle Count setup is done per item. It is not possible to add Cycle Counting periods to an Item Group and count all items within. However to setup Cycle Counting per Item can be done very easy by batch using Rapid Start functionality.

Counting Items

1. Go to Warehouse –> Inventory –> Tasks -> Physical Inventory Journals (or search for it)

2. Select Actions –> Functions –> Calculate Counting Period



The Physical Inventory Item selection screen appears. On this screen all items are visible that have to be counted, based on the Counting Period, the Last Phys. Inventory Date.

3. Select the items you want to count and select OK.



Tips
The filter selections in the Item Selection screen are limited. You can only filter on Item No., Variant Code and Location Code. It is not possible to filter on a Bin for example. You can also directly export to Excel and make filters there.

4. Fill in the desired options, such as Posing Date and options like whether it should include items Not in inventory as well, and click OK.



5. After the physical counts have been completed, enter the ‘Qty. (Phys. Inventory)’ from the physical count. The adjustment quantity will appear in the ‘Quantity’ field. 



6. Select Post. This will post the adjustment to the quantity on hand. This action results in new Ledger Entries as well.

The history of counting can be found directly from the Item History, in the Physical Inventory Ledger Entries.



The Item Ledger Entries show the quantity adjustments as well.



When you go back to the Item Card, you’ll find the Cycle Counting related fields to be updated.



    • Related Articles

    • To do Cycle Counting

      You can count items as often as you'd like. For example, because they're more valuable, or because they're fast movers and a large part of your business. Specify the counting frequency by assigning special counting periods to the items. Depending on ...

    • Count, Adjust, and Reclassify Inventory Using Journals

      In this article To count physical inventory To do cycle counting To adjust the quantity of one item To synchronize the adjusted warehouse entries with the related item ledger entries See also Physically count all of the items in inventory to ensure ...

    • Count and Adjust Inventory Using Documents

      In this article To create a physical inventory order To create a physical inventory recording To finish a physical inventory recording To complete a physical inventory orderShow 4 more You can take a physical inventory of your items by using physical ...

    • Manage Inventory

      In this article Inventory reconciliation Related tasks See also Start a free trial! For each physical product you trade in, you must create an item card of the Inventory type. Items you offer to customers but do not keep in inventory you can register ...

    • How to use the period counting functionality in Business Central?

      If you want to use the period counting functionality in Business Central, you need to do some setup first. See video: https://usedynamics.com/business-central/inventory/physical-counting-periods/ First of all, you need to define your counting periods ...