In this topic you will learn how to Run the ZZCLEANUP_PO_ACTIVITY Query.
NOTE: The ZZCLEANUP query can only be run from the Reports (PS9FSRPT) database. It cannot be run in the Production (PS9FSPRD) database.
A portion of the Query Name must be known and entered in order to retrieve the desired information. The Query Name field is not case sensitive; lower, upper or mixed case letters may be entered.
Click the HTML link for the ZZCLEANUP_PO_ACTIVITY query.
Enter the desired information into the Business Unit field. Enter "LSUSH".
NOTE: 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.
Enter the desired information into the Beg Accounting Date field. Enter "110115".
Enter the desired information into the End Accounting Date field. Enter "113015".
NOTE: It may take several minutes for the results to display since the data is being pulled from many tables.
You may download your HTML results to either of the following:
Excel Spreadsheet: The results will display to a web page in Internet Explorer. The Excel functionalism (Data, Sort and Filter, Format Cells, etc.) are available in the web page.
CSV Text File: When you select this option, the results download into Microsoft Excel and can then be sorted and filtered as needed.
Click the Close button on the Excel spreadsheet.
Click the Close button on your search page.
The system also provides the option of running the query and displaying the results directly in Excel. This option will be demonstrated now.
Enter the desired information into the Beg Accounting Date field. Enter "110115".
Enter the desired information into the End Accounting Date field. Enter "113015".
NOTE: Only one PO line is displayed for the original encumbrance amount. No payment has been made against this PO.
Click the Close button on the Excel spreadsheet.
Click the Close button on the search page.
The query results display at the bottom of the page. The query displays one line for the original encumbrance amount and a line for each payment (liquidated amount)
In this example, only one result was returned. Generally, the system will display the first 100 items on the screen. You would use the arrows and links on the far right of the page view additional pages.
Enter the desired information into the Business Unit field. Enter "LSUSH".
This completes Run the ZZCLEANUP_PO_ACTIVITY query.
A portion of the Query Name must be known and entered in order to retrieve the desired information. The Query Name field is not case sensitive; lower, upper or mixed case letters may be entered.
Enter the desired information into the Business Unit field. Enter a valid value e.g. "LSUSH".
NOTE: 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.
Enter the desired information into the Beg Accounting Date field. Enter a valid value e.g. "110115".
Enter the desired information into the End Accounting Date field. Enter a valid value e.g. "113015".
Enter the desired information into the Beg Accounting Date field. Enter a valid value e.g. "110115".
Enter the desired information into the End Accounting Date field. Enter a valid value e.g. "113015".
Enter the desired information into the Business Unit field. Enter a valid value e.g. "LSUSH".