universitas bina nusantara school of information … · modul material management, production...

viii

UNIVERSITAS BINA NUSANTARA

School of Information Systems Skripsi Sarjana Komputer

Semester Ganjil tahun 2011/2012

IMPLEMENTASI SISTEM ERP DENGAN TOOL SAP MODUL MATERIAL MANAGEMENT, PRODUCTION PLANNING DAN

FINANCIAL ACCOUNTING PADA PT. J

Phandryanto 1200968975 Josef 1200976516 Teodorus 1200978534 Abstrak

Tujuan Penelitian adalah menganalisis proses bisnis yang berjalan dan mengembangkan business blueprint untuk menjawab gap yang ada pada proses bisnis berjalan dengan proses binis pada SAP. Business blueprint yang dibahas berkaitan dengan proses produksi, pembelian serta pembayaran ke vendor. Selain itu dibahas juga requirement yang dibutuhkan oleh perusahaan dalam hal pengimplementasian SAP ini. Metode yang digunakan adalah metodologi ASAP (Accelerated SAP), yang merupakan standar dari SAP dalam melakukan pengimplementasian di berbagai perusahaan. User requirement diperoleh dari wawancara langsung dengan business process owner yang dipilih untuk membahas masalah dan kebutuhan user dalam menjalankan proses bisnis pada PT. J. Hasil yang dicapai adalah pengembangan business blueprint yang terkait dengan kegiatan produksi, pembelian serta pembayaran ke vendor pada PT. J. Selain itu, dibuat juga beberapa functional specification untuk menjawab beberapa requirement dari Business process owner yang tidak ter-cover oleh SAP. Ditambah lagi dengan pengembangan yang dibuat oleh tim berupa aplikasi dengan bahasa pemrogaman ABAP untuk mendukung aktivitas permintaan data material baru. Simpulan yang didapat adalah munculnya beberapa gap antara proses bisnis berjalan dan proses bisnis pada SAP yang didapat dari hasil analisis kebutuhan melalui wawancara langsung dengan Business process owner, hal inilah yang men-trigger tim untuk menyusun business blueprint untuk menjawap gap tersebut. Selain itu hal-hal lain seperti functional specification dan pengembangan aplikasi pada SAP juga dikembangkan untuk mendukung proses bisnis pada PT. J. Kata Kunci Implementasi SAP, ERP, Material Management, Production Planning, Financial Accounting

ix

PRAKATA

Puji syukur kami panjatkan kepada Tuhan Yang Maha Esa, atas berkat dan

rahmat-Nya atas terselesaikannya penulisan laporan yang berjudul “Implementasi

Sistem ERP Dengan Tool SAP Modul Material Management, Production Planning dan

Financial Accounting Pada PT. J.” ini dalam rangka memenuhi persyaratan penyelesaian

Jenjang Strata-1 Ilmu Komputer di Universitas Bina Nusantara, Jakarta.

Pada kesempatan ini, penulis juga ingin menyampaikan rasa terima kasih sebesar-

besarnya atas segala bentuk dukungan, nasehat, petunjuk, doa, saran, serta bimbingan

dalam penyelesaian laporan ini. Ucapan terima kasih yang sebesar-besarnya penulis

tujukan kepada:

1. Bapak Prof. Dr. Ir. Harjanto Prabowo, MM selaku Rektor Universitas Bina

Nusantara, Jakarta.

2. Bapak Johan, S.Kom., MM., selaku Head of School of Information Systems dan

Head of Information Systems Department.

3. Ibu Yanti, S.Kom., MM., selaku pembimbing selama penulisan laporan ini.

4. Dosen-dosen Universitas Bina Nusantara yang telah membimbing selama

perkuliahan, sehingga banyak memberikan masukan kepada penulis untuk

menyelesaikan laporan ini.

5. Ibu Mercia Saptawati Natio selaku IT Department Head pada PT. Dynaplast.

6. Bapak Sucipto Darmaputra selaku Application Development Manager pada PT.

Dynaplast.

7. Seluruh anggota Tim SAP PT. Dynaplast yang telah mendukung penulis, baik

berupa bimbingan maupun data fakta yang diberikan kepada penulis.

x

8. Seluruh keluarga penulis yang telah memberikan doa, dukungan, dan semangat

selama penulisan laporan ini.

9. Semua pihak yang telah banyak membantu penyusunan laporan ini baik secara

langsung maupun tidak langsung yang mungkin terlewatkan dan tidak dapat

disebutkan satu persatu.

Kritik dan saran yang membangun akan diterima untuk pengembangan penulisan

selanjutnya. Akhir kata, penulis juga berharap laporan ini akan dapat bermanfaat bagi

semua pihak yang memerlukannya.

Jakarta, 21 Januari 2012

Penulis

xi

DAFTAR ISI

Halaman Judul Luar ......................................................................................................... i

Halaman Judul Dalam .................................................................................................... ii

Halaman Persetujuan Hard Cover ................................................................................. iii

