Logistic Warehouse Custom App Development

Requirement: Bridge Systems manufactures electronic products in contracted OEM factories. These products are packed in export cartons and shipped to our warehouse in The Netherlands. To track the packing of the final goods in the export cartons and construct a database with information on these export cartons and the products packed in each carton, a custom logistic registration software needs to be developed.

Resolution: The product package of each product is labeled with a unique bar code representing the serial number of the product inside. The software is loaded with a pre-build MS Access database containing all these serial numbers as well as information about the manufacturing batch. When completed products are packed in the export carton, a bar code reader is used to scan the product bar codes and retrieve the serial numbers. These serial numbers are linked to the carton and stored in the database. When the carton is completely packed with products, automatically the software prints out a label that is attached to the carton. This label contains information about the product batch, a code-128 bar code containing the number of the carton (including batch number), as well as a QR code containing all the serial numbers inside the export carton. After the whole production batch has been packed in export cartons, the Access file is sent back to Bridge Systems.