Desktop Application for Traceability System on The Printed Circuit Board (PCB) Storage Process

DOI: https://doi.org/10.52158/jacost.v5i1.670
I will put the dimension here
Keywords: traceability systems, barcode, product tracking, PCB, Printed Circuit Board

Abstract

This paper discusses the development of desktop applications for traceability systems. The application was developed to facilitate data recording and tracking in an electronics manufacturing company's storage process of Printed Circuit Board (PCB) products. The application is developed using the Visual Basic language and Microsoft Excel databases. Additionally, the application is integrated with a barcode scanner to simplify the data entry process from PCBs and employee ID cards. Through the trial process conducted on the developed application, it has generally functioned in accordance with the development goals. Program control validation has been tested through several application access attempts from users registered as operators and administrators. The application has successfully recorded data from inbound and outbound processes, demonstrating storage and tracking functionality. Furthermore, the application has displayed the actual status data of the PCBs present in the warehouse. In terms of user satisfaction, seven users stated that this application was effective and efficient compared to the manual data recording process previously used by the company. This result was obtained from a questionnaire after the application was implemented in the company warehouse.

Downloads

Download data is not yet available.

References

Y. Chen et al., "An Optimization Model for Process Traceability in Case-Based Reasoning Based on Ontology and the Genetic Algorithm," IEEE Sens J, vol. 21, no. 22, pp. 25123–25132, Nov. 2021.

M. Jamkhedkar, P. Sanghavi, P. Gajera, Prof. V. A. Mishra, and Prof. K. H. Wanjale, "Technologies for Traceability in Inventory Management System," Journal of University of Shanghai for Science and Technology, vol. 23, no. 06, pp. 588–594, Jun. 2021.

B. A. Kresna, K. B. Seminar, and M. Marimin, "Developing a Traceability System for Tuna Supply Chains," International Journal of Supply Chain Management, vol. 6, no. 3, pp. 52–62, 2017. Accessed: Sep. 20, 2023. [Online]. Available: ../1584.html

L. Yu, D. Zhang, N. Peng, and X. Liang, "Research on the application of binary-like coding and Hough circle detection technology in PCB traceability system," J Ambient Intell Humaniz Comput, vol. 1, pp. 1–11, Feb. 2021.

B. Wigger et al., "Label-/tag-free traceability of electronic PCB in SMD assembly based on individual inherent surface patterns," The International Journal of Advanced Manufacturing Technology, vol. 98, no. 9–12, pp. 3081–3090, Oct. 2018.

S. T and S. K., "Introduction on Data Analysis and Graphical Representation of Data," International Research Journal on Advanced Science Hub, vol. 2, no. Special Issue ICIES 9S, pp. 74–79, Nov. 2020.

A. R. Ochs et al., "Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering," Journal of Visualized Experiments, vol. 2019, no. 153, p. e60038, Nov. 2019.

N. I. Bakti, M. Williamson, R. Sehjal, and M. Thilagarajah, "The use of Microsoft Excel as an electronic database for handover and coordination of patients with trauma in a District General Hospital," BMJ Innov, vol. 3, no. 3, pp. 130–136, Jul. 2017.

E. Y. Setiawan, “Automasi Stock Opname BMN Melalui Pemindaian QR Code Menggunakan Aplikasi Visual Basic for Application,” Jurnal Pari, vol. 5, no. 2, pp. 125–137, 2020.

F. Ramadhan, H. S. Rukmi, A. Imran, C. Nugraha, and R. Ferdiansyah, “Software Design using Visual Basic for Application and Microsoft Excel Programming for Students,” REKA ELKOMIKA: Jurnal Pengabdian kepada Masyarakat, vol. 1, no. 2, pp. 86–97, Dec. 2020.

Published
2024-02-03
How to Cite
[1]
Alvin and E. Rudiawan Jamzuri, “Desktop Application for Traceability System on The Printed Circuit Board (PCB) Storage Process”, J. Appl. Comput. Sci. Technol., vol. 5, no. 1, pp. 9 - 15, Feb. 2024.
Section
Articles
Bookmark and Share