[Владимир Максимов]

А посмотреть, что именно запрос находит? В смысле, какую именно дату

    ItemId      itemId      = 'XXXXX';
    InventDimId inventDimId = 'AAAAJWTIQ';
    TransDate   transDate   = str2DateDMY('12.03.2015');
    InventTrans inventTrans;
    ;

    select firstonly inventTrans
    order by DatePhysical asc
    where InventTrans.ItemId        == itemId
        && InventTrans.inventDimId  == inventDimId
        && InventTrans.DatePhysical >= transDate;

    info(strFmt('>= %1', InventTrans.DatePhysical));

    select firstonly inventTrans
    order by DatePhysical desc
    where InventTrans.ItemId        == itemId
        && InventTrans.inventDimId  == inventDimId
        && InventTrans.DatePhysical <= transDate;

    info(strFmt('<= %1', InventTrans.DatePhysical));