[OFBiz] SVN: r7161 - trunk/applications/accounting/entitydef

[sichen@svn.ofbiz.org]

Author: sichen
Date: 2006-03-31 20:01:18 -0600 (Fri, 31 Mar 2006)
New Revision: 7161

Modified:
   trunk/applications/accounting/entitydef/entitymodel.xml
Log:
Fixed a bad group-by which made fin account balance queries wrong when there are ADJUSTMENTs and DEPOSITS

Modified: trunk/applications/accounting/entitydef/entitymodel.xml
===================================================================
--- trunk/applications/accounting/entitydef/entitymodel.xml	2006-04-01 01:08:46 UTC (rev 7160)
+++ trunk/applications/accounting/entitydef/entitymodel.xml	2006-04-01 02:01:18 UTC (rev 7161)
@@ -2128,7 +2128,7 @@
     	       on a range of transactionDates for a given finAccountId, finAccountTransTypeId">
     	   <member-entity entity-alias="FAT" entity-name="FinAccountTrans"/>
     	   <alias entity-alias="FAT" name="finAccountId" group-by="true"/>
-    	   <alias entity-alias="FAT" name="finAccountTransTypeId" group-by="true"/>
+    	   <alias entity-alias="FAT" name="finAccountTransTypeId" group-by="false"/> <!-- must not group-by this, or aggregating DEPOSIT and ADJUSTMENT won't work -->
     	   <alias entity-alias="FAT" name="transactionDate" group-by="false"/>
        <alias entity-alias="FAT" name="amount" function="sum"/>
        <alias entity-alias="FAT" name="currencyUomId" group-by="true"/>