ofbiz-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (OFBIZ-6845) On the balance sheet, it display incorrect value on the total of long-term asset.
Date Mon, 21 Mar 2016 20:49:25 GMT

     [ https://issues.apache.org/jira/browse/OFBIZ-6845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Le Roux updated OFBIZ-6845:
-----------------------------------
    Fix Version/s:     (was: Upcoming Branch)

> 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
>             Fix For: 14.12.01, 15.12.01
>
>         Attachments: addConditionForLongTermAsset.patch
>
>
> 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. 
> {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)

Mime
View raw message