To anyone who has the time to consider this;
What would be a valid WHERE clause to use in a Free SQL Statement in an AutoIndex job that uses a file cabinet for for both the iterated File Cabinet and External data source where the match code is the Inoice Number, Vendor Name and Amount but does NOT match on DocID?
I'm filtering the File Cabinet for any invoice status 'New' and assuming I need the SQL Statement for the filter on the External Source. I cannot use the Status field as a filter on the External side (Status NOT New) as some invoices may still have that status until they are processed.
What I'm trying to do is catch any newly stored invoices that might be duplicates of some invoice that has already been stored, but make sure that I don't catch the one that was just stored. AI job runs every 10 seconds.
Thanks in advance for any suggestions,