Priviet Social Sciences Journal

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

by Uya Asy Syuura Anandri ORCID , Ilyas Ilyas
Vol. 6 No. 1 (2026): January 2026

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.

References

  1. 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.
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. Booch, G., Rumbaugh, J., & Jacobson, I. (2007). The Unified Modeling Language User Guide. Addison-Wesley.
  12. Dobing, B., & Parsons, J. (2006). How UML is used. Communications of the ACM, 49(5), 109–113. https://doi.org/10.1145/1125944.1125949
  13. 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
  14. 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
  15. 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
  16. Ilyas, Putri, A. K., & Pahrianti, M. (2024). Sistem Pendukung Keputusan & Implementasi Metode (M. H. Maruapey, Ed.; 1st ed., Vol. 1). PENERBIT KBM INDONESIA.
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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.
  24. Sommerville, I. (2016). Software Engineering. Pearson.
  25. 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
  26. Whitten, J. L., & Bentley, L. D. (2007). Systems Analysis and Design Methods. McGraw-Hill.