Lembar Pernyataan Dewan Penguji…………………….……………………………...iv

Lembar Pemberian Hak Cipta Non Eksklusif………….……………………………...vii

ABSTRAK .................................................................................................................. viii

PRAKATA ..................................................................................................................... ix

DAFTAR ISI .................................................................................................................. xi

DAFTAR GAMBAR ................................................................................................ xxiii

DAFTAR TABEL ...................................................................................................... xxix

BAB 1 PENDAHULUAN .............................................................................................. 1

1.1 Latar Belakang ..................................................................................................... 1

1.2 Ruang Lingkup ..................................................................................................... 3

1.3 Tujuan Manfaat .................................................................................................... 4

1.4 Metodologi ........................................................................................................... 5

1.5 Sistematika Penulisan ........................................................................................... 7

BAB 2 LANDASAN TEORI ...................................................................................... 10

2.1 Teori-Teori Dasar/Umum ................................................................................... 10

2.1.1 Sistem ERP ................................................................................................. 10

2.1.1.1 Pengertian ERP ................................................................................... 10

2.1.1.2 Modul-Modul ERP.............................................................................. 11

2.1.2 Implementasi Sistem ERP .......................................................................... 13

xii

2.1.2.1 Pengertian Implementasi ..................................................................... 13

2.1.2.2 Pendekatan Implementasi Sistem ....................................................... 14

2.1.3 Sistem Produksi .......................................................................................... 14

2.1.3.1 Pengertian Sistem Produksi ................................................................ 14

2.1.3.2 Perencanaan Produksi ......................................................................... 15

2.1.4 Sistem Pembelian ....................................................................................... 16

2.1.5 Sistem Pembayaran ..................................................................................... 17

2.1.5.1 Pengertian Sistem Pembayaran ........................................................... 17

2.1.5.2 Aktivitas Umum dari Proses Pembayaran .......................................... 18

2.1.5.3 Akuntansi untuk Pembelian Persediaan .............................................. 21

2.1.5.4 Rekonsiliasi Bank ............................................................................... 21

2.1.5.5 Mengembangkan Sebuah Sistem Akuntansi ....................................... 22

2.1.5.6 Bank Statement .................................................................................... 23

2.1.5.7 Proses Rekonsiliasi Bank .................................................................... 24

2.2 Teori-Teori Khusus ............................................................................................ 25

2.2.1 SAP ............................................................................................................. 25

2.2.1.1 SAP ECC Core (6.0) ........................................................................... 25

2.2.1.2 Metodologi ASAP ............................................................................... 26

2.2.2 SAP Modul Production Planning ............................................................... 31

2.2.2.1 Siklus Production Planning ................................................................ 31

2.2.2.1.1 Material Requirement Planning (MRP) ...................................... 31

2.2.2.1.2 Production Order Creation ......................................................... 32

2.2.2.1.3 Capacity Requirement Planning ................................................. 36

2.2.2.1.4 Production Execution .................................................................. 38

2.2.2.2 Master Data ........................................................................................ 44

xiii

2.2.2.2.1 Bill of material ............................................................................ 44

2.2.2.2.2 Work Center ................................................................................ 47

2.2.2.2.3 Routing ........................................................................................ 49

2.2.3 SAP Modul Material Management ............................................................ 50

2.2.3.1 Pengertian Material Management ....................................................... 50

2.2.3.2 Persediaan ........................................................................................... 51

2.2.3.3 Material ............................................................................................... 53

2.2.3.4 Material Management ......................................................................... 55

2.2.3.5 Siklus Material Management dalam SAP R/3 .................................... 58

2.2.4 SAP Modul Financial Accounting ............................................................ 60

2.2.4.1 House Bank ......................................................................................... 60

2.2.4.2 Chart of Account ................................................................................. 60

2.2.4.3 Fiscal Year .......................................................................................... 60

2.2.4.4 Payment Program Configuration ....................................................... 61

2.2.4.5 Profit Center Accounting .................................................................... 62

2.2.4.6 Segment ............................................................................................... 62

2.2.4.7 Cost Center Accounting ...................................................................... 63

BAB 3 PROJECT PROFILE ........................................................................................ 64

3.1 Gambaran Umum Perusahaan ............................................................................ 64

3.1.1 Sejarah Perusahaan ..................................................................................... 64

3.1.2 Visi dan Misi Perusahaan ........................................................................... 64

3.1.3 Struktur Organisasi PT. J ............................................................................ 66

3.2 Proses Bisnis PT.J ............................................................................................ 116

3.2.1 Proses Produksi ......................................................................................... 116

3.2.2 Proses Pembelian (Purchasing) ................................................................ 129

xiv

3.2.3 Proses Pembayaran (Payment) ................................................................. 132

3.3 Project SAP pada PT. J ................................................................................... 135

3.3.1 Struktur Project TEAM ............................................................................ 135

3.3.1.1 Nama Tim ......................................................................................... 135

3.3.1.2 Slogan Tim ........................................................................................ 135

