Помогите сваять отчет по остаткам на складе

[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));

}