Web-Based Spare Parts Expenditure Recording Portal with Read-Only Pull from ERP Infor (PT CBI Case Study)

Alvito Kurnia Fahrio kurnia

doi:10.59934/jaiea.v5i2.1843

Authors

Alvito Kurnia Fahrio kurnia Universitas Singaperbangsa Karawang

DOI:

https://doi.org/10.59934/jaiea.v5i2.1843

Keywords:

warehouse management, spare part checkout, Infor ERP, read-only integration, Extreme Programming

Abstract

A companion portal for spare parts management was developed at the PT Century Batteries Indonesia (PT CBI) warehouse to address manual record keeping that is prone to discrepancies and difficult to trace. This article focuses on two key aspects: a checkout flow that validates expenditure amounts against Portal stock, and a reconciliation mechanism that pulls on-hand data from Infor's ERP read-only system to maintain ERP data integrity. The system was developed following the Extreme Programming (XP) methodology with short iterations and regular feedback from warehouse users. Black-box testing and UAT (User-to-User) testing demonstrated that the main flow functioned as expected; all assessed features were accepted with scores of 4.1–4.8. Consequently, discrepancies were detected more quickly and addressed through adjustments in Infor; the Portal then pulled back on-hand to ensure consistency. These results demonstrate that the "checkout in Portal → adjustment in Infor → pulled back on-hand (read-only)" pattern effectively reduces errors caused by manual recording while improving transaction traceability in the spare parts expenditure process in the warehouse environment.

Keywords : warehouse management; spare part checkout; Infor ERP; read-only integration; Extreme Programming;

Downloads

Download data is not yet available.

References

A. Herdiansah, R.I. Borman, and S. Maylinda, “A Laravel Web Framework-Based Laminating Process Quality Control Monitoring and Reporting Information System,” Jurnal Tekno Kompak, vol. 15, no. 2, pp. 13–24, Aug. 2021, doi: 10.33365/jtk.v15i2.1091.

N. DeHoratius and A. Raman, “Inventory record inaccuracy: An empirical analysis,” Management Science, vol. 54, no. 4, pp. 627–641, 2008, doi: 10.1287/mnsc.1070.0789.

Y. Zhang and F. Pan, “Design and Implementation of a New Intelligent Warehouse Management System Based on MySQL Database Technology,” Informatica, vol. 46, no. 3, pp. 355–364, 2022, doi: 10.31449/inf.v46i3.3968.

S. Chen, W. Meng, W. Xu, Z. Liu, J. Liu, and F. Wu, “A Warehouse Management System with UAV Based on Digital Twin and 5GTechnologies,” in 2020 7th International Conference on Information, Cybernetics, and Computational Social Systems, ICCSS 2020, 2020, pp. 864–869. doi: 10.1109/ICCCS52145.2020.9336832.

AA Ali, “IoT Based Warehouse Management System Leveraging On RFID and Cloud Platform Technologies,” inATNT 2024, 2024. doi: 10.1109/ATNT61688.2024.10719252.

S. Gawande, R. Agrawal, R. Ingole, P. Akotkar, and AK Shahade, “Review of Warehouse Management Systems,”Int. J. Adv. Res. Sci. Commun. Technol., pp. 53–56, 2023, doi: 10.48175/ijarsct-9541.

K. Beck and C. Andres, Extreme Programming Explained: Embrace Change, 2nd ed. Boston, MA, USA: Addison-Wesley, 2004. ISBN 978-0-321-27865-4.

A. Shrivastava, I. Jaggi, N. Katoch, D. Gupta, and S. Gupta, “A Systematic Review on Extreme Programming,”J. Phys. Conf. Ser., vol. 1969, no. 1, 2021, doi: 10.1088/1742-6596/1969/1/012046.

HR, I.R., T. Alam S., and H., “Optimizing Warehouse Operations in Bangladesh: Leveraging IoT and Cloud Migration for Enhanced Security and Efficiency,” inFiCloud 2024, 2024. doi: 10.1109/FiCloud62933.2024.00061.

KR Elmasri and SB Navathe, Fundamentals of Database Systems, 7th ed. Pearson, 2016.

G. Kurniawan, F. Adnan, JA Putra, U. Jember, and P. Correspondence, “USER INTERFACE AND USER EXPERIENCE DESIGN OF BATIK CLOTH E-COMMERCE APPLICATION IN REZTIS BATIK UMKM USING DESIGN THINKING APPROACH,” vol. 10, no. 3, pp. 551–560, 2023, doi: 10.25126/jtiik.2023106733.

JB Ardika and N. Ratama, “Implementation of QR Code Using Google Application Programming Interface (API) in Building a Warehouse Information System with Web-Based Extreme Programming Method (Case Study: PT Bell Flavors & Fragrances Indonesia),”J. Technol. Sis. Inf. And App., vol. 5, no. 1, p. 47, 2022, doi: 10.32493/jtsi.v5i1.16165.

R. Andrian Ibrahim and G. Saktian Laksito, "Optimization of White Box Testing by Utilizing Branching and Repeating Structures in Java Programs Using Base Path,"Int. J. Math. Stat. Comput., vol. 2, no. 2, pp. 85–89, 2024.