3.3.1.3 Logo Tim .......................................................................................... 135

3.3.1.4 Struktur Organisasi “TEAM” ........................................................... 136

3.3.1.5 Tanggung Jawab dan Wewenang ...................................................... 137

3.3.2 Objectives ................................................................................................. 140

3.3.3 Jadwal Implementasi ................................................................................ 141

3.3.4 Project Scope ............................................................................................ 142

3.3.5 User Role .................................................................................................. 143

3.4 Masalah yang Ditemukan ................................................................................. 144

3.5 Rencana Penyelesaian Masalah ........................................................................ 145

3.6 Peran ................................................................................................................. 146

3.7 Solusi yang Ditawarkan .................................................................................... 147

3.8 Analisis Kebutuhan…………………………………………………………...148

3.8 Length of Effort ................................................................................................ 148

BAB 4 RANCANGAN SISTEM .............................................................................. 159

4.1 Business Blueprint ............................................................................................ 159

4.1.1 Pengenalan Business Blueprint ................................................................. 164

4.1.2 Pengenalan Enterprise Structure .............................................................. 164

4.1.2.1 Company Code .................................................................................. 164

4.1.2.2 Plant .................................................................................................. 164

4.1.2.3 Storage Location ............................................................................... 165

xv

4.1.2.4 Warehouse ......................................................................................... 165

4.1.3 Assignment ................................................................................................ 165

4.1.3.1 Integrasi Struktur Organisasi Material Management dengan

Warehouse Management ................................................................... 166


Production Planning ......................................................................... 166


Financial Controlling ....................................................................... 167

4.1.4 Detail Rancangan ...................................................................................... 167

4.1.5 Pemetaan berdasarkan Modul ................................................................... 171

4.1.5.1 Pemetaan pada Modul Production Planning .................................... 171

4.1.5.1.1 Master Data .............................................................................. 171

4.1.5.1.1.1 Bill of material ................................................................... 171

4.1.5.1.1.1.1 BOM Usage ............................................................... 172

4.1.5.1.1.1.2 Base Quantity ............................................................. 172

4.1.5.1.1.1.3 Multi Level BOM ....................................................... 173

4.1.5.1.1.2 Work Center....................................................................... 174

4.1.5.1.1.2.1 Work Center Category ............................................... 174

4.1.5.1.1.2.2 Standard Value Key Formula .................................... 174

4.1.5.1.1.2.3 Set up Type Key ......................................................... 175

4.1.5.1.1.2.4 Person Responsible .................................................... 176

4.1.5.1.1.2.5 Location ..................................................................... 176

4.1.5.1.1.2.6 Supply Area ................................................................ 177

4.1.5.1.1.2.7 Shift Sequence ............................................................ 177

4.1.5.1.1.2.8 Capacity Planner Group ............................................ 178

xvi

4.1.5.1.1.2.9 Naming Convention ................................................... 179

4.1.5.1.1.3 Routing .............................................................................. 179

4.1.5.1.1.3.1 Routing Usage ........................................................... 180

4.1.5.1.1.3.2 Control Key ................................................................ 180

4.1.5.1.1.3.3 Standard Value .......................................................... 182

4.1.5.1.1.4 Production Version ............................................................ 183

4.1.5.1.2 Production Planning ................................................................. 183

4.1.5.1.2.1 Planning Strategy .............................................................. 183

4.1.5.1.2.2 MRP Controller ................................................................. 184

4.1.5.1.2.3 Procurement Type ............................................................. 185

4.1.5.1.2.4 Activate Requirement Planning ......................................... 185

4.1.5.1.2.5 Capacity Planning ............................................................. 186

4.1.5.1.2.6 Planned Order Converting ................................................ 187

4.1.5.1.3 Production Execution ................................................................ 187

4.1.5.1.3.1 Production Order Execution ............................................. 187

4.1.5.1.3.2 Production Order Release ................................................. 187

4.1.5.1.4 Production Goods Movement .................................................... 189

4.1.5.1.4.1 Production Replenishment................................................. 189

4.1.5.1.4.2 Goods Issue to Production Order ...................................... 191

4.1.5.1.4.3 Goods Receipt Production Order ...................................... 192

4.1.5.1.5 Production Confirmation .......................................................... 194

4.1.5.1.6 Closed Production Order .......................................................... 204

4.1.5.2 Pemetaan pada Modul Material Management .................................. 205

4.1.5.2.1 Master Data .............................................................................. 205

4.1.5.2.1.1 Pemetaan Material Type .................................................... 205

xvii

4.1.5.2.1.2 Material valuation strategy................................................ 207

4.1.5.2.1.3 Material Group .................................................................. 207

4.1.5.2.1.4 Material Number ............................................................... 209

4.1.5.2.1.5 Unit of Measure ................................................................. 210

4.1.5.2.1.6 Term of Payment ................................................................ 211

4.1.5.2.2 Purchasing Documents ............................................................. 212

