PHP код:
static void Job110(Args _args)
{
inventtrans inventtrans;
inventdim inventdim;
inventsum inventsum;
;
select sum(Qty),sum(costAmountPosted),
sum(costAmountAdjustment) from InventTrans index hint ItemIdx
group by ItemId
where
InventTrans.DatePhysical <= ваша дата &&
InventTrans.ItemId == "ваша номенклатура" &&
InventTrans.StatusIssue != StatusIssue::OnOrder &&
InventTrans.StatusIssue != StatusIssue::Picked &&
InventTrans.StatusIssue != StatusIssue::ReservOrdered &&
InventTrans.StatusIssue != StatusIssue::ReservPhysical &&
InventTrans.StatusIssue != StatusIssue::Deducted &&
InventTrans.StatusIssue != StatusIssue::QuotationIssue &&
InventTrans.StatusReceipt != StatusReceipt::Registered &&
InventTrans.StatusReceipt != StatusReceipt::Arrived &&
InventTrans.StatusReceipt != StatusReceipt::QuotationReceipt &&
InventTrans.StatusReceipt != StatusReceipt::Ordered
join inventDim index hint DimIdIdx
where inventDim.inventDimId == InventTrans.inventDimId &&
inventDim.InventLocationId == "ваш склад";
inventDim.inventDimId;
info(strfmt("%1, %2 ",inventtrans.Qty, inventtrans.costAmountAdjustment + inventtrans.costAmountPosted));
}