I am trying to run a formatted search to display a simple estimated delivery time for each line item in my sales order. My query is as follows:
SELECT (CASE
WHEN (T0.OnHand - T0.IsCommitted) > 0
THEN (DocDate + T0.LeadTime)
WHEN (T0.OnHand - T0.IsCommitted) <= 0
THEN (DocDate + 5 + T0.LeadTime)
END)
FROM OITM
WHERE T0.ItemCode = $[$38.1.0.0]
This query errors out, any ideas?