Analysis and design of a web-based integrated inventory information system using the PIECES framework: A case study of PT. Asia Persada Nusantara

Uya Asy Syuura  Anandri; Ilyas Ilyas

doi:10.55942/pssj.v6i1.1514

Authors

Uya Asy Syuura Anandri Universitas Islam Indragiri https://orcid.org/0009-0000-2385-7400
Ilyas Ilyas Universitas Islam Indragiri

DOI:

https://doi.org/10.55942/pssj.v6i1.1514

Keywords:

Inventory Information System, PIECES, Stock Reservation, UML, ERP, Audit Trail, SDLC Prototype Model

Abstract

This study aims to analyze and develop a systematic or analytical web-based integrated inventory information system for PT. Asia Persada Nusantara, analytical used by PIECES framework. Based on a case-study approach, both with the SDLC methodology with a prototyping model, the requisite data were acquired by a complete review of documents and by conducting interviews with stakeholders. The Object Oriented Tool Development was modeled using the Unified Modeling Language (UML) to define the functional and non-functional requirements. The resultant design captures role-based authentication, stock reservation systems, processing of goods receipts including the processing of delivery notes, keeping of discrepancies, payment and reconciliation systems, and role-based audit trails as a way of enforcing operational control. The shared schema of the relational database using ERD supports the atomic transactions of the key turbines (reservation, transaction creation, commitment) and helps to reduce the risk of overselling and information inconsistency. It is proposed that a staged implementation plan (Minimum Viable Product) should be used with an initial focus on real-time inventory and reservation logic to achieve more immediate operations payoffs. The indicators of future improvement in stock accuracy and process efficiency are stated by impact assessment, whereas the real benefits depend on piloting testing, initial data quality, and organizational readiness. This research provides a technical map that is suitable for developing prototypes and validating them empirically.

Author Biographies

Uya Asy Syuura Anandri, Universitas Islam Indragiri

Uya Asy Syuura Anandri is an under graduate student undertaking an Information Systems Program at Universitas Islam Indragiri. Expertise areas include database design, such as the development of Entity Relationship Diagrams (ERD), descriptive statistics analysis and implementation of information systems in microenterprises, small- and medium-sized enterprises (UMKM) and Implementation Artificial Intelligence (AI) and Business Intelligence. Contributions to research include case studies and practice reports on the local UMKM business models in Tembilahan, and the creation and deployment of information systems, based on ERD, to small enterprises. Data on the audit and deployment of information-systems in community-related settings is found in publications and conference proceedings. Uya is still actively involved in campus research work and other community service activities with a vision of changing the academic findings into local economic empowerment.

Ilyas Ilyas, Universitas Islam Indragiri

Ilyas is Lecturer in the Information System, Faculty Engineering and Computer Science, Islamic University of Indragiri (UNISI). He has a long record of research and publication in information systems and computing, including topics such as decision support systems, web-based information systems, and system analysis applied to organizational and community contexts. Ilyas has published multiple articles in national scientific journals and has been actively involved in research related to information system design and implementation.

References

Alfassa, A. I., Sudrajat, S., & Marwasta, D. (2023). Development of official statistics models for analysis of population sectoral data in Indragiri Hilir Regency. E3S Web of Conferences, 468, 06007.

Alles, M. G., Kogan, A., & Vasarhelyi, M. A. (2018). Putting continuous auditing theory into practice: Lessons from two pilot implementations. Journal of Information Systems, 32(1), 53–73. https://doi.org/10.2308/isys-51763

Anandri, U. A. S. (2025). Business plan and financial feasibility study of “Prata Bubuhan” breakfast UMKM stall in Indragiri Hilir Regency. Priviet Social Sciences Journal, 5(11), 388–399. https://doi.org/10.55942/pssj.v5i11.746

Anandri, U. A. S., & Arkan, M. N. (2025). Pemanfaatan Power BI Untuk Visualisasi Data Penjualan Produk Pada Perusahaan Percetakan. Jurnal Sistem Informasi (TEKNOFILE), 3(10), 716–721. https://jurnal.nawansa.com/index.php/teknofile/article/view/562

Anandri, U. A. S., Arkan, Mhd. N., Abdullah, & Ilyas. (2025). Implementasi dan Pengembangan Aplikasi Point Of Sales Berbasis Website pada UMKM RitelShop Tembilahan. Jurnal Pengabdian Masyarakat (ABDIMAS), 3(7), 304–314. https://jurnal.nawansa.com/index.php/abdimas/article/view/751

Anandri, U. A. S., Nabil Arkan, M., Risky, M., Elma Sudiarti, Y., Isya Alfassa, A., & Rachman, A. (2025). Analisis Statistika Deskriptif Data Mahasiswa Sistem Informasi B 2024 Universitas Islam Indragiri. TEKNOFILE: Jurnal Sistem Informasi, 3(6), 422–432. https://jurnal.nawansa.com/index.php/teknofile/article/view/619

