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
- On the search page of Query Viewer Search By“Query Name” begins with“CTC_LATE_RECEIPTS.”
![Query Viewer](https://media.screensteps.com/image_assets/assets/000/006/922/original/5c5fd5b0-276c-427d-b10f-fee7916ad754.png)
- Click Search.
- Click either the HTML or Excel link for the query named CTC_LATE_RECEIPTS.
![Query](https://media.screensteps.com/image_assets/assets/000/006/924/original/e3211437-92f3-48f2-a8dd-d40b36f3b6c1.png)
- A new window will open and you will be prompted for the following:
- From Date
- To Date
- Business Unit
![View Results page](https://media.screensteps.com/image_assets/assets/000/006/926/original/b07febb2-5dd4-4ab0-8e8a-fcb65b17ab86.png)
- Click View Results. Receipts that match your search criteria will be displayed with the following:
- Unit
- Receipt Nbr
- Received Date
- Receipt Line
- PO Unit
- Due
- PO Number
- 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.
0 Comments
Add your comment