X++:
if (salestable.salesid == (select salesid
from salestable
join wmspickingroute
where salestable.salesid == wmspickingroute.transrefid
&& salestable.SalesStatus == salesstatus::completeleft
&&( wmspickingroute.expeditionstatus == wmsexpeditionstatus::started
|| wmspickingroute.expeditionstatus == wmsexpeditionstatus::activated)))
так проще ошибку найти