Opening Balance

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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