Trying to make our stock takes more user friendly and efficient by moving away from pens and paper and using a small webapp which update the main sheet on the fly to allow the inventory manager to see live results and send teams back to count locations where there may be a miscount or gap in quantities. Please my budget is not massive and i have found a way to use google sheets however I would rather have logins for each team and popup messages from the admin to send people back to recount. Please see the attachment of main sheets and count sheets.
Sku List - 6 Columns - ProductName, Description,ProductType,PalletQty,CaseQty,SingleQty
MainCountSheet - 14 columns - Location,SKU,WMS
Qty per Loc.,1st Count,2nd Count,3rd Count,Final Qty,Discrep,Remarks,Total WMS per SKU,Total Phys per SKU,WMS diff,Item Master,Product Type
Admin Feature -
Need to have an admin section where you determine how many teams there are and assign a group of locations to the teams.
Admin sheet will see the database update every 30seconds to see the counts being updated. If anything doesn't match what the main warehouse system shows as in stock then the admin will mark the count as problematic and a notification will be sent to the team who counted to recheck at the end of their workflow.
Login as Team1 and you will see all the locations that you have been assigned to count.
Count Sheet should show the following:
Location,SKU,Description,QtyPallets,QtyCases,QtySingles,Total(Sum of QtyPallets x SKUList_PalletQty,Sum of QtyCases x SKUList_CaseQTY,Sum of QtySingles x SKUList_SingleQty) = Total counted.