Skip to Content
0
Former Member
Sep 30, 2005 at 11:34 PM

Estimating Delivery Time

12 Views

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?