Analisis dan Perancangan Sistem Penjualan Bahan Bangunan Berbasis Desktop untuk Meningkatkan Akurasi dan Kecepatan Layanan

Gilbert Andre Boantua Sinaga

doi:10.64276/ams.v1i2.69

Authors

Gilbert Andre Boantua Sinaga Politeknik Unggul LP3M

DOI:

https://doi.org/10.64276/ams.v1i2.69

Keywords:

System Design, Desktop Application, Sales Information System, Data Accuracy, Service Speed

Abstract

Panglong Cemerlang is a building materials trading business located in Beringin District, Deli Serdang Regency, where sales transactions were previously recorded manually using handwritten invoices and sales ledgers. This manual process resulted in slow service, data duplication, and a high risk of recording errors. This study presents the analysis and development of a desktop-based sales information system to improve data accuracy and transaction speed. The system was developed using Visual Basic 2010 as the programming language and Microsoft Access as the database management system. The development process involved system analysis, Context Diagram creation, Data Flow Diagram (DFD), Entity Relationship Diagram (ERD), database design, interface design, and flowchart modeling to ensure structured data integration. The implemented system includes features for login authentication, master data management (items, employees, and administrators), sales transaction processing, and automated report generation. The implementation results indicate that the system reduces manual recording errors, eliminates duplicate data entry, accelerates transaction processing time, and enables real-time report generation. Therefore, the desktop-based sales system enhances operational efficiency, improves data accuracy, and supports managerial decision-making in small and medium-scale trading businesses.

References

Abror, K. H., Mansyuri, U., & Arief, R. (2025). Web Based Used Motorcycle Sales Information System Design At Wipa Motor Using Laravel Framework. Brilliance, 5(1), 451–460.

Akbar, M. R., Zurfadly, A., & Apriani, M. (2025). Perancangan Database Elite Hotel Tembilahan Menggunakan Erd (Entity Relationship Diagram). Jurnal Sistem Informasi (Teknofile), 3(5).

Akula, D. K., Mohammed, Y. S., Syed, A., Mohammad, G., Haque, M., & Arafat, Y. (2025). The Role Of Information Systems In Enhancing Strategic Decision Making : A Review And Future Directions. The American Journal Of Management And Economics Innovations, 07(1), 1–26. Https://Doi.Org/10.37547/Tajmei/Volume07issue08-07

Anggraini, Nur, S. R., & Murdowo, S. (2023). Perancangan Sistem Informasi Penjualan Roti (Studi Kasus Kiky Bakery). Infokam, 19(2).

Ardhana, V. Y. P. (2024). Penerapan Metode Extreme Programming Pada Sistem Informasi Penjualan Berbasis Web. Journal Of Information Systems Management And Digital Business, 1(2). Https://Doi.Org/10.59407/Jismdb.V1i2.414

Bendig, D., & Bräunche, A. (2025). The Role Of Artificial Intelligence Algorithms In Information Systems Research : A Conceptual Overview And Avenues For Research. In Management Review Quarterly (Vol. 75, Issue 4). Springer International Publishing. Https://Doi.Org/10.1007/S11301-024-00451-Y

Fathoni, M. (2025). Sistem Informasi Pengiriman Barang Berbasis Web Pada Pt. Jne Express. Sujarwo Muhammad Fathoni, 19(1), 1953–1963.

Fathoni, M., Sumardi, H., & Lpm, P. U. (2024). Algoritma Keprimitifan Dari Suatu Digraph. Muhammad Fathoni Hari Sumardi, 18(3), 657–664.

Fildzah, A. A. (2017). Pengaruh Experiential Marketing Terhadap Loyalitas Nasabah Melalui Kepuasan Nasabah Bank Syariah Mandiri Cabang Gresik. Universitass Islam Negeri Maulana Malik Ibrahim.

Hall, J. A. (2021). Accounting Information Systems (10th Ed.). Cengage Learning.

Handayani, C., Wulandari, D., Amanda, S., Fadila, Z., & Fathoni, M. (2021). Pelatihan Penggunaan Google Classroom Dan Google Meet Sebagai Media Digital Untuk Pembelajaran Daring Selama Pandemi Covid- 19 Bagi Guru- Guru Di Sdit. Tridarma: Pengabdian Kepada Masyarakat (Pkm), 4(2), 102–111.

Harahap, V. A. N., Nurwani, & Nasution, J. (2023). Analysis Of Accountability And Transparency In Management Of School Operational Assistance (Bos) On School Progress At Smp Muhammadiyah 16 Lubuk Pakam. Indonesian Interdisciplinary Journal Of Sharia Economics (Iijse), 6(3), 1863–1877.

