[ https://issues.apache.org/jira/browse/OFBIZ-6845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Supatthra Nawicha updated OFBIZ-6845: ------------------------------------- Attachment: addConditionForLongTermAsset.diff > 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)