4.1.5.2.2.1 Purchasing Document Type .............................................. 213

4.1.5.2.2.2 Item Category Group ......................................................... 214

4.1.5.2.2.3 Account Assignment Object ............................................... 214

4.1.5.2.2.4 Purchase Requisition ......................................................... 214

4.1.5.2.2.5 Purchase Order ................................................................. 215

4.1.5.2.2.6 Goods Movement ............................................................... 216

4.1.5.3 Pemetaan pada Modul Financial Accounting ................................... 218

4.1.5.3.1 Master Data .............................................................................. 218

4.1.5.3.1.1 Account Group ................................................................... 218

4.1.5.3.1.2 Account Payable G/L Account .......................................... 218

4.1.5.3.1.3 Vendor Account Group ...................................................... 220

4.1.5.3.1.4 Cash G/L Account ............................................................. 220

4.1.5.3.1.5 Bank Details ...................................................................... 221

4.1.5.3.1.6 Cost Center ........................................................................ 222

4.1.5.3.2 Invoice Receipt for Invoice ........................................................ 223

4.1.6 Ruang Lingkup Proses Bisnis (PP-MM-FI) ............................................. 224

4.1.7 Business Scenario ..................................................................................... 228

4.1.7.1 Inhouse Production for Sales ............................................................ 228

4.1.7.2 Perencanaan Kebutuhan Material Produksi ...................................... 231

xviii

4.1.8 Business Process ....................................................................................... 234

4.1.8.1 Business Process Production Planning ............................................ 234

4.1.8.1.1 Maintain Bill of material ........................................................... 234

4.1.8.1.2 Maintain Routing ...................................................................... 236

4.1.8.1.3 Maintain Work Center ............................................................... 238

4.1.8.1.4 Production Planning inhouse .................................................... 239

4.1.8.1.5 Production Execution Inhouse .................................................. 241

4.1.8.1.6 Closed Production Order for Inhouse ....................................... 246

4.1.8.1.7 Production Planning for Mixing ............................................... 247

4.1.8.1.8 Production Execution for Mixing .............................................. 248

4.1.8.1.9 Closed Mixing Production Order .............................................. 249

4.1.8.2 Business Process Material Management .......................................... 250

4.1.8.2.1 Purchasing Requisition-Stock ................................................... 250

4.1.8.2.2 Purchasing Order-Stock ............................................................ 252

4.1.8.2.3 Goods Receipt-Stock ................................................................. 255

4.1.8.2.4 Proses Pengakuan Hutang Dagang ............................................ 257

4.1.8.2.5 Goods Issue Return to Vendor .................................................. 258

4.1.8.2.6 Goods Issue Consumption to Production Order ....................... 260

4.1.8.2.7 Goods Receipt Production Order .............................................. 262

4.1.8.3 Business Process Financial Accounting ........................................... 264

4.1.8.3.1 Bank Reconciliation .................................................................. 264

4.2 Functional specification ................................................................................... 267

4.2.1 Functional specification Production Planning ......................................... 267

4.2.1.1 Down Time Confirmation ................................................................. 267

4.2.1.1.1 Requirement Details .................................................................. 267

xix

4.2.1.1.2 Transparent Tables/Logical Database Used ............................ 268

4.2.1.1.3 Sample File ................................................................................ 269

4.2.1.1.4 Input Screen Format ................................................................. 269

4.2.1.1.5 Program Requirements/Pseudocode/Flow Charts of the

Program ................................................................................... 269

4.2.1.1.6 Output Layout/Log .................................................................... 270

4.2.1.2 Reverse Down Time Confirmation .................................................... 271



4.2.1.2.3 Sample File ................................................................................ 272



Program ................................................................................... 273


4.2.1.3 Automatic Maintain Dynamic Bin when Saving Production Order . 274




Program ................................................................................... 275

4.2.1.4 User Exit MWMTO008 Modification .............................................. 276





Program .................................................................................... 278

xx

4.2.1.5 Create Form Bukti Pengeluaran Barang .......................................... 279





Program ................................................................................... 284

4.2.1.5.5 Output Layout ............................................................................ 287

4.2.1.6 Create Production Efficiency Report ................................................ 288



4.2.1.6.3 Sample File ................................................................................ 290



Program ................................................................................... 291


4.2.1.7 Create Material Efficiency Report .................................................... 301



4.2.1.7.3 Sample File ................................................................................ 301



Program .................................................................................... 302


4.2.2 Functional specification Material Management ...................................... 303

4.2.2.1 Inventory Aging report ...................................................................... 303

xxi



4.2.2.1.3 Sample File ................................................................................ 305



Program .................................................................................... 305

4.2.2.1.5.1 Perhitungan Logical ........................................................ 305

4.2.2.1.5.2 Database Execution ........................................................ 309


4.2.2.1.6.1 Output Layout pada Report ............................................. 311

4.2.2.1.6.2 Table Required Output .................................................... 311

4.2.2.2 Term of Payment Report ................................................................... 313



