ABSTRAK TB.Murah merupakan sebuah Toko bahan bangunan yang masih menggunakan metode manual dalam semua proses bisnis yang terjadi setiap hari. Sehingga menyulitkan pencatatan dan pelaporan stok, transaksi penjualan , transaksi pembelian, pengiriman, penginformasian barang ke gudang, retur jual, retur beli dan transaksi D/O. Maka dari itu, sebuah sistem komputerisasi yang bernama Sistem Penjualan, Pembelian , Pengiriman serta Multi Warehouse dapat membantu dalam pencatatan semua transaksi,pengiriman, penginformasian barang ke gudang dan pelaporan stok, serta pembuatan laporan-laporan yaitu : laporan penjualan tunai dan kredit, laporan pembelian, laporan stok per bulannya dan lain sebagainya. Aplikasi berbasis desktop ini dibuat dengan menggunakan bahasa pemrograman C#.NET dan basis data SQL Server 2008. Kata Kunci: TB.Murah, penjualan, pembelian, rekapitulasi barang , konsumen, supplier, pembayaran kredit, laporan, Multi gudang, webservis, aplikasi desktop, C#, D/O, retur, pengiriman.
vi
Universitas Maranatha
ABSTRACT TB.Murah is a building materials store that still use manual methods in all business processes that occur every day. Making it difficult to recording and reporting of stock, sale, purchase, delivery, informing the goods to the warehouse, sales returns, purchase returns and transactions of D/O. Therefore, a computerized system called System Sales, Purchase, Delivery and Multi Warehouse can assist in recording all transactions, delivery, informing the goods to the warehouse and inventory reporting, and making reports namely: cash and credit sales report, purchase report , stock reports per month, and so forth. This desktopbased applications created using the programming language C #. NET and SQL Server 2008 database. Keywords: TB.Murah, sales, purchasing, recapitulation of goods, consumers, suppliers, credit payments, reports, multi warehouse, webservice, desktop applications, C #, D/O, returns, shipping.
vii
Universitas Maranatha
DAFTAR ISI LEMBAR PENGESAHAN ........................................................................................... i PERNYATAAN ORISINALITAS LAPORAN PENELITIAN.......................................... ii PERNYATAAN PUBLIKASI LAPORAN PENELITIAN ............................................... iii PRAKATA ................................................................................................................. iv ABSTRAK ................................................................................................................. vi ABSTRACT ............................................................................................................. vii DAFTAR ISI ............................................................................................................ viii DAFTAR GAMBAR ................................................................................................... xi DAFTAR TABEL ..................................................................................................... xiv BAB I PENDAHULUAN..............................................................................................1 1.1. Latar Belakang Masalah..................................................................................1 1.2. Rumusan Masalah ..........................................................................................2 1.3. Tujuan Pembahasan .......................................................................................2 1.4. Ruang Lingkup Kajian .....................................................................................3 1.4.1. Ruang Lingkup Software ..........................................................................3 1.4.2. Ruang Lingkup Aplikasi ............................................................................3 1.5. Sumber Data ...................................................................................................4 1.6. Sistematika Pembahasan................................................................................4 BAB II KAJIAN TEORI ...............................................................................................6 2.1. Sistem Informasi Pembelian dan Penjualan .............................................6 2.1.1. Hakikat Penjualan .............................................................................6 2.1.2. Pembelian .........................................................................................7 2.2. Inventory ..................................................................................................8 2.2.1. Goods Receipt (Penerimaan Barang)................................................9 2.2.2. Goods Issues ....................................................................................9 2.2.3. Inventory Counting ............................................................................9 2.3. Surat Jalan .............................................................................................10 2.4. Delivery Order (D/O) ..............................................................................10 2.5. Microsoft Visual Studio ...........................................................................10 2.5.1. Microsoft visual C#.net ....................................................................11 2.5.2. Microsoft .net Frameworks ..............................................................12 2.6. SQL Server ............................................................................................12 2.7. Proses Bisnis .........................................................................................13 2.8. Flowchart ...............................................................................................14 2.9. Entity Relationship Diagram (ERD) ........................................................17 2.10. Data Flow Diagram (DFD) ......................................................................21 2.11. Kamus Data ...........................................................................................22 2.12. Proses Specification (PSPEC) ...............................................................23 BAB III ANALISIS DAN DESAIN SISTEM................................................................25 3.1. Proses Bisnis .........................................................................................25 3.1.1. Proses Penjualan Barang................................................................25 3.1.2. Proses Pengiriman Barang .............................................................27 3.1.3. Proses Pembayaran Piutang...........................................................27 3.1.4. Proses Retur Jual............................................................................29 3.1.5. Proses Pembelian Barang...............................................................30 3.1.6. Proses Barang Pembelian yang datang ..........................................31 3.1.7. Proses Pembayaran Utang .............................................................33 3.1.8. Proses Retur Beli ............................................................................34 3.1.9. Proses D/O .....................................................................................34
viii
Universitas Maranatha
3.1.10. Proses Pengambilan Barang D/O ...................................................35 3.2. Entity Relationship Diagram (ERD) ........................................................38 3.3. Data Flow Diagram (DFD) ......................................................................57 3.4. PSPEC................................................................................................. 101 3.5. KAMUS DATA...................................................................................... 147 BAB IV HASIL PENELITIAN ................................................................................ 179 4.1. Tampilan Login..................................................................................... 179 4.2. Tampilan Menu utama.......................................................................... 179 4.3. Tampilan Menu Pelanggan .................................................................. 185 4.4. Tampilan Menu Suplier ........................................................................ 186 4.5. Tampilan Menu Kategori Barang .......................................................... 187 4.6. Tampilan Menu Barang ........................................................................ 188 4.7. Tampilan Menu Karyawan .................................................................... 189 4.8. Tampilan Menu Gudang ....................................................................... 190 4.9. Tampilan Menu Giro............................................................................. 191 4.10. Tampilan Menu Kendaraan .................................................................. 192 4.11. Tampilan Menu Barang Rusak ............................................................. 193 4.12. Tampilan Menu Tambah Transaksi Penjualan ..................................... 194 4.13. Tampilan Menu History Penjualan ........................................................ 196 4.14. Tampilan Menu Tambah Retur Jual ..................................................... 197 4.15. Tampilan Menu Tambah Pembayaran PIutang .................................... 198 4.16. Tampilan Menu Lihat History Pembayaran piutang ............................. 199 4.17. Tampilan Menu Tambah Transaksi D/O ............................................... 200 4.18. Tampilan Menu Tambah Pengambilan D/O.......................................... 201 4.19. Tampilan Tambah Transaksi Pengiriman ............................................. 202 4.20. Tampilan Menu Lihat History Pengiriman ............................................. 204 4.21. Tampilan Menu Tambah Transaksi Pembelian..................................... 206 4.22. Tampilan Menu Lihat History Pembelian .............................................. 207 4.23. Tampilan Menu Tambah History Retur Beli .......................................... 209 4.24. Tampilan Menu Tambah Penerimaan Barang ...................................... 210 4.25. Tampilan Menu Tambah Pembayaran Hutang ..................................... 211 4.26. Tampilan Menu Kirim informasi ke Gudang .......................................... 212 4.27. Tampilan Menu Data dari Server.......................................................... 213 4.28. Tampilan Menu Data dari Gudang........................................................ 214 4.29. Tampilan Menu Tutup Stok .................................................................. 215 4.30. Tampilan Menu Rekapitulasi Barang .................................................... 216 4.31. Tampilan Menu Laporan Penjualan ...................................................... 217 4.32. Tampilan Menu Laporan Pembelian ..................................................... 219 4.33. Tampilan Menu Laporan Perhitungan Laba Rugi ................................ 220 BAB V PEMBAHASAN DAN HASIL UJI COBA PENELITIAN ............................... 222 5.1. Halaman Menu Utama ......................................................................... 222 5.2. Halaman Menu Barang ........................................................................ 227 5.3. Halaman Menu Kategori Barang .......................................................... 230 5.4. Halaman Menu Gudang ....................................................................... 231 5.5. Halaman Menu Pelanggan ................................................................... 233 5.6. Halaman Menu Karyawan .................................................................... 234 5.7. Halaman Menu Suplier ......................................................................... 236 5.8. Halaman Menu Kendaraan .................................................................. 238 5.9. Halaman Menu Giro ............................................................................. 239 5.10. Halaman Menu Transaksi Penjualan .................................................... 240 5.11. Halaman Menu History Penjualan ........................................................ 243
ix
Universitas Maranatha
5.12. Halaman Menu Retur Jual .................................................................... 243 5.13. Halaman Menu History Retur Jual ........................................................ 248 5.14. Halaman Menu Pembayaran Piutang ................................................... 249 5.15. Halaman Menu History Pembayaran Piutang ....................................... 250 5.16. Halaman Menu Transaksi Pembelian ................................................... 250 5.17. Halaman Menu History Transaksi Pembelian ....................................... 253 5.18. Halaman Menu Retur Beli .................................................................... 254 5.19. Halaman Menu History Retur Beli ........................................................ 256 5.20. Halaman Menu Pembayaran Hutang ................................................... 257 5.21. Halaman Menu Penerimaan Barang .................................................... 259 5.22. Halaman Menu History Penerimaan Barang ........................................ 262 5.23. Halaman Menu Transaksi D/O ............................................................. 263 5.24. Halaman History Transaksi D/O ........................................................... 265 5.25. Halaman Menu Pengambilan D/O ........................................................ 265 5.26. Halaman Menu History Pengambilan D/O ............................................ 269 5.27. Halaman Menu Atur Pengiriman .......................................................... 270 5.28. Halaman Menu History Kiriman ............................................................ 271 5.29. Halaman Form pop up Kiriman Berangkat............................................ 272 5.30. Halaman Menu Tutup Stok................................................................... 273 5.31. Halaman Menu Rekapitulasi Barang .................................................... 274 5.32. Halaman Menu Kirim Informasi ke Gudang .......................................... 275 5.33. Halaman Menu Data dari Server .......................................................... 275 5.34. Halaman Menu Data dari Gudang ........................................................ 276 5.35. Halaman Form pop up Barang Jual ...................................................... 278 5.36. Halaman Menu Laporan Penjualan ...................................................... 280 5.37. Halaman Menu Laporan Retur Jual ...................................................... 282 5.38. Halaman Menu Laporan Pembayaran Piutang ..................................... 284 5.39. Halaman Menu Laporan Pembelian ..................................................... 286 5.40. Halaman Menu Laporan Penerimaan Barang ...................................... 287 5.41. Halaman Menu Laporan Retur Beli ...................................................... 289 5.42. Halaman Menu Laporan Pembayaran Hutang ..................................... 291 5.43. Halaman Menu Laporan D/O................................................................ 292 5.44. Halaman Menu Laporan Pengambilan D/O .......................................... 294 5.45. Halaman Menu Laporan Pengiriman Barang........................................ 296 5.46. Halaman Menu Laporan Rekapitulasi Barang ...................................... 298 5.47. Halaman Menu Laporan Perhitungan Laba-Rugi.................................. 299 BAB VI SIMPULAN DAN SARAN ......................................................................... 301 6.1. Simpulan .............................................................................................. 301 6.2. Saran ................................................................................................... 301 DAFTAR PUSTAKA ............................................................................................... 303 RIWAYAT HIDUP PENULIS .................................................................................. 304
x
Universitas Maranatha
DAFTAR GAMBAR Gambar 1 - Contoh ERD.........................................................................................18 Gambar 2 - relasi satu ke satu ................................................................................19 Gambar 3 - relasi satu ke banyak ...........................................................................19 Gambar 4 - Relasi banyak ke satu ..........................................................................19 Gambar 5 - Relasi banyak ke banyak .....................................................................20 Gambar 6 Simbol External Entity ............................................................................21 Gambar 7 Simbol Proses ........................................................................................21 Gambar 8 Simbol Data Store ..................................................................................22 Gambar 9 Simbol Data Flow ...................................................................................22 Gambar 10 - Flowchart Penjualan (Manual)............................................................26 Gambar 11 - Flowchart Pengiriman barang (Manual)..............................................28 Gambar 12 - Flowchart Pembayaran Piutang (Manual) ..........................................29 Gambar 13 Flowchart Proses Retur Jual (manual) .................................................30 Gambar 14 - flowchart pembelian barang (Manual) ................................................31 Gambar 15 - Flowchart Barang Pembelian datang .................................................32 Gambar 16 - Flowchart pembayaran utang .............................................................33 Gambar 17 Flowchar Retur Beli ( Manual ) .............................................................34 Gambar 18 - Flowchart D/O ....................................................................................35 Gambar 19 - Flowchart Pengambilan barang D/O ..................................................36 Gambar 20 Flowchart Proses Multi Gudang (manual).............................................37 Gambar 21 ERD Sistem Penjualan dan Pembelian ................................................38 Gambar 22 DFD Level 0 Sistem Penjualan, Pembelian, Pengiriman Barang Serta MultiGudang Pada Toko Bahan Bangunan .............................................................57 Gambar 23 DFD Level 1 Sistem Penjualan, Pembelian, Pengiriman, Serta Multi Gudang pada Toko Bahan Bangunan .....................................................................63 Gambar 24 DFD Level 2 Proses 2 Pengelolaan Master Data .................................66 Gambar 25 DFD Level 3 Proses 2.1 Pengelolaan Barang ......................................67 Gambar 26 DFD Level 3 Proses 2.2 Pengelolaan Kategori ....................................68 Gambar 27 DFD Level 3 Proses 2.3 Pengelolaan Gudang .....................................69 Gambar 28 DFD Level 3 Proses 2.4 Pengelolaan Pelanggan .................................70 Gambar 29 DFD Level 3 Proses 2.5 Pengelolaan Karyawan ..................................71 Gambar 30 DFD Level 3 Proses 2.6 Pengelolaan Suplier ......................................72 Gambar 31 DFD Level 3 Proses 2.7 Pengelolaan Kendaraan ...............................73 Gambar 32 DFD Level 3 Proses 2.8 Pengelolaan Giro ..........................................74 Gambar 33 DFD Level 3 Proses 2.9 Pengelolaan Barang Rusak ...........................75 Gambar 34 DFD Level 2 Proses 3 Pengelolaan Penjualan .....................................76 Gambar 35 DFD Level 3 Proses 3.1 Pengolahan Transaksi Penjualan ..................77 Gambar 36 DFD Level 3 Proses 3.2 Pengolahan Pembayaran Piutang .................78 Gambar 37 DFD Level 3 Proses 3.3 Pengolahan Retur Jual ..................................79 Gambar 38 DFD Level 2 Proses 4 Pengelolaan Pembelian ....................................80 Gambar 39 DFD Level 3 Proses 4.1 Pengelolaan Transaksi Pembelian.................81 Gambar 40 DFD Level 3 Proses 4.2 Pengelolaan Penerimaan Barang ..................82 Gambar 41 DFD Level 3 Proses 4.3 Pengelolaan Pembayaran Hutang .................83 Gambar 42 DFD Level 3 Proses 4.4 Pengelolaan Retur Beli ..................................84 Gambar 43 DFD Level 2 Proses 5 Pengelolaan Pengiriman ...................................85 Gambar 44 DFD Level 3 Proses 5.2 Kelola History Pengiriman ..............................86 Gambar 45 DFD Level 2 Proses 6 Pengelolaan D/O ..............................................87 Gambar 46 DFD Level 3 Proses 6.1 Pengolahan D/O ............................................88
xi
Universitas Maranatha
Gambar 47 Gambar 48 Gambar 49 Gambar 50 Gambar 51 Gambar 52 Gambar 53 Gambar 54 Gambar 55 Gambar 56 Gambar 57 Gambar 58 Gambar 59 Gambar 60 Gambar 61 Gambar 62 Gambar 63 Gambar 64 Gambar 65 Gambar 66 Gambar 67 Gambar 68 Gambar 69 Gambar 70 Gambar 71 Gambar 72 Gambar 73 Gambar 74 Gambar 75 Gambar 76 Gambar 77 Gambar 78 Gambar 79 Gambar 80 Gambar 81 Gambar 82 Gambar 83 Gambar 84 Gambar 85 Gambar 86 Gambar 87 Gambar 88 Gambar 89 Gambar 90 Gambar 91 Gambar 92 Gambar 93 Gambar 94 Gambar 95 Gambar 96 Gambar 97
DFD Level 3 Proses 6.2 Pengolahan pengambilan D/O .......................89 DFD Level 2 Proses 7 Pengelolaan Keluar Masuk Barang...................90 DFD Level 4 Proses 7.1 Melakukan Tutup dan Batal Stok ...................90 DFD Level 2 Proses 8 Pengelolaan Pengiriman Informasi ...................91 DFD Level 2 Proses 9 Pengelolaan Laporan – Laporan .......................97 Rancangan Form Login ...................................................................... 166 Rancangan Form Pelanggan.............................................................. 167 Rancangan Form Suplier ................................................................... 167 Rancangan Form Karyawan ............................................................... 168 Rancangan Form Kategori ................................................................. 168 Rancangan Form Barang .................................................................. 169 Rancangan Form Kendaraan ............................................................. 169 Rancangan Form Giro ........................................................................ 170 Rancangan Form Barang Rusak ........................................................ 170 Rancangan Form Transaksi Penjualan............................................... 171 Rancangan Form Retur Jual .............................................................. 171 Rancangan Form Pembayaran Piutang.............................................. 172 Rancangan Form Transaksi Pembelian.............................................. 172 Rancangan Form Retur Beli ............................................................... 173 Rancangan Form Pembayaran Hutang .............................................. 173 Rancangan Form Penerimaan Barang ............................................... 174 Rancangan Form Pengiriman Barang ................................................ 174 Rancangan Form transaksi D/O ......................................................... 175 Rancangan Form Pengambilan D/O................................................... 175 Rancangan Form Kirim Informasi ke Gudang ..................................... 176 Rancangan Form Data dari Gudang................................................... 176 Rancangan Form Data dari Server ..................................................... 177 Rancangan Contoh History Transaksi ................................................ 177 Rancangan Customize Laporan Transaksi ......................................... 178 Rancangan Cetak Laporan Transaksi ................................................ 178 Tampilan Login................................................................................... 179 Tampilan Menu Utama ....................................................................... 180 Tampilan Menu Pelanggan................................................................ 185 Tampilan Menu Suplier ...................................................................... 186 Tampilan Menu Kategori Barang ........................................................ 187 Tampilan Menu Barang ...................................................................... 188 Tampilan Menu Karyawan .................................................................. 189 Tampilan Menu Gudang ..................................................................... 190 Tampilan Menu Giro........................................................................... 191 Tampilan Menu Kendaraan ................................................................ 192 Tampilan Menu Barang Rusak ........................................................... 193 Tampilan Menu Tambah Transaksi Penjualan ................................... 194 Tampilan ketika klik tombol lihat barang ............................................. 194 Tampilan Menu History Penjualan ...................................................... 196 Tampilan Menu Tambah retur Jual ..................................................... 197 Tampilan Menu Tambah Pembayaran Piutang................................... 198 Tampilan Menu Lihat History pembayaran piutang............................. 199 Tampilan Menu Tambah Transaksi D/O ............................................. 200 Tampilan Menu tambah pengambilan D/O ......................................... 201 Tampilan Tambah Transaksi Pengiriman ........................................... 202 Tampilan saat link lihat nota jual atau nota D/O diklik......................... 203
xii
Universitas Maranatha
Gambar 98 Tampilan Menu Lihat History Pengiriman ........................................... 204 Gambar 99 Tampilan Ketika link berangkat di tekan ............................................. 205 Gambar 100 Tampilan Menu Tambah Transaksi Pembelian................................. 206 Gambar 101 Tampilan Menu Lihat History Pembelian .......................................... 207 Gambar 102 Tampilan Menu Tambah Retur Beli .................................................. 209 Gambar 103 Tampilan Menu Tambah Penerimaan Barang .................................. 210 Gambar 104 Tampilan Menu Tambah Pembayaran Hutang ................................. 211 Gambar 105 Tampilan Menu Kirim Informasi Ke Gudang ..................................... 212 Gambar 106 Tampilan Menu Data dari Server ...................................................... 213 Gambar 107 Tampilan Menu Data dari Gudang.................................................... 214 Gambar 108 Tampilan Menu Tutup Stok .............................................................. 215 Gambar 109 Tampilan Menu Rekapitulasi Barang ................................................ 216 Gambar 110 Tampilan Menu Laporan Penjualan .................................................. 217 Gambar 111 Contoh Laporan Penjualan ............................................................... 218 Gambar 112 Tampilan Laporan Pembelian........................................................... 219 Gambar 113 Tampilan Menu Laporan Perhitungan Laba Rugi ............................. 220 Gambar 114 Laporan Perhitungan Laba Rugi ....................................................... 221
xiii
Universitas Maranatha
DAFTAR TABEL Tabel I - Simbol Flowchart (Emanuel, 2007) ...........................................................15 Tabel II - Simbol ERD (Fathansyah, 2007)..............................................................20 Tabel III Simbol Kamus Data(Kedall, 2003). ...........................................................23 Tabel IV - Contoh PSPEC (Jogianto,2006) .............................................................24 Tabel V Tabel Kategori ...........................................................................................39 Tabel VI Tabel Barang ............................................................................................39 Tabel VII Tabel Gudang ..........................................................................................40 Tabel VIII Tabel Pelanggan.....................................................................................40 Tabel IX Tabel Karyawan ........................................................................................41 Tabel X Tabel Suplier .............................................................................................41 Tabel XI Tabel Kendaraan ......................................................................................42 Tabel XII Tabel Giro................................................................................................42 Tabel XIII Tabel Penjualan......................................................................................43 Tabel XIV Tabel Penjualan Detail ...........................................................................43 Tabel XV Tabel Retur Jual ......................................................................................44 Tabel XVI Tabel Retur Jual Detail ...........................................................................45 Tabel XVII Tabel Piutang ........................................................................................45 Tabel XVIII Tabel DO..............................................................................................46 Tabel XIX Tabel DO Detail ......................................................................................46 Tabel XX Tabel Barang Rusak................................................................................47 Tabel XXI Tabel Pengambilan DO ..........................................................................47 Tabel XXII Table Pengambilan DO Detail ...............................................................48 Tabel XXIII Tabel Kiriman .......................................................................................48 Tabel XXIV Tabel Kiriman Detail .............................................................................49 Tabel XXV Tabel Pembelian ...................................................................................50 Tabel XXVI Tabel Pembelian Detail ........................................................................50 Tabel XXVII Tabel Penerimaan...............................................................................51 Tabel XXVIII Tabel Penerimaan Detail ....................................................................51 Tabel XXIX Tabel Retur Beli ...................................................................................52 Tabel XXX Tabel Retur Beli Detail ..........................................................................52 Tabel XXXI Tabel Hutang .......................................................................................53 Tabel XXXII Tabel Stok...........................................................................................54 Tabel XXXIII Tabel Stok Detail ................................................................................54 Tabel XXXIV Tabel Informasi ..................................................................................55 Tabel XXXV Tabel Informasi Reply .........................................................................56 Tabel XXXVI Keterangan DFD Keseluruhan ...........................................................97 Tabel XXXVII PSPEC Login.................................................................................. 101 Tabel XXXVIII PSPEC Tambah Barang ................................................................ 102 Tabel XXXIX PSPEC Ubah Barang ...................................................................... 102 Tabel XL PSPEC Hapus Barang........................................................................... 103 Tabel XLI PSPEC lihat barang .............................................................................. 103 Tabel XLII PSPEC Cari Barang ............................................................................ 104 Tabel XLIII PSPEC Tambah Kategori ................................................................... 104 Tabel XLIV PSPEC Tambah Kategori ................................................................... 105 Tabel XLV PSPEC Hapus Kategori....................................................................... 105 Tabel XLVI PSPEC Lihat Kategori ........................................................................ 105 Tabel XLVII PSPEC Cari Kategori ........................................................................ 106 Tabel XLVIII PSPEC Tambah Gudang ................................................................. 106
xiv
Universitas Maranatha
Tabel XLIX PSPEC Ubah Gudang ........................................................................ 107 Tabel L PSPEC Hapus Gudang ............................................................................ 107 Tabel LI PSPEC Lihat Gudang ............................................................................. 108 Tabel LII PSPEC Cari Gudang.............................................................................. 108 Tabel LIII PSPEC Tambah Pelanggan .................................................................. 109 Tabel LIV PSPEC Ubah Pelanggan ...................................................................... 109 Tabel LV PSPEC Hapus Pelanggan ..................................................................... 109 Tabel LVI PSPEC Lihat Pelanggan ....................................................................... 110 Tabel LVII PSPEC Cari Pelanggan ....................................................................... 110 Tabel LVIII PSPEC Tambah Karyawan ................................................................. 111 Tabel LIX PSPEC Ubah Karyawan ....................................................................... 111 Tabel LX PSPEC Hapus Karyawan ...................................................................... 112 Tabel LXI PSPEC Lihat Karyawan ........................................................................ 112 Tabel LXII PSPEC Cari Karyawan ........................................................................ 113 Tabel LXIII PSPEC Tambah Suplier ..................................................................... 113 Tabel LXIV PSPEC Ubah Suplier.......................................................................... 114 Tabel LXV PSPEC Hapus Suplier ......................................................................... 114 Tabel LXVI PSPEC Lihat Suplier .......................................................................... 115 Tabel LXVII PSPEC Cari Suplier .......................................................................... 115 Tabel LXVIII PSPEC Tambah Kendaraan ............................................................. 116 Tabel LXIX PSPEC Ubah Kendaraan ................................................................... 116 Tabel LXX PSPEC Hapus Kendaraan .................................................................. 116 Tabel LXXI PSPEC Lihat Kendaraan .................................................................... 117 Tabel LXXII PSPEC Cari Kendaraan .................................................................... 117 Tabel LXXIII PSPEC Tambah Giro ....................................................................... 118 Tabel LXXIV PSPEC Ubah Giro ........................................................................... 118 Tabel LXXV PSPEC Hapus Giro........................................................................... 119 Tabel LXXVI PSPEC Lihat Giro ............................................................................ 119 Tabel LXXVII PSPEC Cari Giro ............................................................................ 120 Tabel LXXVIII PSPEC Lihat Barang Rusak........................................................... 120 Tabel LXXIX PSPEC Cari Barang Rusak .............................................................. 120 Tabel LXXX PSPEC Tambah Barang Rusak ........................................................ 121 Tabel LXXXI PSPEC Tambah Transaksi Penjualan .............................................. 122 Tabel LXXXII PSPEC Lihat History Penjualan ...................................................... 122 Tabel LXXXIII PSPEC Tambah Pembayaran Piutang ........................................... 123 Tabel LXXXIV PSPEC Lihat History Pembayaran Piutang .................................... 123 Tabel LXXXV PSPEC Tambah Retur Jual ............................................................ 124 Tabel LXXXVI PSPEC Lihat History Retur Jual..................................................... 125 Tabel LXXXVII Tambah Transaksi Pembelian ...................................................... 125 Tabel LXXXVIII PSPEC Ubah Transaksi Pembelian ............................................. 126 Tabel LXXXIX PSPEC Lihat History Transaksi Pembelian .................................... 126 Tabel XC PSPEC Tambah Transaksi Penerimaan Barang ................................... 127 Tabel XCI PSPEC Lihat History Transaksi Penerimaan Barang ........................... 128 Tabel XCII PSPEC Tambah Transaksi Pembayaran Hutang ................................ 128 Tabel XCIII PSPEC Lihat History Pembayaran Piutang ........................................ 129 Tabel XCIV PSPEC Tambah Transaksi Retur Beli................................................ 130 Tabel XCV PSPEC Lihat History Transaksi Retur Beli .......................................... 130 Tabel XCVI PSPEC Atur Pengiriman .................................................................... 131 Tabel XCVII PSPEC Lihat History Pengiriman ...................................................... 132 Tabel XCVIII PSPEC Pengiriman Berangkat ........................................................ 132 Tabel XCIX PSPEC Pengiriman Datang ............................................................... 133
xv
Universitas Maranatha
Tabel C PSPEC Tambah Transaksi D/O............................................................... 133 Tabel CI PSPEC Lihat History D/O ....................................................................... 134 Tabel CII PSPEC Tambah Transaksi Pengambilan D/O ....................................... 134 Tabel CIII PSPEC Lihat History Pengambilan D/O................................................ 135 Tabel CIV PSPEC Melakukan Tutup Stok............................................................. 135 Tabel CV PSPEC Melakukan Batal Stok............................................................... 136 Tabel CVI PSPEC Lihat Rekapitulasi Barang ....................................................... 136 Tabel CVII PSPEC Kirim Informasi ke Gudang ..................................................... 137 Tabel CVIII PSPEC Kirim Informasi ke Server ..................................................... 137 Tabel CIX PSPEC Kelola Informasi dari Gudang .................................................. 137 Tabel CX PSPEC Cetak Laporan Penjualan ......................................................... 138 Tabel CXI PSPEC Cetak Laporan Penjualan ........................................................ 139 Tabel CXII PSPEC Cetak Laporan Pembayaran Piutang...................................... 139 Tabel CXIII PSPEC Cetak Laporan Pembelian ..................................................... 140 Tabel CXIV PSPEC Cetak Laporan Retur Beli ...................................................... 140 Tabel CXV PSPEC Cetak Laporan Pembayaran Hutang ...................................... 141 Tabel CXVI PSPEC Cetak Laporan Pengiriman ................................................... 142 Tabel CXVII PSPEC Cetak Laporan Penerimaan Barang ..................................... 142 Tabel CXVIII PSPEC Cetak Laporan Pembayaran Hutang ................................... 143 Tabel CXIX PSPEC Cetak Laporan Pengambilan D/O ......................................... 143 Tabel CXX PSPEC Cetak Laporan Rekapitulasi Barang....................................... 144 Tabel CXXI PSPEC Cetak List Barang ................................................................. 144 Tabel CXXII PSPEC Laporan Perhitungan Laba-Rugi .......................................... 145 Tabel CXXIII PSPEC Cetak List Karyawan ........................................................... 145 Tabel CXXIV PSPEC Cetak List Suplier ............................................................... 146 Tabel CXXV PSPEC Cetak List Pelanggan .......................................................... 146 Tabel CXXVI Kamus Data Data Barang ................................................................ 147 Tabel CXXVII Kamus Data Data Kategori ............................................................. 147 Tabel CXXVIII Kamus Data Data Gudang............................................................. 148 Tabel CXXIX Kamus Data Data Pelanggan .......................................................... 148 Tabel CXXX Kamus Data Data Karyawan ............................................................ 148 Tabel CXXXI Kamus Data Data Suplier ................................................................ 149 Tabel CXXXII Kamus Data Data Kendaraan ......................................................... 149 Tabel CXXXIII Kamus Data Data Giro .................................................................. 150 Tabel CXXXIV Kamus Data Data Penjualan ......................................................... 150 Tabel CXXXV Kamus Data Data Penjualan Detail ................................................ 151 Tabel CXXXVI Kamus Data Data Retur Jual ......................................................... 152 Tabel CXXXVII Kamus Data Data Retur Jual Detail .............................................. 152 Tabel CXXXVIII Kamus Data Data Pembelian ...................................................... 153 Tabel CXXXIX Kamus Data Data Pembelian Detail .............................................. 153 Tabel CXL Kamus Data Data Penerimaan ............................................................ 154 Tabel CXLI Kamus Data Data Penerimaan Detail ................................................. 154 Tabel CXLII Kamus Data Data Retur Beli ............................................................. 155 Tabel CXLIII Kamus Data Data Retur Beli Detail .................................................. 155 Tabel CXLIV Kamus Data Data Kiriman................................................................ 156 Tabel CXLV Kamus Data Data Kiriman Detail....................................................... 157 Tabel CXLVI Kamus Data Data D/O ..................................................................... 157 Tabel CXLVII Kamus Data Data D/O Detail .......................................................... 158 Tabel CXLVIII Kamus Data Data Pengambilan D/O .............................................. 158 Tabel CXLIX Kamus Data Data Pengambilan DO Detail....................................... 159 Tabel CL Kamus data Data Informasi ................................................................... 159
xvi
Universitas Maranatha
Tabel CLI Kamus Data Data Informasi Reply........................................................ 160 Tabel CLII Kamus Data Data Piutang ................................................................... 161 Tabel CLIII Kamus Data Data Hutang ................................................................... 161 Tabel CLIV Kamus Data Range Tanggal .............................................................. 162 Tabel CLV Kamus Data Range Tahun .................................................................. 162 Tabel CLVI Kamus Data Range Bulan .................................................................. 163 Tabel CLVII Kamus Data Username ..................................................................... 163 Tabel CLVIII Kamus Data Password ..................................................................... 163 Tabel CLIX Kamus Data Range Total D/O ............................................................ 163 Tabel CLX Kamus Data Range Total Batal ........................................................... 164 Tabel CLXI Kamus Data Range Total Penerimaan ............................................... 164 Tabel CLXII Kamus Data Range Total Tagihan .................................................... 164 Tabel CLXIII Kamus Data Range Jumlah Bayar ................................................... 165 Tabel CLXIV Kamus Data Range Total Retur Beli ................................................ 165 Tabel CLXV Kamus Data Range Total Pembelian ................................................ 166 Tabel CLXVI Test Case Halaman Menu Utama .................................................... 222 Tabel CLXVIII Test Case Halaman Menu Barang ................................................. 227 Tabel CLXIX Test Case Halaman Menu Kategori Barang ..................................... 230 Tabel CLXX Test Case Halaman Menu Gudang ................................................... 231 Tabel CLXXI Test Case Halaman Menu Pelanggan.............................................. 233 Tabel CLXXII Test Case Halaman Menu Karyawan .............................................. 234 Tabel CLXXIII Test Case Halaman Menu Suplier ................................................. 236 Tabel CLXXIV Test Case Halaman Menu Kendaraan ........................................... 238 Tabel CLXXV Test Case Halaman Menu Giro ...................................................... 239 Tabel CLXXVI Test Case Halaman Menu Transaksi Penjualan ............................ 240 Tabel CLXXVII Test Case Halaman Menu History Penjualan ............................... 243 Tabel CLXXVIII Test Case Halaman Menu Retur Jual .......................................... 243 Tabel CLXXIX Test Case Halaman Menu History Retur Jual ................................ 248 Tabel CLXXX Test Case Halaman Menu Pembayaran Piutang ............................ 249 Tabel CLXXXI Test Case Halaman Menu History Pembayaran Piutang ............... 250 Tabel CLXXXII Test Case Halaman Menu Transaksi Pembelian .......................... 250 Tabel CLXXXIII Test Case Halaman Menu History Transaksi Pembelian ............. 253 Tabel CLXXXIV Test Case Halaman Menu Retur Beli .......................................... 254 Tabel CLXXXV Test Case Halaman Menu History Retur Beli ............................... 256 Tabel CLXXXVI Test Case Halaman Menu Pembayaran Hutang ......................... 257 Tabel CLXXXVII Test Case Halaman History Pembayaran Hutang ...................... 258 Tabel CLXXXVIII Test Case Halaman Menu Penerimaan Barang ........................ 259 Tabel CLXXXIX Test Case Halaman Menu History Penerimaan Barang .............. 262 Tabel CXC Test Case Halaman Menu Transaksi D/O........................................... 263 Tabel CXCI Test Case Halaman History Transaksi D/O ....................................... 265 Tabel CXCII Test Case Halaman Menu Pengambilan D/O ................................... 265 Tabel CXCIII Test Case Halaman Menu History Pengambilan D/O ...................... 269 Tabel CXCIV Test Case Halaman Menu Atur Pengiriman .................................... 270 Tabel CXCV Test Case Halaman Menu History Kiriman ....................................... 271 Tabel CXCVI Test Case Halaman Form pop up Kiriman Berangkat...................... 272 Tabel CXCVII Test Case Halaman Menu Tutup Stok ............................................ 273 Tabel CXCVIII Test Case Halaman Menu Rekapitulasi Barang ............................ 274 Tabel CXCIX Test Case Halaman Menu Kirim Informasi ke Gudang .................... 275 Tabel CC Test Case Halaman Menu Data dari Server .......................................... 275 Tabel CCI Test Case Halaman Menu Data dari Gudang....................................... 276 Tabel CCII Test Case Halaman Form pop up Barang Jual ................................... 278
xvii
Universitas Maranatha
Tabel CCIII Test Case Halaman Menu Laporan Penjualan ................................... 280 Tabel CCIV Test Case Halaman Menu Laporan Retur Jual .................................. 282 Tabel CCV Test Case Halaman Menu Laporan Pembayaran Piutang .................. 284 Tabel CCVI Test Case Halaman Menu Laporan Pembelian.................................. 286 Tabel CCVII Test Case Halaman Menu Laporan Penerimaan Barang .................. 287 Tabel CCVIII Test Case Halaman Menu Laporan Retur Beli ................................. 289 Tabel CCIX Test Case Halaman Menu Laporan Pembayaran Hutang .................. 291 Tabel CCX Test Case Halaman Menu Laporan D/O ............................................. 292 Tabel CCXI Test Case Halaman Menu Laporan Pengambilan D/O ...................... 294 Tabel CCXII Test Case Halaman Menu Laporan Pengiriman Barang ................... 296 Tabel CCXIII Test Case Halaman Menu Laporan Rekapitulasi Barang................. 298 Tabel CCXIV Test Case Halaman Menu Laporan Perhitungan Laba-Rugi............ 299
xviii
Universitas Maranatha
