I am Using the following query to calculate running balance.It's working perfectly for me.i need date wise report look like Output 2.
Select
t2.tentryno,t2.tseqid,t2.glcode,t2.descript,t2.Debit,t2.Credit,t2.entrydate, (Select SUM(Debit-Credit) From balancesheet As t1 Where t1.glcode=t2.glcode and t1.tseqid <= t2.tseqid )as Amount From balancesheet As t2 where glcode='01-04-0003' order by glcode,tseqid,entrydate
for Output 1 and Output 2 plz check image link.
[
^]
Plz help me
What I have tried:
I am Using the following query to calculate running balance.It's working perfectly for me.i need date wise report look like Output 2.
Select
t2.tentryno,t2.tseqid,t2.glcode,t2.descript,t2.Debit,t2.Credit,t2.entrydate, (Select SUM(Debit-Credit) From balancesheet As t1 Where t1.glcode=t2.glcode and t1.tseqid <= t2.tseqid )as Amount From balancesheet As t2 where glcode='01-04-0003' order by glcode,tseqid,entrydate
for Output 1 and Output 2 plz check image link.
[
^]
Plz help me