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

 

 

SALES APPLICATION ON DISTRO SOUPLAY

 

Ade Bani Riyan

Intention, Syntax Corporation Indonesia Cirebon Jawa Barat, Indonesia

Email: [email protected]

 

 

Abstract

 

 

 

Article Information:

Received

Revised

Accepted

 

 

Keywords:

Application; Sales; Distro souplay

The development of the business world is now inseparable from the support of technology, especially computer technology and information because in increasingly modern economic activities are needed the existence of computer technology to support and facilitate all economic activities in order to achieve these goals. With the use of computers as a tool in Distro Souplay does not mean without problems, there are still troublesome things and obstacles to create a comfortable and efficient atmosphere while in Distro suoplay. The accumulation of irregular goods data. The slow search for data needed when ordering an item of goods Adds knowledge and insights, especially about the sale of goods and implements the science obtained in lectures into the business world..

 

Introduction

The development of this world is currently running very rapidly which creates an increasingly tight competition (Sastro M, 2017). Accompanied by the development of information technology, causing the flow of information that is difficult to obtain can now be easily obtained according to needs (Crotty, 2005). Computer is a device needed for the process of presenting data processing so that the processed data can provide the necessary information can be realized (Simarmata et al., 2020).

The development of the business world is now inseparable from the support of technology, especially computer technology and information because in increasingly modern economic activities are needed the existence of computer technology to support and facilitate all economic activities in order to achieve these goals (Van den Ende & Kemp, 1999). With the use of computers as a tool in Distro Souplay does not mean without problems, there are still troublesome things and obstacles to create a comfortable and efficient atmosphere while in Distro suoplay (Al-Mubarak et al., 2007). The accumulation of irregular goods data. Slow search of required data when ordering an item (Talib, 2014).

So to be able to produce information quickly and accurately can not be met. Almost every work related to accuracy and speed in data processing is done with this tool (Sumakul, 2015). Despite the large amount of data, the presentation of the results can be completed in a short time. Distro is a shop that sells a variety of goods such as clothing, pants, jackets, shoes and others (Kim, 2013). Which is a major need for everyone now. More importantly, especially young people, therefore business in this field will be very promising for now and in the future (Mutoharoh, 2018).

Based on the description above, the author is interested in creating an Application for the sale of goods in Distro Suoplay that will help the Distro in running its business better and is expected to improve the performance and quality that has existed, especially in terms of sales transactions of Distro goods (Indrajani, 2011). The title the author took for the final task was "Sales App On Distro Suoplay"

Distro Suoplay is a shop engaged in the sale of shoes, pants and others. Distro's business unit is growing in all indonesian entrepreneurs.

 

Method

Research objectives

The objectives to be achieved by writing this final task are as follows:

A.        As one of the requirements to complete diploma III (D3) program.

B.        Implementation of goods sales program using Visual Basic.

Benefits of research

Benefits of research This final task, supporting the sales program system, among others:

a.       Presenting an application program for the sale of goods that is expected to be one of the alternatives in solving problems faced by the owners of Distro Suoplay.

b.       Development of sales program system that can help to implement or implementation of sales program application in Distro Suoplay in running its business better and can improve performance and quality, especially in terms of sales transactions of special goods Distro Suoplay.

c.       Adding knowledge and insights, especially about the sale of goods and implementing the science obtained in lectures into the business world.

 

Results and Discussion

A.   System Design

1.    Entity Relationship Diagram / ERD

 

 

Figure 1

Entity Relationship Diagram

 

 

 

 

 

 

2.    Running System

Table 1

Proposed System Document

 

3.    Normalization

a.                   Unormalisasi

Table 2

Transaction Table

No_faktur

Kode_Barang

Nama_Barang

Jumlah

1101010000000

110011

T-shirt Ouval

1

110601000000

110022

Kemeja Bloods

1

Diskon

Total_Harga

Dibayar

Kembali

10%

135000

150000

15000

10%

180000

200000

20000

 

Nama_Spg

Grand_total

Tanggal

Diar

135000

11/Oktber/2016

Diar

200000

11/Oktber/2017

 

