query arus kas

select bank,
    rkn as rekening,
    sum(u_msk) uang_masuk,
    sum(u_klr) uang_keluar
from
(select p.c_bankaccount_id,
    ba.bank as bank,
    ba.accountno as rkn,
    case when dt.name = 'AR Receipt' then p.payamt else 0 end as u_msk,
    case when dt.name = 'AP Payment' then p.payamt else 0 end as u_klr,
    dt.name as doctype,
    p.isreceipt,
    p.documentno
from c_payment_v p
join c_doctype dt on dt.c_doctype_id = p.c_doctype_id
join c_bankaccount_view ba on ba.c_bankaccount_id = p.c_bankaccount_id
where p.ad_client_id = 1000003) as mstr
group by bank, rkn;