[Roman777]

еще вариант (а вдруг подойдет?)

PHP код:

static void Job24(Args _args)
{
    InventSum           inventSum;
    InventDim           inventDIm;
    ItemId              itemId      = '747642';
    InventLocationid    iLocation   = 'Location';
    ;

    while select itemId, sum(postedQty), sum(received), sum(deducted), sum(registered), sum(picked)
        from inventSum
        group by itemid
        where inventSum.ItemId              == itemId
    join    inventDIm
        where inventDIm.inventDimId         == inventSum.InventDimId &&
              inventDIm.InventLocationId    == iLocation
    {
        Info(strfmt("%1     %2", InventSum.ItemId, inventSum.physicalInvent()));
    }
}