如何从信用卡和借记栏计算运行余额

问题描述

我正在使用以下查询来计算运行余额。它对我来说非常有效。我需要日期明智的报告看起来像输出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

推荐答案

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