An Effective Open ERP System for Automation in Financial Reporting for SMEs based on Service Oriented Architecture

Muhardi Saputra - Telkom University, Jl. Telekomunikasi No 1, Bandung, 40257, Indonesia
Rafa Fadlila - Telkom University, Jl. Telekomunikasi No 1, Bandung, 40257, Indonesia


Citation Format:



DOI: http://dx.doi.org/10.30630/joiv.7.3-2.2367

Abstract


Small-Medium Enterprises (SMEs) are currently in high demand and highly developed in many countries. However, several SMEs still do not yet have an information system to support their business processes. This causes the absence of a system that helps integrate data from each process and sector in SMEs. All data exchanges and transaction report generation are done manually and recorded using physical documents that reduce effectiveness and increase costs. This research uses the accounting module in Open ERP or Odoo Version 11.0 software and Service Oriented Architecture (SOA) methods to design ERP systems for general types of SMEs in the finance sector, specifically on the sales and purchase process. So the solution for recording financial transactions and making financial reports for SMEs is to design an ERP system based on Open Source using the Service Oriented Architecture methodology, namely Smart SMEs, by implementing the Automatic Reporting feature to create best practices on an integrated system, especially in recording transactions in the sales and purchase processes so that financial reports can be generated automatically and are real-time. The result of this research is the design of ERP systems in the finance section connected occurs especially in the financial recording of the purchase of goods, the sale of goods, and the creation of financial statements automatically. This system can help the finance sector record transactions and make automatic financial reports that can be generated in real-time.

Full Text:

PDF

References


K. Digdowiseiso and E. Sugiyanto, “How effective is institutional quality for the creation of small & medium enterprises (Smes) in Indonesia?,†Economics and Sociology, vol. 14, no. 1, pp. 263–274, 2021, doi: 10.14254/2071-789X.2021/14-1/17.

T. TAMBUNAN, “ENTREPRENEURSHIP DEVELOPMENT: SMES IN INDONESIA,†https://doi.org/10.1142/S1084946707000575, vol. 12, no. 01, pp. 95–118, Nov. 2011, doi: 10.1142/S1084946707000575.

M. Saputra, B. M. Izzati, and J. Rahmadiani, “The Acceptance of Government Resource Planning System Using UTAUT 2,†Jurnal Sistem Informasi, vol. 17, no. 1, pp. 1–19, Apr. 2021, doi: 10.21609/JSI.V17I1.1010.

T. Siregar, W. Puspitasari, and M. Saputra, “ERP in Indonesia SMEs: a Study for Post Implementation Evaluation from User’s Perspective Acceptance,†9th International Conference on ICT for Smart Society: Recover Together, Recover Stronger and Smarter Smartization, Governance and Collaboration, ICISS 2022 - Proceeding, 2022, doi: 10.1109/ICISS55894.2022.9915088.

D. A. Sari, “Faktor-Faktor Yang Mempengaruhi Daya Saing Umkm Syaiko Rosyidi,†Buletin Bisnis dan Manajemen, vol. 03, no. 02, pp. 14–25, 2018.

N. C. Rosianti and M. ER, “Analisis Tingkat Kematangan Proses Bisnis Dan Kesiapan Teknologi Informasi Studi Kasus Usaha Garmen Mikro, Kecil, Dan Menengah Di Jawa Timur,†Jurnal Teknik ITS, vol. 6, no. 2, pp. 264–269, 2017, doi: 10.12962/j23373539.v6i2.23160.

Iswandir, “AUDIT SISTEM INFORMASI AKUNTANSI BERBASIS KOMPUTER DALAM PENYAJIAN FINANCIAL REPORT,†JSI (Jurnal sistem Informasi) Universitas Suryadarma, vol. 6, pp. 171–178, 2019.

S. A. Siregar, “Sistem Informasi Akuntansi Persediaan Barang Berbasis Komputer Pada Bagian Gudang Di Sekolah Cinta Kasih Jakarta,†Infotech: Journal of Technology Information, vol. 5, no. 1, pp. 13–18, 2020, doi: 10.37365/it.v5i1.53.

M. Saputra and S. H. Supangkat, “Financial technology business model as branchless banking for people in rural areas: Case study : esia,†2017 International Conference on ICT for Smart Society, ICISS 2017, vol. 2018-Janua, pp. 1–6, 2018, doi: 10.1109/ICTSS.2017.8288890.

E. Satyawati and L. Lyna, “Akuntansi, Teknologi Dan Usaha Mikro Kecil Menengah (Umkm) Dengan Metode Rapid Application Development (Rad),†Prosiding, vol. 5, no. November, pp. 908–914, 2017.

M. Saputra, S. P. Hendarsyah, and W. Witjaksono, “Utilization of Service Oriented Architecture to Customize Accounting Business Process in Open ERP System for Smart SME’s,†International Journal of Innovation in Enterprise System, vol. 4, no. 02, pp. 13–22, 2020, doi: 10.25124/ijies.v4i02.63.

S. P. Hendarsyah, “Perancangan sistem erp smart SMEs berbasis model layanan pada proses accounting dengan metode service oriented architecture,†2019.

N. Holmberg, B. Johansson, R. Atem, D. Carvalho, and R. Atem De Carvalho, “How to gain synchronization between business processes and enterprise resource planning systems: A SOA based perspective on ERP implementation,†2013, Accessed: Jan. 04, 2023. [Online]. Available: https://www.researchgate.net/publication/239464261

H. F. Erdiyana and Suharjito, “ERP System Integration with Mobile Applications Using Service Oriented Architecture,†Proceedings of 2019 International Conference on Information Management and Technology, ICIMTech 2019, pp. 1–5, Aug. 2019, doi: 10.1109/ICIMTECH.2019.8843745.

