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

Query Viewer page
  1. Click Search.
  2. Click either the HTML or Excel link for the query named CTC_PO_OVERDUE.
Query
  1. A new window will open and you will be prompted for the following:
    1. Date Option:  Available options include One Week Late,  2 Weeks Late, and Select Dates
    2. FromDate
    3. ToDate
    4. BusinessUnit

All fields are required

View Results page
  1. Click View Results. The query will display POs that are late within the constraints of the Date Option field.
  2. The output includes:
    1. Business Unit
    2. Buyer
    3. Buyer Name
    4. Supplier
    5. PO ID
    6. PO Line
    7. PO Schedule
    8. Item
    9. Item Descr
    10. Category
    11. Ship To
    12. Amount
    13. Due Date
    14. Days Late
    15. Weeks Late
    16. 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).

0 Comments

Add your comment

E-Mail me when someone replies to this comment