Hou, Z. (2021). The Role Of Perceived Quality On High-Speed Railway Tourists’ Behavioral Intention: An Application Of The Extended Theory Of Planned Behavior. Sustainability, 13, 1–15.

Jakak, P. M., Sinta, V., Wardianto, W., Fadholi, R., & Nurpiji, N. (2025). Implementasi Sistem Penjualan Sembako Pada Toko Sundari Berbasis Desktop. Jurnal Pengabdian Kepada Masyarakat Nusantara, 6(1), 1150–1155. Https://Doi.Org/10.55338/Jpkmn.V6i1.4941

Kotler, P., Keller, K. L., & Chernev, A. (2021). Marketing Management. Pearson Education.

Kurniawan, D., Kuswanto, V., & Gunawan, A. H. (2023). Analysis And Design Of Web-Based Building Material Sales Information System At Tigaraksa Regional Building Store Using User Accptance Testing Meth. Update Technology, 4(2). Https://Doi.Org/10.31253/Algor.V4i2.1526

Laudon, K. C., & Laudon, J. P. (2020). Management Information Systems: Managing The Digital Firm (16th Ed.). Pearson.

Manurung, D. O., Venansia, A., & Fatmawati, F. (2024). Pengembangan Proyek Sistem Informasi Penjualan Laptop Berbasis Web Pada Bless Computer. Bina Insani Ict Journal, 11(1). Https://Doi.Org/10.51211/Biict.V11i1.2733

Muliady, P., & Riki, R. (2025). Analisis Dan Perancangan Sistem Informasi Penjualan Pada Umkm Bahan Material Bangunan Berbasis Website Di Daerah Bonang. Poters (Proceedings Of Technology, Engineering And Computers), 1(2).

Mushi, G. E., Burgi, P.-Y., & Serugendo, G. D. M. (2025). Designing A Farmers Digital Information System For Sustainable Agriculture : The Perspective Of Tanzanian Agricultural Stakeholders. The Electronic Journal Of Information Systems In Developing Countries, 1(1), 1–20. Https://Doi.Org/10.1002/Isd2.12344

Nafayta, E., & Saleh, A. (2024). Advances In Applied Accounting Research Evaluation Of Sales Accounting Information Systems In Improving The Effectiveness Of Accounts Receivable Control. Advances In Applied Accounting Research, 2(3), 196–210. Https://Doi.Org/Https://Doi.Org/10.60079/Aaar.V2i3.314

Nugroho, A., & Harini, D. (2024). Teknik Random Forest Untuk Meningkatan Akurasi Data Tidak Seimbang. J. Sist. Inform. Tek. Inform. Komputer, 2(2). Https://Doi.Org/10.53624/Jsitik.V2i2.379

Nur Fatiha Utami Nasution, Mesra B, Toyib Daulay, Elfitra Desy Surya, & Nur Afrina Siregar. (2023). The Analyze Effect Of Service Marketing Mixes On Purchase Decisions Consumers Which Mediation By Consumer Trust To Use Service Of Jne Main Branch Medan. International Journal Of Management, Economic And Accounting, 1(2), 514–527. Https://Doi.Org/10.61306/Ijmea.V1i2.52

Pennycook, G., Mcphetres, J., Zhang, Y., Lu, J. G., & Rand, D. G. (2020). Fighting Covid-19 Misinformation On Social Media: Experimental Evidence For A Scalable Accuracy-Nudge Intervention. Psychological Science, 31(7), 770–780. Https://Doi.Org/10.1177/0956797620939054

Putr, H. M., Ferdiansyah, T., Nugroho, W. H., Setyo, T., & Saprudin. (2024). Perancangan Sistem Informasi Dan Penjualan Online Berbasis Web Pada Jasa Percetakan Anugerah Niaga Cipta Dengan Metode Waterfall. Ijns, 13(2). Https://Doi.Org/10.55181/Ijns.V13i2.1844

Romney, M. B., & Steinbart, P. J. (2021). Accounting Information Systems. Pearson.

Rong, J., Hao, H., & Xu, W. (2024). Big Data Intelligent Tourism Management Platform Design Based On Abnormal Behavior Identification. Intelligent Systems With Applications, 21(October), 1–11. Https://Doi.Org/10.1016/J.Iswa.2023.200312

Sutrisno, G., Kania, M. M., & Ristiani, R. (2024). Customer Experience Dan Customer Engagement Sebagai Prediktor Loyalitas Pelanggan : Peran Kepuasan Pelanggan Sebagai Pemediasi. Joce Ip, 18(2).

Tjiptono. (2018). Strategi Pemasaran. Bayu Media.

Yusman, S. Y. R. S. V. K. E. (2022). The Effect Of Products, Services And Promotions On Decision On Customer Requests On Service Products At Bank Bsi Tiban Batam Branch. Jurnal Mantik, 6(36), 2377–2384.