DEBUG PIUTANG - CEK DATA

1. Semua Penjualan Belum Bayar:

IDInvoiceTanggalGrand TotalRekening FieldRekening TableCustomer
58INV-202606-00582026-06-040CORYNA SANDRAWATILiora
57INV-202606-00572026-06-010CORYNA SANDRAWATISteven
56INV-202605-00562026-05-280CORYNA SANDRAWATISteven
55INV-202605-00552026-05-260CORYNA SANDRAWATILiora
54INV-202605-00542026-05-220CORYNA SANDRAWATILiora
53INV-202605-00532026-05-210CORYNA SANDRAWATILiora
52INV-202605-00522026-05-200CORYNA SANDRAWATIMurah Senyum
51INV-202605-00512026-05-190CORYNA SANDRAWATILiora
50INV-202605-00502026-05-0410,210,500CORYNA SANDRAWATILiora
49INV-202605-00492026-05-0234,559,800CORYNA SANDRAWATILiora
48INV-202604-00482026-04-246,272,400CORYNA SANDRAWATILiora
47INV-202604-00472026-04-224,540,000CORYNA SANDRAWATILiora
46INV-202604-00462026-04-1411,400,000CORYNA SANDRAWATILiora
45INV-202604-00452026-04-1112,420,000CORYNA SANDRAWATILiora
44INV-202604-00442026-04-0946,050,000CORYNA SANDRAWATILiora
43INV-202604-00432026-04-0442,366,000CORYNA SANDRAWATILiora
42INV-202603-00422026-03-1527,402,000CORYNA SANDRAWATILiora
41INV-202603-00412026-03-1214,500,000CORYNA SANDRAWATISteven
40INV-202603-00402026-03-0941,815,000CORYNA SANDRAWATILiora
39INV-202602-00392026-02-2612,850,000CORYNA SANDRAWATILiora
38INV-202602-00382026-02-2239,555,000CORYNA SANDRAWATILiora
37INV-202602-00372026-02-0314,500,000CORYNA SANDRAWATISteven
36INV-202601-00362026-01-3030,619,250CORYNA SANDRAWATILiora
35INV-202601-00352026-01-2330,605,000CORYNA SANDRAWATILiora
34INV-202601-00342026-01-1027,953,800CORYNA SANDRAWATILiora
33INV-202601-00332026-01-0714,500,000CORYNA SANDRAWATISteven
32INV-202601-00322026-01-0520,855,000CORYNA SANDRAWATILiora
31INV-202512-00312025-12-15825,000CORYNA SANDRAWATIDinda
30INV-202512-00302025-12-159,075,000CORYNA SANDRAWATIDinda
28INV-202512-00282025-12-0920,850,000CORYNA SANDRAWATILiora
27INV-202512-00272025-12-033,154,000CORYNA SANDRAWATILiora
26INV-202512-00262025-12-018,175,676CORYNA SANDRAWATIDinda
25INV-202512-00252025-12-01825,000CORYNA SANDRAWATIDinda
24INV-202512-00242025-12-0115,245,000CORYNA SANDRAWATIReynaldo
22INV-202511-00222025-11-29510,000CORYNA SANDRAWATILiora
23INV-202511-00232025-11-294,499,000CORYNA SANDRAWATILiora
21INV-202511-00212025-11-286,350,000CORYNA 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
6INV-202510-00062025-10-2213,000,000CORYNA SANDRAWATIAri
5INV-202510-00052025-10-221,657,500CORYNA SANDRAWATILiora
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
51INV-202605-0051Papa Bear100100,0000
51INV-202605-0051Creamer AVI Hijau20885,0000
51INV-202605-0051Creamer AVI Merah2914,0000
52INV-202605-0052Minyak Kunci Mas 900ml300247,0000
53INV-202605-0053Kuping Gajah Virgo10408,0000
53INV-202605-0053Cuka Apel3630,0000
54INV-202605-0054Kuping Gajah Virgo10408,0000
54INV-202605-0054Cuka Apel3630,0000
55INV-202605-0055Cherry Merah11,830,0000
55INV-202605-0055Kacang Shanghai5595,0000
55INV-202605-0055Interbis Choco Puff2207,7000
55INV-202605-0055Interbis Nanas1139,0000
55INV-202605-0055Interbis Rose5239,0000
55INV-202605-0055Danes Happy1100,0000
55INV-202605-0055Interbis Badut5147,4000
56INV-202605-0056Fansi AMDK 220ml100016,0000
57INV-202606-0057Minyak Tawon 900ml130228,5000
57INV-202606-0057Biaya Handling dan Ongkos Kirim1251,0000
58INV-202606-0058Sukitaro4095,0000
58INV-202606-0058Mikako Ayam Geprek2079,0000
58INV-202606-0058Mikako Campur3579,0000
58INV-202606-0058Permen New York Kacang31,155,0000
58INV-202606-0058Permen New York Kelapa21,378,0000
58INV-202606-0058Interbis Bon Bon Chocolate30237,0000
58INV-202606-0058Interbis Marie2158,0000
58INV-202606-0058Kacang Ika Pedas578,5000

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-00216,350,0006,350,0000
22INV-202511-0022510,000510,0000
23INV-202511-00234,499,0004,499,0000
24INV-202512-002415,245,00015,245,0000
25INV-202512-0025825,000825,0000
26INV-202512-00268,175,6768,175,6760
27INV-202512-00273,154,0003,154,0000
28INV-202512-002820,850,00020,850,0000
30INV-202512-00309,075,0009,075,0000
31INV-202512-0031825,000825,0000
32INV-202601-003220,855,00020,855,0000
33INV-202601-003314,500,00014,500,0000
34INV-202601-003427,953,80027,953,8000
35INV-202601-003530,605,00030,605,0000
36INV-202601-003630,619,25030,619,2500
37INV-202602-003714,500,00014,500,0000
38INV-202602-003839,555,00039,555,0000
39INV-202602-003912,850,00012,850,0000
40INV-202603-004041,815,00041,815,0000
41INV-202603-004114,500,00014,500,0000
42INV-202603-004227,402,00027,402,0000
43INV-202604-004342,366,00042,366,0000
44INV-202604-004446,050,00046,050,0000
45INV-202604-004512,420,00012,420,0000
46INV-202604-004611,400,00011,400,0000
47INV-202604-00474,540,0004,540,0000
48INV-202604-00486,272,4006,272,4000
49INV-202605-004934,559,80034,559,8000
50INV-202605-005010,210,50010,210,5000
51INV-202605-0051029,528,0000
52INV-202605-0052074,100,0000
53INV-202605-005305,970,0000
54INV-202605-005405,970,0000
55INV-202605-005507,391,4000
56INV-202605-0056016,000,0000
57INV-202606-0057029,956,0000
58INV-202606-0058022,184,5000

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

KLIK DISINI UNTUK UPDATE GRAND TOTAL

5. Daftar Rekening:

IDNama RekeningBankAktif
1CORYNA SANDRAWATIBCA1