Advanced Statement Formats
This selection enables you to create custom
financial statement formats.
Begin entering data, or enter END to exit this screen.
Enter a unique ID code which identifies the format. The
ID should contain standard
keyboard characters and no spaces. If the ID already exists, the rest of the
information will be displayed, allowing you to edit from the MODIFICATIONS
prompt. To search for an ID, enter ??? and RETURN to select from the list displayed.
Here, you may enter a longer, descriptive name for the
Enter the number of print positions between 0 and 132
which this column will
occupy on the report. Press the RETURN to to exit this prompt after all column
information has been entered, to access the line information portion of the screen.
Enter an L to have the data start printing at the left
side of the column, or enter an
R for data to be printed on the right side of the column. Example: (ABCD ) vs.
Enter the number of decimal positions to show in the
or 2). Example: 12, 12.0, 12.00
may enter up to 3 characters for this field from the following list:
||Prints a dollar sign in front of
||Prints a comma separating
1000s in numbers.
||Prints CR following negative
values, and nothing following positive or zero values.
||Prints DR following positive
values, and nothing following negative or zero values.
||Encloses negative balances.
||Prints - following negative values,
and nothing following positive or zero values.
||Causes the minus sign to be
You may specify literal data to be output or a formula
to calculate from other columns
or totals or a code to show an amount desired from the chart of accounts on an account
A formula must start with an "F;". Other column
data on the same line is specified with
a "Cn". Amounts on total lines may be specified by using to total name,
Literal data may be entered directly.
codes used with account type lines are:
||display the Chart of Account ID.
||after the semi-colon (;), the
following codes may be
used to control the display of the ID(END,DEPT,ACCT). All
other characters will be printed as entered, i.e.: GL#;ACCT or
||Entity portion of the ID, DEPT -
department, ACCT account number.
||General Ledger description from the
Chart of Accounts file.
||Month to Date amount.
||Month to Date budget amount.
||Month to Date amount last year.
||Future Month to Date.
||2 mos. ahead MTD-# - Previous Month
to Date. MTD-2 = 2 mos. prior
||Quarter to Date amount.
||Quarter to Date budget amount.
||Quarter to Date amount last year.
||Last Quarter Amount.
||Year to date amount.
||Year to date budget amount.
||Year to Date amount last year.
||Beginning Year Balance.
||Year to Date Activity
The valid types are:
H - HEADING LINE
Special text line that should be used at the top of the
first page. When a P
type line is printed, the last H type lines used are printed again. Also, if H type
lines come after other type lines, a form feed is executed before they are printed
except when the previous line is a P type line.
C - COLUMN HEADING LINE
Special text line that operates like the H type line.
This allows you to change H
type lines without affecting C type lines at Page time.
P - PAGE LINE
Prints the text associated with it, executes a form
feed, and prints the most
current heading and column lines. If H type lines directly follow the P type
line, they are printed instead of the previous heading lines.
TX - TEXT LINE
Will be printed "as is" where placed. Useful
for putting in commends and
A - ACCOUNT LINE
A valid Chart of Accounts ID will be prompted for to
supply data for the columns.
AS - ACCOUNT LINE
Account line with output suppressed.
NI - NET INCOME LINE
Used in balance sheet statements to be added into
retained earnings. It will be
printed out like an account line. When this is used, the system will calculate the
net income for the entity and departments specified.
NIS - NET INCOME LINE
Net income line with output suppressed.
S - SUBTOTAL LINE
This will accumulate all A type and NI type lines since
the last S type line and
will print the data in the columns. If a column formula has been specified, the
column formula will take precedence. A name for each columns subtotal amount
will be prompted for.
SS - SUBTOTAL LINE
Subtotal line with output suppressed.
T - TOTAL LINE
Allows the entry of a formula computed on the subtotal
lines. The result of this
formula will be printed. A name for each columns total will be prompted for.
TS - TOTAL LINE
Total line with output suppressed.
For A type lines, enter the Chart of Accounts ID. If you
wish to use a description
other than the one in the Chart of Accounts file, type it in after the ID using a ; to
separate. This text will only be used in a GLDESC output column. ie:
For NI type lines, the text will be used in the GLDESC
output column like the
A type lines.
All other line types will appear as entered. The text will
be printed from left to
right starting at the first print position.
On P type lines, the text will be printed before the output
In all text lines, some special codes are allowed. They
must be separated from each
other and the normal text by semi-colons (;). The codes insert data into the text. The
||Time, the current system time as
||Date, the current system date as
||Input Date, from input when
statement is run.
||Number of pages,
||Center the line on "n"
print positions, i.e.: C80
T;SP25;THIS IS A HEADING;SP25;D;C132
These Sub-Value line numbers correspond to the column
numbers. Enter Y
if you wish to multiply the amount by -1 to reverse the sign at display time.
Enter up to three characters. You may use the $ to
print the dollar sign in front
of the numbers output. Also, a comma (,) may be used to print the comma to
separate 1000s in numbers. Only one of the following alphabetic characters
may be used:
||causes CR to follow negative
||causes DR to follow positive values
||causes negative balances to be
enclosed in arrows, i.e."<1234.56>
||causes a hyphen (-) to follow
||causes the hyphen to be suppressed
||causes all output in this column to
For NI type lines, enter only on the first Sub-Value
line the entities to calculate net
income, separated by semi-colons (;). Use parentheses to surround the departments
desired. The same entities and departments will be used in all the columns.
Subtotal lines must be named. These lines will total all
account lines and NI lines
since the last subtotal line.
Total lines must be named. On total lines, a formula may be specified after the name
with an = separating them. i.e.: