MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > General Ledger > Screens > Financial Statement Title > GL300S02 - Financial Statement Line Description

GL300S02 - Financial Statement Line Description

  

 

WILLIAMS                        GENERAL LEDGER                        12/22/92

 DSP01         FINANCIAL STATEMENT TITLE FILE MAINTENANCE             LINE DESC

                                                                          ENTER

       Report Group                                                            

       Company/Location         001  BRU                                       

       Center                                                                  

       Report Type              B                                               

       Statement Code           A99       Reporting Class      C               

       Sequence No              4                                              

                                                                               

       Accumulator Code         1                                              

       Percent Denominator      0                                              

       Fin or Stat              F                                              

       Print Statistics         N                                              

       Edit Code                Y                                              

       Dollar Sign              N                                              

       Underscore               N                                              

                                                                               

       Line Description         PREPAID EXPENSES                               

                                                                                

                                                                               

 F2=Command          F3=Exit             F4=Prompt           F7=Rpt Heading    

 F10=Search          F19=Mass Maint                                            

                                                                               

 

 

The Financial Statement Line Description screen defines the descriptions, level of detail and calculations for each line.  The sequence number determines the order in which each line within a single statement code will be printed.

REPORT GROUP

Optional.  This field is used to identify a group of locations for which a financial statement is being created.  One or more locations may be assigned to one group.  If entered, the group must exist on the Reference File.

COMPANY/LOCATION

Optional.  The company/location field identifies the reporting entity for which a financial statement is being created.  If entered, the entity must exist on the Reference File.

CENTER

Optional.  Financial Statements may be prepared only for a given center.  The center level in the organizational structure may be used for sales locations, operational departments, or other areas for which an Income Statement is desired.  A center can have both Balance Sheet and Income Statement accounts assigned to it.  However, only Income Statement reports can be prepared for centers.  The center must exist on the Account/Center Master File if entered.

REPORT TYPE

Required.  The report type field defines the type of report being created.  Based on the report type being created, line descriptions will either appear left justified or centered.  Valid values are:

B - Balance Sheet (left justified)

I - Income Statement (centered)

STATEMENT CODE

Required.  The statement code is used as a sequential line reference for each Financial Statement line.  Statement codes must be assigned sequentially within each report type for an entity.  Line descriptions are printed on each Financial Statement.  Statement codes are also assigned to the Account/Center Master File accounts that will be included in each Financial Statement line.

REPORTING CLASS

Required if management accounts are used.  Enter the reporting class to be associated with this financial statement detail line.  The line will be printed on all financial statements with the same reporting class.  Valid values are:

C - Common

F - Fiscal

M - Management If you choose the common (C) reporting class, the line will be printed on all financial statements.  This field is only displayed if the Use Management Accounts flag is set to yes (Y) on Reference File category 133.

SEQUENCE NUMBER

Required.  If several report lines contain the same statement code, different sequence numbers must be assigned to each line.  Sequence numbers identify the order in which each line within a single statement code will be printed.  Sequence numbers are typically assigned to non-amount fields that will be printed consecutively.  Sequence numbers are also assigned to a group of lines sharing one statement code.  The amounts from each line are accumulated into a subtotal line which is indicated by a change in accumulator code (see below).  If only one report line uses a statement code, the sequence number should be 01.

ACCUMULATOR CODE

Optional.  The system provides six levels of accumulators to develop subtotals and totals for all columns of data on Financial Statements.  Assign a single-digit accumulator code to each Financial Statement line description record for which amounts or quantities should be accumulated for printing.  Separate accumulators are maintained for financial and statistical amounts.  The accumulator code controls printing and clearing of these accumulator levels.  Typically, single line amounts are assigned low accumulator codes.  Subtotal, total, and grand total lines are assigned higher codes.  Valid codes and their functions are as follows:

0 - Prints line description only; does not print amounts;

1 - Prints level 1 accumulators and resets them to zero;

2 - Prints level 2 accumulators and resets levels 1 and 2 to zero;

3 - Prints level 3 accumulators and resets levels 1, 2, and 3 to zero;

4 - Prints level 4 accumulators and resets levels 1, 2, and 3 to zero;

5 - Prints level 5 accumulators and resets levels 1 through 4 to zero;

6 - Prints level 6 accumulators and resets levels 1 through 5 to zero;

9 - Returns printing to the top of the next page before processing the next line description record.

PERCENT DENOMINATOR

Optional.  Percent columns are printed on Income Statements and are calculated by dividing the current and year-to-date actual amounts by one of nine base denominator amounts.  This facility allows the preparation of percentages based on financial amounts or statistical amounts.  The percent denominator code assigned to a line description identifies the base denominator amount used to calculate the percent value for the line.  (Percent denominator codes are also assigned to the Account/Center Master File accounts to be accumulated into each base denominator amount.)

FINANCIAL/STATISTICAL

Required.  Financial and statistical amounts can be printed on Financial Statements.  This data type code is used to define which type of data to print on the specified line.  Valid values are:

F - Financial

S - Statistical

PRINT STATISTICS

Required.  The statistical amount print code is used to identify when accumulated amounts are to be printed, and the line description associated with the statistical amounts.  Valid values are:

Y - Yes (print statistical amount)

N - No  (do not print statistical amount)

EDIT CODE

Required.  Account balances in the General Ledger System follow normal accounting conventions for debits and credits.  Asset and expense accounts normally have debit balances, while liability, retained earnings, and revenue accounts normally have credit balances.  Standard accounting procedures also dictate that debit and credit signs usually are not printed following account balances on Financial Statements unless the balance of an account is the opposite of its normal balance.  The edit code controls the printing of debit and credit signs on Financial Statements.  Valid values are:

Y - Print CR for credit amounts

N - Print DR for debit amounts

In general, lines containing asset and expense account amounts are assigned an edit code of Y so that a credit sign (CR) is printed only if the line amount contains a credit balance.  Likewise, liability, retained earnings, and revenue accounts are assigned an edit code of N so that a debit sign (DR) is printed only if the line amount contains a debit balance.

DOLLAR SIGN

Required.  This field is used in order to print or suppress the dollar sign on amount lines.  Valid values are:

Y - Yes (print dollar sign)

N - No  (do not print dollar sign)

UNDERSCORE

Required.  This field is used to control the printing of an underscore beneath the amounts on a given report line.  Valid values are:

Y - Yes (print underscore)

N - No  (do not print underscore)

LINE DESCRIPTION

Optional.  Line descriptions may be entered to be printed on Financial Statements.  If a Balance Sheet is being processed, the line description will appear left justified on the report.  If an Income Statement is being processed, the line description will appear in the center.  When entering a line description for a Balance Sheet, if an indented description is desired, blank spaces must be entered as part of the line description.

COMMAND KEYS

F2    - Display a window where a fast path option or mnemonic can be entered.  Fast path allows the next menu selection to be made directly from this screen.  When the window is displayed, pressing F3-Exit will remove it.

F3    - Exit the program and return to the menu.

F4    - Display a list of values for the field where the cursor is positioned.  If you select one of the items from the list, it will be returned to the application screen.

F7    - Display a blank report heading screen in enter mode.

F8    - Display the Line Description screen.  (Displayed only in review mode.)

F10   - Display the Search screen, which allows you to select a heading on line description record that has already been created.

F13   - Delete all records for the currently displayed report.  (Displayed only in review mode.)

F14   - Delete the currently displayed record.  (Displayed only in review mode.)

F19   - Display the Mass Maintenance screen, which allows you to duplicate title file records or change a report number.

F24   - Display additional command keys available from this screen.