![]() |
#8 |
Участник
|
Я бы еще подправил метод
\Classes\InventSumDateEngine\selectInventOnHand вот это место X++: insert_recordset inventSumDateTrans (ItemId, PostedQty, ReceivedQty, DeductedQty, PickedQty, RegisteredQty, PostedValue, #InventDimFields, ParmId, TransType) select ItemId, sum(PostedQty), sum(Received), sum(Deducted), sum(Picked), sum(Registered), sum(PostedValue) from inventSum group by ItemId where inventSum.Closed == NoYes::Yes join #InventDimFields, parmId /*scalar*/, inventSumDateType /*scalar*/ from inventDim group by #InventDimFields where inventDim.InventDimId == inventSum.InventDimId exists join inventTrans where inventTrans.ItemId == inventSum.ItemId && inventTrans.InventDimId == inventSum.InventDimId && inventTrans.DateStatus >= perDate; Насколько я помню используется только в одном отчете по остаткам. |
|