A. Girbea, C. Suciu, S. Nechifor, and F. Sisak, “Design and implementation of a service-oriented architecture for the optimization of industrial applications,†IEEE Trans Industr Inform, vol. 10, no. 1, pp. 185–196, Feb. 2014, doi: 10.1109/TII.2013.2253112.

A. Tewary and P. Kosalge, “Implementing service oriented architecture - A case study,†Int J Bus Inf Syst, vol. 14, no. 2, pp. 164–181, 2013, doi: 10.1504/IJBIS.2013.056137.

P. Belley and L. Lochner, “The Changing Role of Family Income and Ability in Determining Educational Achievement,†J Hum Cap, vol. 1, no. 1, pp. 37–89, 2007, doi: 10.1086/524674.

R. Vinaja, Enterprise resource planning and business intelligence systems for information quality: an empirical analysis in the Italian setting, vol. 21, no. 3. 2018. doi: 10.1080/1097198x.2018.1505039.

W. L. Liao, C. Y. Yao, and Y. P. Yang, Effect of Fintech on the Cost Malmquist Productivity Index in the China Banking Industry, vol. 542. Springer Singapore, 2019. doi: 10.1007/978-981-13-3648-5_9.

H. N. Azizah, W. Puspitasari, and M. Saputra, “Inventory Budgeting and Purchasing Optimization in ERP System for Health Industry: Conceptual Model for Accounts Payable,†2020 8th International Conference on Information and Communication Technology, ICoICT 2020, 2020, doi: 10.1109/ICoICT49345.2020.9166236.

C. Nafianto, W. Puspitasari, and M. Saputra, “Development of Flexible Production Scheduling by Applying Gantt Charts in Manufacturing Module Open Source ERP (Case Study CV. XYZ),†ICSECC 2019 - International Conference on Sustainable Engineering and Creative Computing: New Idea, New Innovation, Proceedings, pp. 182–185, 2019, doi: 10.1109/ICSECC.2019.8907025.

F. Nasution, W. Puspitasari, and M. Saputra, “Automation Financial Processing in Account Receivable for Integrated Hospital System using ERP and Quickstart Approach,†ACM International Conference Proceeding Series, pp. 204–211, 2020, doi: 10.1145/3404709.3404759.

H. N. Azizah, W. Puspitasari, and M. Saputra, “Inventory Budgeting and Purchasing Optimization in ERP System for Health Industry: Conceptual Model for Accounts Payable,†2020 8th International Conference on Information and Communication Technology, ICoICT 2020, 2020, doi: 10.1109/ICoICT49345.2020.9166236.

S. Supriyono and S. Sutiah, “Improvement of Project Management Using Accelerated SAP Method in the Odoo ERP,†Jan. 2020, doi: 10.4108/EAI.3-8-2019.2290729.

F. Pramaswari, A. P. Nasution, and S. L. Nasution, “The Effect of Branding Quality and Service Quality on Customer Satisfaction through Financial Technology (FinTech) at PT. WOM Finance Branch Rantauprapat,†Budapest International Research and Critics Institute (BIRCI-Journal): Humanities and Social Sciences, vol. 4, no. 2, pp. 2995–3004, 2021, doi: 10.33258/birci.v4i2.2012.

F. Nasution, W. Puspitasari, and M. Saputra, “Automation Financial Processing in Account Receivable for Integrated Hospital System using ERP and Quickstart Approach,†ACM International Conference Proceeding Series, pp. 204–211, Jun. 2020, doi: 10.1145/3404709.3404759.

J. Leoni, S. C. Strada, M. Tanelli, K. Jiang, A. Brusa, and A. M. Proverbio, “Automatic stimuli classification from ERP data for augmented communication via Brain–Computer Interfaces,†Expert Syst Appl, vol. 184, no. January, p. 115572, 2021, doi: 10.1016/j.eswa.2021.115572.

P. Hasanaj and B. Kuqi, “Analysis of Financial Statements,†Humanities and Social Science Research, vol. 2, no. 2, p. p17, 2019, doi: 10.30560/hssr.v2n2p17.

A. R. Maulida, S. F. S. Gumilang, and R. W. Witjaksono, “Pengembangan Sistem Informasi Berbasis Enterprise Resource Planning Modul Warehouse Management pada Odoo dengan Metode Rapid Application Development di PT. Brodo Ganesha Indonesia,†eProceedings of Engineering, vol. 3, no. 2, pp. 3337–3345, 2016.

M. Zdravković, M. Trajanović, and M. Manić, “SOA-based approach to the enterprise resource planning implementation in small enterprises,†Facta universitatis - series: Mechanical Engineering, vol. 5, no. 1, pp. 97–104.

T. Anita Christiani, “Potential Legal Conflict For The Implementation Of Financial Services Authority Regulation Number 65 /POJK.04/2020,†Jurnal Magister Hukum Udayana (Udayana Master Law Journal), vol. 10, no. 1, p. 15, 2021, doi: 10.24843/jmhu.2021.v10.i01.p02.

E. Satyawati, “Akuntansi , Teknologi Dan Usaha Mikro Kecil Menengah ( Umkm ) Dengan Metode Rapid Application Development ( Rad ),†vol. 5, no. November, pp. 908–914, 2017.

P. I. Santosa, “Measuring user experience during a web-based survey: A case Of back-to-back online surveys,†Int J Adv Sci Eng Inf Technol, vol. 6, no. 3, pp. 339–344, 2016, doi: 10.18517/ijaseit.6.3.815.