Skip to Content
avatar image
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...

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • 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:

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

    All the best,

    Kerstin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 20, 2012 at 03:54 AM

    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

    Add comment
    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)

    Check these tread also

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

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

    Regards

    Kennedy

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2012 at 10:06 AM

    Hi Ajay Gapat

    Close the Tread If you got solution.

    Regards

    Kennedy

    Add comment
    10|10000 characters needed characters exceeded