Substitution Codes

<< Click to Display Table of Contents >>

Navigation:  General Ledger > Financial Reporting > Setup & Special Features >

Substitution Codes

For Compilation Letters and report Title Descriptions (record type "T")

 

The text can also contain substitution codes.  These codes all start with a ^ (the symbol above the 6) and can be placed anywhere in the text.  These codes can also be place in Title lines and their meaning is determined based on the options specified when the report is printed.  The valid substitution codes are:

^0

Company Code

^1

Company Address 1

^2

Company Address 2

^3

Company Address 3

^4

City-state-zip

^5

Sub-Account Name

^6

Sub-Account Name 2

^7

Address 1

^8

Address 2

^9

Sub-Account code itself

^A

Cost Center Name (suppresses normal printing of the cost center)

^B

Balance Sheet Date (i.e. 80 character execution time option line)

^C

Current Fiscal year (2 digits).  (i.e. Fiscal Year ending YY.)

^D

Today's date spelled out.  (i.e. September 13, 2007)

^F

Variable date(s) spelled out depending on balance sheet type:

1 (non-comparative) - Current Period Ending Date (i.e. ^T)
2 (compare w/open entry) - Curr Period Ending Date "and" date of last day of last fiscal year. (i.e. March 31, 2007 and December 31, 2006)
3 (compare w/prior yr) - Current Period Ending date + Last Yr (i.e. ^U)
4 (compare w/any period) - Curr Period Ending date "and" date of comparative period (i.e. March 31, 2007 and February 28, 2007)

^G

Number of months in the current period

^H

"Month" or "Months" depending upon ^G

^L

Last year's fiscal year (2 digits).

^M

Months variable (i.e. one month; one month and three months; one month and six months; one month and twelve months, etc.)

^N

Company Name

^P

Number of periods in financial statements are covering (i.e. ONE, TWO, THREE, FOUR, etc.)

Number of months in YTD period (income statement)

^Q

"Month" or Months" depending upon ^P

^S

Current Period Ending Date (Month Day, no year)

^T

Current Period Ending Date spelled out (i.e. December 31, 2007)

^U

Current Period Ending Date + Last year (i.e. December 31, 2007 and 2006)

^ZS

Displays Sub-Accounts in a group