Skip to content

Setting Up Cycle Counting with Warehouse Management in Dynamics NAV

ArcherPoint How-To Blog: How To Identify  Licensed and Out of Range Objects I was recently asked about Cycle Counting and how Microsoft Dynamics NAV updated the ‘Next Counting Period’ on an Item Card.  By following the process below, the inventory quantity will be updated, the financial adjustment will be posted to the General Ledger, and the “Next Counting Period’ will be updated.

  1. Define the counting periods in “Phys. Invt. Counting Periods”
    • Go to Warehouse>>Inventory>>Phys. Invt. Counting Periods to setup counting periods.

Set up the counting periods in Phys. Invt. Counting Periods

Figure 1 – Set up the counting periods in Phys. Invt. Counting Periods

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

Define the Counting Period

Figure 2 – Define the Counting Period

  1. Go to Warehouse>>Inventory>>Tasks>>Phys. Inventory Journal
     
  2. Select the Action Tab>>Calculate Counting Period>>OK

Select Calculate Counting Period from Phys. Inventory Journal

Figure 3 – Select Calculate Counting Period from Phys. Inventory Journal

View of the Phys. Invt. Item Selection screen

Figure 4 – View of the Phys. Invt. Item Selection screen

  1. Highlight the items you want to count or have time to count and select ‘OK’.

Highlight the items you want to count

Figure 5 - Highlight the items you want to count

Options available for Calculate Phys. Inventory

Figure 6 – Options available for Calculate Phys. Inventory

  1. 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. 

View of the Phys. Inventory Journal. Note the values in Qty. (Phys. Inventory) and Quantity fields

Figure 7 – View of the Phys. Inventory Journal. Note the values in Qty. (Phys. Inventory) and Quantity fields

  1. Select ‘Post’. This will post the adjustment to the quantity on hand.

Post the adjustment quantity to the quantity on hand

Figure 8 – Post the adjustment quantity to the quantity on hand

  1. To post the financial adjustment to the General Ledger
    • Go to Warehouse>>Inventory>>Tasks>>Item Journals>>Action Tab>>Calculate Whse. Adjustment

Show items to be posted to the General Ledger

Figure 9 – Show items to be posted to the General Ledger

  1. Review the entries and Post, this will update the General Ledger.

Review entries and post

Figure 10 – Review entries and post

  1. Go to the Item Card and confirm the ‘Next Counting Period’ has been updated.

Review Item Card to confirm update was performed

Figure 11 – Review Item Card to confirm update was performed

If you have any further questions on Warehouse Management, please contact ArcherPoint.

Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube
Get Help Now