Cycle Counting

I have an Appsheet for Inventory Management. Where I can Receive new inventory in by scanning UPC and scanning it to a location. I have another table where I can Pick an item by scanning UPC. Another table for Putaway. And I have a table that shows all locations and qtys for every item. 

What I want to try to do now, is put in a cycle counting feature. Since I have been seeing some negative qtys for some items in locations and showing that I have an item in a location but not physically there. 

Is there a way I can add in a cycle counting feature that takes the table that shows all the locations and qtys and UPCs of an item and when you open the cycle counting tab, it will take you location by location to scan all inventory in locations and automatically make corrections? 

0 0 85
0 REPLIES 0
Top Labels in this Space