This should be easy - am I losing it?
In SQL I produce job numbers for quick job entry using something like this (obviously with other criteria):
select d.partnum, d.orderqty, CONVERT(varchar,d.ordernum)+'-'+CONVERT(varchar,d.orderline) jobNum from Production.erp.OrderDtl d where CONVERT(varchar,d.ordernum)+'-'+CONVERT(varchar,d.orderline) not in (select jobnum from Production.Erp.JobHead)
Now automating this, and I’ve been fiddling with this on and off for days - haven’t been able to figure out how use a calculated field in a
where NOT in select statement in a BAQ.
I’m telling everyone (with Great Sincerity ®) to stick to Epicor tools so I have to figure this out!