X++:
InventSum inventSum;
WmsPallet wmsPallet;
InventDim inventDim;
;
while select inventSum
where inventSum.ItemId == "a25009"
&& inventSum.Closed == NoYes::No
&& inventSum.ClosedQty == NoYes::No
join inventDim
where inventDim.inventDimId == inventSum.InventDimId
exist join wmsPallet
where wmsPallet.wMSPalletId == inventDim.wMSPalletId
&& wmsPallet.IsPalletBlocked == NoYes::Yes
{
inventSum.PhysicalInvent += inventSum.PhysicalInvent;
}
info(strfmt("%1", inventSum.PhysicalInvent));
Не знаю как точно поле для связи называется на таблице WMSPallet