如何从信用卡和借记栏计算运行余额 [英] How to calculate running balance from the credit and debit column

问题描述

我正在使用以下查询来计算运行余额。它对我来说非常有效。我需要日期明智的报告看起来像输出2.

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

输出1和输出2的
plz检查图像链接。

[ ^ ]



Plz帮助我



我尝试了什么：



我使用以下查询来计算运行余额。它对我来说非常合适。我需要日期明智的报告看起来像输出2.

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

输出1和输出2 plz检查图像链接。

[ ^ ]



Plz帮助我

for Output 1 and Output 2 plz check image link.
[^]

Plz help me

推荐答案

请参阅以下链接，说明如何管理：

sql - 当前行的累积值+前一行的总和 - Stack Overflow [ ^ ]

See the following link that explains how to manage this:
sql - Cumulating value of current row + sum of previous rows - Stack Overflow[^]

这篇关于如何从信用卡和借记栏计算运行余额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！