Hi Maya, I am not sure how the start date works on the balance sheet report. Balance sheet report is a list of each GL's closing balance till the "end-date" which we select on the report, so irrespective of "startdate", closing balance will always be the same, if we have passed the year end closing entries in the system.
Please connect with me on skype to discuss more on your requirement and issues which you are facing. Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019636073 http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos> On Mon, Feb 10, 2020 at 5:42 PM Maya Duruva <m...@duruva.net> wrote: > > Hi Reehan, > > Thanks for your reply. > > I tried the "Closing Entries" option as you said. Working now. thanks for > your suggestion. > But, the Balance sheet report still remains the same. May i know the > balance sheet not working as per the "Closing Entries"? > > because the "balance sheet" pentaho report doesn't have a "Start Date" > Parameter. as you said when we editing the reports they seem to fail in > receiving the DB credentials. May i know is there any way to edit the > report or else change the DB credentials as per need? > > We need a balance sheet pentaho report "2019-04-01" to till now only. But > it has been shows all data and End date parameter only available. > Please be give me any alternate way if you know. > > Thanks > > Regards, > Maya > > > ---- On Mon, 10 Feb 2020 16:24:40 +0530 *ರೀಹಾನ್ ಯೆ. ಕೆ. ಲಾಲ್ಖಾನ್ವರ್ > <reehan.lalk...@gmail.com <reehan.lalk...@gmail.com>>* wrote ---- > > Hi Maya, > > The value of the "financial-year-beginning-month" is used to calculate > interest calculation on the savings account, they have no bearing on the > reports AFAIK. > > The Pentaho reports run on query and also on editing the reports they seem > to fail in receiving the DB credentials, probably that is why the edited > reports are empty. > > Lastly if the start-date and end-date are provided the financial reports > are generated according to those dates and so any range of dates can be > provided for generating reports. And to disallow creating entries after a > specific date the feature of Closing Entries exists under Accounting. > > Regards, > > Reehan Ahmed Khan IL > http://techyinme.blogspot.com/ > http://spateofthoughts.blogspot.com/ > > > On Mon, Feb 10, 2020 at 2:46 PM Maya Duruva <m...@duruva.net> wrote: > > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > > Hi All, > > I need to know about the "Financial Year" in mifos x. > For example if we set a "financial-year-beginning-month" value as '4' in > the "configuration" where it can be reflect? > > 1. it can be not allowing the accounting entries for previous month(1,2,3) > ? > 2. The Balance sheet report generate based from "4th month" to "END_DATE" ? > > please be reply me if anyone have knowledge about this. > > > > And also we need some clarification based on the this. That's why i am > asking the above question. > > Currently we have data from "2019-01-01" > and "financial-year-beginning-month" is also '1'. But as per our > organisation rule the financial year beginning month is "APRIL". > So, we need to generate a balance sheet report from > "2019-04-01"(YY-MM-DD) to end_date in the report. > > I tried some ways to generate a report for our requirement > > 1. just change the value of the "financial-year-beginning-month" is '4'. > But nothing can change in the "Balance sheet" report. It same as a old > report. > 2. also copy the database to local and open the pentaho report file(prpt > flie) via "Pentaho report designer"tool. After that i have add start date > parameter and change some query related to start date and end date. Those > changes i have made in all Sub-report also. After the change i just got a > empty report. But before the changes i have got a report data. > i think it's something related to accounting. > > So, please be reply any one have idea about this. > > Thanks in advance. > > Regards, > Maya > > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users >
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
