Per Part Traceability

A leading supplier of automotive bumpers received a mandate to track production data and to apply printed labels to their bumpers with a serial number to be referenced later in case of a warranty return issue. My task was to read the data from the production computer, generate a serial number, automatically print a label on the selected label printer, and store the production data with serial number into the central SQL database. In addition, I had to add the capability to print a report and to re-print a sticker based on a serial number input.

Since the beginning of this project, the client has requested a second system at another plant.