BPM To check if there is an open DMR before close 9.05.603

Epicor ERP 9
1

Good Morning,
I am trying to write a BPM to check for DMRs before we close a job. I saw the thread here and am trying the suggestion:

https://epiusers.help/t/trigger-alert-on-job-close-when-a-open-dmr-for-same-job-exists/25683

but am getting an error that it is “Unable to find any table in the query.” All the tables turned purple and I even tried using the editor to write the query but still get the same error. Any ideas what I could be doing wrong?

Thanks,
Melissa

for each ttJobClosing where (ttJobClosing.RowMod = ‘A’ or ttJobClosing.RowMod = ‘U’) , first DMRHead where DMRHead.Company = ttJobClosing.Company and DMRHead.JobNum = ttJobClosing.JobNum and DMRHead.OpenDMR = True no-lock