OUTPUT DATA

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
type line.

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, i.e.:
F;(C1*100)/(C2+TOTAL1).

Literal data may be entered directly.

 

The codes used with account type lines are:
GL#	display the Chart of Account ID.
GL#;	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 GL#;ENT-ACCT
ENT	Entity portion of the ID, DEPT - department, ACCT account number.
GLDESC	General Ledger description from the Chart of Accounts file.
MTD	Month to Date amount.
MTDBUD	Month to Date budget amount.
MTDLY	Month to Date amount last year.
MTD#	Future Month to Date.
MTD2	2 mos. ahead MTD-# - Previous Month to Date. MTD-2 = 2 mos. prior
QTD	Quarter to Date amount.
QTDBUD	Quarter to Date budget amount.
QTDLY	Quarter to Date amount last year.
LQ	Last Quarter Amount.
YTD	Year to date amount.
YTDBUD	Year to date budget amount.
YTDLY	Year to Date amount last year.
BYB	Beginning Year Balance.
YTDACT	Year to Date Activity

TYPE

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
underlines.

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 column’s 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 column’s total will be prompted for.

TS - TOTAL LINE

Total line with output suppressed.

TEXT OR ACCOUNT NUMBER

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:
01.01.1000;BANK AMOUNT

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 is paged.

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
codes are:

T	Time, the current system time as HH:MMPM.
D	Date, the current system date as /web/YY.
ID	Input Date, from input when statement is run.
P	Page number.
SPn	Number of pages, i.e.: SP5
Cn	Center the line on "n" print positions, i.e.: C80

An example of the codes follows:

T;SP25;THIS IS A HEADING;SP25;D;C132

REV

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.

FORMAT

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 1000’s in numbers. Only one of the following alphabetic characters
may be used:

C	causes CR to follow negative values
D	causes DR to follow positive values
E	causes negative balances to be enclosed in arrows, i.e."<1234.56>
M	causes a hyphen (-) to follow negative values
N	causes the hyphen to be suppressed
S	causes all output in this column to be suppressed.

FORMULA

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. i.e.:

01(01);02(01,02,03);03(04,05)

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.:

TOT1=ST1+ST2+ST3