View & Print the Requisition Budgetary Activity Report to HTML

In this topic you will learn how to View & Print the Requisition Budgetary Activity Report to HTML. This report will retrieve information on Requisitions submitted to Purchasing from your Department, for a specified period of time. You will be able to view any remaining pre-encumbrance amounts in this report.

NOTE: This report must be run in the PS9FSRPT database.

Click Purchasing link.

The first time you use this method, you will need to create a Run Control ID in order to access the Process Scheduler. Click on the Add a New Value tab or hyperlink to create the Run Control ID.

The system defaults you into the Find an Existing Value tab. On all subsequent prints, you will use the Find an Existing Value tab to search for existing Run Control IDs.

The Report Request Parameters page displays. The user will enter or select the Report Request Parameters.

Note: If you had selected an existing Run Control ID, the above page would contain the parameters from the last time you ran the report.

To eliminate retrieving all Requisitions for all 11 Business Units, the minimum entries required are the following:

• Business Unit

• The DeptID or Project/Grant, if applicable. If Project/Grant is entered, there is no need to enter any other parts of the ChartString since a Project/Grant number is tied to only one ChartString.

NOTE: If this involves a Project/Grant, you may retrieve information since the inception of the Project/Grant.

For all documents for a specific fiscal year, enter 07-01-XX to 06-30-XX in the From and To fields.

The user will specify the Remaining Amount fields as follows:

• If you wish to view all of your Department’s Requisitions, generated during a specific period, regardless of the balance (i.e. those with a Remaining Balance of Zero, as well as those not equal to a Remaining Balance of Zero), do not specify an operand and accept the default entry of 0 (Zero) in the Remaining Balance field;

• You may specify an operand and enter the dollar amount in the adjacent field or accept the default entry of 0 (Zero); or

• For the purposes of managing encumbrances, the user will select “Not Equal” (< >) to a Remaining Amount of 0 (Zero) so that only the Requisition Lines with a Remaining Amount (including credits) will be retrieved.

Enter ChartField Options

The user may enter a single or multiple ChartFields.

• If the user wishes to specify a different ChartField value than what is displayed in the ChartField field, he/she should click the ChartField lookup button and select another value (Account, Dept ID, Fund, Program, Class Project ID, etc.);

• If the user wishes to specify more than one ChartField value, he/she will need to click the Add a New Row (+) button to insert an additional row(s) and select the appropriate values.

• If the user wishes to run the report to view all Requisitions for his/her Business Unit, click the Delete a Row (-) button to delete the row indicating the ChartField value.

NOTE: Most users will not run all Requisitions their Business Unit.

NOTE: When a specific Project/Grant value is entered, the remaining fields may be left blank since there would only be one ChartString for the specific Project/Grant.

To add additional ChartField values:

Click the Add a new row at row 1 button.

NOTE: The values entered in the Requisition Budgetary Activity Parameter page, in this example, will retrieve only those Requisitions, for the Department and Budget Dates specified, with a Remaining Amount not equal to 0 (Zero).

Select the PSNT option.

Click the Refresh button until the process is complete (i.e. Run Status = Success and Distribution Status = Posted).

Click the Administration tab to access the report.

This action opens a new window.

As specified in the Requisition Budgetary Activity Parameter page, only the Requisition line(s) with a Remaining Amount are retrieved. This will make it easier for the user to analyze the report when determining the pre-encumbrances that need to be closed or adjusted.

TIPS:

Pre-Encumbrance:

If the user finds that a pre-encumbrance remains (even after the PO has been built), he/she should contact Purchasing (i.e. the Buyer associated with the PO) for assistance rather than AP.

View the fields on the Requisitions Budgetary Activity Report.

Print the report:

Click the Print icon on the toolbar or click the File menu.

NOTE: You may save the report by clicking Save As or email the report by clicking Send, Page By E-mail.

NOTE: Select print options and click OK.

Click the Close button or Select: File, Close to close the report.

A Run Control ID is used as a means to access the Process Scheduler. You may save parameters related to a particular process or report to a Run Control ID to minimize data entry when running recurring process and/or reports.

A Run Control ID is:

1. Specific to the end-user's Operator (User) ID;

2. Can be entered in upper case, lower case, or mixed case;

3. Can be up to 30 characters long;

4. Characters can be either number or letters, but CANNOT include any special characters (e.g. $, &, #, commas, apostrophes, etc.);

5. CANNOT contain blank spaces; and

6. Must be one continuous string of characters. If using more than one word the words must be linked by an underscore.

Run Control ID (continued)

Examples of Run Control IDs that meet the requirements:

1. print_request can be used since an underscore links the two words together; or

2. printrequest can be used because it is one string of characters.

Run Control ID (continued)

Examples of Run Control Ids that do not meet the requirements:

1. print request because there is a blank space between the two words; or

2. print_request's because a special character is used. In this example an apostrophe is used.

Run Control ID (continued)

Creating a new Run Control each time you print requires you to re-enter your print parameters each time as well. By selecting the Find an Existing Value tab and use an existing Run Control ID, the Requisition Print page will display print parameters from your most recent print request. Entering the new Requisition ID would be the only piece of information needed.

View & Print the Requisition Budgetary Activity Report to HTML

This completes View & Print the Requisition Budgetary Activity Report.

Select the PSNT option.

Click the Requisitions link.

Click the Reports link.

Click the Req and PO Budgetary Activity link.

Click the Add a New Value link.

Enter the desired information into the Run Control ID field. Enter

a valid value

e.g.

"REQ_ACT_REPORT"

Click the Add button.

Click the Collapse Menu button.

Enter the desired information into the Business Unit field. Enter

a valid value

e.g.

"LSUNO"

Enter the desired information into the Budget Date From field. Enter

a valid value

e.g.

"07012010"

Click the Choose a date button.

Click the desired date.

Click the button to the right of the Remaining Amount field.

Click the Not Equal (<>) list item.

Click the Look up ChartField button.

Click the DEPTID link.

Enter the desired information into the From ChartField Value field. Enter

a valid value

e.g.

"1053000"

Click the Add a new row at row 1 (Alt+7) button.

Click the Look up ChartField button.

Click the CLASS_FLD link.

Enter the desired information into the From ChartField Value field. Enter

a valid value

e.g.

"10105"

Click the Delete row 2 button.

Click the OK button.

Click the Save button.

Click the Run button.

Click the button to the right of the Server field.

Click the Requisition Budgetary Activity option.

Click the Process Monitor link.

Click the Refresh button.

Click the Go back to Req and PO Budgetary Activity link.

Click the Report Manager link.

Click the Administration tab.

Click the Requisition Budgetary Activity link.

Click the Maximize/Restore button.

Click the desired object.

Click the Print... list item.

Click the Close button.

Click the OK button.