(Universitas Pembangunan Jaya, Tangerang Selatan, Indonesia)
(2) * Ida Nurhaida
(Universitas Pembangunan Jaya, Tangerang Selatan, Indonesia)(3) Irma Paramita Sofia
(Universitas Pembangunan Jaya, Tangerang Selatan, Indonesia)(4) Fitriyah Nurhidayah
(Universitas Pembangunan Jaya, Tangerang Selatan, Indonesia)*Corresponding author
AbstractEnterprise Resource Planning (ERP) applications such as Odoo generally do not have predictive analytics capabilities for time series data and are limited to recording historical financial data. The limitations of ERP systems make companies dependent on traditional statistical models such as ARIMA, which often fail to capture complex non-linear patterns in financial data. However, the ability to accurately predict cash flow is crucial for strategic financial management in companies. This study aims to develop and evaluate a predictive model using a Long Short-Term Memory (LSTM) approach that is accurate and integrated into Odoo ERP. The research method includes designing a microservices architecture with FastAPI as a bridge between Odoo ERP, the predictive model, and prediction graph visualization. The LSTM model is evaluated by comparing it with the ARIMA model using 3,740 Daily cash flow data, with evaluation metrics MAE, MAPE, R2. System testing will use Black Box Testing and White Box Testing. The research results show that LSTM significantly outperforms the ARIMA model with an R2 evaluation of 0.8801 and an accuracy of 96.62%. The system testing results also yielded positive outcomes as the integration architecture runs stably and functionally. This research contributes by providing an Odoo ERP system that has predictive analysis capabilities with interactive graphical visualizations through Grafana, which helps companies make decisions effectively.
KeywordsCash Flow; LSTM; ERP; Financial Prediction; AI Integratin; Odoo
|
DOIhttps://doi.org/10.33122/ejeset.v6i2.1235 |
Article metricsAbstract views : 24 | PDF views : 7 |
Cite |
Full Text Download
|
References
Al-Selwi, S. M., Hassan, M. F., Abdulkadir, S. J., & Muneer, A. (2023). LSTM Inefficiency in Long-Term Dependencies Regression Problems. Journal of Advanced Research in Applied Sciences and Engineering Technology, 30(3), 16–31. https://doi.org/10.37934/araset.30.3.1631
Charankar, N., & Kumar Pandiya, D. (2023). Microservices and API Deployment Optimization using AI. International Journal on Recent and Innovation Trends in Computing and Communication, October. http://www.ijritcc.org
Chen, C., Zhang, Q., Kashani, M. H., Jun, C., Bateni, S. M., Band, S. S., Dash, S. S., & Chau, K. W. (2022). Forecast of rainfall distribution based on fixed sliding window long short-term memory. Engineering Applications of Computational Fluid Mechanics, 16(1), 248–261. https://doi.org/10.1080/19942060.2021.2009374
Chicco, D., Warrens, M. J., & Jurman, G. (2021). The coefficient of determination R-squared is more informative than SMAPE, MAE, MAPE, MSE and RMSE in regression analysis evaluation. PeerJ Computer Science, 7, 1–24. https://doi.org/10.7717/PEERJ-CS.623
Firdausha Litaay, A. Y., Rahmi, I., & Yusna, Y. (2024). Implementation of Enterprise Resource Planning (Erp) Odoo on the Financial Statements of Dhuafa Schools. Simposium Nasional Akuntansi Vokasi (SNAV) XII, 520–535.
Karaaslan, O. (2023). Analysis Based on the Importance of Cash Flow Management in Business Management. Journal of Humanities, Arts and Social Science, 7(9), 1879–1883. https://doi.org/10.26855/jhass.2023.09.033
Kim, Y. S., Kim, M. K., Fu, N., Liu, J., Wang, J., & Srebric, J. (2025). Investigating the impact of data normalization methods on predicting electricity consumption in a building using different artificial neural network models. Sustainable Cities and Society, 118(October 2023), 105570. https://doi.org/10.1016/j.scs.2024.105570
Kong, Y., Wang, Z., Nie, Y., Zhou, T., Zohren, S., Liang, Y., Sun, P., & Wen, Q. (2024). Unlocking the Power of LSTM for Long Term Time Series Forecasting. 11968–11976. http://arxiv.org/abs/2408.10006
Kotios, D., Makridis, G., Fatouros, G., & Kyriazis, D. (2022). Deep learning enhancing banking services: a hybrid transaction classification and cash flow prediction approach. Journal of Big Data, 9(1). https://doi.org/10.1186/s40537-022-00651-x
Lim, B., & Zohren, S. (2021). Time-series forecasting with deep learning: A survey. Philosophical Transactions of the Royal Society A: Mathematical, Physical and Engineering Sciences, 379(2194). https://doi.org/10.1098/rsta.2020.0209
Lindemann, B., Müller, T., Vietz, H., Jazdi, N., & Weyrich, M. (2021). A survey on long short-term memory networks for time series prediction. Procedia CIRP, 99(March), 650–655. https://doi.org/10.1016/j.procir.2021.03.088
Muhammad, R., & Nurhaida, I. (2025). Penerapan LSTM Dalam Deep Learning Untuk Prediksi Harga Kopi Jangka Pendek Dan Jangka Panjang. JIPI (Jurnal Ilmiah Penelitian Dan Pembelajaran Informatika), 10(1), 554–564. https://doi.org/10.29100/jipi.v10i1.5904
Papaioannou, P. G., Talmon, R., Kevrekidis, I. G., & Siettos, C. (2022). Time-series forecasting using manifold learning, radial basis function interpolation, and geometric harmonics. Chaos, 32(8), 21–25. https://doi.org/10.1063/5.0094887
Putu, N., Ginanti, V., Wiedyaningsih, C., & Yuniarti, E. (2024). Jurnal Farmasi Sains dan Praktis Comparison Of Forecasting Drug Needs Using Time Series Methods In Healthcare Facilities : A. 10(2), 156–165.
Rahman, M. A., Bhowmik, J., Ahamed, M. S., & Rahman, R. (2024). Opportunities and Challenges in Data Analysis Using Sap: a Review of Erp Software Performance. Global Mainstream Journal, 1(4), 50–67. https://doi.org/10.62304/ijmisds.v1i04.192
Rahman, M., & David, J. (2022). Advantages and disadvantages of literature review. Howandwhat, 21(2). https://www.howandwhat.net/advantages-disadvantages-literature-review/
Salsabila, A., Anggraini Puspita Sari, & Achmad Junaidi. (2025). Predicting CO levels using LSTM and Rolling-Features. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 4(3), 2178–2183. https://doi.org/10.59934/jaiea.v4i3.1126
Sarathi, P., Pedda, R., & Jangam, S. K. (2022). Predictive Analytics in Oracle Fusion Cloud ERP : Leveraging Historical Data for Business Forecasting. 3(4), 86–95.
Sari. (2017). Analisis kebangkrutan Lehman Brothers dengan menggunakan metode Z-Score Altman dan model logit (Skripsi, Universitas Gadjah Mada). UGM Repository. [Universitas Gajah Mada]. https://etd.repository.ugm.ac.id/penelitian/detail/143102
Shahriar, M. S., Hasan, K. B. M. R., Hossain, T., Beg, T. H., Islam, K. M. A., & Zayed, N. M. (2021). Financial Decision Making and Forecasting Techniques on Project Evaluation: a Planning, Development and Entrepreneurial Perspective. Academy of Entrepreneurship Journal, 27(4), 1–7.
Singh, V. (2025). AI-Driven ERP Evolution: Enhancing Supply Chain Resilience with Neural Networks and Predictive LSTM Models. European Journal of Advances in Engineering and Technology, 12(2), 47–52.
Sirisha, U. M., Belavagi, M. C., & Attigeri, G. (2022). Profit Prediction Using ARIMA, SARIMA and LSTM Models in Time Series Forecasting: A Comparison. IEEE Access, 10(November), 124715–124727. https://doi.org/10.1109/ACCESS.2022.3224938
Skogsvik, K., Skogsvik, S., & Andersson, H. (2023). Bankruptcy Risk in Discounted Cash Flow Equity Valuation. Journal of Risk and Financial Management, 16(11). https://doi.org/10.3390/jrfm16110476
Sofian, H., Yunus, N. A. M., & Ahmad, R. (2022). Systematic Mapping: Artificial Intelligence Techniques in Software Engineering. IEEE Access, 10, 51021–51040. https://doi.org/10.1109/ACCESS.2022.3174115
Sukaina Izzat, & Nada N. Saleem. (2023). Software Testing Techniques and Tools: A Review. Journal of Education and Science, 32(2), 30–44. https://doi.org/10.33899/edusj.2023.137480.1305
Surakhi, O., Zaidan, M. A., Fung, P. L., Motlagh, N. H., Serhan, S., Alkhanafseh, M., Ghoniem, R. M., & Hussein, T. (2021). Time-lag selection for time-series forecasting using neural network and heuristic algorithm. Electronics (Switzerland), 10(20), 1–22. https://doi.org/10.3390/electronics10202518
Tandean, V. A., Kusnadi, E., Anantadjaya, S. P., & Nawangwulan, I. M. (2024). Impact of Cash Flow Management on the Sustainability of Indonesian MSMEs. Community Development Journal: Jurnal Pengabdian Masyarakat, 5(4), 8237–8241. https://repository.ipmi.ac.id/2571/1/33286-Article Text-112284-1-10-20240830.pdf
Taslim, D. G., & Murwantara, I. M. (2024). Comparative analysis of ARIMA and LSTM for predicting fluctuating time series data. Bulletin of Electrical Engineering and Informatics, 13(3), 1943–1951. https://doi.org/10.11591/eei.v13i3.6034
Tatachar, A. V. (2021). Comparative Assessment of Regression Models Based On Model Evaluation Metrics. International Research Journal of Engineering and Technology, 8(9), 853–860. www.irjet.net
Yi, K., Zhang, Q., Fan, W., Cao, L., Wang, S., He, H., Long, G., Hu, L., Wen, Q., & Xiong, H. (2025). A Survey on Deep Learning based Time Series Analysis with Frequency Transformation. In Proceedings of the ACM SIGKDD International Conference on Knowledge Discovery and Data Mining (Vol. 2, Issue 1). arXiv. https://doi.org/10.1145/3711896.3736571
Refbacks
- There are currently no refbacks.
Copyright (c) 2025 Muhammad Ananta Arya Novandi*, Ida Nurhaida, Irma Paramita Sofia, and Fitriyah Nurhidayah
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Electronic Journal of Education, Social Economics and Technology (eJESET)
ISSN 2723-6250 (Online)
Published by the SAINTIS Publishing
Homepage: http://ejeset.saintispub.com
Editor E-mail : ; editor.ejeset@gmail.com
Editorial Office Address:
