Journal of Business, Social and Technology (Bustechno) http://bustechno.ridwaninstitute.co.id/index.php/jbt/issue/current

INVENTORY APPLICATION PROGRAM ON CV X IN SEMARANG

Sayudin

Ridwan Institute, Cirebon, West Java, Indonesia

Email: [email protected]

�

Abstract

Article Information: Received Revised Accepted Keywords: the program; application; inventory

This research uses qualitative approach. Qualitative approach is a process of research and understanding based on a methodology that investigates a phenomenal.� According to jane richie qualitative research is an effort to improve the social world and its perspective in the world, in terms of concepts, behaviors, perceptions and problems about human beings are meticulous. From the discussion and observation of research, it can be concluded the following: First, it takes a long time to modulate the inventory of goods, therefore it is necessary to improve through development methods such as HIPO and basic visual coding. Second, The lack of thoroughness in modulates every item entering and exiting, for that the need for a program of application of inventory.

Introduction

Batik X is a home industry company engaged in batik fashion. Batik X was established from 2010 until now. Along with the development of Batik X joined several online shops to market its products, including Zalora, VIP Plaza, Mataharimall.com, Qoo10, and Muslimarket. There is also an offline shop that is in Centro Bintaro Jaya X-change. From some customers who cooperate with Batik X, Zalora is the first customer to cooperate with Batik X (Darmawan & Setiawati, 2015).

Zalora is one of the customers who cooperate with Batik X and along with the many competitions in the field of e-commerce, zalora and other online shops many are turning to a market place that is not stored in supplier warehouses but stored in warehouses owned by the company (Basuki & Pasa, 2018). So along with the large demand for goods needed by customers will be more and more administration modulate the data of goods entering and exiting the warehouse, therefore there must be a lot of goods that will be recap by the administration because of the number of goods in the warehouse stored as inventory in each marketplace (Fathansyah, 2012). Therefore, the administration has problems in modululating data that every day can reach hundreds of batik that has just come and must be dissied to each marketplace, after which the administration must also make a price for each batik that every model, motif, color is different. The administration must also prepare a price tag to be tagged in batik to be sold. Before clothes are marketed in the online shop, we must also photograph our batik first according to the criteria given by e-commerce. Therefore, Batik Amarta Nawa collaborates with Inbound Indonesia to photograph our batik with detailed models and criteria, and the background desired by Amarta Nawa (Gie, 2007).

Along with the number of goods coming in and out of the warehouse and the large number of customer requests, the administration must be thorough. Inventory of goods in the warehouse is certainly very important for an admin to know what items are ordered by online shop customers and make no mistake, the inventory of goods from each online shop in the warehouse must also be very careful in order to be faithful to the purchase of goods in the message remains available. Therefore an administration needs to store every item that comes in and out of the warehouse (Indrajani, 2011).

Methods

This research uses a qualitative approach. Qualitative approach is a process of research and understanding based on a methodology that investigates a phenomenal.� According to jane Richie (Moleong, 2019) qualitative research is an effort to improve the social world and its perspective in the world, in terms of concepts, behaviors, perceptions and problems about human beings are meticulous.

The method that researchers used in this study was a descriptive method. The descriptive method according to Nawawi (Campo, Ballester, Langlois, Dacremont, & Valentin, 2010) can be interpreted as a problem solving procedure that is investigated by describing or describing the state of the subject or object of research (a person, institution, society, and others) at this time based on facts that appear or as is. According to (Yin, 2011) descriptive research method is research intended to investigate the circumstances, conditions or other things already mentioned, the results of which are presented in the form of research reports.

Scientific methods are used to obtain data with specific purposes and uses. Based on this, there are four keywords that need to be considered, namely scientific means, data, purpose, and usefulness. The reason the author uses qualitative methods that are deriktif because qualitative method is not to look for some of the influence of a variable on other variables, but the research that the author does is to explore, find and explain how the problem can be handled to the maximum.

Results and Discussion

A. System Design

System design consists of ERD, normalization, HIPO structure, program flowchart and program display design.

1. Entity Relationship Diagram / ERD

In the previous chapter it has been explained about the understanding of ERD, and in this chapter the author will create an ERD based on the application program to be created (Cagiltay, Tokdemir, Kilic, & Topalli, 2013).

Diagram 1

ERD Inventory

2. Normalization

Picture 2

Unormalization

Picture 3

Normalization to one (1NF)

Picture 4

Second normalization (2NF)

3. Structure HIPO

HIPO (Hirearchical Plus Input Proses Output) is a program documentation tool and also as a hipo design tool based on functions that aregrammed on the main menu (Davis, 2019). Here is the structure of HIPO program in inventory application program on CV Amarta Nawa:

Picture 5

HIPO Production Schedule

4. Flowchart Program

Flowchart program consists of login flowchart, main menu flowchart, file menu flowchart, report flowchart, flowchart 1A, flowchart 2A, flowchart 1A. A, flowchart 1A (Chapin, 2003). B, flowchart 1A. C, flowchart 2A. A, flowchart 2A. B, flowchart 2A. C as follows:

a. Flowchart Login Picture 6 Flowchart Login b. Flowchart Main Menu
Picture 7 Flowchart Main Menu c. Flowchart Data Master Picture 8 Flowchart Menu File
d. Flowchart Process Picture 9 Flowchart Process
e. Flowchart� 1B From flowchart Data Master there is flowchart 1B as follows : Picture 10 Flowchart 1B
5. Program View Design The design of the program display consists of login form, main menu form, menswear form, top women's formpakaian, lower women's clothing form, and report form as follows:
Form Login Picture 11 Menu Login	Form Main Menu Picture 12 Main Menu
Goods Form Picture 13 Goods Form	Form Customers Picture 14 Form Customers
Form Supplier Picture 15 Form Supplier	Form User Picture 16 Form User
Form Incoming Items Picture 17 Form Incoming Items	Form Sales Picture 18 Form Sales
Form Stock Picture 19 Form Stock

B. Implementation

Implementation consists of relationships between tables, database structure and program end result as follows :

Relationships Between Tables

Picture 20

Relationships Between Tables

1. Database Structure

The database structure consists of administrative data, menswear data, top women's clothing data, lower women's clothing data, supplier data and report data (Priana & Fitriani, 2016).

a. Data User

Contains all admin data amarta nawa.

File name������ :�� Penjualan.mdb

Name_table�� :�� m_user

Media :�� Microsoft Acces 2007

Primary key�� : ��Userid

Tabel 1

Data Admin

No	Field name	Type	Size	Description
1	User id	Text	10	Primery key
2	Pass	Text	20	-
3	odlevel	Text	5	-
4	namauser	Text	20	-
5	Status	number	2	-

b. Goods Data

Contains all menswear data amarta nawa Data Goods

File name������ :� �Penjualan.mdb

Nama_table�� :�� Goods

Media :�� Microsoft Acces 2007

Primary key�� :�� Itemid

Table 2

Goods Data

No	Field name	Type	Size	Description
1	Itemid	Text	10	Primery key
2	itemname	Text	25	-
3	itemdesc	Text	40	-
4	itemgroupid	Text	10	-
5	itemvendid	Text	8	-
6	iteminstok	Text	Double	-
7	itembalance	Number	Double	-
8	itemsale	Number	Double	-
9	itemcost	Number	Double	-
10	itemstatus	Number	Integer	-
11	itemuserid	text	10	-

c. Customer Data

Contains all women's clothing data on amarta nawa

File name������ :�� Penjualan.mdb

Name_table�� :�� Customers

Media ����������� :�� Microsoft Acces 2007

Primary key�� :�� custid

Tabel 3

Customer Data

No	Field name	Type	Size	Description
1	Custid	Text	8	Primery key
2	Custname	Text	30	-
3	Custaddr	Text	255	-
4	Custphone	Text	15	-
5	Custfax	Text	15	-
6	Custpic	Text	25	-
7	Custstatus	Number	Integer	-
8	Custuserid	Text	10	-

d. Supplier Data

Contains all women's clothing data on amarta nawa

File Name����� :�� Penjualan.mdb

Name_table�� :�� Supplier

Media :�� Microsoft Acces 2007

Primary key�� :�� vendid

Tabel 4

Women's Clothing Data Below

No	Field name	Type	Size	Description
1	Venidid	Text	8	Primery key
2	vendname	Text	30	-
3	Venaddr	Text	255	-
4	vendphone	Text	15	-
5	Vendfax	Text	15	-
6	Vendpic	Text	25	-
7	vendstatus	Number	Integer	-
8	venduserid	Text	10	-

e. Incoming Goods Data

Contains all women's clothing data on amarta nawa

File Name����� : ��Penjualan.mdb

Name_table�� :�� tr_masuk

Media :�� Microsoft Acces 2007

Primary key�� :�� receivedid

Tabel 5

Data Supplier

No	Field name	Type	Size	Description
1	receivedid	Text	15	Primery key
2	receiveddate	Date/Time		-
3	receivenid	Text	8	-
4	receivedesc	Text	255	-
5	receiveqty	Number	Double	-
6	receiveuserid	Text	10	-

f. ��Data Sales

Contains all women's clothing data on amarta nawa

File Name����� :� �Penjualan.mdb

Name_table�� :�� Sales

Media :�� Microsoft Acces 2007

Primary key�� :�� salesid

Tabel 6

Data Sales

No	Field name	Type	Size	Keterangan
1	Salesid	Text	15	Primery key
2	Salesdate	Date/Time		-
3	Salescutid	Text	8	-
4	Jumlahsalesqty	Number	Double	-
5	Salesmount	Number	Double	-
6	Salesuserid	Text	10	-

2. Main Menu View, Program Input And Output (sort by stages from start to end)

Menu Login Picture 21 Menu Login	Main Menu Picture 22 Main Menu
Form� Goods Picture 23 Form Goods
Form Incoming Items Picture 24 Form Incoming Items

3. Compile Program / Program End Result

Picture 25

Program End Result

Picture 26

Lap Customer List

Conclusion

From the discussion and observation of research, it can be concluded the following First, it takes a long time to modulate the inventory of goods, therefore it is necessary to improve through development methods such as HIPO and basic visual coding. Second, The lack of thoroughness in modulates every item entering and exiting, for that the need for a program of application of inventory.

REFERENCES

Basuki, Sucipto, & Pasa, Ali. (2018). Pengembangan Sistem Informasi Penilaian Kinerja Dosen Pada Stmik Insan Pembangunan. Insan Pembangunan Sistem Informasi Dan Komputer (IPSIKOM), 6(1). Google Scholar

Cagiltay, Nergiz Ercil, Tokdemir, Gul, Kilic, Ozkan, & Topalli, Damla. (2013). Performing and analyzing non-formal inspections of entity relationship diagram (ERD). Journal of Systems and Software, 86(8), 2184�2195. Google Scholar

Campo, Eva, Ballester, Jordi, Langlois, Jennifer, Dacremont, Catherine, & Valentin, Dominique. (2010). Comparison of conventional descriptive analysis and a citation frequency-based descriptive method for odor profiling: An application to Burgundy Pinot noir wines. Food Quality and Preference, 21(1), 44�55. Google Scholar

Chapin, Ned. (2003). Flowchart. In Encyclopedia of Computer Science (pp. 714�716). Google Scholar

Darmawan, Deni, & Setiawati, Linda. (2015). Developing Integrated Management Information System in Research: A Study at the Institute for Research and Community Services of Universitas Pendidikan Indonesia. International Journal of Applied Engineering Research, 10(16), 37206�37210. Google Scholar

Davis, William S. (2019). HIPO (hierarchy plus input-process-output). In The information system consultant�s handbook (pp. 503�510). CRC Press. Google Scholar

Fathansyah, Basis Data. (2012). Bandung. Informatika. Google Scholar

Gie, T. L. (2007). Administrasi Perkantoran Modern, Edisi Keempat. Yogyakarta: Liberty. Google Scholar

Indrajani, S. M. (2011). Pengantar dan Sistem Basis Data. Jakarta: PT Elex Media Komputindo. Google Scholar

Moleong, Lexy J. (2019). Metodologi penelitian kualitatif. Google Scholar

Priana, Isan, & Fitriani, Leni. (2016). Perancangan Aplikasi Perangkat Lunak Pengelolaan Data Bank Sampah di PT. Inpower Karya Mandiri Garut. Jurnal Algoritma, 13(2), 407�413. Google Scholar

Yin, Robert K. (2011). Applications of case study research. sage. Google Scholar

Copyright holder :

Sayudin (2021)

First publication right :

Journal of Business, Social and Technology (Bustechno)

This article is licensed under: