Supatthra Nawicha created OFBIZ-6845: ----------------------------------------
Summary: On the balance sheet, it display incorrect value on the total of long-term asset. Key: OFBIZ-6845 URL: https://issues.apache.org/jira/browse/OFBIZ-6845 Project: OFBiz Issue Type: Bug Components: accounting Affects Versions: Trunk Reporter: Supatthra Nawicha Priority: Minor Attachments: addConditionForLongTermAsset.diff Now, it display the totals of all transactions on the totals of long term asset. I have checked on the code and I have found the missing condition checked in there. {code:title=BalanceSheet.groovy|borderStyle=solid} 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(); {code} Actually, it should be: {code:java} 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(); {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)