[Revised June 08]
Analyses stock to find the dead, or overstocked, items. Can be selected by various criteria and can exclude items of low value to avoid clogging the report with irrelevant items. Shows "months to sell' for overstock items, at current rate of sale. 'Infinite' months means incalculable, in excess of 99 months.
Commonly used to check for stock that is not performing and which might need to be put on special and discontinued. In the case of dispensary stock a list could be circulated to nearby pharmacies for assistance with disposal.
Overstocked Items Report displays those Stock Cards with SOH greater than the number of the month entered in the option multiplied by expected figure in the Stock Cards. This is because SOH is too large. Dead Items Report shows items with SOH greater than zero and no history sold in the last months depending on the number entered in options.
To report
1. From RxOne Start Menu, Reports. Or, from the Main Menu, Windows, Reports.
2. 'Overstock/dead stock report' .
3. Various choices and filters are available. Select those required, then Next to move on until Finished selecting.
To delete inactive cards
1. Go to Reports, Stock Reports, Dead Items report
2. Select Dead Items
3. Enter the number of months for something to be dead
4. Tick exclude items created after and select an appropriate date
5. Run the report
6. The SOH for all products on this list should be checked and changed as required.
a) To change SOH quickly export the list to Bulk Stock Edit
b) Select each item that the SOH changed
c) On the options tab select Check Set SOH to and enter the new SOH
d) Click on make changes to update
7. Go to Utilities, Stock Utilities, Bulk Stock Edit
8. Select "Stock not used within x Months"
9. Click OK to view
10. Check for any items that you don't want on the list select them and press the delete key to remove
11. Select make changes to all items
12. On the select option tab select Delete Stock Items
Discussion
‘Dead’ products are totally dead, as in no sales at all for at least the last 13 months. These are ones that the computer can do nothing about... just stopping buying won’t fix the problem no matter how long you wait. The money tied up here is already lost, so just dispose of them in anyway that gets a few bucks back. Sending a junior sales person off to a flea market in a nearby town (not your own town) with them, and letting her sell them for whatever she can get and splitting the money 50/50 with her, is usually the best solution. The important thing is to get them off the shelves to avoid them wasting the space and contaminating your image, and any money that comes in is a bonus.
‘Overstocked’ products are just overstocked but not dead, i.e. there are some sales and the machine will fix the overstock given long enough. But it is worth running your eye down the total money tied up, and ‘months to sell’ to see if there are any standouts that you'd like to do anything about. E.g. if there is $20 worth of stock of a particular item and it is going to take 55 months to clear at the current rate, who cares. But if there is $1000 worth of it in stock, then it is worth giving some of this item a push lest it die on the shelves before it is all gone. Stock in a pharmacy probably has a half life of around 18 months.
The best way to handle dead and big money overstocked items is to pick the 5 or 10 items with the greatest amount of money tied up, in different categories (not 2 x perfumes for example), and put a red spot or similar on them, and let staff know what they are suitable for and to push then. If you put the items on a board in the staff room, and can run a ‘red spot sales’ competition, you can move a lot of this stock. It is also necessary to mark them as ‘no reorder’ or the machine will think they've taken off and reorders when the stock gets low enough. Normally you don't want this.
Related topics