| Sn |
Receipt
|
Description
|
Date.
|
Chq.Date.
|
Chq.No.
|
Bank
|
Amount |
status |
select
vddat,chqdate,chqno,chqrdate,vcrdet.id,vcrdet.vdnum,pdcstatus,remarks, vdamt,vdaccode,vdnarr,
b.traccode,b.accname as trnname,vcrdet.currency,vcrdet.currate,
c.accname
from vcrdet
left join (select vcrdet.vdnum, vcrdet.traccode,chart_of_acc.accname from vcrdet
inner join chart_of_acc on chart_of_acc.accno=vcrdet.traccode
) as b
on b.vdnum=vcrdet.vdnum
left join (select vcrdet.vdnum,chart_of_acc.accname from vcrdet
inner join chart_of_acc on chart_of_acc.accno=vcrdet.vdaccode
where vcrdet.vdaccode!=''
and vcrdet.vdtype=''
group by vcrdet.vdnum) as c
on c.vdnum=vcrdet.vdnum
where (vcrdet.vdtype='' )
group by vdnum
order by chqdate,vdaccode,vddat