Design of a Web-Based Information System for Tracking Oil Palm Fruit Invoices

Indra; Syarif Subandi

Authors

Indra Darmajaya University Author
Syarif Subandi Author

Keywords:

Information System, Invoice Tracking, Oil Palm, Web-based

Abstract

Financial administration services—specifically regarding the processing of invoices for raw oil palm fresh fruit bunches (FFB) purchased from third parties—constitute a vital element of palm oil industry operations. At PT HPI-Agro, the process of tracking invoices from external suppliers (such as cooperatives, CVs, and limited liability companies) is currently performed manually using Microsoft Word, Microsoft Excel, and conventional bookkeeping, lacking an integrated monitoring system. This situation leads to inefficient inter-departmental coordination, resulting in payment delays of 10 to 14 working days. This study aims to design a web-based invoice tracking information system to accelerate administrative workflows and provide real-time updates on payment status. The system was designed using the Systems Development Life Cycle (SDLC) methodology, with analysis conducted via Unified Modeling Language (UML) modeling and Logical Record Structure (LRS), utilizing MySQL as the database server. Functionality testing and satisfaction surveys indicate that the information system is highly viable for implementation, achieving a respondent acceptance rate of 96% or higher. Implementation of this system has successfully eliminated manual bureaucratic processes and enhanced transparency regarding invoice status at PT HPI-Agro.

References

1. Al-Ghifari, M. F., & Azizah, F. N. (2022, November). Development of application for entity-relationship diagram conversion to logical schema of NoSQL column oriented. In 2022 International Conference on Data and Software Engineering (ICoDSE) (pp. 30-35). IEEE.

2. Alruwais, N. M., & Zakariah, M. (2024). Student recognition and activity monitoring in e-classes using deep learning in higher education. IEEE access, 12, 66110-66128.

3. Aithal, P. S. (2023). How to create business value through technological innovations using ICCT underlying technologies. International Journal of Applied Engineering and Management Letters (IJAEML), 7(2), 232-292.

4. Azizi, S., Hamzah, S. I., & Al Farisi, S. (2025). Challenges in Marriage Document Verification and Their Implications for Marriage Validity: An Empirical Study of KUA Tambaksari, Surabaya. SMART: Journal of Sharia, Traditon, and Modernity, 197-218.

5. Bistarelli, S., Ceccarelli, M., Luchini, C., Mercanti, I., & Santini, F. (2024, January). A Preliminary Study on the Creation of a Covert Channel with HTTP Headers. In ITASEC.

6. Chen, X., Liu, Q., Mallet, F., Li, Q., Cai, S., & Jin, Z. (2022). Formally verifying consistency of sequence diagrams for safety critical systems. Science of computer programming, 216, 102777.

7. Cuarez, R., Bongcawil, A., Tubo, C., & Guiritan, D. J. (2025, November). Document Routing and Tracking System using Workflow Management Algorithm. In 2025 International Conference on Emerging Technologies and Innovation for Sustainability (EmergIN) (pp. 36-41). IEEE.

8. Dagher, J., & Fayad, L. (2024). Business Process Reengineering: A Crucial approach for enhanced organizational sustainability. In Navigating the Intersection of Business, Sustainability and Technology (pp. 25-59). Singapore: Springer Nature Singapore.

9. Dathan, B., & Ramnath, S. (2025). Modeling Object-Oriented Systems. In Object-Oriented Analysis, Design and Implementation: An Integrated Approach (pp. 93-119). Cham: Springer Nature Switzerland.

10. Gandi, R., Suseela, G., Singh, S., Kumar, V. K. A., & Sudhakara, M. (2025). Data-driven rehabilitation using machine learning approaches for adaptive recovery and treatment. In Predictive Algorithms for Rehabilitation and Assistive Systems (pp. 31-66). IGI Global Scientific Publishing.

11. Hasan, R., & Akter, S. (2022). Information system-based decision support tools: A systematic review of strategic applications in service-oriented enterprises. Review of Applied Science and Technology, 1(04), 26-65.

12. Karnia, D., & Purbasari, Y. (2025). Design of public service information system. International Journal of Information Systems and Technology, 1(02), 52-62.

13. Keet, C. M. (2023). Conceptual Data Models. In The What and How of Modelling Information and Knowledge: From Mind Maps to Ontologies (pp. 49-79). Cham: Springer Nature Switzerland.

14. Maaitah, T. (2023). The Role of Business Intelligence Tools in the Decision Making Process and Performance. Journal of intelligence studies in business, 13(1), 43.

15. Mohamed, A., & Ismail, I. (2022). A performance comparative on most popular internet web browsers. Procedia Computer Science, 215, 589-597.

16. Molla, M. M. I., Ahmad, J., & Kadir, W. M. N. W. (2024). A comparison of transforming the user stories and functional requirements into UML use case diagram. International Journal of Innovative Computing, 14(1), 29-36.

17. Perdiansyah., C. (2025). Design Point of Sales and Inventory System at Cafe Youth Creatino. International Journal of Information Systems and Technology, 1(05. 284–295.

18. Ramires, M., Machado, C., Gomes, A., Carvalho, P., & Rito Lima, S. (2022, April). Is web browsing secure? Assessment from an end-user perspective. In World Conference on Information Systems and Technologies (pp. 115-125). Cham: Springer International Publishing.

19. Shehzadi, N., Ferzund, J., Fatima, R., & Riaz, A. (2025). Automatic complexity analysis of UML class diagrams using visual question answering (VQA) techniques. Software, 4(4), 22.

20. Thomas, A. (2024). Digitally transforming the organization through knowledge management: a socio-technical system (STS) perspective. European Journal of Innovation Management, 27(9), 437-460.