GL Template Functions

AA - Account Accumulate

AP - Account Print

AR - Add Account to Ratio Base

ARA - Account Range Accumulate

ARP - Account Range Print

ARR - Add Range to Ratio Base

CLR1 - Clear Subtotal Level 1

CLR2 - Clear Subtotal Level 2

CLR3 - Clear Subtotal Level 3

CLR4 - Clear Subtotal Level 4

CLR5 - Clear Subtotal Level 5

CLR6 - Clear Subtotal Level 6

CLR7 - Clear Subtotal Level 7

CLR8 - Clear Subtotal Level 8

CLR9 - Clear Subtotal Level 9

CPAT - Print Accumulated Total (Credit)

CR - Clear Ratio Base   

CSB1 to 9  - Totals and places parenthesis around credit

CVAR -  Print Variable (Credit)

CVAR1 through 10 - Clear Variable 1 through 10

CVARA - Clear all Variables

DEFINE - Define Custom Variable

DL - Double Underline

DPAT - Print Accumulated Total (Debit)  

DSB1 to 9 - Subtotal Level 1 - 9 (Debit)

DVAR - Print Variable (Debit)

FF - New Page

HEADER - Print Header (left)

HEADERC - Print Header (centered)

HEADERR - Print Header (right)

LF - Linefeed

UL - Underline

VAR - Set Variable(s) to Print

VAR1 - Add to Variable 1

VAR2 - Add to Variable 2

VAR3 - Add to Variable 3

VAR4 - Add to Variable 4

VAR5 - Add to Variable 5

VAR6 - Add to Variable 6

VAR7 - Add to Variable 7

VAR8 - Add to Variable 8

VAR9 - Add to Variable 9

VAR10 - Add to Variable 10

 

Custom Variables:

PUM reports:

The DEFINE function must be on the first line of the template with a formula entered in Description.

Enter a formula similar to this:  PUM(000,001A) or PUM(000,????)

Stands for per unit months (area#, community#).  Question marks are used to indicate that there a multiple communities within the area.

In the Column Specification Master:

A formula must be entered in the Expression area for a column with a Column Type of Column Calculation

Enter a formula similar to this:  Column#/[PUMY or PUMM(area#,community#)]  For example:  C3/[PUMY(000,001A)]