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

E-Mail me when someone replies to this comment