Generate a Receipt Notice Report

Purpose: Use this document as a reference for how to run the Receipt Notice Query in ctcLink.

Audience: Purchasing Staff

Generating a Receipt Notice Report

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.”


Query Viewer
  1. Click Search.
  2. Click either the HTML or Excel link for the query named CTC_LATE_RECEIPTS.
  1. A new window will open and you will be prompted for the following:
    1. From Date
    2. To Date 
    3. Business Unit
View Results page
  1. 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.


Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.