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

[Former Member]

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...

[KennedyT21]

Hi Ajay Gapat

Close the Tread If you got solution.

Regards

Kennedy

[KennedyT21]

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)

Check these tread also

http://scn.sap.com/thread/1873302

http://scn.sap.com/thread/1870801

Regards

Kennedy

[Former Member]

H Ajay.....

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

Please try this function to get your problem solved......

Regards,

Rahul

[Former Member]

Hi,

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

Thanks,

Gordon

[K_Pauquet]

Hi Ajay Gapat,

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

http://scn.sap.com/community/business-one

All the best,

Kerstin