You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Supatthra Nawicha (JIRA)" <ji...@apache.org> on 2016/02/15 07:29:18 UTC
[jira] [Updated] (OFBIZ-6845) On the balance sheet, it display
incorrect value on the total of long-term asset.
[ https://issues.apache.org/jira/browse/OFBIZ-6845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Supatthra Nawicha updated OFBIZ-6845:
-------------------------------------
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.
{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}
was:
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}
> 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
> 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)