4.2.2.2.3 Sample File ................................................................................ 314



Program ................................................................................... 315

4.2.2.2.5.1 Perhitungan Logical ........................................................ 315

4.2.2.2.5.2 Database Execution ........................................................ 315


4.2.3 Functional specification Financial Accounting ....................................... 320

4.2.3.1 Print Bukti Pembayaran .................................................................... 320



xxii

4.2.3.1.3 Sample File ................................................................................ 321



Program .................................................................................... 322


4.2.3.2 Aging report for AP .......................................................................... 323



4.2.3.2.3 Sample File ................................................................................ 324



Program ................................................................................... 325


4.3 Pengembangan Lain-lain .................................................................................. 326

BAB 5 SIMPULAN DAN SARAN ........................................................................... 345

5.1 Simpulan ........................................................................................................... 345

5.2 Saran ................................................................................................................. 347

DAFTAR PUSTAKA ................................................................................................. 348

xxiii

DAFTAR GAMBAR

Gambar 2.1 Input-ouput sistem produksi ...................................................................... 15

Gambar 2.2 Proses rekonsiliasi bank ............................................................................ 24

Gambar 2.3 The Accelerated SAP Road Map ............................................................... 26

Gambar 2.4 Project Preparation and Business Blueprint Phases ................................. 28

Gambar 2.5 Production Planning Cycle ....................................................................... 31

Gambar 2.6 Siklus pada Production Order .................................................................. 32

Gambar 2.7 Gambaran Keseluruhan dari Production Order Creation ......................... 34

Gambar 2.8 Formulas for Capacity Requirement ......................................................... 37

Gambar 2.9 Available Capacity .................................................................................... 38

Gambar 2.10 Single-Level Bill of material ................................................................... 46

Gambar 2.11 Multi Level Bill of material ..................................................................... 47

Gambar 2.12 Kegunaan dari data Work Center ............................................................ 49

Gambar 2.13 Routing: Sequences ................................................................................. 50

Gambar 3.1 Struktur Organisasi PT. J .......................................................................... 66

Gambar 3.2 Struktur organisasi departemen blow moulding ........................................ 67

Gambar 3.3 Struktur organisasi departemen decoration............................................... 71

Gambar 3.4 Struktur organisasi departemen engineering plant I ................................. 74

Gambar 3.5 Struktur organisasi departemen engineering plant II ................................ 79

Gambar 3.6 Struktur organisasi departemen injection moulding .................................. 82

Gambar 3.7 Struktur organisasi departemen toothbrush............................................... 85

Gambar 3.8 Struktur organisasi departemen logistik .................................................... 86

Gambar 3.9 Struktur organisasi departemen finance and accounting .......................... 90

Gambar 3.10 Struktur organisasi departemen information technology ........................ 99

xxiv

Gambar 3.11 Struktur organisasi departemen quality insurance (QA) ....................... 101

Gambar 3.12 Struktur organisasi departemen product & development ...................... 106

Gambar 3.13 Struktur organisasi departemen purchasing .......................................... 110

Gambar 3.14 Proses perencanaan dan pengendalian produksi (bagian 1) .................. 116



Gambar 3.17 Proses pelaksanaan produksi (bagian 1) ................................................ 120

Gambar 3.18 Proses pelaksanaan produksi (bagian 2) ................................................ 121

Gambar 3.19 Proses raw material preparation (bagian 1) ......................................... 123

Gambar 3.20 Proses raw material preparation (bagian 2) ......................................... 124

Gambar 3.21 Proses inline dan outgoing inspection (bagian 1).................................. 126

Gambar 3.22 Proses inline dan outgoing inspection (bagian 2).................................. 127

Gambar 3.23 Proses pembelian (bagian 1) ................................................................. 129

Gambar 3.24 Proses pembelian (bagian 2) ................................................................. 130

Gambar 3.25 Proses pembayaran (bagian 1)............................................................... 132

Gambar 3.26 Proses pembayaran (bagian 2)............................................................... 133

Gambar 3.27 Logo “TEAM”....................................................................................... 135

Gambar 3.28 Struktur organisasi “TEAM” ................................................................. 136

Gambar 4.1 Hubungan struktur organisasi MM dan WM .......................................... 166

Gambar 4.2 Hubungan struktur organisasi MM dan PP ............................................. 166

Gambar 4.3 Hubungan struktur organisasi MM dan FI/CO ....................................... 167

Gambar 4.4 Multi Level BOM .................................................................................... 173

Gambar 4.5 Production version .................................................................................. 183

Gambar 4.6 Form production order............................................................................ 189

Gambar 4.7 Transfer material supply to dynamic bin ................................................ 190

xxv

Gambar 4.8 Form bukti pengeluaran barang/material(stock transfer)........................ 191

Gambar 4.9 Form goods issue slip .............................................................................. 192

Gambar 4.10 Form bukti pengeluaran barang/material (goods receipt) ..................... 193

