ANDROID-BASED E-INVENTORY SYSTEM (CASE STUDY: DPRD KABUPATEN BERAU)

ABSTRACT


Introduction
The rapid development of information technology can solve many problems in various industries (Tarantang, Awwaliyah, Astuti, & Munawaroh, 2019).With Presidential Instruction (Inpres) Number 3 of 2003, the government realized that using communication and information technology in government processes (e-government) can increase the efficiency, effectiveness, transparency, and accountability of government administration (Syamsuar & Reflianto, 2019).The government sector cannot be separated from technological advances, where the government must be able to use information and communication technology to implement government systems (Iswandari, 2021).
However, there is a problem in implementing this e-government where the inventory documentation system still exists, which is only recorded on paper even though the latest data has been changed and has begun to be stored in an Excel file.This problem must be resolved immediately because state property management must know precisely the assets owned (Hudiya, Puspita, Kawigraha, & Hapid, 2021).
Another problem is the slow update of existing stock items.This problem can cause data discrepancies because the goods data must be audited manually.This can cause data differences in reports and different quantities of items (Kasemin, 2016).
The above problems can lead to new problems where when an inspection of office goods is held.During the inspection, supervisors need the latest data as soon as possible.Employees must first check the stock of goods and update the data on Excel, which results in slow updating of the required data (Manoharan & Ingrams, 2018).
Technology that can solve the above problems.One of the technologies that can overcome the above problems is a mobile-based e-inventory application (Lindo & Tukino, 2023).Mobile applications are chosen because they can be connected to cloud servers, which will help store data anywhere the user wants to use the application as long as the user is connected to the internet network (Hay, Safaah, & Ramadhan, 2019).In addition, the purpose of this application is to facilitate the process of updating the stock inventory of consumables, make it easier for users to document goods, and facilitate data retrieval to increase work effectiveness (Sinaga & Rahayu, 2018).The development of this application aims to be a development for the development of e-government applications in the Berau Regency DPRD related to inventory for consumables.
Consumable goods are those included in state wealth that are consumable for official purposes or for a period of use that is less than one year (Juansyah, 2018).An example of consumables is stationary; the purpose of consumables in this study is because of the short period of use of these goods, which requires that the goods must constantly be audited.
This application aims to improve the recording and administration services of the use of consumables in the fields in the DPRD Secretariat and realize the Development of an integrated consumables recording application in the Berau Regency DPRD through the Android Application.

Research Methods Data obtained
The data obtained is a file containing an inventory list of consumables recorded between 2020 and 2021, where the data contains the date of the item update, the item's name, and the item's quantity and unit.The sample of the file in question can be seen in the following figure.

Data collection procedure
Data is obtained by directly interviewing staff from related agencies and requesting copies of several documents.Data collection is carried out online and in stages with vulnerable data collection between October 16, 2022, and April 25, 2023

Business rules
The system to be analyzed is a system that will later be used to monitor the movement of inventory goods.Hopefully, this system can meet the needs and overcome existing problems.

Stages of Research
At this stage, the author explains what activities will be carried out in this research activity, as the activities can be seen in the following picture.

Results and Discussion Splash screen Page implementation
The initial view when the application is run before heading to the login page.A splash screen page is displayed so that users understand the application to be used.Here is the splash screen page of the system application.

Login Page Implementation
The login page displays the login form when the user already has an account and enters the email and password created in this application.However, if the user forgets the password can click forgot password above the login button.

Menu Page Implementation
This page is displayed after the user successfully enters the system; this page displays request data for admins and leaders and several buttons for the user; the menu page can be seen in the picture.The code to retrieve data is as follows:

Inventory page implementation
This page will display data from existing inventory, and on this page, admins can add inventory data that is not yet on this page.Also, admins can update data and delete inventory data.The display of the inventory page can be seen in the following figure.The request code can be seen in the following code:

Conclusion
It can run well based on research that has been made and tested.The e-inventory system developed using the Android platform can facilitate the process of inventory management and increase efficiency in decision-making.The e-inventory application also allows users from various locations easy access, making monitoring inventory in realtime more accessible.Therefore, adding features and improvements related to existing limitations is necessary for further development.

Figure 1
Figure 1 Goods request letter

Figure 2
Figure 2 Research stage flow

Figure 3
Figure 3 Splash Screen Display

Figure 4
Figure 4 Screan Login Display

Figure 5
Figure 5 Menu Display

Figure 6
Figure 6 Inventory Display