Adding Title Lines

Sage ERP Accpac General Ledger 6.0

Adding Title Lines (\T)

The Financial Reporter allows you to specify up to five lines that can appear at the top of each tab of a Financial Statement.

You can only define one set of title lines in a specification, and all title lines must be together (contiguous). If you have defined more than one set of title lines, Financial Reporter will use the last set in the specification.

The first five lines of the report specification are the title lines, which will be repeated at the top of each tab of the report, as shown below.

The Universal Corporation

Balance Sheet

As at October 31, 1999

Current Balance

Petty cash

274.57

Bank account

8,437.54

Bank account, CAD dollars

4,372.96

Total:

13,085.07

If you wanted the title to appear only on the first tab of the report, leave the first column for these rows blank. The rows will be transferred "as Is" to the beginning of the Report range.

Using title lines in Excel instead of \T lines

Note that the title lines generated by Financial Reporter use the standard Excel mechanism for title lines, so if you use the Financial Reporter "\T" line, you cannot separately mark a group of cells as title lines. Note also that title lines must be consecutive, and cannot be split by a tab break.