Gambar 4.11 Ruang lingkup proses bisnis (PP-MM-FI) ............................................ 224

Gambar 4.12 Business scenario inhouse production for sales (bagian 1) .................. 228

Gambar 4.13 Business scenario inhouse production for sales (bagian 2) .................. 229

Gambar 4.14 Business scenario perencanaan kebutuhan material produksi .............. 231

Gambar 4.15 Maintain bill of material ....................................................................... 234

Gambar 4.16 Maintain Routing................................................................................... 236

Gambar 4.17 Maintain work center ............................................................................ 238

Gambar 4.18 Production planning inhouse (bagian 1) ............................................... 239

Gambar 4.19 Production planning inhouse (bagian 2) ............................................... 240

Gambar 4.20 Production Execution inhouse (bagian 1) ............................................. 241




Gambar 4.24 Closed production order for inhouse .................................................... 246

Gambar 4.25 Production planning for mixing ............................................................ 247

Gambar 4.26 Production execution for mixing ........................................................... 248

Gambar 4.27 Closed mixing production order ........................................................... 249

Gambar 4.28 Purchasing requisition-stock ................................................................ 250

Gambar 4.29 Purchasing order-stock ......................................................................... 252

Gambar 4.30 Dokumen purchase order ..................................................................... 254

Gambar 4.31 Goods receipt-stock ............................................................................... 255

Gambar 4.32 Dokumen surat tanda penerimaan barang ............................................ 256

xxvi

Gambar 4.33 Proses pengakuan hutang dagang ......................................................... 257

Gambar 4.34 Goods issue return to vendor ................................................................ 258

Gambar 4.35 Goods issue consumption to production order ..................................... 260

Gambar 4.36 Goods receipt production order ............................................................ 262

Gambar 4.37 Bank reconciliation ............................................................................... 264

Gambar 4.38 Dokumen rekonsiliasi bank .................................................................. 266

Gambar 4.39 Input screen format pada user exit MWMTO008 modification ............ 277

Gambar 4.40 Transparent tables pada user exit MWMTO008 modification ............. 277

Gambar 4.41 Transparent tables pada create form bukti pengeluaran barang ........... 280

Gambar 4.42 Table AFRU .......................................................................................... 280

Gambar 4.43 Table AFPO........................................................................................... 281

Gambar 4.44 Table AFVC .......................................................................................... 281

Gambar 4.45 Table CRHD .......................................................................................... 282

Gambar 4.46 Table MARM ........................................................................................ 282

Gambar 4.47 Table TC24 ............................................................................................ 283

Gambar 4.48 Table MAKT ......................................................................................... 283

Gambar 4.49 Contoh tampilan bukti penerimaan barang .......................................... 284

Gambar 4.50 Penomoran field pada bukti pengeluaran barang .................................. 285

Gambar 4.51 Contoh print out bukti pengeluaran barang ........................................... 287

Gambar 4.52 Hubungan antar table pada create production effiency report ............. 291

Gambar 4.53 Table MCHB ......................................................................................... 311

Gambar 4.54 Table MSEG (bagian 1) ........................................................................ 311

Gambar 4.55 Table MSEG (bagian 2) ........................................................................ 312

Gambar 4.56 Table MBEW ........................................................................................ 312

Gambar 4.57 Table MKPF (bagian 1) ........................................................................ 312

xxvii

Gambar 4.58 Table MKPF (bagian 2) ........................................................................ 312

Gambar 4.59 Struk bukti pembayaran bank ................................................................ 322

Gambar 4.60 Output Layout pada aging report for AP .............................................. 325

Gambar 4.61 Tampilan awal program ........................................................................ 326

Gambar 4.62 Tampilan awal menu material master requsition ................................. 327

Gambar 4.63 Tampilan possible entries untuk pilihan input-an user ......................... 328

Gambar 4.64 Tampilan program menu material master request yang telah

di-input ................................................................................................... 329

Gambar 4.65 Dialog box identifikasi plant ................................................................. 329

Gambar 4.66 Tampilan untuk user meng-input data material master request ........... 330

Gambar 4.67 Tampilan untuk user meng-input data material master request yang

telah di-input ......................................................................................... 331

Gambar 4.68 Tampilan view basic data dan classification ......................................... 332

Gambar 4.69 Tampilan view sales ............................................................................. 332

Gambar 4.70 Tampilan view purchasing dan MRP .................................................... 333

Gambar 4.71 Tampilan view work scheduling dan warehouse ................................... 333

Gambar 4.72 Tampilan view accounting .................................................................... 334

Gambar 4.73 Dialog box untuk memverifikasi valuation class .................................. 334

Gambar 4.74 Tampilan request number yang muncul ................................................ 335

Gambar 4.75 Tampilan error saat memvalidasi proses extend ................................... 336

Gambar 4.76 Tampilan menu request status ............................................................... 337

Gambar 4.77 Tampilan daftar request ........................................................................ 338

Gambar 4.78 Tampilan untuk melihat data input-an user........................................... 339

