Re: [Mifos-users] Jasper reports in Pentaho

2011-03-28 Thread Udai Gupta
Hi, > http://wiki.pentaho.com/display/ServerDoc1x/2.+Creating+an+Action+Sequence+With+Jasper This is old documentation (Legacy BI Server), but may be it works the same way in Server2x. I think both Jasper and BIRT capabilities are there in Pentaho BI server as a component plugin. biserver-ce-3.6.

Re: [Mifos-users] Apply "interest rate+spread" for late payment (Declining Balance - Interest Recalculation FS)

2011-03-28 Thread Tejus Datta
Hi Miguel, There is an inherent penalization for late payment while using the new declining balance interest recalculation int. type. For eg. 1000 is the loan amount which was disbursed on 1 April. Consider this to be a monthly loan (10 installments). Assume that the Installment amount due on 1

[Mifos-users] Jasper reports in Pentaho

2011-03-28 Thread Adam Monsen
Is anyone currently running their Jasper reports in Mifos BI (Pentaho)? Seems like it is doable: http://wiki.pentaho.com/display/ServerDoc1x/2.+Creating+an+Action+Sequence+With+Jasper signature.asc Description: OpenPGP digital signature --

Re: [Mifos-users] Center meeting re-schedule

2011-03-28 Thread Gayl Kennedy
done, see - MIFOS-4915 Ability to select the first/next repayment date when changing the centre meeting date feel free to add comments or vote for same. regards Gayl On 28 March 2011 17:06, Ryan W

Re: [Mifos-users] Apply "interest rate+spread" for late payment (Declining Balance - Interest Recalculation FS)

2011-03-28 Thread Ryan Whitney
Er, that should be for the automated application of penalties, not features! :) This is what you get when I'm responding to community mail before I've finished my morning coffee! :) r On 3/28/11 9:07 AM, "Ryan Whitney" wrote: > Miguel, > > What you are describing sounds like a penalty. At t

Re: [Mifos-users] Reports - seeking SQL statements

2011-03-28 Thread Ryan Whitney
Jessica, Have you look at the demo reports from the BI product? http://mifos.org/functional-specifications/pentaho-reports-in-mifos These might resolve a lot of your requests below We also have this - http://mifosforge.jira.com/wiki/display/MIFOS/SQL+Query+Repository Ryan On 3/27/11 10:29 PM

Re: [Mifos-users] Apply "interest rate+spread" for late payment (Declining Balance - Interest Recalculation FS)

2011-03-28 Thread Ryan Whitney
Miguel, What you are describing sounds like a penalty. At the moment, Mifos doesn't have any features for automated application of features, its done manually through the application of MISC PENALTY feature. Ryan On 3/28/11 1:49 AM, "Miguel Jóia Santos" wrote: > > Hi, > > I am currently te

Re: [Mifos-users] Center meeting re-schedule

2011-03-28 Thread Ryan Whitney
I think the easiest way to change it where it gives you that flexibility is to give you a date picker for when you want the next meeting. I would say to file the enhancement. Ryan On 3/28/11 1:44 AM, "Gayl Kennedy" wrote: > Would it be useful (and feasible) to put in an enhancement request to

Re: [Mifos-users] Want A Sql Statement

2011-03-28 Thread Ryan Whitney
Trilok, You can change the order in the query yourself. Ryan On 3/27/11 11:55 PM, "Trilok J. Pandya" wrote: >Ramya, > > thanks, > > this will give me some output but i want it in following manner, > > > Member ID Member Name Centre Principal Penalty Prepayment Reason Status

Re: [Mifos-users] Apply "interest rate+spread" for late payment (Declining Balance - Interest Recalculation FS)

2011-03-28 Thread Miguel Jóia Santos
Hi, I am currently testing the new feature for loans using Declining Balance - Interest Recalculation FS for MIFOS 2.1. It really works well. It can calculate daily interest on the outstanding debt. However for the Mozambican MFI’s we would prefer to use a feature of “interest rate + spread”, w

Re: [Mifos-users] client outside of a group

2011-03-28 Thread Gayl Kennedy
Hi Jessica do individuals have different loan accounts than those in centres? we were able to create a report to filter out those with an individual account into a report as the type of loan was specific to individuals. G On 24 March 2011 17:20, Ryan Whitney wrote: > Jessica, > > At the moment,

Re: [Mifos-users] Center meeting re-schedule

2011-03-28 Thread Gayl Kennedy
Would it be useful (and feasible) to put in an enhancement request to select when you want the change to be effective from so you can choose from "Immediately" or "After the next installment date"? I still need to log an enhancement request for the issue we had when we change the meeting date befor

Re: [Mifos-users] Reports - seeking SQL statements

2011-03-28 Thread Ramya.Toshniwal
Hi Jessica, I think the following might help in your case: I am posting the solutions for first three cases for now a) List future disbursement on a given future time: By this you mean, on a selected future date, what are the disbursements expected. select center.display_name as

[Mifos-users] Finding Sql Statement for Center Meeting Change Details

2011-03-28 Thread Trilok J. Pandya
dear friends, i want a query for center meeting change details list. the coloumns like following Centre Day Time FE New Day New Time New FE Reason Date