|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows:
Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
Marco,
I've added a script that initialises values in the table m_loan_paid_in_advance... a scheduled job runs daily just after midnight and updates the values.
The ProgramDetails report doesn't need a "group by" as it just lists the active loans within the 'program'.
The m_loan_paid_in_advance's primary key is loan_id as a loan will have zero or one m_loan_paid_in_advance and the field principal_in_advance_derived contains a sum of all installments (principal) that have been fully or partially paid in advance. A sum is all that is needed in the dashboard data that you are currently showing. That's my understanding at the moment, if it's incorrect can you give me an example of what you expect.