|
|
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: adebaniriyan@gmail.com
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
|
Ade
Bani Riyan (2020) |
|
First
publication right : Journal of
Business, Social and Technology (Bustechno) |
|
This
article is licensed under:
|
