Report - RF Open PO (Purchase Order)

Description

Purpose

The Research Foundation (RF) Open Purchase Order report displays all open purchase orders and closed purchase orders with remaining balances within the specified parameters. This monitoring report should be used to review open purchase orders and open purchase orders on terminating awards

Frequency

Reports can be scheduled or run on demand.

Setting Report Parameters

The following table describes the required parameters to use to run the report:


Parameter	Description (click in the field to see the List of Values)
Required Parameters
Days Terminating		Number of days until awards terminate. Defaults to 30. This will display the open purchase orders on awards terminating within 30 days. Value can be changed. The report displays the open purchase orders and closed purchase orders with balances remaining for awards terminating within the period defined by the Days Terminating parameter.
Location		User's campus location
No of Days Open		Number of days purchase order is open or closed with remaining balances. Defaults to 120. This will display the open purchase orders that have been open or closed with remaining balances for over 120 days. Value can be changed.
Username		Defaults with user name. Cannot be changed.

Understanding the Output

The RF Open PO Report is sorted by purchase order number. The table that follows describe the report output:

Column Heading	Description of Column
PO Number - Release	Purchase order, blanket purchase projection, or blanket release number.
Project	Project number that will be charged for the expenditure. Note: This column will be blank if the purchase order is a Blanket Purchase Projection
Award	Award number that will be charged for the expenditure. Note: This column will be blank if the purchase order is a Blanket Purchase Projection.
Task	Task number that will be charged for the expenditure. Note: This column will be blank if the purchase order is a Blanket Purchase Projection.
End Date	The award period ending date of the award that will be charged for the expenditure Note: This column will be blank if the purchase order is a Blanket Purchase Projection.
Close Date	The close date of the award. Note: This column will be blank if the purchase order is a Blanket Purchase Projection.
Expenditure Type	Expenditure type that will be charged. Note: This column will be blank if the purchase order is a Blanket Purchase Projection.
Supplier Name	Name of the vendor or person supplying the goods or services.
PO/Release Date	Date the purchase order, blanket purchase projection, or blanket release was entered.
PO/Release Balance	The balance of all items on the purchase order. If the purchase order is a blanket purchase projection then the balance is the Amt. Agreed - minus the total Released amount.

Helpful Tips

If both the Days Terminating and No of Days Open parameters are used, the resulting data will be a combination of the two results. For example, if Days Terminating is set to 30 and No of Days Open is set to 365, the resulting report will include all POs that are open or closed with remaining balances that have a PO date that is 365 days or more old or are for awards that are closing within 30 days.
For complete details on running Oracle reports, refer to the Run a Report help topic.
The report is available in PDF and ASCII (TEXT) format. PDF is a formatted, printable version. ASCII can be easily pulled into a spreadsheet or word processor.
Once you select a format and run the report, you cannot change the output format. You will need to run the report again and select the desired output format on the Submit Request form.

Effective Date: 10/24/2007 7:38:01 PM