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:
WHEN (T0.OnHand - T0.IsCommitted) > 0
THEN (DocDate + T0.LeadTime)
WHEN (T0.OnHand - T0.IsCommitted) <= 0
THEN (DocDate + 5 + T0.LeadTime)
WHERE T0.ItemCode = $[$126.96.36.199]
This query errors out, any ideas?