Designing a Sales Information System Based on Java Netbeans

Article Study Case Designing a Sales Information System Based on Java Netbeans Amelia Rose Smith Carnegie Mellon University, 5000 Forbes Avenue, Pittsburgh, PA 15213, USA ameliaroses2019@gmail.com Abstract Bunbun Food Store is a small company in the household needs sector that sells various kinds of frozen food products. However, the transaction process and data processing still use the manual method, namely recording it on a sales note in two copies. This process takes a long time and has a very high error rate. So the aim of the research is to develop an existing application system for purchasing and selling goods to make it easier to collect data and process transactions for buying and selling goods. The research methodology used in the data processing system is the library study method, namely data collection which is carried out by taking data from various library books, journals and other books which can be used as a basis for analyzing problems that can be discussed in research, as well as field study methods. namely by conducting direct observations such as interviews and observations. The system development method used is the Waterfall method. The result of this research is that there is an application device created using the Java programming language and data storage using a MySQL database so that the data collection process and purchase and sales transactions at the Bunbun Food Store become more effective, efficient and practical. Keywords: Inventory management system, point-of-sale system (POS system), frozen food retail, small business automation, manual data processing inefficiencies, Java programming language, MySQL database, Waterfall development method, library research methodology Introduction The development of globalization accompanied by the development of information technology has resulted in the flow of information that was previously difficult to obtain can now be easily obtained according to needs. Increasingly advanced technological developments require performance within an agency or company that is relatively fast and precise in producing the required information. One of them is the application of computer technology as a tool that is absolutely used as the main support in business competition and good human resource support. This kind of incident can be experienced by several shops, such as Toko Bunbun Food Store, which is located at Jalan Cilandak KKO Gang Depot Es No. 42 Kelurahan Ragunan Kecamatan Pasar Minggu Kota South Jakarta 12550. Toko Bunbun Food Store is a shop that provides processed meat and food. ready-to-eat frozen items such as nuggets, sausages, meatballs and AMELIA ROSE SMITH 1 Amelia Rose Smith so on, however there are several problems experienced by Toko Bunbun Food Store in the sales process. Data collection on the sales process is all done manually, there is no information system to support the process. so problems arise that must be resolved immediately. The most significant problem is in the data input process, the process of purchasing goods from suppliers and sales transactions and reports, so that the data obtained is often problematic due to human error. Based on the needs analysis as outlined, the Bunbun Food Store requires an information system that can support the processing of sales data quickly, precisely and accurately and can provide convenience for employees in working. For this purpose, research was carried out with the title "Designing a Sales Information System at the Bunbun Food Store Based on Java Netbeans" which is expected to be able to overcome the problems that arise in the store. Methods Methodology is a science that discusses scientific methods, their steps, types up to the limits of the scientific method. A. Method of collecting data Data collection methods are one aspect that plays a role in the smoothness and cleanliness of research. In this research, the data collection method that the author uses is as follows: 1) Field Study The field study was carried out by looking directly at the implementation of the sales information system at the Bunbun Food Store. In this field study, data collection techniques were used, namely Observation and Interviews, to study and observe the processes at the Bunbun Food Store from March 2022 to July 2022. 2) Study of literature Literature study is research carried out by researchers by collecting a number of books, magazines related to the problem and research objectives. The data and information collected for designing a sales information system is by studying literature books on analyzing and designing a system, studying systems from similar sales system applications, and studying guide books on Java programming to iterate with MYSQL as the database. AMELIA ROSE SMITH 2 Article Study Case B. System Development Steps The software development process carried out in this research is through the SDLC (Software Development Life Cycle) process with 6 stages, namely Requirement Analysis, Design, Implementation, Testing and Evolution or can be replaced with a Maintenance Program [7]. The following are the 6 stages of the SDLC process: 1) Needs Analysis Requirements analysis is useful for obtaining data that will be used as input for a system and for obtaining data related to this final assignment. The process of designing a sales information system starts from understanding the user. 2) Literature Study Literature study also means data collection techniques by reviewing books, literature, notes, and various reports related to the problem you want to solve. 3) System Design System design aims to design the system that will be created so that it can be implemented according to user needs. 4) System Testing Before the sales information system is used properly, it must be tested first. This test suite is run together with actual data from existing or running systems. 5) Implementation After the database design and application interface design are carried out, the implementation or coding stage is entered, where the author carries out the process of translating the design documents into computer programming language command lines. 6) Software Maintenance: Software maintenance can be carried out periodically to check if the software is working as it should. There needs to be an employee tasked with maintaining the system so that it can operate properly as required. AMELIA ROSE SMITH 3 Amelia Rose Smith Results and Discussions A. Problem Analysis From the research results, the author can analyze the problems at the Bunbun Food Store, namely the sales system which is still relatively simple. Sales data recording is done manually. Sales data is recorded based on handwriting, so there is the possibility of errors in making reports. Likewise, in terms of data storage, data is stored in folders and will be stored in archives. B. Alternative Problem Solving Based on the problems that have been explained, a computerized system will be needed. The author can suggest several alternative problem solutions that can be tried, namely creating a computerized application that can help improve company performance for the better, creating a database system to store data so that it is more efficient and accurate and can reduce the possibility of data loss and damage, so that Toko Bunbun Food Store is able to run programs easily, quickly, precisely and accurately in the process of making reports and sales transactions. AMELIA ROSE SMITH 4 Article Study Case C. Data Flow Diagram (DFD) A data flow diagram is a model that explains data flow to process data in a system and to document the system currently in use. Purchase Order Report data list of purchased Customer payment invoice payment invoice Cashier memorandum payment Sales Information System at the Bunbun Food Store Based on Java Netbeans stock data Supplier Inventory Data Report stock request stock request stock data warehouse Memorandum payment Sales Report Inventory Data Report Supplier Data Report Purchase Order Report Purchase Order Report Inventory Data Report Sales Report Purchase Order return Report Shop Owner Purchase Order return Report Figure 1. Data Flow Diagram D. Entity Relationship Diagram (ERD) An entity relationship diagram is a model that describes a relationship between data in a database based on basic data objects that have relationships between relationships AMELIA ROSE SMITH 5 Amelia Rose Smith Id_Warehouse WAREHOUSE Name_Warehouse Num_Warehouse Addr_Warehouse Name_Cashier Id_Cashier CASHIER PRODUCT OWN DO NAME SUPPLIER ID SUPPLIER ACCEPT ORDER OWN INFORMATION PRICE NUM_ORDER QUANTITY DATE_ORDER ID_PURCHASING ID_WAREHOUSE NAME_PURCHASIN G NUM_DEMAND ID_PRODUCT NAME_PRODUCT NAME_WAREHOUSE PHONE Figure 2. Entity Relationship Diagram AMELIA ROSE SMITH 6 NUM SUPPLIER ADDRESS SUPPLIER SUPPLIER Article Study Case E. Display Figure 3. Login Form Display This display is at the beginning of the program. The login menu is used as a keyword before entering the main program. So that not just anyone can access this program. So that confidentiality in the Menu Form is maintained properly. If the user can enter the username and password correctly, the main menu will appear and the program is ready to run. Figure 4. Display Main Menu The screen above displays the Main Menu display in the Sales Information System at the Bunbun Food Store. On the main screen, a menu bar is available which consists of master data which is used to enter data relating to item type data, item data, supplier data, purchase data, sales data, purchase return data, and reports. AMELIA ROSE SMITH 7 Amelia Rose Smith Figure 5. Screen display of item type data form The screen above displays the item type data form. On the item type data form screen to input item type data consisting of Type Code and Item Type. Figure 6. Screen display of data form AMELIA ROSE SMITH 8 Article Study Case The screen above displays the item data form. On the item data form screen to input item data consisting of item code, item name, type code, item type, purchase price, selling price and stock. Figure 7 Screen display of data form Supplier The screen above displays the supplier data form. On the supplier data form screen to input supplier data consisting of Supplier Code, Supplier Name, Telephone Number and Address. AMELIA ROSE SMITH 9 Amelia Rose Smith Figure 8. Screen Display of Purchase Transaction Form The screen above displays the purchase transaction data form. On the purchase transaction data form screen to input purchase transaction data consisting of Purchase Number, Purchase Date, Supplier Code, Supplier Name, Item Code, Item Name, Selling Price, Stock, Quantity and Sub Total Figure 9. Sales Transaction Form Screen Display AMELIA ROSE SMITH 10 Article Study Case The screen above displays the sales transaction data form. On the sales transaction data form screen to input sales transaction data consisting of Sales Number, Sales Date, Item Code, Item Name, Selling Price, Stock, Quantity and Sub Total. CONCLUSIONS AND RECOMMENDATIONS After knowing the problems that exist at the Bunbun Food Store, an application was designed which was built with Netbeans IDE 8.2 tools and implemented a sales information system at the Bunbun Food Store to facilitate administration in the process of inputting and searching for data such as goods data, supplier data, data purchases, sales transaction data and purchase return data because the data that has been input will be stored properly in the database. By using this application, we hope it will make it easier for the Bunbun Food Store to process data and reports because it uses a computerized system AMELIA ROSE SMITH 11 Amelia Rose Smith References Deitel, P. J., & Deitel, H. M. (2017). Java How to Program (Early Objects). Pearson Education. Schildt, H. (2018). Java: The Complete Reference, Eleventh Edition. McGraw-Hill Education. Gaddis, T. (2019). Starting Out with Java: From Control Structures through Objects. Pearson. Sierra, K., Bates, B., & Robson, E. (2018). Head First Java, 3rd Edition. O'Reilly Media. Vaswani, V. (2014). Java Programming for Absolute Beginners. Apress. Kurniawan, B. (2016). Java 7: A Comprehensive Guide for Beginner. Brainy Software. Eckel, B. (2006). Thinking in Java, 4th Edition. Prentice Hall. Suryanarayana, G., & Chugh, V. (2015). Design Patterns in Java. Packt Publishing. Urma, R. G., Fusco, M., & Mycroft, A. (2018). Modern Java in Action: Lambdas, Streams, Functional and Reactive Programming. Manning Publications. Robillard, M. P. (2009). Introduction to Software Design with Java. Springer. AMELIA ROSE SMITH 12