There is a need to review the stock reconciliation/Stock take process in ERPNext.
In my opinion the current feature can only be used effectively by companies with few inventory items (maybe a few hundreds), once you have inventory in the thousands stock take using this tool becomes very difficult.
The following are the issues I see and my proposed solution
Procedure for keying in items when using the Stock reconciliation tool
In ERPNext you call up an item in the reconciliation tool and key in the total quantity physically counted, and you can only key in an item once in the item table
This can be problematic in a real life warehouse. It is possible to come across quantities of an item in various areas in the warehouse, it may not be convenient or even possible to put the items physically together and key in a single line of the item and quantity.
The ideal situation is for the system to allow users scan in the items as they are seen, it should be possible to key in many instances of an item, ERPNext should then be able to sum up the total quantities keyed in and compare with the system quantity to get the variance.
Number of Stock takers
At the moment only one person can do stock take in ERPNext, ideally multiple users should be able to open a ¨stock take sheet¨ in the system and when done the individual stock sheets should be summed up and the total used to compare with the system quantity.
What to do to Uncounted items
Uncounted items in this case are items that are not counted at all, the reason for this could be because we are not counting those set of item(s) during this stock take or because the items do not exist in the store anymore (zero quantity).
The system should give the user the option to either make quantity of uncounted items be zero or retain the system quantity of unseen items. This should be via a check box that comes up after summing up all stock take sheets and clicking save but before clicking submit
If this can be done the Stock reconciliation tool will become useable for companies with larger inventory counts
This is open to review by the community.