Author: hansbak
Date: Mon Feb 15 06:33:00 2016
New Revision: 1730456
URL: http://svn.apache.org/viewvc?rev=1730456&view=rev
Log:
https://issues.apache.org/jira/browse/OFBIZ-6845: On the balance sheet, it
display incorrect value on the total of long-term asset.
Modified:
ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/actions/reports/BalanceSheet.groovy
Modified:
ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/actions/reports/BalanceSheet.groovy
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/actions/reports/BalanceSheet.groovy?rev=1730456&r1=1730455&r2=1730456&view=diff
==============================================================================
---
ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/actions/reports/BalanceSheet.groovy
(original)
+++
ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/actions/reports/BalanceSheet.groovy
Mon Feb 15 06:33:00 2016
@@ -238,7 +238,7 @@ transactionTotals = [];
balanceTotal = BigDecimal.ZERO;
List longtermAssetAndExprs = mainAndExprs as LinkedList;
longtermAssetAndExprs.add(EntityCondition.makeCondition("glAccountClassId",
EntityOperator.IN, longtermAssetAccountClassIds));
-transactionTotals = select("glAccountId", "accountName", "accountCode",
"debitCreditFlag",
"amount").from("AcctgTransEntrySums").orderBy("glAccountId").queryList();
+transactionTotals = select("glAccountId", "accountName", "accountCode",
"debitCreditFlag",
"amount").from("AcctgTransEntrySums").where(longtermAssetAndExprs).orderBy("glAccountId").queryList();
transactionTotalsMap = [:];
transactionTotalsMap.putAll(longtermAssetOpeningBalances);
transactionTotals.each { transactionTotal ->