Anandri, U. A. S., & Prasetyo, D. Y. (2025). Analisis Model Bisnis Inovatif Kue Pancung Keliling Untuk Pemberdayaan UMKM Tembilahan. ABDIMAS: Jurnal Pengabdian Masyarakat, 3(6), 204–212. https://jurnal.nawansa.com/index.php/abdimas/article/view/629

Arkan, Mhd. N., & Anandri, U. A. S. (2025). Perancangan Entity-Relationship Diagram (ERD) Menggunakan SQL Server Database Pada Platform Tautanhalaman Web Lynk.Id. TEKNOFILE: Jurnal Sistem Informasi, 4(3), 221–227. https://jurnal.nawansa.com/index.php/teknofile/article/view/411

Aswintama, P., Haryanto, E., & Setyawan, R. A. (2025). Implementation of role-based access control, multi tenancy and audit logging in a single sign-on system. Jurnal Mandiri IT, 14(1), 119–128. https://doi.org/10.35335/mandiri.v14i1.441

Atieh, A. M., Kaylani, H., Al-Abdallat, Y., Qaderi, A., Al-Tamimi, O., & Al-Faouri, N. (2016). Performance improvement of inventory management system processes by an automated warehouse management system. Procedia CIRP, 41, 568–572. https://doi.org/10.1016/j.procir.2015.12.122

Booch, G., Rumbaugh, J., & Jacobson, I. (2007). The Unified Modeling Language User Guide. Addison-Wesley.

Dobing, B., & Parsons, J. (2006). How UML is used. Communications of the ACM, 49(5), 109–113. https://doi.org/10.1145/1125944.1125949

Gunasekaran, A., Subramanian, N., & Rahman, S. (2017). Supply chain resilience: Role of complexities and strategies. International Journal of Production Research, 55(22), 6809–6819. https://doi.org/10.1080/00207543.2017.1362936

Hendricks, K. B., Singhal, V. R., & Stratman, J. K. (2007). The impact of enterprise systems on corporate performance. Journal of Operations Management, 25(1), 65–82. https://doi.org/10.1016/j.jom.2006.05.002

Huang, Z., Kim, S. H., & Sadjadi, S. J. (2019). Order allocation and inventory reservation in multi-channel distribution systems. International Journal of Production Economics, 216, 47–60. https://doi.org/10.1016/j.ijpe.2019.04.012

Ilyas, Putri, A. K., & Pahrianti, M. (2024). Sistem Pendukung Keputusan & Implementasi Metode (M. H. Maruapey, Ed.; 1st ed., Vol. 1). PENERBIT KBM INDONESIA.

Kembro, J., Selviaridis, K., & Naslund, D. (2017). Theoretical perspectives on information sharing in supply chains. Supply Chain Management: An International Journal, 22(5), 401–417. https://doi.org/10.1108/SCM-01-2017-0006

Lopulalan, P. M., Suhartono, R. H. S., Bakri, B., Karim, A., & Anandri, U. A. S. (2025). Reconstructing a Sustainable Quality Management System in Higher Education through an Integrative Approach between Academic Audits and Organizational Reflection. Journal of Educational Analytics, 4(3), 675–690. https://doi.org/10.55927/jeda.v4i3.362

Ouyang, F., & Jiao, P. (2021). Artificial intelligence in education: The three paradigms. Computers and Education: Artificial Intelligence. https://doi.org/10.1016/j.caeai.2021.100020

Prasetyo, D. Y., Sudiarti, Y. E., Anandri, U. A. S., Risky, M., & Ihwan, K. (2025). Website E-Commerce Pada Toko Oska Cake. JUTI UNISI, 9(2), 31–40. https://doi.org/10.32520/juti.v9i2.4834

Rai, A., Patnayakuni, R., & Patnayakuni, N. (2002). Technology investment and business performance. Information Systems Research, 13(1), 3–23. https://doi.org/10.1287/isre.13.1.3.97

Ramadhan, F. A., & Mansur, A. (2024). Bibliometric Analysis and Data Visualization: Business Intelligence in Digitalization of Supply Chain Management in Healthcare Sector. Prozima: Productivity, Optimization, and Manufacturing System, 8(2), 115–131. https://doi.org/10.21070/prozima.v8i2.1728

Rianto, B., Jalil, M., Sandi Rais, M., & Bindas, A. (2023). The Development Of Enterprise Architecture Business CRM At Pt. Capella Dinamik Nusantara With EAP Methodology. Jurnal Perangkat Lunak, 5(2), 65–73.

Sommerville, I. (2016). Software Engineering. Pearson.

Vasarhelyi, M. A., Kogan, A., & Tuttle, B. M. (2015). Big data in accounting. Accounting Horizons, 29(2), 381–396. https://doi.org/10.2308/acch-51068

Whitten, J. L., & Bentley, L. D. (2007). Systems Analysis and Design Methods. McGraw-Hill.