29.05.2006, 12:26
|
#1
|
Участник
|
Цитата:
Сообщение от Sada
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)); }
ругается однако
|
|