Hi,

I've been using the sample query Retrieve Stock from All Locations from the Linnworks Documentation, and I'd like to know if there is something I can add to the script that will give me a time or date stamp to show when the report was generated.

The script currently (as on the Linnworks Documentation) is:

SELECT

                si.ItemNumber,

                si.ItemTitle,

                sLoc.Location,

                sl.Quantity,

                sl.MinimumLevel,

                sl.InOrderBook,

                sl.OnOrder,

                il.BinRackNumber

FROM

                [StockItem] si

                LEFT OUTER JOIN StockLevel sl ON si.pkStockItemId = sl.fkStockItemId

                LEFT OUTER JOIN StockLocation sLoc ON sl.fkStockLocationId = sLoc.pkStockLocationId

                LEFT OUTER JOIN ItemLocation il ON il.fkStockItemId = si.pkStockItemId AND il.fkLocationId = sLoc.pkStockLocationId

WHERE

                si.bLogicalDelete = 0

ORDER BY

                si.ItemNumber,

                sLoc.Location

Any suggestions?

Thanks.

Fantastic. Thanks.