Tinotenda It will be great to get feedback about the custom report Bharat shared and whether it worked for your use case
> On 25 Jan 2022, at 09:17, Bharath Gowda <bgo...@mifos.org> wrote: > > > 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 > > >> 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
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