b.    Normal Shape To One (1 NF)

Table 3

Transaction Table

*No_faktur

*Kode_Barang

Nama_Barang

Jumlah

1101010000000

110011

T-shirt Ouval

1

110601000000

110022

Kemeja Bloods

1

Diskon

Total_Harga

Dibayar

Kembali

10%

135000

150000

15000

10%

180000

200000

20000

 

Grand_Total

*Nama_Spg

Tanggal

135000

Diar

11/Oktber/2016

200000

Diar

11/Oktber/2017

Description: * candidate key

 

c.          Second Normalization Shape (2 NF)

Table 4

Transaction Table

*No_faktur

**Kode_Barang

Nama_Barang

Jumlah

 

1101010000000

110011

T-shirt Ouval

1

 

110601000000

110022

Kemeja Bloods

1

 

 

 

 

 

 

 

Diskon

Total_Harga

Dibayar

Kembali

 

10%

135000

150000

15000

 

10%

180000

200000

20000

 

**Nama_Spg

Grand_total

Tanggal

Diar

135000

11/Oktber/2016

Diar

200000

11/Oktber/2016

Description: *primary key** guest key

 

 

Table 5

Goods Table

**Kode_Barang

Nama_Barang

Satuan

Total_Harga

110011

T-shirt Ouval

1

135000

110022

Kemeja Bloods

1

180000

 

Table 6

Table Spg

**Nama_Spg

Kode_Spg

Alamat

Telepon

Diar

Spg01

Bekasi

81290494949

Diar

Spg01

Bekasi

81290494949

 

 

 

 

 

4.    Program View Design

a.                   Login Menu Design

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Figure 2

Login Menu Design

b.    Main Menu Design

 

 

 

 

 

 

 

 

 

 


Figure 3

 Main Menu Design

c.     Sales Report Menu Design

 

 

 

 

 

 

 

 


Figure 4

Sales Report Menu Design

 

 

 

 

 

 

 

B.   Implementation

a.     Relationships between Tables

Figure 5

Relationships between Tables

 

1.       Database Structure

a.       File Structure Goods

Name File :  Goods

Function : Entering the ITEM ID Code

Software :  Ms. Acces

Table 7

Goods File Structure

Nama Field

Type Data

Size

Discription

Kode Barang

Text

13

 

Nama barang

Text

30

 

Warna

Text

15

 

Satuan

Text

10

 

Harga jual

Number

Long Integer

 

Stok

Number

Integer

 

 

A.   Sales File Structure

File Name : Sales

Function : Entering Invoice No Code

Software :  Ms. Acces

 

Table 8

Sales File Structure

Nama Field

Tipe Barang

Size

Discription

No Faktur

Text

10

 

Tanggal

Date/Time

 

 

Kode_Spg

Text

5

 

Total_Barang

Number

Integer

 

Total_Harga

Number

Long Integer

 

Diskon

Number

Long Integer

 

Grand_Total

Number

Long Integer

 

Dibayar

Number

Long Integer

 

Kembali

Number

Long Integer

 

 

 

 

 

Nama Field

Tipe Barang

Size

Discription

No Faktur

Text

10

 

Tanggal

Date/Time

 

 

Kode_Spg

Text

5

 

Total_Barang

Number

Integer

 

 

a.   File Structure Spg

Name File      :  Spg

Function        : Entering Code Spg

Software        :  Ms. Acces

Table 9

     File Structure Spg

Nama Field

Tipe Data

Size

Discription

Kode_Spg

Text

5

 

Nama­_Spg

Text

30

 

Alamat

Text

30

 

Telepon

Text

15

 

Contact­_Person

Text

30

 

b.       Main Menu Display, Program Input and Output (Order from start to end of program)

1.       Application Input Display

a)    Form Login

 

Figure 6

 Login Form View

b)    Form main Menu

 

Figure 7

 Main Menu Form View

 

a)       Form Data Goods

Figure 8

 Display of Goods Data

b)    Form Data Spg

Figure 9

View Data Spg

c)    Form Sales Transactions

Figure 10

Sales Transaction View

 

 

 

 

d)    Form Sales Report

