Formatting Rows

Sage ERP Accpac General Ledger 6.0

Formatting Report Lines

The format you apply to a line of a report specification is used for every line that it generates on the final report. In the following example, column titles are bold and underlined, and column G uses right alignment:

A

B

C

D

E

F

G

\\

 

Z

T

=FRACCT("ACCTID")

=FRACCT("ACCTDESC")

=FRAMT("BALP")

 

 

 

 

Account Number

Account Description

Current Balance

1100:1300

 

\

\

\

\

\

The column titles in the generated report are also bold and underlined, and all the figures in column G (Current Balance) are aligned to the right:

 

 

 

 

 

Account Number

Account Description

Current Balance

 

 

 

1100

Cash

462

 

 

 

 

1200

Bank Account

8,946

 

 

 

 

1300

Receivables

73,986

If you put a border around one cell of the specification, all cells that use the bordered cell as a template will have borders.