I've tried to simplify my excel file to articulate my problem better.
I have a pack of 100 clear folders. I order a pack of it and enter 1 (pack) into incoming, BUT I give out let's say 20 clear folders and not 20 packs. Problem is that I don't know how to circumvent this problem. Another spreadsheet would probably help, but I don't know how to properly do this.
Bookmarks