Better system for a full stock take of all items (regardless of stock level)
In our business, when a department does a stock take, it's important to count ALL of the items that are listed in the system under that category - regardless of their current stock count in the system.
The stocktake module in Dear works well if you want to count all of the items in a chosen category that have a positive value (non-zero stock on hand), but isn't the point of doing a stock take to also take into account the products that the system shows as zero? If you're trying to also count the items that the system identifies as zero stock on hand, you're in for a bit of a runaround.
The zero SOH section doesn't generate a list of what to count like the non-zero SOH section does, so you have to find that list yourself and (once counted) import the data that Dear requires (the challenge here being unit cost)
You'd think that somewhere in the system you could easily find one report that has all of the following:
- A full list of all the products
- Category field
- Quantity on hand
- Unit cost (or average cost)
If you could export such a report, you could use that to count stock, then split it into zero and non-zero products and import to each section. Unfortunately, I have yet to find a single report that achieves this. Copying unit cost data and pasting into another spreadsheet before uploading a CSV into the system is asking for trouble, as users could easily do this incorrectly and import the wrong information.
- First prize - Allow users to do stock takes for particular categories that pulls all the products in the system, irrespective of quantity on hand
- Improve the zero SOH section to automatically pull the items that are in the chosen category having a quantity of zero (like the non-zero SOH section works), and bringing in the average costs as well, if they exist in the system.
- Improve the "export all products" report for the zero SOH section so that it is filtered by the same categories as the non-zero SOH section (or has a category field) and shows unit costs. Currently, if the SOH in this report is 0 then the cost will not show, and the unit cost is the data we need after all
- At the very least, offer a report that we can use to get a full list of products, their category, their QTY and their unit cost (or average cost)
5 people like this idea