Gideon Manurung
erp.workshop.app / beranda

🚗 Service ERP

Beranda ERP

Menu kartu seperti sistem asli: invoice, pelunasan, master data, absensi, kas, dan slip.

05 / Product

Service Business ERP

Service business ERP — track jobs, inventory, invoices, and technician assignments in one place.

Solo developer2025Next.jsReactTypeScriptTailwind CSS

03 / Context

Problem

Service businesses track jobs on WhatsApp and paper. Technicians don't know their assignments, inventory is checked manually, and invoicing is delayed.

04 / Concept

Solution

Built an ERP for service operations: job ticketing with status tracking, inventory linked to jobs, automatic invoice generation, and technician assignment with mobile access.

01 / Outcome

Deliverable

  • Job dashboard with status tracking per stage
  • Customer, vehicle, and goods/services master data
  • Invoice creation, payment, and print/PDF
  • Daily attendance, salary slips, and cash ledger

02 / Process

Workflow

  1. 1Admin receives job → creates job ticket with customer & vehicle data
  2. 2Job flows: Queued → In Progress → Ready → Completed
  3. 3Parts usage reduces inventory automatically
  4. 4Invoice created when job completed → payment recorded
  5. 5Daily attendance → auto-generate salary slips at month end

05 / System

Architecture

  • UI: Next.js with dashboard and data tables
  • State: job status, inventory, payment flow in TypeScript
  • Data: Job, Customer, Vehicle, Employee, Inventory, Invoice tables
  • Output: PDF invoices, salary slips, and cash reports

06 / Diagram

Flowchart

Admin operasional membuat invoice di website ERP — bukan sidebar Sheets. Keuangan melunasi sisa dan mencatat kas. Sistem hitung PPN/PPH, PDF, dan status garansi.

Admin operasional

Invoice & master data

Buat invoice karoseri di website: pilih pelanggan dan kendaraan, tambah barang/jasa, hitung PPN/PPH dan DP. CRUD pelanggan, kendaraan, dan katalog produk.

Buat InvoiceData PelangganData KendaraanData Barang/Jasa

Keuangan

Pelunasan & kas

Lunasi sisa invoice, catat pemasukkan/pengeluaran, jurnal otomatis ke chart of accounts. Generate PDF invoice ke Drive.

PelunasanPemasukkanPengeluaranJurnalPDF Invoice

HRD

Absensi & slip

Master karyawan, absensi harian, pekerjaan borongan, dan generate slip gaji PDF per periode.

Data KaryawanAbsensi HarianPekerja BoronganSlip Gaji
MenuOperasionalKeuanganHRD
Buat invoice●●○
Pelunasan pembayaran●●○
CRUD pelanggan / kendaraan / barang●○○
Data garansi●○○
Pemasukkan / pengeluaran / jurnal○●○
Karyawan & absensi○○●
Slip gaji PDF○●●
Pekerjaan borongan●○●
Mulai / selesai Proses Input / output Keputusan Proses sistem

OPERASIONAL

Invoice & master

  1. Buka website

  2. Pilih pelanggan + kendaraan

  3. Tambah barang / jasa

    Harga, diskon, garansi

  4. Ada DP?

    Tidak · Grand total penuhYa · Isi nominal + akun kas

  5. Simpan invoice

  6. PDF siap

KEUANGAN

Pelunasan & kas

  1. Cari sisa bayar

  2. Input pelunasan

  3. Update status

    DP → Lunas

  4. Kas keluar/masuk?

    Tidak · Selesai bayarYa · Catat jurnal COA

  5. Buku kas update

SISTEM

PDF, pajak, garansi

  1. Validasi form

  2. Tulis Invoice + Item

  3. Hitung PPN / PPH / sisa

  4. Masa garansi habis?

    Tidak · AktifYa · Status Expired

  5. Generate PDF Drive

  6. Jurnal otomatis

  7. Commit

07 / Data

Database Design

Skema website Service ERP. Setiap garis menghubungkan dua tabel yang bertetangga: PK emas, FK hijau. Kaki gagak = sisi banyak.

satu → banyak
Pelanggan
PKid
jenis
nama
pic
telepon
kota
Kendaraan
PKid
FKpelanggan_id
no_plat
merek_tipe
no_rangka
kilometer
Barang_Jasa
PKid
deskripsi
tipe
satuan
harga
Karyawan
PKid
nama
divisi
tipe_upah
gaji_pokok
ptkp
Invoice
PKid
nomor
FKpelanggan_id
FKkendaraan_id
grand_total
dp
sisa
status_bayar
Invoice_Item
PKid
FKinvoice_id
FKbarang_id
qty
diskon
ppn
total
Garansi
PKid
FKinvoice_id
FKitem_id
mulai
berakhir
status
Absensi
PKid
FKkaryawan_id
tanggal
status
periode
Jurnal
PKid
FKinvoice_id
FKakun_id
jenis
nominal
tanggal
Chart_of_Accounts
PKid
kode
nama
tipe
Slip_Gaji
PKid
FKkaryawan_id
periode
gaji_bersih
pdf_url

08 / Features

Full Features

Service ERP website modules — invoice forms, payments, master data, attendance, cash, and salary slips.

  • Create new invoice

    Full form: invoice no., date, due date, job number, work order, status (DP/Full/Net). Pick customer & vehicle, fill plate, brand, km, chassis.

  • Items, VAT/withholding, warranty

    Add products to invoice: price, qty, discount, VAT/withholding rates, warranty period (days/months/years). Item table + browser tax preferences.

  • Piece-rate workers

    Add workers per invoice: description, qty, unit, rate, Progress/Completed status, inspected by.

  • Payment settlement

    Find invoices with balance > 0, view grand total/paid/remaining, add payment, pick account, save settlement.

  • Customer data

    CRUD institution/individual: auto ID PLG-xxx, PIC, address, city, phone. Used in invoice form.

  • Vehicle data

    Plate, make/type, body type, year, customer, owner institution, driver.

  • Goods/services data

    Service type (J-xxx) or Goods (B-xxx): description, brand, unit, price, cost, stock.

  • Daily attendance

    Date, employee, clock in/out, Present/Leave/Sick/Absent status, late (minutes), overtime.

  • Employee data

    ID K-xxx (monthly) / L-xxx (piece-rate), division, WhatsApp, email, base salary, PTKP status.

  • Salary slip

    Period, pick employee, earnings/deductions, late minutes, take-home pay, generate PDF. Separate for monthly and piece-rate.

  • Expenses & income

    Cash out/in: chart of accounts, vendor or received from, qty × price, invoice project allocation, funding source, proof.

  • Invoice PDF to Drive

    Generate invoice PDF from template, save to Drive, link recorded in sales.

← Therapy Practice ManagementGarment Work Order System →
← Back to work