This is my annual request to simplify our physical inventory. However, I just came up with a very simple solution.
Create a sheet identical to 12-2, except add one column showing quantity on hand and one column for entering the physical count. Then add or subtract as necessary and put the result in source or destination as required.
With this sheet we can then scan in the part# and enter the quantity and boop-de-boop, we done.

Comments

  • We send our inventory to excel and printout sheets by class number.