[
https://issues.apache.org/jira/browse/FINERACT-2466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Saghy resolved FINERACT-2466.
----------------------------------
Resolution: Fixed
> Regression of Trial Balance report
> ----------------------------------
>
> Key: FINERACT-2466
> URL: https://issues.apache.org/jira/browse/FINERACT-2466
> Project: Apache Fineract
> Issue Type: Bug
> Affects Versions: 1.14.0
> Reporter: Adam Saghy
> Assignee: Adam Saghy
> Priority: Major
>
> {code:java}
> seeing regression test failures. All year end trial balance reporting tests
> are failing as retained earnings are not coming up.
> and date_part('year', e.year_end_date::date) < date_part('year',
> '${endDate}'::date) <--- originally in the retained_earning query
> AND EXTRACT(YEAR FROM e.year_end_date) < EXTRACT(YEAR FROM CAST('${endDate}'
> AS DATE)) <-- new changes{code}
> *Sample scenario to test:*
> # Create and disburse loan at end of year
> # Asset sale at end of year
> # Run Trial balance report for 01/01
>
> *Acceptance criteria*
> * Fix the query and ensure the correct behaviour
> * Write a test for this to avoid regression in the future
--
This message was sent by Atlassian Jira
(v8.20.10#820010)