Hello!
I need to get a stock filtered by warehouse.
Here is my query, I've optimized it to work faster by placing a condition into virtual table parameters:
Code |
---|
SEL ECT StockSliceLast.Quantity, StockSliceLast.Inventory, StockSliceLast.Cell FR OM InformationRegister.Stock.SliceLast(&Period, Contractor = &Contractor) AS StockSliceLast |
The problem is that it returns all inventory which ever have been assigned to this contractor while I need only ones which are in stock by the date in Period.