Skip to Content
avatar image
Former Member

Opening Balance

Hi, I created a GL report with debit and Credit. I want to have opening balance based on either year/month selected. Logic would be, if user has selected the Jan 2015, then opening balance should be sum of all transaction till DEC 2014 . Tried option using First . However it doesnt work as expected. Appreciate if anyone had handled this earlier, would provide insight. Note: We are not BW customers Regards Ben

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 18, 2016 at 08:04 AM

    Hi Ben, I suppose you´re looking for a solution at report side .

    As I don´t know how you gonna select the month/year, I will use a data variable [date] = Jan 2015.

    Opening balange = Sum ([credit] where ([transaction date] < [date]))+Sum ([debit] where ([transaction date] < [date]))

    Regards,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18, 2016 at 08:50 AM

    Do you follow any specific Fiscal year or end user can randomly select any month and any Year and you want the data till the previous month of the selected value?

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2016 at 08:52 AM

    You should use prompt inside the query filter with <= condition on date field (from which the use is going to select the date value.

    --Subbu

    Add comment
    10|10000 characters needed characters exceeded