axapta2009：在特定日期对 inventtrans 求和，按维度过滤

发布于 2024-10-29 20:24:19 字数 573 浏览 1 评论 0原文

我需要计算在特定日期具有特定物理尺寸 [inventTransPosting.Dimension] 的 InvnetTrans 的总和。即我需要类似的

select sum(CostAmountPosted) //other sums
     from InventTrans 
     where  InventTrans.transDate  < 3\3\2010
exists join InventTransPosted 
    where InventTransPosted.dimension[1] == 'XXX'
       && InventTransPosted.inventTransId == inventTrans.inventTransId
       && //other relations

可以使用 InventSum* 类通过 InventDim 过滤 InvenTranses 来计算 InvenTrans 总和。是否可以通过非发明维度进行过滤？或者是否有必要更改 InventSum* 类？现在我没有看到 inventSum* 类可以按维度过滤。也许我错过了一些课程？

原文

I need to calculate sum of InvnetTrans'es that have specific physicial dimensions[inventTransPosting.Dimension] on specific date. I.e. I need analogue of

select sum(CostAmountPosted) //other sums
     from InventTrans 
     where  InventTrans.transDate  < 3\3\2010
exists join InventTransPosted 
    where InventTransPosted.dimension[1] == 'XXX'
       && InventTransPosted.inventTransId == inventTrans.inventTransId
       && //other relations

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?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

风尘浪孓 2024-11-05 20:24:19

重构您的选择：

select sum(CostAmountPosted) //other sums
     from InventTrans 
exists join InventTransPosting
    where InventTransPosting.dimension[1] == 'XXX'
       && InventTransPosting.transDate  < 3\3\2010
       && InventTransPosting.inventTransId == inventTrans.inventTransId
       && InventTransPosting.itemId == inventTrans.itemId
       && //other relations

在 InventTransPosting 上创建相关索引，将 Dimension[1] 作为第一个索引字段，将 TransDate 作为第二个索引字段。

Restructure your select:

select sum(CostAmountPosted) //other sums
     from InventTrans 
exists join InventTransPosting
    where InventTransPosting.dimension[1] == 'XXX'
       && InventTransPosting.transDate  < 3\3\2010
       && InventTransPosting.inventTransId == inventTrans.inventTransId
       && InventTransPosting.itemId == inventTrans.itemId
       && //other relations

Make relevant index on InventTransPosting with Dimension[1] as first index field and TransDate as second.

回复收藏 0 原文