[Ace of Database]

Я считаю остатки на дату так:

PHP код:

static InventQty physicalQuantity(
                            ItemId _itemId,
                            InventLocationId _inventLocationId,
                            TransDate _perDate
                           )
{
    InventSumDatePhysicalDim    isd = new InventSumDatePhysicalDim();
    InventDim                   dim;
    InventDimParm               p;
    ;
    dim.InventLocationId = _inventLocationId;
    isd.parmInventDim(dim);
    isd.parmItemId(_itemId);
    isd.parmPerDate(_perDate);
    p.initFromInventDim(dim);
    isd.parmInventDimParm(p);
    isd.init();
    return isd.physicalQuantity();
}