[jira] [Created] (FINERACT-2589) [HOTFIX] Fix repayment template next unpaid installment amount

["SHamir Husein (Jira)" <ji...@apache.org>]

SHamir Husein created FINERACT-2589:
---------------------------------------

             Summary: [HOTFIX] Fix repayment template next unpaid installment amount
                 Key: FINERACT-2589
                 URL: https://issues.apache.org/jira/browse/FINERACT-2589
             Project: Apache Fineract
          Issue Type: Bug
    Affects Versions: 1.14.0
            Reporter: SHamir Husein


Updated the repayment transaction template query so it returns the next installment with an outstanding balance instead of always defaulting to the earliest installment.

This was needed because partially paid loans could produce an incorrect repayment template amount when the first matching installment was already fully satisfied. The change reuses the existing due amount expressions in the query ordering, and adds an integration test to verify the repayment template now returns the next unpaid installment amount.
h2. Checklist

Please make sure these boxes are checked before submitting your pull request - thanks!
 *  Write the commit message as per [our guidelines|https://github.com/apache/fineract/blob/develop/CONTRIBUTING.md#pull-requests]
 *  Acknowledge that we will not review PRs that are not passing the build _("green")_ - it is your responsibility to get a proposed PR to pass the build, not primarily the project's maintainers.
 *  Create/update [unit or integration tests|https://fineract.apache.org/docs/current/#_testing] for verifying the changes made.
 *  Follow our [coding conventions|https://cwiki.apache.org/confluence/display/FINERACT/Coding+Conventions].
 *  Add required Swagger annotation and update API documentation at fineract-provider/src/main/resources/static/legacy-docs/apiLive.htm with details of any API changes
 *  [This PR must not be a "code dump"|https://cwiki.apache.org/confluence/display/FINERACT/Pull+Request+Size+Limit]. Large changes can be made in a branch, with assistance. Ask for help on the [developer mailing list|https://fineract.apache.org/#contribute].

Your assigned reviewer(s) will follow our [guidelines for code reviews|https://cwiki.apache.org/confluence/display/FINERACT/Code+Review+Guide].

PR -> https://github.com/apache/fineract/pull/5768



--
This message was sent by Atlassian Jira
(v8.20.10#820010)