Run the CLEANUP_PO_ACTIVITY Query

In this topic you will Run the CLEANUP_PO_ACTIVITY Query.

NOTE: This query must be run in the Reporting database. It cannot be run in Production.

A portion or all of the Query Name must be known and entered in order to retrieve the desired information. The Query Name field is not case sensitive.

Query results can be run to two formats: HTML and Excel. Queries should first be run to HTML to ensure all results are viewed.

You may run the query for a specific department by entering the department number, or you may utilize the "wild card" (%) to run the query for the entire Business Unit.

The query will retrieve only those lines that have a remaining amount other than zero.

NOTE: It may take several minutes to display results since the data must be pulled from many different tables within the system.

The query results will display at the bottom of the page. Only the first 100 lines displaying for view.

Click the Right button of the scrollbar to view additional information.

Results can be downloaded from HTML to Excel by clicking the Excel Spreadsheet link. This will open a new window.

You also have the ability to run your query directly to an Excel spreadsheet.

Click Signout then click File, Exit.

In this example only 10 lines have been retrieved. When working in Production if more than 100 lines are retrieved, click the right arrow to view the next page.

Run the CLEANUP_PO_ACTIVITY Query

This completes Run the CLEANUP_PO_ACTIVITY Query.

A portion or all of the Query Name must be known and entered in order to retrieve the desired information. The Query Name field is not case sensitive.

Enter the desired information into the begins with field. Enter

a valid value

e.g.

"CLEANUP"

Enter the desired information into the Business Unit field. Enter

a valid value

e.g.

"LSUNO"

Enter the desired information into the Department field. Enter

a valid value

e.g.

"11015%"

Enter the desired information into the Beg Accounting Date field. Enter

a valid value

e.g.

"070111"

Enter the desired information into the End Accounting Date field. Enter

a valid value

e.g.

"063012"

Enter the desired information into the Business Unit field. Enter

a valid value

e.g.

"LSUNO"

Enter the desired information into the Department field. Enter

a valid value

e.g.

"11015%"

Enter the desired information into the Beg Accounting Date field. Enter

a valid value

e.g.

"070111"

Enter the desired information into the End Accounting Date field. Enter

a valid value

e.g.

"063012"