PO Report By GL Account Number

In the case of sequence number two, the system will proceed to prompt you for information regarding a single sequence specification based either on the GL account or ALIAS structure. Page breaking and sub-totals will be done based on the selected level.

Note: If a user is restricted to certain GL criteria, they will be prevented from modifying the existing criteria and the GL range option will not be available.

Select Level to Sort on

Enter the level (either GL or alias) to sort the report on
Accept the default, to produce the report in GL sequence.

Account Range or Criteria

Enter 'R' to select a starting and ending GL account.
Enter 'C' to select a GL Selection Criteria. Security exists to limit the available GL Selection Criteria if a symbol has been set up for the user.

If 'Range is selected, the following prompt will appear:

Enter starting G-L account #
Enter the GL account number to start reporting from or <Enter> to report on the first GL in your file.

If GL Selection 'Criteria can be selected the following prompt will appear:

Enter ending G-L account #
Enter the GL account number that you wish end reporting or <Enter> to end report on the last GL in your file.

Balances as at Period End

Enter Period #

Accept default, to have a report produced with current balances.
Enter period number to report on a prior period. The program will reconstruct the balance of the PO's at a specified period end. Note: PO's with a zero balance will not be reported.

Verify Commitment Balance

This prompt only appears when selecting PO Report by GL Account Number.

Enter 'Y' to verify the commitment balance. The verification process will compare the outstanding GL amount on the PO against the GL balance and report any differences. Note: Errors may not be detected if there is a commitment balance left in a GL account, but the sum of the PO's on this account is zero.

Display End Use

Enter 'Y' to display the end use of each PO on the report. The end use will be extracted from field 09 on the PO.
Enter 'N' if the end use of each PO is not to be displayed on the report.

Report by GL Sequence

In the case of sequence number 5, the system will proceed to prompt the user for information regarding the use of dictionary and the sequence specification.

Use the Dictionary

Entering 'Y' results in the use of the dictionaries for production of the descriptions for the general ledger accounts as displayed on the report.
Enter 'N' to use the description as shown on the GL record in the GL file.

Note: Use of the dictionary results in greater file activity and a longer run time for the report, although it provides more meaningful descriptions on the output.

Change Parameters in Level

Enter the level number for the appropriate element name you wish to change in terms of size or the skip before or skip after requirements for the printing of your report. This sequence may be repeated until the levels which are to be used in the report have all had the appropriate changes made to their characteristics.

Enter Level Selection Sequence

Enter each of the 2 digit level numbers to be used in the production of the report. <Enter> after entering each level number. When the last element has been entered for the construction of the account code, <Enter> to begin the questions regarding batch and printer output options.

Enter Number OF OVERRIDE BREAKS

Enter a number from zero to the maximum number of levels included in the account structure used to produce the report. This number controls the number of total breaks that will be taken during the production of this report.

If a zero is entered, the report will reproduce a grand total only.

PO Statistics Report

Starting Report Date

Enter the start date to include on the report
Accept the default, to report on the oldest date on file.

Ending Report Date

Enter the last date you want included on the report
Accept the default, to accept the most recent date on file.

Starting Purchase Order

Enter the first PO to include
Accept the default, to report on the oldest PO on file.

Ending Purchase Order

Enter the last PO to include
Accept the default, to report on the most recent PO on file.

Minimum Dollar Amount

Enter the minimum dollar amount to appear on the report
Accept the default, to report on all PO's within the selected range regardless of the dollar amount.

Maximum Dollar Amount

Enter the maximum dollar amount to appear on the report
Accept the default, to report on all PO's within the selected range regardless of the dollar amount.

Sort Order

Enter 'P' to produce the report in PO number sequence.
Enter 'V' to produce the report in vendor number order.
Enter 'A' to produce the report in dollar amount order. The amounts will be reported in smallest to largest dollar amount sequence.
Enter 'G' to produce the report by GL level. A window displays listing all levels of your GL account. Use arrow keys to select the level to sort the report by.

If 'G' is selected, the following prompts will appear:

Secondary Sort Order

You can select a secondary order to sort your report.

Enter 'P' for PO order
Enter 'V' for vendor order
Enter 'A' for amount order.

Report Expenditures and Budgets

Enter 'Y' - To see the expenditure and budget information
Enter 'N' to bypass the expenditure and budget information.

Selection Criteria Code

To use criteria selection use Lookup.

GL: Year for Validation

The GL in your master profile will be displayed.

Accept the default, to accept the year as displayed
Enter a new year. GL accounts are validated against this year.