Gambar 4.79 Tampilan untuk melihat secara detail data input-an user ..................... 340

Gambar 4.80 Tampilan data input-an user yang diganti ............................................ 341

xxviii

Gambar 4.81 Tampilan notofikasi new material number ........................................... 342

Gambar 4.82 Tampilan untuk meng-approve pembuatan material secara massal ..... 342

Gambar 4.83 Tampilan konfirmasi request number yang di-approve ........................ 343

Gambar 4.84 Tampilan auto-refresh pada window ..................................................... 343

Gambar 4.85 Tampilan e-mail notofikasi ................................................................... 344

xxix

DAFTAR TABEL

Tabel 3.1 Identitas posisi blow moulding section head I, II, III................................. 67

Tabel 3.2 Identitas posisi MPC process section head ................................................ 69

Tabel 3.3 Identitas posisi trial & setting section head ............................................... 70

Tabel 3.4 Identitas posisi decoration department head/manager/assistant manager 71

Tabel 3.5 Identitas posisi process decoration section head ....................................... 73

Tabel 3.6 Identitas posisi engineering department head/manager/associate

manager ..................................................................................................... 74

Tabel 3.7 Identitas posisi maintenance utility section head ....................................... 76

Tabel 3.8 Identitas posisi engineering development section head ............................. 77

Tabel 3.9 Identitas posisi workshop section head ...................................................... 78

Tabel 3.10 Identitas posisi maintenance section head plant II .................................. 79

Tabel 3.11 Identitas posisi workshop section head plant II ....................................... 81

Tabel 3.12 Identitas posisi infection moulding section head ..................................... 82

Tabel 3.13 Identitas posisi MPC section head ........................................................... 83

Tabel 3.14 Identitas posisi toothbrush section head .................................................. 85

Tabel 3.15 Identitas posisi PPIC section head ........................................................... 87

Tabel 3.16 Identitas posisi store keeper ..................................................................... 88

Tabel 3.17 Identitas posisi finance & administration manager ................................. 90

Tabel 3.18 Identitas posisi finance section head ........................................................ 92

Tabel 3.19 Identitas posisi general accounting section head .................................... 94

Tabel 3.20 Identitas posisi tax section head............................................................... 95

Tabel 3.21 Identitas posisi costing section head ........................................................ 96

Tabel 3.22 Identitas posisi management accounting section head ............................ 97

xxx

Tabel 3.23 Identitas posisi information technology offer........................................... 99

Tabel 3.24 Identitas posisi QA manager ................................................................. 102

Tabel 3.25 Identitas posisi QA section head ............................................................ 103

Tabel 3.26 Identitas posisi product & development department head ..................... 106

Tabel 3.27 Identitas posisi product engineering section head/supervisor ............... 107

Tabel 3.28 Identitas purchasing officer ................................................................... 110

Tabel 3.29 Identitas posisi technical purchasing section head ................................ 112

Tabel 3.30 Identitas posisi non technical purchasing section head ......................... 113

Tabel 3.31 Identitas posisi purchasing administration ............................................ 114

Tabel 3.32 Jadwal implementasi .............................................................................. 141

Tabel 3.33 User role ................................................................................................ 143

Tabel 3.34 Length of effort ....................................................................................... 148

Tabel 4.1 Storage location ....................................................................................... 165

Tabel 4.2 Rincian organizational structure pada PT. J ........................................... 167

Tabel 4.3 Storage bin ............................................................................................... 170

Tabel 4.4 Rincian multi level BOM pada level finished goods ................................ 173

Tabel 4.5 Work center category ............................................................................... 174

Tabel 4.6 Standard value key ................................................................................... 175

Tabel 4.7 Setup type key ........................................................................................... 175

Tabel 4.8 Person responsible ................................................................................... 176

Tabel 4.9 Location ................................................................................................... 176

Tabel 4.10 Supply area ............................................................................................ 177

Tabel 4.11 Shift sequence ......................................................................................... 177

Tabel 4.12 Capacity planner group ......................................................................... 178

Tabel 4.13 Naming convetion untuk work center .................................................... 179

xxxi

Tabel 4.14 Control key for operations ..................................................................... 180

Tabel 4.15 MRP controller ...................................................................................... 184

Tabel 4.16 Procurement type ................................................................................... 185

Tabel 4.17 Order type .............................................................................................. 187

Tabel 4.18 Unplanned break down .......................................................................... 194

Tabel 4.19 Planned break down............................................................................... 195

Tabel 4.20 Reason type for scrapping...................................................................... 195

Tabel 4.21 Material type .......................................................................................... 205

Tabel 4.22 Material type characteristic ................................................................... 206

Tabel 4.23 Perbedaan standard price dengan Moving average price ...................... 207

Tabel 4.24 Material group ....................................................................................... 208

Tabel 4.25 Hubungan material type, material group dan valuation strategy .......... 208

Tabel 4.26 Penomoran material per material type ................................................... 209

