I am upgrading servers from 2008 to 2016 and my inventory alert is not working on Windows 2016 server installation. All other alerts are imported from 2008 server and working fine . I am receiving fallowing error :
Incorrect syntax near '<' but same query is working on Windows 2008 installation.
Any ideas or somebody with similar experience?
Query is below:
SELECT ICILOC.ITEMNO AS Item, ICITEM.[DESC] AS 'Desc', ICREORD.MINLEVEL AS 'Min Level',
ICILOC.QTYONHAND - ICILOC.QTYSHNOCST + ICILOC.QTYRENOCST + ICILOC.QTYADNOCST + ICILOC.QTYONORDER - ICILOC.QTYSALORDR AS NetQty,
ICREORD.PERIODSTRT AS [Per Start], ICREORD.PERIODEND AS [Per End], 19000000 + MONTH({ fn NOW() }) * 100 + 01 AS [Cur Month]
FROM ICITEM INNER JOIN
ICILOC ON ICITEM.ITEMNO = ICILOC.ITEMNO AND ICITEM.ITEMNO = ICILOC.ITEMNO INNER JOIN
ICREORD ON ICITEM.ITEMNO = ICREORD.ITEMNO AND ICILOC.ITEMNO = ICREORD.ITEMNO AND
ICILOC.QTYONHAND - ICILOC.QTYSHNOCST + ICILOC.QTYRENOCST + ICILOC.QTYADNOCST + ICILOC.QTYONORDER - ICILOC.QTYSALORDR < ICREORD.MINLEVEL
WHERE (ICILOC.LOCATION = 'PICK') AND ({*FormatReorderDate} <= ICREORD.PERIODEND AND ICREORD.PERIODSTRT <= {*FormatReorderDate})
ORDER BY ICILOC.ITEMNO