select sum(debet) as total_debet,sum(kredit) as total_kredit 
	from "Akunting".buku_besar
	where objek='' and kode_akunting='1200.00.000'  and kode_buku_besar not ilike 'RKM%'
	group by objek<pre>Resource id #5</pre>

	<form style='display:block;' id='parameter_' name='parameter_'>
	<table border='0'>
		<tr>
		<td> Tanggal Pembayaran </td><td>:</td>
		<td><input type='text' name='input1_' id='input1_' value='27-01-2026 '>&nbsp;&nbsp;format [dd-mm-yyyy]	</td>
		</tr>
		<tr>
		<td> Jumlah Sisa Tagihan </td><td>:</td>
		<td><input type='hidden' id='jumlah_sisa_' value='0'>
			<input type='hidden' name='no_faktur_' id='no_faktur_' value=''> 
			<b>Rp. 0.00</b></td>
		</tr>
		<tr>
		<td>Pilihan Bayar </td><td>:</td>
		<td><select title='' id='pilihan_bayar_' name='pilihan_bayar_' onclick='proses_inputan(this.value,"")'>
			<option>CASH</option>
			<option>BANK BCA (IDR)</option><option>BANK BCA (USD)</option><option>BANK BCA USD (DEPOSITO LILY)</option><option>BANK BRI (IDR) HARTUTI SIMKA</option><option>BANK BRI AMPERA (USD)</option><option>BANK MAYBANK (IDR) LEONARDO</option><option>BANK PERMATA (IDR)</option><option>BANK WINDU (IDR)</option><option>BANK INDEX</option><option>BANK OCBC IDR - ESCROW</option><option>BANK MAYBANK - 132</option><option>BANK BRI ARIVAI (IDR) - 308</option><option>BANK MAYBANK KI - 768</option><option>BANK SMBC (IDR)</option><option>BANK DANAMON KAS</option><option>BANK BRI SRIWIJAYA (IDR) - 302</option><option>BANK DBS (209054186)</option><option>BANK OCBC IDR (1908-0001-1297)</option><option>BANK MANDIRI (IDR)</option><option>BANK BNI (IDR)</option><option>BANK CIMB NIAGA (800191692200)</option><option>BANK MANDIRI (ESCROW)</option><option>BANK DANAMON (KAS KECIL)</option><option>BANK BRI KC SERPONG</option><option>BANK OCBC IDR</option>			<option>BANK</option>	
			<option>GIRO</option>
			<option>RETUR</option>
					
			<option>POTONGAN METERAI</option>
			<option>POTONGAN NOTA/MEMO</option>
			<!--option>KOREKSI NOTA</option-->
		</select></td>
		</tr>
		<tr>
			<td>Pilihan Bayar Dengan COD</td><td>:</td>
			<td><select id='pilihan_cod_' name='pilihan_cod_' onchange='proses_jumlah_transfer(this.value,"");'>
			<option>Pilih COD</option>			</select></td>
		</tr>
				<!--tr>
			<td>Pilihan Bayar Dengan Transfer Ekonomi</td><td>:</td>
			<td><select id='pilihan_transfereko_'  name='pilihan_transfereko_' onchange='proses_jumlah_transfer(this.value,"");'>
			<option>Pilih Transfer EKONOMI</option>			</select></td>
		</tr-->
		<tr>
			<td>Pilihan Bayar Dengan Giro (yang sudah cair)</td><td>:</td>
			<td><select id='pilihan_giro_'  name='pilihan_giro_' onchange='proses_jumlah_giro(this.value,"");'>
			<option>Pilih Giro</option>			</select></td>
		</tr>
		<tr>
			<td>Pilihan Bayar Dengan Retur </td><td>:</td>
			<td><select id='pilihan_retur_' name='pilihan_retur_' onchange='proses_jumlah_retur(this.value,"");'>
			<option>Pilih Retur</option>			</select></td>
		</tr>
		<tr>
		<td>Jumlah Pembayaran </td><td>:</td>
		<td> <input type='hidden' id='jumlah_bayar_' value='0' name='jumlah_bayar_'>
		<input id='convert_jumlah_bayar_'  onkeyup="cek_saldo(this.value,'');" type='text' value='0'>
		<label style='color:red;' id='show_'>
		</td> 
		</tr>
		<tr>
		<td>Sisa Tagihan  </td><td>:</td><td><span id='jumlah_skrg_'></span></td> 
		</tr>
		<tr>
		<td>Status Nota  </td><td>:</td><td><span id='status_nota_'></span></td> 
		</tr>		
		<tr>
		<td> Info Pembayaran </td><td>:</td>
		<td><input type='text' name='info_' id='info_' value='' size='60px'>	</td>
		</tr>
		<tr height='10px'><td></td></tr>
		
		<tr>
			<td colspan='3' align='center'> 
			<span style='cursor:pointer;color:blue;font-size:14px;' onclick='bayar_piutang("parameter_");' id='button1_'><b>Confirm</b></span>
			&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span onclick='reset_piutang("parameter_");'style='cursor:pointer;color:blue;font-size:14px;' id='button2_'><b>Cancel</b></span>
			</td>
		</tr>
	</table>
	</form>
	<br>