Navigation: Main Menu > Reporting Tools > Query > Query Viewer

1. On the search page of Query Viewer Search By“Query Name” begins with“CTC_LATE_RECEIPTS.”

2. Click Search.
3. Click either the HTML or Excel link for the query named CTC_LATE_RECEIPTS.

4. A new window will open and you will be prompted for the following:
   1. From Date
   2. To Date 
   3. Business Unit

5. Click View Results. Receipts that match your search criteria will be displayed with the following:
   1. Unit
   2. Receipt Nbr
   3. Received Date
   4. Receipt Line
   5. PO Unit
   6. Due
   7. PO Number
   8. SupplierNote: The query will return only those receipts that have a receipt match status of N (have not been matched), were received between the specified dates, and the receipt date is past due.