DEBUG PIUTANG - CEK DATA

1. Semua Penjualan Belum Bayar:

IDInvoiceTanggalGrand TotalRekening FieldRekening TableCustomer
48INV-202512-00012025-12-012,617,000SUMBER BERKAT ANAKDinda
49INV-202512-00022025-12-0186,877,500AHMAD ANDIK NURFIANSYAHDinda
47INV-202510-00072025-10-2023,000,000AHMAD ANDIK NURFIANSYAHAli
46INV-202510-00062025-10-1937,932,000ANGKASA MITRA NIAGA - BRIDinda
45INV-202510-00052025-10-139,681,000AHMAD ANDIK NURFIANSYAHAllen Toko Tunas Jaya Kisar
44INV-202510-00042025-10-097,342,000AHMAD ANDIK NURFIANSYAHSajad
42INV-202510-00032025-10-073,588,000ANGKASA MITRA NIAGA - BRIDinda

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

Penjualan IDInvoiceProdukQtyHargaTotal

3. Perhitungan Manual Total per Invoice:

IDInvoiceGrand Total DBCalculated (qty*harga)Sum Total Field
42INV-202510-00033,588,0003,588,0000
44INV-202510-00047,342,0007,342,0000
45INV-202510-00059,681,0009,681,0000
46INV-202510-000637,932,00037,932,0000
47INV-202510-000723,000,00023,000,0000
48INV-202512-00012,617,0002,617,0000
49INV-202512-000286,877,50086,877,5000

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

KLIK DISINI UNTUK UPDATE GRAND TOTAL

5. Daftar Rekening:

IDNama RekeningBankAktif
1AHMAD ANDIK NURFIANSYAHBRI1
2SUMBER BERKAT ANAKBRI1
3ANGKASA MITRA NIAGA CV - BCABCA1
4ANGKASA MITRA NIAGA - BRIBRI1
5HARTONO MULTI REJEKIBCA1
6NUR AZIZAHBCA1
7PT SENTANA PRIMA UNGGULBCA1
8TUMBAK SAKTI DISTRIBUSI PANGAREPBCA1
9CV SELALU ADA BERKATBCA1