Former Member

# How to calculate and Display Cumulative Balance (LC) In General Ledger - GL Account Crystal Report Query

Hi ,

I want to generate Crystal Report for General Ledger - GL Account Report

In this Query How to calculate Or Display Cumulative Balance (LC)

SELECT T2.[RefDate] as 'Posting Date', T2.[DueDate] as 'Due Date', T0.[Series], T3.[SeriesName], T0.[DocNum] as 'Doc. No.', T0.[TransId], T0.[JrnlMemo], T1.[AcctCode] as 'Offset Acct', T1.[AcctName] as 'Offset Acct Name', T1.[SumApplied] as 'Deb./Cred.(INR)' FROM [dbo].[OVPM] T0 INNER JOIN [dbo].[VPM4] T1 ON T0.DocNum = T1.DocEntry INNER JOIN [dbo].[OJDT] T2 ON T0.TransId = T2.TransId INNER JOIN [dbo].[NNM1] T3 ON T0.Series = T3.Series

Please Give Me Solution As Soon As Possible...

10|10000 characters needed characters exceeded

• Jun 21, 2012 at 10:51 AM

Hi Ajay Gapat,

this is the German language forum. Please close this thread & post your question in the general forum here:

All the best,

Kerstin

10|10000 characters needed characters exceeded
• Former Member
Jul 19, 2012 at 05:39 PM

Hi,

You can use CR's function to add a formula field to get the Cumulative Balance.

Thanks,

Gordon

10|10000 characters needed characters exceeded
• Former Member
Jul 20, 2012 at 03:54 AM

H Ajay.....

To get the Cummulative Total, Crystal Report have inbuilt Function called Running Total.

Regards,

Rahul

10|10000 characters needed characters exceeded
• Jul 20, 2012 at 08:28 AM

Hi Ajay,

Try this,

Create a formula field (Field1)

`If OnFirstRecord then OpeningBalance_Field + 'Deb./Cred.(INR)'`

.Now create a runningTotal for the above formula field(Field1)

Regards

Kennedy