Figure 11

 Sales Report View

 

2.       Application Output Display

a.     Sales Data Report

 

 

 

 

 

 

 

 

 

 

 

Figure 12

 Sales Report View

 

b.    Sales Data Report between Spg

 

 

 

 

 

 

 

 

 

 

 

     Figure 13

Sales Data View between Spg

 

Conclusion

Based on the subject matter in the discussion that has been described in the previous chapters, the author can draw some conclusions including the processing of sales data of Distro Souplay is still piled on the Note. So when data storage error rate is still frequent, sales data of goods that have not been effective and data storage is inefficient. With the application of distro souplay sales program submitted has been computerized so that it can display accurate data so that it can facilitate the process of work. The application of Distro Souplay sales program improves performance and human resources so that it can create a fast and effective work process. With the application of distro souplay sales program can create ease in data storage and search..

 

References

 

Al-Mubarak, S., Al-Ali, N., Abou Rass, M., Al-Sohail, A., Robert, A., Al-Zoman, K., Al-Suwyed, A., & Ciancio, S. (2007). Evaluation Of Dental Extractions, Suturing And Inr On Postoperative Bleeding Of Patients Maintained On Oral Anticoagulant Therapy. British Dental Journal, 203(7), E15–E15. Google Scholar

 

Crotty, James. (2005). The Neoliberal Paradox: The Impact Of Destructive Product Market Competition And ‘Modern’financial Markets On Nonfinancial Corporation Performance In The Neoliberal Era. Financialization And The World Economy, 1, 77–110. Google Scholar

Indrajani, S. M. (2011). Pengantar Dan Sistem Basis Data. Jakarta: Pt Elex Media Komputindo.

Al-Mubarak, S., Al-Ali, N., Abou Rass, M., Al-Sohail, A., Robert, A., Al-Zoman, K., Al-Suwyed, A., & Ciancio, S. (2007). Evaluation Of Dental Extractions, Suturing And Inr On Postoperative Bleeding Of Patients Maintained On Oral Anticoagulant Therapy. British Dental Journal, 203(7), E15–E15. Google Scholar

 

Crotty, James. (2005). The Neoliberal Paradox: The Impact Of Destructive Product Market Competition And ‘Modern’financial Markets On Nonfinancial Corporation Performance In The Neoliberal Era. Financialization And The World Economy, 1, 77–110. Google Scholar

 

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

 

Kim, Bowon. (2013). Competitive Priorities And Supply Chain Strategy In The Fashion Industry. Qualitative Market Research: An International Journal. Google Scholar

 

Mutoharoh, Eva. (2018). Rancang Bangun Sistem Informasi Akuntansi Penjualan Kosmetik Pada Relof Clinic. Google Scholar

 

Sastro M, Agus. (2017). Rancang Bangun Alat Monitoring Daya Dengan Penyimpanan Data Ke Microsd Card Menggunakan Arduino Dan Visual Basic Dan Visual Basic. Universitas Muhammadiyah Surabaya. Google Scholar

 

Simarmata, Janner, Taufiq, Mhd Ebit, Sidik, Jafar, Saputra, Riki Wahyudi, Hapsah, Siti, Sari, Angereiny Citra, Pratama, Nur Apna, Sitompul, Divo Santana, Al-Wafi, Niswan, & Al Akbar, Riza. (2020). Pengantar Manajemen Sistem Informasi. Yayasan Kita Menulis. Google Scholar

 

Sumakul, Ribka. (2015). Aplikasi Pengelolaan Surat Dinas Pada Kantor Regional Xi Badan Kepegawaian Negara. Politeknik Negeri Manado. Google Scholar

 

Talib, H. (2014). Panduan Lengkap Ms Access. Jakarta: Alex Media Computindo. Google Scholar

 

Van Den Ende, Jan, & Kemp, René. (1999). Technological Transformations In History: How The Computer Regime Grew Out Of Existing Computing Regimes. Research Policy, 28(8), 833–851. Google Scholar

 

Copyright holder :

Ade Bani Riyan (2020)

 

First publication right :

Journal of Business, Social and Technology (Bustechno)

 

This article is licensed under: