My name is Robin, and I work at an re-seller of electronical items in Norway. I have an idea that I would like to make. I'm just going to write what I want the sheet to do, and if someone could just give me a hint of what I need to read up upon, it would be much appreciated!
Everyday, we receive pallets with items from our major distributor. The same day the trailer with items arrive, we also get a packing-note. For every pallet we take apart, we need to find every item, and 'check' them of in the list. This is to ensure that we actually get what we are ordering, and to see what we have to report as missing.
This process it extremely time consuming, and is something that I would like to speed up. So here is my idea;
The first picture is what the packing note looks like.
Red circle - This is the number(name) of the box, or pallet the items is in.
Green circle - This is the name of the item that should be in the pallet or box.
Blue circle - This is the amount of items like this we are waiting to receive.
What I would like to make in Excel, is a program that automatically takes the PDF document (pre-uploaded to a certain folder by user), breaks the information into separate fields that is pre-configured by me. For example like in picture number 2.
And when all the items on the pallets have been checked, the Excel document should automatically generate a new printable document with a complete list of everything that is either Missing or Too Much, see example in picture number 3.
Lets say there is a barcode named "1000000000XXXXXABC" on a BOX. I take the barcode scanner, and scan it. I need the program to automatically jump to that BOX on the list, and start checking the items. When all items in the box is emptied, the user can press enter, and you are ready to scan a new BOX or Pallet.
The IT department will help me connect the document to our systems, so that the document knows what barcode belongs to which item - connecting programs to our databases is very strict, and will have to be done by our IT department.
38 freelancers are bidding on average $600 for this job
hello robin how are you? i made same thing for a canada based packing company ckdpack with some more features and its made in .net technolgy i can give you demo also lets discuss here himanshu