STMNTMNU Select and Print Financial Statements 3

Second Screen

 

Column Name

Type and Description

            (Type)

1 alphabetic character. Enter one of the following to delineate the Custom Statement Type.

 P             =             Present

B             =             Budget

C             =             Comparative

V             =             Variance

R             =             Ratio

 Note : Type R Ratio is valid for Profit & Loss Statements only.

 In change mode if a space is entered for an existing TYPE the following message will be displayed.

 Entering Space In Type Will Delete Entry. Ok to Continue? "Y" to delete the column.

(Period)

From

 

2 alphanumeric characters. Enter CP to delineate the Current Period or the Period Number (1-13) that you want to define.

 If type V (Variance) was entered in the previous field, specify the column numbers to be included in the variance.

 The "To" column should contain the base value for the variance calculation.

(Period)

To

 2 alphanumeric characters. Enter CP to delineate the Current Period or the Period Number (1-13). that you want to define.

 

 

(Year/Rev)

Year/Rev

 2 alphanumeric characters. Enter one of the following:

 PY          =             Previous Year

CY          =             Current Year

NY          =             Next Year

    Or

If the column has been defined as a Type C (comparative) enter the Year that you want to compare. For example, 89 for (1989), and 90 (1990) or PY for Previous Year. If the column has been defined as a type P, R or C this field entry is skipped.

 If a relative year assignment of PY, CY or NY is used it is referenced to the year of the last period in the period file. For example if the year of the last period was 1991 then CY would equal 1991, PY would equal 1990 and NY would equal 1992.

 Note: The information entered into the REV field applies to budgets only, since comparatives do not have revisions.

(Format Number)

Print Formatted Numbers?

 Y or N. Enter Y If you want to print formatted numbers or N to decline.

 An example of a formatted number is 9,999,999,99.

 An example of an unformatted number is 9999999.99.

(Rounding)

Option

 1 alphabetic character. Rounding enables you to decrease the column width to conserve horizontal space.

 Enter one of the following:

 N             =             No Rounding

D             =             To Dollar

T             =             To Thousand

M             =             To Million

 If this column is an R statement Type (Ratio), entry is not permitted.

(Titles)

Line 1

 17 alphanumeric characters. Enter the title to appear on the first line of the column each time an LEG command is encountered in the layout file.

(Titles)

Line 2

 17 alphanumeric characters. Enter the title to appear on the second line of the column each time an LEG command is encountered in the layout file.

 You may additionally specify a period ending date by entering the % sign followed by the period date. For example, %99/99/99.

 If you are working in a B (Budget) type column, enter % RR to reference a budget revision number.

 

Generalized Statement Selection

 

Name

Type and Description

1. Starting Specification No

3 numeric digits. Enter the starting specifications no. range, or press RETURN to default to All specifications.

2. Ending Specification No

3 numeric digits. Enter the ending specifications no. range, or press RETURN to default to the same value as entered for the starting specification number.

3. Select Consolidated                   Statements?

Y or N.  RETURN defaults to N.

 For purposes of this accounting package, a consolidated statement is understood to be a statement for which all accounts, regardless of profit center or financial entity designation, are included.

 This would be the statement for the entire company.

 When the question Select Consolidated Statements? is answered Y, specifications for which All profit centers have been chosen are selected to be printed on the next run. Conversely, if the question is answered N, any specification with All for the profit center designation will be passed over.

 This feature allows you to very quickly select from the specifica­tions you have on file those that pertain to consolidated company activity.

4. Select Statements for                 Financial Entity

5 alphanumeric characters. Press the F1 key to default to ALL financial entities (i.e., all specifications within a non-blank entity).

 The financial entity is looked up on the Financial Entity File, and the description is automatically displayed. The entry will not be allowed if the entity is not on file.

 Similar considerations apply here as do for the entry for 5 below.

5. Select Statements For Profit       Center

A standard profit center number in the standard profit center number format. Depending on the format of the profit center in the G/L account number. Press the F1key to default to ALL profit centers.

 If you wish to select statements for a specific profit center, enter the number of that profit center here. All specifications within the range that you entered with that profit center's designation will be selected.

 For example, if you wish to print out all statements and supporting schedules for profit center 0010, you must enter 0010 in this field. In order for the entry to be accepted, profit center 0010 must be defined in the G/L Account File. Refer to the Run Instructions for G/L Account File Maintenance if you are not sure how to do this.

 Pressing the RETURN key here defaults the entry to All. This means that all specifications with the designation of a particular profit center will be selected. This is not to be confused with the selection of consolidated statements.

For instance, there are specifications on file for three profit centers (00100, 00200 and 00300) as well as specifications for consolidated statements. All specifications for profit centers 00100, 00200 and 00300 would be selected.

 Specifications for consolidated statements (All profit centers) would be ignored, as well as specifications for specific financial entities.

 This feature allows you to select from the file of Statement Speci­fications each and every financial statement and supporting schedule that pertains to a specific profit center without requiring you to step through the entire file in change mode to set the Print Next Run? response to Y for the desired specifications.

 

List

 

Name

Type and Description

1. Starting Specification No

3 numeric digits. Enter the starting specifications range or press RETURN to default to All specifications.

2. Ending Specification No

3 numeric digits. Enter the ending specifications range or press RETURN to default to the same value as entered for the starting specification number.

3. For Financial Entity

5 alphanumeric characters. Press RETURN if you wish to print all specifications in the above range regardless of financial entity.

 

If a financial entity is entered, it must exist on the Financial Entity file.

4. Show Selected Specs

    Only?

Y or N.  RETURN defaults to N.

 If you answer Y to the question Show Selected Specs Only ? the report will show only those speci­fications for which the answer to Print Next Run ? in the Statement Specifications file is Y. This allows you to see very easily which specifications will be considered on your next financial statements run.

 


Print Standard Statements

 

Name

Type and Description

1. Starting Date

A standard date in the standard date format.

 The starting and ending dates entered will determine for which date the financial statement will print.

 The date will default to the current period starting date contained the G/L Accounting Period file if you press RETURN. You will be warned if the starting date entered does not correspond to a regular accounting period entered in the G/L Accounting Period file.

2. Ending Date

A standard date in the standard date format. This is the ending date for which financial statements will be printed.

 It will default to the current period ending date contained in the G/L Accounting Period file.

 

 

 

Feedback and Knowledge Base