DEBUG PIUTANG - CEK DATA

1. Semua Penjualan Belum Bayar:

IDInvoiceTanggalGrand TotalRekening FieldRekening TableCustomer
27INV-202512-00272025-12-030CORYNA SANDRAWATILiora
26INV-202512-00262025-12-010CORYNA SANDRAWATIDinda
25INV-202512-00252025-12-010CORYNA SANDRAWATIDinda
24INV-202512-00242025-12-010CORYNA SANDRAWATIReynaldo
23INV-202511-00232025-11-290CORYNA SANDRAWATILiora
22INV-202511-00222025-11-290CORYNA SANDRAWATILiora
21INV-202511-00212025-11-280CORYNA SANDRAWATILiora
20INV-202511-00202025-11-277,947,000CORYNA SANDRAWATILiora
19INV-202511-00192025-11-2415,346,000CORYNA SANDRAWATILiora
18INV-202511-00182025-11-2422,920,000CORYNA SANDRAWATILiora
15INV-202511-00152025-11-1215,450,000CORYNA SANDRAWATILiora
14INV-202511-00142025-11-113,404,500CORYNA SANDRAWATILiora
13INV-202511-00132025-11-1014,500,000CORYNA SANDRAWATILiora
12INV-202511-00122025-11-0832,594,925CORYNA SANDRAWATILiora
11INV-202511-00112025-11-064,494,000CORYNA SANDRAWATILiora
10INV-202511-00102025-11-0632,709,875CORYNA SANDRAWATILiora
9INV-202510-00092025-10-3014,936,000CORYNA SANDRAWATILiora
8INV-202510-00082025-10-281,772,000CORYNA SANDRAWATILiora
7INV-202510-00072025-10-238,300,000CORYNA SANDRAWATILiora
5INV-202510-00052025-10-221,657,500CORYNA SANDRAWATILiora
6INV-202510-00062025-10-2213,000,000CORYNA SANDRAWATIAri
4INV-202510-00042025-10-1514,500,000CORYNA SANDRAWATISteven
3INV-202510-00032025-10-0212,899,000CORYNA SANDRAWATILiora
2INV-202510-00022025-10-0122,275,000CORYNA SANDRAWATILiora
1INV-202509-00012025-09-295,900,000CORYNA SANDRAWATILiora

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

Penjualan IDInvoiceProdukQtyHargaTotal
21INV-202511-0021Semprit Jempol5210,0000
21INV-202511-0021Kue Kering RST15193,0000
21INV-202511-0021Sagon5210,0000
21INV-202511-0021Permen 4x2,1kg1345,0000
21INV-202511-0021Bolu Kering RST2205,0000
21INV-202511-0021Jelly5120,0000
22INV-202511-0022Kue Kering Campur2255,0000
23INV-202511-0023Kukis Lestari25143,0000
23INV-202511-0023Merry Gold Mix2462,0000
24INV-202512-0024Sirup ABC Leci25127,0000
24INV-202512-0024Sirup ABC Orange50127,0000
24INV-202512-0024Teh Pucuk 330ml10057,2000
25INV-202512-0025Biaya Handling dan Ongkos Kirim1825,0000
26INV-202512-0026Sabena Stik Balado 5x340gr6049,5500
26INV-202512-0026Sabena Stik Keju 5x340gr5049,5500
26INV-202512-0026Sabena Stik Sapi Panggang 5x340gr2549,5500
26INV-202512-0026Sabena Stik Jagung Bakar 5x340gr2049,5500
26INV-202512-0026Sabena Stik Cocopandan 5x340gr1049,5500
27INV-202512-0027Kacang Shanghai Boby5590,0000
27INV-202512-0027Jelly368,0000

3. Perhitungan Manual Total per Invoice:

IDInvoiceGrand Total DBCalculated (qty*harga)Sum Total Field
1INV-202509-00015,900,0005,900,0000
2INV-202510-000222,275,00022,275,0000
3INV-202510-000312,899,00012,899,0000
4INV-202510-000414,500,00014,500,0000
5INV-202510-00051,657,5001,657,5000
6INV-202510-000613,000,00013,000,0000
7INV-202510-00078,300,0008,300,0000
8INV-202510-00081,772,0001,772,0000
9INV-202510-000914,936,00014,936,0000
10INV-202511-001032,709,87532,709,8750
11INV-202511-00114,494,0004,494,0000
12INV-202511-001232,594,92532,594,9250
13INV-202511-001314,500,00014,500,0000
14INV-202511-00143,404,5003,404,5000
15INV-202511-001515,450,00015,450,0000
18INV-202511-001822,920,00022,920,0000
19INV-202511-001915,346,00015,346,0000
20INV-202511-00207,947,0007,947,0000
21INV-202511-002106,350,0000
22INV-202511-00220510,0000
23INV-202511-002304,499,0000
24INV-202512-0024015,245,0000
25INV-202512-00250825,0000
26INV-202512-002608,175,6760
27INV-202512-002703,154,0000

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

KLIK DISINI UNTUK UPDATE GRAND TOTAL

5. Daftar Rekening:

IDNama RekeningBankAktif
1CORYNA SANDRAWATIBCA1