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

[Supatthra Nawicha (JIRA)]

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)