Autodesk Prodsmart allows you to create and perform Inventory Counts, so that you can guarantee the accuracy of your current inventory.
If you want to perform Inventory Counts, talk to your account manager so he tells you what is needed to turn on the feature that enables you to do so.
Check below how this feature works.
Create the Inventory Count task.
1. Go to ‘Inventory’ > ‘Inventory Counts’ > ‘+Add Inventory Count’.
2. Personalize your inventory count as required.
‘Code’: unique identifier of the ‘Inventory Count’.
‘As of date’: date considered for the inventory adjustments.
Under Warehouse #1:
‘Warehouse’: select one in case you want a specific warehouse to be counted.
‘Workers’: choose the workers that will be assigned to the inventory count; if empty, all workers can perform this inventory count.
‘Deviation Threshold’: acceptable difference value that might occur from an inventory count versus the existing stock on the date defined ‘As of date’ (in percentage %).
If all these 3 are left blank, the inventory count will be set for every warehouse, every location and all workers will be able to perform it.
If you select a Warehouse that has several locations, you are able to click ‘+Add Warehouse Location’ and a new personalization box will be displayed:
‘Warehouse Location’: if you want to filter your inventory count in a specific location of the chosen warehouse.
‘Product’: select one in case you want to count a specific product in the selected locations.
‘Lot/Batch Number’: you can also filter your inventory count by lot/batch number by inserting the desired one here.
Let’s check some examples to better understand what was explained above:
Example 1: All locations will be counted; All workers will be able to count them.
Example 2: All locations of Warehouse A2 will be counted; All workers will be able to count them.
Example 3: From Warehouse A2, location 01 with product ‘Wood’ will be counted and location 02 with all products will be counted; workers Ana Maria and José Paulo will be able to count these. From warehouse Shipping, worker Jane Doe will be asked to count all locations.
For now, we’ll create our own example in order to move on with the explanation of this feature: code ‘IC WH2, Receiving DD01 and Wood’, for January 12th at 11:59AM, counting all locations from Warehouse 2 by worker Jane Doe with a 10% Deviation Threshold, and counting location DD01 from warehouse Receiving and all locations in warehouse Receiving containing the product Wood.
How to perform and record a Inventory Count
Now that you created an Inventory Count, it's time to perform and record it.
You can do so in the back office (as it is explained below) or on the mobile device, in the ‘Inventory Count’ button - you can learn more about this button here.
1. Go to ‘Inventory’ > ‘ Inventory Count Records’ > ‘+Add Inventory Count Record’.
2. To create the record, you’ll be asked to fill the ‘Inventory Count’ code, ‘Warehouse location’, ‘Worker’ that is counting, ‘Creation Date’ of counting, ‘Product’ and ‘Quantity’ counted, and ‘Lot/Batch Number of the product.
3. Once you’re done filling these fields, you can ‘Save Inventory Count Record’, ‘Save and Continue Editing’ or ‘Save and Add Another’.
Check your Inventory Count Records
After you’re done counting your inventory, you can check the data collected by the workers.
1. Go to ‘Inventory’ > ‘Inventory Count Records’.
2. Filter by the data that best suits your search: ‘Start Time’ and ‘End Time’, ‘Inventory Count’ code, ‘Product’, ‘Warehouse location’ and ‘Worker’. You’ll be shown the inventory count records for the filtered data.
Summary and Analytics
You can check the analytics or the summary about the data you just collected on the buttons shown in the picture below. These can be found after you open the Inventory Count which data you want to analyze.
In ‘Summary’, you can check the inventory count entries you performed for the selected Inventory Count. You’ll be shown a table with the ‘Warehouse’, ‘Warehouse Location’, ‘Product’, ‘Lot/Batch Number’, existing ‘Inventory’ in the ‘As of date’ previously defined, ‘Count’ performed, ‘Difference’ between ‘Inventory’ and ‘Count’, and lastly ‘Difference Percentage’.
This last field will take into account the ‘Deviation Threshold’ value defined. It will be green in case the difference is 0; black in case the difference is acceptable within the deviation threshold; red otherwise (you can check the deviation threshold defined in the ‘i’ button – in our example, we defined 20% for warehouse ‘Receiving’ and 0% for ‘Warehouse A2’).
After analyzing the inventory count summary, you can decide whether you want to ‘Create Adjustment Stock Movements’ or ‘Create Recount’. In case you create a recount, a new ‘Inventory Count’ will be created for everything that is not within the threshold for each warehouse.
After performing a recount task for one location, you’ll be able to see its result in the ‘Summary’ tab. Check the image below to see how the summary looks after we create a recount for ‘Wood’ in location ‘Receiving - DD02’ of 6 units.
If you create adjustment stock movements, the system will create the necessary adjustments for the inventory level to meet your inventory counts.
Also, in the summary screen, there’ll be a warning mentioning you have performed stock movements. You can only create adjustment stock movements once per Inventory Count.
In ‘Analytics’, you’ll be able to analyze:
‘Inventory Deviation’ graphic, showing deviation in units and percentage per product.
‘Absolute Deviation Percentage’ gauge.
‘Top 5 Deviations’ list.
You can also export several files about your Inventory Count:
‘Inventory Count’: exports data about the Inventory Count that was created.
‘Summary’: will export all data on your summary page to an excel file.
‘Missing Counts’: will export a file with the stock not counted for that Inventory Count.
‘Counted not Requested’: all locations/products that were counted in this Inventory Count but not requested at first.
‘Counted Existing on Another Location’: exports everything that we counted but that also exists in other locations not specified on the Inventory Count.
If after reading this article you still have some doubts, feel free to reach out to us through our Live-chat feature, or directly to your CSM.
Need help? Request a Prodsmart expert to contact you here.