Statement Row / Account List Utility

The Statement Row/Account List Utility will analyze a statement to determine which General Ledger accounts are included and which accounts are not included. Part 1 of the report will list all accounts used in the statement, whether they be individually referenced, included as part of a range, or included in an external reference. Part 2 of the report will use the range specified in the setup screen to determine if any accounts defined by this range are not found in the statement.

1) Access this utility from the main General Ledger screen >Statements> Utilities>Analysis and select the

button.

Upon making this selection, the following message will appear, click OK to continue.

2) The Statement Account Analysis Utility screen will appear. Select the statement you wish to analyze, and then select the accounts you would like the utility to use in determining if they are included in the statement you specified above.

Outlined below is an explanation of each field. Use these to guide you through the entry screen above.

Stmt Code to Examine:

Scroll down to select the Statement Code for which you would like to run this utility.

Options for Part II of Report

Starting Account

Enter the Starting Account number in the range of accounts you wish the utility to use in determining if they are included in the statement you specified above.

Ending Account

Enter the Ending Account number in the range of accounts you wish the utility to use in determining if they are included in the statement you specified above.

Entity Code to Use (Optional)

If you wish to use this option, Select the Entity Code you wish to use.

Printing Options

Form / Queue

The system will automatically default to Lists / Lists, and the report will print Portrait. However, if you wish the report to print Landscape, you may select a different Form / Queue.

Once you have made your selections, press F2 to continue.

4)You may view the report on the screen or print it to your printer. Part 1 of the report will list all accounts used in the statement, whether they be individually referenced, included as part of a range, or included in an external reference. Part 2 of the report will use the range specified in the setup screen to determine if any accounts defined by this range are not found in the statement.

Sample Report shown below: