Can be used for small format retail stores. Instead of finding stock codes manually from excel sheet, use this python interface for scanning in code to find the instance or instances in multiple columns.
Requirements: Python 3.6 and above, Tkinter, Openpyxl
Simplistic interface!
Usage --
Open Stocktake.py Select file for stocktake Select columns to be searched Set column of quatity total to match with found Set 3 column for Found,Excess and Short Start scanning.
Found will be updated with quantity found. Will notify if excess is found Row will be highlighted for found stock. Save you stocktake and open excel file to have look.
Currently supporting only '.xlsx' excel format