How do you create an exception report to identify item that have no cross referencing information.
Ex: Checks to invoices. Invoices are scanned, indexed in OnBase and imported into Oracle for processing. Once the invoice is validated in Oracle and a check is cut the check file is staged for OnBase to retrieve the file and cross-reference the checks with the invoices in a nightly process. When inquiring on the invoice number we now have access to the check by using cross-referencing and vice-verses .
I need a report created that would show any invoices that did not get linked to a check but should have.
Thank
Cheryl
