查找物料/仓库的总可用物料和可用物料 [英] Finding the Total Available and Available physical for an Item/Warehouse

问题描述

我有一个用于显示字段的方法，该方法可以执行以下操作；

I have a method for a display field which does the following;

return InventSum::find(_salesLine.ItemId, InventDim::_salesLine.InventDimId).AvailPhysical();

这为我提供了生产线站点/仓库/地点的现有可用物理信息.

This gives me the on-hand Available Physical for the line site/warehouse/location.

我需要查看仅适用于站点/仓库的总数.我想我需要按物料/仓库搜索inventDim以获得我的indidimid，但是我找不到该方法，因此我怀疑这是不正确的.

I need to see the total available for just the site/warehouse. I think I need to search inventDim by Item/Warehouse to get my inventdimid, but I cannot find the method so I am suspicious that this is incorrect.

任何人都可以帮忙吗?

推荐答案

我的工作解决方案...

My working solution...

InventDimParm       invDimParm;
InventDim           warehouseInvDim;
InventDim           salesLineInventDim;
;

salesLineInventDim = _salesLine.inventDim();

warehouseInvDim.InventSiteId = salesLineInventDim.InventSiteId;
warehouseInvDim.InventLocationId = salesLineInventDim.InventLocationId;

warehouseInvDim = InventDim::findOrCreate(warehouseInvDim);
invDimParm.initFromInventDim(InventDim::find(warehouseInvDim.inventDimId));

return InventSum::findSum(_salesLine.ItemId,warehouseInvDim,invDimParm).availOrdered();

我知道这是针对availOrdered()的，但是它对于availPhysical()的作用完全相同

I know this is for availOrdered() but it works exactly the same for availPhysical()

这篇关于查找物料/仓库的总可用物料和可用物料的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！