Purpose of Each Column in a Specification

Sage ERP Accpac General Ledger 6.0

What Each Column Does in the Financial Report Specification

Most of a financial report specification is a template for the report it produces. For example, all report formatting -- such as column widths, fonts, highlighting and underlining -- appears on the financial report specification.

The first four columns of the report specification (usually columns A through D) contain important control information.

Column A determines the purpose of a row

For example, a row can be a comment, a title line, a default line specification, a line of text on the final report, or an account detail line.

Column B restricts the set of accounts specified in column A

For example, you can restrict the account range to income accounts with a normal credit balance.

Column C removes zero-balance lines from a report or overrides a default condition to remove zero lines

You can also suppress lines that meet other criteria (such as less than 5,000).

Column D consolidates ranges of accounts or lists them individually

Allows you to consolidate by account number segment, and to consolidate transaction details or list them individually.

See also