title: axapta2009: sum inventtrans on specific date, filter by dimension
body: <p>I need to calculate sum of InvnetTrans'es that have specific physicial dimensions[inventTransPosting.Dimension] on specific date. I.e. I need analogue of</p>
  
  <pre><code>select sum(CostAmountPosted) //other sums
       from InventTrans 
       where  InventTrans.transDate  &lt; 3\3\2010
  exists join InventTransPosted 
      where InventTransPosted.dimension[1] == 'XXX'
         &amp;&amp; InventTransPosted.inventTransId == inventTrans.inventTransId
         &amp;&amp; //other relations
  </code></pre>
  
  <p>It is possible to calculate InvenTrans sum with InventSum* classes filtering InvenTranses by InventDim.
  Is it possible somehow to filter by non inventdim dimensions?
  Or it is neccessary to change InventSum* classes? 
  Right now I don't see that inventSum* classes can filter by Dimensions. Maybe I missed some classes?</p>