Tabel 4.27 Unit of measure ...................................................................................... 211

Tabel 4.28 Term of payments ................................................................................... 212

Tabel 4.29 Purchasing document type ..................................................................... 213

Tabel 4.30 Item category group ............................................................................... 214

Tabel 4.31 Account assignment object ..................................................................... 214

Tabel 4.32 Release Strategy untuk purchase requisition ......................................... 215

Tabel 4.33 Release Strategy untuk purchase order ................................................. 216

Tabel 4.34 Good movement type .............................................................................. 217

Tabel 4.35 Penomoran material document .............................................................. 217

Tabel 4.36 Account group ........................................................................................ 218

Tabel 4.37 Reconciliation account ........................................................................... 219

Tabel 4.38 Vendor account group ............................................................................ 220

xxxii

Tabel 4.39 Cash in G/L account .............................................................................. 220

Tabel 4.40 Bank details............................................................................................ 221

Tabel 4.41 Cost center ............................................................................................. 222

Tabel 4.42 Document type pada invoice receipt and payment ................................. 223

Tabel 4.43 Down time confirmation table................................................................ 267

Tabel 4.44 Down time problem type table ............................................................... 267

Tabel 4.45 Shift definition table pada down time confirmation ............................... 268

Tabel 4.46 Transparent table pada down time confirmation ................................... 268

Tabel 4.47 Sample file pada down time confirmation .............................................. 269

Tabel 4.48 Input screen format pada down time confirmation ................................ 269

Tabel 4.49 Logical flow pada down time confirmation ............................................ 270

Tabel 4.50 Output layout pada down time confirmation (bagian 1) ........................ 270



Tabel 4.53 Transparent table pada reverse down time confirmation ...................... 272

Tabel 4.54 Sample file pada reverse down time confirmation ................................. 272

Tabel 4.55 Input screen format pada reverse down time confirmation ................... 272

Tabel 4.56 Logical flow pada reverse down time confirmation ............................... 273

Tabel 4.57 Output layout pada reverse down time confirmation (bagian 1) ............ 273



Tabel 4.60 Transparent tables pada automatic maintain dynamic bin .................... 275

Tabel 4.61 Logical flow pada automatic maintain dynamic bin .............................. 275

Tabel 4.62 Logical flow pada user exit MWMTO008 modification ........................ 278

Tabel 4.63 Input screen format pada create form bukti pengeluaran barang .......... 284

xxxiii

Tabel 4.64 Field pada create production efficiency report ...................................... 288

Tabel 4.65 Transparent tables pada create production efficiency report ................ 289

Tabel 4.66 Sample file pada create production efficiency report ............................ 290

Tabel 4.67 Input screen format pada create production efficiency report ............... 290

Tabel 4.68 Field dan logical flow pada create production efficiency report ........... 291

Tabel 4.69 Output layout pada create production efficiency report (bagian 1) ....... 299




Tabel 4.73 Transparent tables pada create material efficiency report .................... 301

Tabel 4.74 Sample file pada create material efficiency report ................................ 301

Tabel 4.75 Input screen format pada create material efficiency report ................... 302

Tabel 4.76 Logical flow pada create material efficiency report .............................. 302

Tabel 4.77 Output layout pada create material efficiency report (bagian 1) ........... 303



Tabel 4.80 Transparent tables pada inventory aging report .................................... 304

Tabel 4.81 Sample file pada inventory aging report ................................................ 305

Tabel 4.82 Input screen format pada inventory aging report .................................. 305

Tabel 4.83 Perhitungan logical pada inventory aging report .................................. 305

Tabel 4.84 Database execution pada inventory aging report .................................. 309

Tabel 4.85 Output layout pada inventory aging report (bagian 1) .......................... 311

Tabel 4.86 Output layout pada inventory aging report (bagian 2) .......................... 311

Tabel 4.87 Transparent tables pada term of payment report ................................... 313

Tabel 4.88 Sample file pada term of payment report ............................................... 314

xxxiv

Tabel 4.89 Input screen format pada term of payment report ................................. 315

Tabel 4.90 Perhitungan logical pada term of payment report .................................. 315

Tabel 4.91 Database execution pada term of payment report ................................. 315

Tabel 4.92 Output layout pada term of payment report (bagian 1) .......................... 320

Tabel 4.93 Output layout pada term of payment report (bagian 2) .......................... 320

Tabel 4.94 Transparent tables pada print bukti pembayaran .................................. 320

Tabel 4.95 Sample file pada print bukti pembayaran ............................................... 321

Tabel 4.96 Input screen format pada print bukti pembayaran ................................. 321

Tabel 4.97 Program requirements pada print bukti pembayaran ............................ 322

Tabel 4.98 Transparent tables pada aging report for AP ........................................ 323

Tabel 4.99 Sample file pada aging report for AP .................................................... 324

Tabel 4.100 Input screen format pada aging report for AP ..................................... 324

Tabel 4.101 Program requirements pada aging report for AP ................................ 325