Assets NOT Scanned in Stocktake Since Date

This query can be run to find all the assets that have not be scanned in 12 months or 24 months in a stocktake, so we know the missing items.  You'll need to change the EntryDateTime to get the records within your specified timeframe.

You can execute this query using Excel Query Builder in RentalPoint...

SELECT A1.*
FROM tblAsset01 A1
WHERE ISNULL(A1.asset_code, '') <> ''
  AND A1.ASSET_CODE NOT IN
    (SELECT DISTINCT A.asset_code
     FROM tblasset01 A
     INNER JOIN tblStockTakHistory S ON S.Product_code = A.PRODUCT_COde
     AND S.Stock_Number = A.STOCK_NUMBER
     WHERE EntryDateTime < '2016-12-31' )