Hi, Thank you for listing down your query here, OOB there are no reports to show the data you need, but you could easily create a custom report for the same.
Refer to this document to help you in creating a stretchy custom report https://mifosforge.jira.com/wiki/spaces/docs/pages/67141770/Custom+Reports Enter the below parameter names Report Name: Matured Loans Report Type: Table Use Report: check this box Sql: use the query given below Report Parameters: do not enter anything Use the below query in the SQL section of the custom report to get the desired output "SELECT o.name,c.display_name,m.account_no,p.name ,m.principal_disbursed_derived,m.interest_charged_derived, m.principal_repaid_derived,m.interest_repaid_derived FROM m_loan m JOIN m_client c ON c.id = m.client_id JOIN m_product_loan p ON p.id = m.product_id JOIN m_office o ON o.id = c.office_id WHERE m.loan_status_id = 600" Note: you can modify the column outputs you need as per your requirements. Regards, Bharath Lead Implementation Analyst | Mifos Initiative Skype: live:cbharath4| Mobile: +91.7019635592 http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos> On Mon, Jan 24, 2022 at 8:23 PM tinotenda pfidze <pfidze...@gmail.com> wrote: > Good Day > > Am running mifos x build 18.03.01 and need help on how to view a report of > the loans that have been fully paid / or loans that have matured in the > system > > Regards > > > _______________________________________________ > 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
