[fineract] branch develop updated: Fix general ledger report

[arnold]

This is an automated email from the ASF dual-hosted git repository.

arnold pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git


The following commit(s) were added to refs/heads/develop by this push:
     new ba75f7b93 Fix general ledger report
ba75f7b93 is described below

commit ba75f7b93b13f7c4a1c2fe5bdf8718fb6db226fe
Author: Adam Saghy <adamsa...@gmail.com>
AuthorDate: Fri Jul 22 22:24:58 2022 +0200

    Fix general ledger report
---
 .../db/changelog/tenant/parts/0018_pentaho_reports_to_table.xml     | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git 
a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0018_pentaho_reports_to_table.xml
 
b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0018_pentaho_reports_to_table.xml
index 8c5b1c802..7c1e64e6a 100644
--- 
a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0018_pentaho_reports_to_table.xml
+++ 
b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0018_pentaho_reports_to_table.xml
@@ -244,4 +244,10 @@
             <column name="report_parameter_name" value="toDate"/>
         </insert>
     </changeSet>
+    <changeSet id="2" author="fineract" context="mysql">
+        <update tableName="stretchy_report">
+            <column name="report_sql" value="select details.edate entry_date, 
sum(details.debit_amount) debit_amount, sum(details.credit_amount) 
credit_amount,  details.description, ifnull(opb.openingbalance,0) 
openingbalance,  if (details.manual_entry=1,details.id,'0system') transtype, if 
(actype in (1,5),    (sum(details.debit_amount) - sum(details.credit_amount)),  
  (sum(details.credit_amount) - sum(details.debit_amount))) as cumulative_sum  
from ( select a.account_id acid1 ,concat(g [...]
+            <where>report_name = 'GeneralLedgerReport Table'</where>
+        </update>
+    </changeSet>
 </databaseChangeLog>