Skip to Content
avatar image
Former Member

Opening balance in gl report

Hi all,

         I am creating a customized  gl report. I want to add opening balance field in the report. I have credit and debit balances. How can i do that in crystal report. Please share some ideas.

Regards,

akram ali khan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 06, 2015 at 01:03 PM

    Hi Akram,

    You can create a Formula and use it in your report.

    In Field Explorer, Right click on the Formula -> New give name and click OK.

    Add the logic for Opening Balance and save it.

    Thanks,

    Nrupal

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Akram,

      Is Opening Balance a field in your database?

      If you are using 2 different parameters for Start date and End date  then you can use this formula:

      "opening balance as on " & Monthname(Month({?Start Date parameter})) & " 1 " & ToText(Year({?Start Date parameter})) & " - " & ToText({Opening Balance});

      Thanks,

      Nrupal

  • Jan 07, 2015 at 08:06 AM

    Hi,

         use the below query as a sub report using Command

    SELECT

    J1.ShortName,sum(case when j1.Debit<>'0' then debit else  (Credit*-1) end) as OB

    FROM

    JDT1 J1

    INNER JOIN OJDT J ON J1.TransId=J.TransId

    WHERE

    j.RefDate< '20150101'

    GROUP BY

    J1.ShortName

    put the parameter based on main query start date paramater.

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear All,

                          I am working on a customized g/l report. Yes system is not saving opening balance . it is storing only debit and credit balances. Please find attached screen shot.

      Please help me out on this issue

      regards,

      akram

      Capture.JPG (38.1 kB)