How to check when a stock count needs to be performed

How to Create a Stock count session

To start the stock count, we first must run the inventory sessions function: Inventory > Counts > Inventory Sessions.

Click new, and enter your Site, and a name for the session. The status will default to be in creation. After creation you will see to be counted, then when all lines have been counted or closed, the status will move to closed. You can see previous counts on the left list.

On this screen you define the parameters of your stock count, including

Stock Count Type 

• Product – Which allows you to tailor your countdown to products and Categories of products
• Location – Which allows you to count via location or a range of locations. 

Stock Count Method – To specify what basis the selection of products to be counted is made

• Manual – Products are selected manually or via the selection criteria on the selection tab.
• Annual Stock Count – The system selects products with the option ‘Annual Stock count’ defined at Product site level, the selection criteria from selection tab are then taken into account.
• Cycle Count – The system selects products with the option ‘Cycle count’ defined at Product site level. This takes into account the selection criteria, but also the ABCD class, the number of counts already performed, the number of counts planned and the stock count date. 

Stock Count Sort 

• Product Location – The lines are sorted by product and then location.
• Location Product – The lines are sorted by location and then product.

Process

• Global – If ticked, the last stock count date is updated on the product site record.
• Products without stock – If ticked, products with no expected stock will be included in the count lists.

Next the count worksheets area of the screen lets you define the sizing of the stock count lists.

• Maximum Lines – Maximum numbers of lines per stock count list.
• Percentage Limit – Completion Percentage for each list (to allow room for any unplanned stock recording).
• Number of Products – Maximum number of products per stock count list.
• Multi Lists – Allows the same product to be counted across multiple lists.
• Location Position – When counting via location, allows products to be sorted via location for each list. 

After defining your parameters and selection criteria Click create. You can then run a simulation to check how your stock count is going to look. If you aren’t happy at this time, then you can always modify your parameters.

Please note: Once the stock count lists are generated, it is no longer possible to make stock movements on these products until the product is counted, or released (the stock line will appear ‘locked’). Therefore it is advisable to manually check whether there are any allocated Sales Orders outstanding on the system for the stock lines you intend to count. Any allocated sale orders will need to be deallocated first. 

When you are ready to start the count, click on the Generate button.

How to Perform the Stock Count

Stocks count lists are printed by Inventory > Counts > Counts. Here we can see the Inventory sessions in left list. By selecting the ‘To be Counted’ Inventory session we created earlier. 

On this screen we can choose to print out our count worksheet.

To do this click the printer button on the right hand toolbar, and select list. 

On the lines below we can enter the amount of each product counted, along with adding any other products found during the count on the extra lines below. 

To ‘count’ each product in the system, click on the Action button on each line, and click ‘Counter Detail’ 

This will allow us to enter details of what was counted on the line, including any variances. 

• Save on each line to update the status.
• If the stock to be counted is required for a stock movement, you can click the release button on the right hand list.
• Once completed click validate. This updates and product-site totals, updates any stock movements resulting from the count and releases the product block. The adjustment nominal posting will be then generated by the stock accounting interface.

The addition of new product lines to the count is still possible at this stage. 

• Finally by clicking closing period, anything not yet counted or validated is given the status ‘cancelled’ and the session is closed.