DEBUG PIUTANG - CEK DATA

1. Semua Penjualan Belum Bayar:

ID	Invoice	Tanggal	Grand Total	Rekening Table	Customer
48	INV-202512-0001	2025-12-01	0	SUMBER BERKAT ANAK	Dinda
49	INV-202512-0002	2025-12-01	0	AHMAD ANDIK NURFIANSYAH	Dinda
47	INV-202510-0007	2025-10-20	23,000,000	AHMAD ANDIK NURFIANSYAH	Ali
46	INV-202510-0006	2025-10-19	37,932,000	ANGKASA MITRA NIAGA - BRI	Dinda
45	INV-202510-0005	2025-10-13	9,681,000	AHMAD ANDIK NURFIANSYAH	Allen Toko Tunas Jaya Kisar
44	INV-202510-0004	2025-10-09	7,342,000	AHMAD ANDIK NURFIANSYAH	Sajad
42	INV-202510-0003	2025-10-07	3,588,000	ANGKASA MITRA NIAGA - BRI	Dinda

2. Detail Penjualan untuk Invoice yang Grand Total = 0:

Penjualan ID	Invoice	Produk	Qty	Harga
48	INV-202512-0001	Biaya Handling dan Ongkos Kirim	1	2,617,000
49	INV-202512-0002	Astor Double Coklat Box 20x150g	50	241,500
49	INV-202512-0002	Beng Beng Maxx Pcs 8x12x36gr	10	320,000
49	INV-202512-0002	Super Star Snaps Triple Coklat Bks 8x12x12.5gr	10	159,200
49	INV-202512-0002	Kis Mint Apple Peach Bks 24x125gr	10	151,000
49	INV-202512-0002	Kis Mint Barley Bks 24x125gr	10	151,000
49	INV-202512-0002	Kis Mint Grape Bks 24x125gr	10	151,000
49	INV-202512-0002	Kopiko Coffee Candy Bks 24x150gr	20	223,000
49	INV-202512-0002	Super Star Triple Coklat 8x20gr	30	137,500
49	INV-202512-0002	Kalpa Wafer Coklat Kelapa 8x24gr	10	159,200
49	INV-202512-0002	Choki Choki Chococashew 9x20 10gr	15	154,500
49	INV-202512-0002	Beng Beng Extra Choco & Caramel Pcs 8x25gr	50	281,000
49	INV-202512-0002	Wow Spagheti Bolognes Bks 40x88gr	20	113,500
49	INV-202512-0002	Wow Spagheti Carbonara Bks 40x88gr	20	113,500
49	INV-202512-0002	Garuda Ting-Ting 125gr (50x2.5gr)	10	152,000
49	INV-202512-0002	Better Fun Bites Bks 6x4x100gr	3	159,000
49	INV-202512-0002	Better Vanilla Cream Bigger Pack 12x10x27gr	15	192,800
49	INV-202512-0002	Roma Kelapa Bks 28x300gr	30	230,000
49	INV-202512-0002	Roma Kelapa Cream Coklat Bks 4x7x189gr	30	239,000
49	INV-202512-0002	Roma Malkist Coklat Bks 30x90gr	20	181,000
49	INV-202512-0002	Roma Malkist Kelapa Kopyor Bks 6x6x224gr	9	247,000
49	INV-202512-0002	Slai Olai Blueberry Pack 20x192gr	7	163,500
49	INV-202512-0002	Slai Olai Blueberry Roll 128gr	3	116,000
49	INV-202512-0002	Slai Olai Stroberi Roll 128gr	10	116,000
49	INV-202512-0002	Roma Malkist Crackers Bks 30x105gr	20	171,200
49	INV-202512-0002	Roma Sandwich Coklat 42x157gr	2	257,500
49	INV-202512-0002	Roma Sandwich Kacang Bks 42x157gr	5	257,500
49	INV-202512-0002	Roma Sari Gandum Coklat 24x108gr	10	171,500

3. Perhitungan Manual Total per Invoice:

ID	Invoice	Grand Total DB	Calculated (qty*harga)
42	INV-202510-0003	3,588,000	3,588,000
44	INV-202510-0004	7,342,000	7,342,000
45	INV-202510-0005	9,681,000	9,681,000
46	INV-202510-0006	37,932,000	37,932,000
47	INV-202510-0007	23,000,000	23,000,000
48	INV-202512-0001	0	2,617,000
49	INV-202512-0002	0	86,877,500

4. Update Manual Grand Total (JALANKAN INI!):

KLIK DISINI UNTUK UPDATE GRAND TOTAL

5. Daftar Rekening:

ID	Nama Rekening	Bank	Aktif
1	AHMAD ANDIK NURFIANSYAH	BRI	1
2	SUMBER BERKAT ANAK	BRI	1
3	ANGKASA MITRA NIAGA CV - BCA	BCA	1
4	ANGKASA MITRA NIAGA - BRI	BRI	1
5	HARTONO MULTI REJEKI	BCA	1
6	NUR AZIZAH	BCA	1
7	PT SENTANA PRIMA UNGGUL	BCA	1
8	TUMBAK SAKTI DISTRIBUSI PANGAREP	BCA	1
9	CV SELALU ADA BERKAT	BCA	1