2. Add a "Repairs" location and user. But for this location, instead of recording the time, I want it to record how many times it has been scanned. On the locations list it will be after Hardware but before Final QC. The user just scans the QR code and that is it, no need to confirm like the other locations.
3. Add a "Container" Location. When an item is scanned at this location it will record it on the document list but also will take the items information and put it onto a new document titled "(Date) Container Packing List" All items scanned on that day from that location will appear onto this one document that can be exported to excel. It is the final location.
4. Add another user called "Management" but this is not a location. When a QR code is scanned it displays the items information as well as the time it was in each department. For example: Machining=Time from Laminating scan time, to Component store in. Component Store=store in to store out time. Assembly=store out to Assembly. Painting = Assembly to Painting. Hardware=Painting to Hardware scan time. Repairs/QC=Hardware to QC. CSQC=QC to Packing. Warehouse=Packing to Container scan times. So it is basically the same report as the weekly report but it is only for this one item. This location doesn't record anything, its for management to be able to walk through the factory and do spot checks to see how long items are taking in each department.