[OFBIZ-6845] On the balance sheet, it display incorrect value on the total of long-term asset.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Trunk
• Fix Version/s: 14.12.01, 15.12.01
• Component/s: accounting
• Assignee: Unassigned
• Reporter: Supatthra Nawicha
• Created: 20/Jan/16 06:21
• Updated: 21/Mar/16 20:49
• Resolved: 15/Feb/16 06:35

Description

Now, it display the totals of all transactions of any assets. I have checked on the code and I have found the missing condition checked in there.

BalanceSheet.groovy

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();

Actually, it should be:

List longtermAssetAndExprs = mainAndExprs as LinkedList;
longtermAssetAndExprs.add(EntityCondition.makeCondition("glAccountClassId", EntityOperator.IN, longtermAssetAccountClassIds));
transactionTotals = select("glAccountId", "accountName", "accountCode", "debitCreditFlag", "amount").from("AcctgTransEntrySums").where(longtermAssetAndExprs).orderBy("glAccountId").queryList();