Generate an Overdue PO Report
Purpose: Use this document as a reference for how to run the Overdue Purchase Order Query in ctcLink.
Audience: Purchasing Staff
Generating an Overdue PO Report
Navigation: Reporting Tools > Query > Query Viewer
On the search page of Query Viewer Search By“Query Name” begins with“CTC_PO_OVERDUE.”
- Click Search.
- Click either the HTML or Excel link for the query named CTC_PO_OVERDUE.
- A new window will open and you will be prompted for the following:
- Date Option: Available options include One Week Late, 2 Weeks Late, and Select Dates
All fields are required
- Click View Results. The query will display POs that are late within the constraints of the Date Option field.
- The output includes:
- Business Unit
- Buyer Name
- PO ID
- PO Line
- PO Schedule
- Item Descr
- Ship To
- Due Date
- Days Late
- Weeks Late
- Months Late
Note: If you select Select Dates as the Date Option,the query will return POs due between those dates. Otherwise the query will ignore the From Date and To Date and will return POs that are 1 or 2 weeks old (based on the PO due date and the system date at run time).