Create/maintain your line formats for your custom GL reports.
Required for user-defined GL Reports.
Note: this Help Topic lists the standard configuration of all fields that may be included in this record. If you are using a customized system, the fields displayed on your screen may not exactly match the order or status (required, optional, default, display-only, hidden, etc.) of the fields described in this Topic.
GL Report Format Id:
Uniquely describes this line format. This field is required.
GL Report Format Name:
Optional. Briefly describes this format.
Security Id:
If multiple location security is implemented on your centralized database system, this informational field displays the Security Id of the local user that created this record. If multiple location security is not implemented on your system, or if this record was created by a global user, this field will be blank.
1 5 10 15 20 25 30 35 0 45 50 55 ...
(Column Definition)
The characters in the column definition field determine the content and position of the information on this line. The numbers listed above this field indicates the column position the text or information with appear on. By default, reports will print in the fixed-width 8 point Courier New Bold font in landscape orientation. This font/orientation allows up to 156 columns to be printed per line. Other font/orientation combinations may be selected when the report is generated.
Blank Lines and Text Headers
You may create generic Report Formats to insert blank and dashed lines into your reports. For example, you could create a Report Format named blank with the column definition field empty. Where 'blank' is included in a GL Report, a blank line would be generated for spacing purposes. Report Formats containing only dashes or equal signs enable you to easily demarcate subtotals, totals, or headers.
Header lines (e.g., General and Administrative Expenses) should be positioned as you wish them to appear on the report (e.g., at the left-hand side, or with leading blanks added for centering). Hint: begin all header format Id's with the characters HDR to make them easy to identify when creating a GL Report.
Extraction Formulas
Lines that are intended to extract and display actual account information are defined using the following formats. The information will be printed beginning at the column location where the @ sign appears in the formula. Note that the Current Period and Prior Period are defined when the GL Report is run: click on Printing GL Reports for details.
Report Format Max. Columns Result
@ID 10 Print Account Id
@NUMBER 10 Print Account Id
@NAME 40 Print Account Name
@ENTITYID 10 Print GL Entity Id
@ENTITYNAME 40 Print GL Entity Name
@ACT 10 Current Period Account Activity
@ACTB 10 Budget: Current Period Account Activity
@PACT 10 Previous Period Account Activity
@PACTB 10 Budget: Previous Period Account Activity
@END 10 Ending Balance
@ENDB 10 Budget: Ending Balance
@BEG 10 Beginning Balance
@BEGB 10 Budget: Beginning Balance
@PEND 10 Previous Ending Balance
@PENDB 10 Budget: Previous Ending Balance
@CPaccountid% 10 The current period as a percentage of the total account
specified by accountid. When entering this format, you will replace
accountid by the Id of a specific total account.
@CYaccountid% 10 The current year as a percentage of the total account
specified by accountid. When entering this format, you will replace accountid
by the Id of a specific total account.
@PPaccountid% 10 The prior period as a percentage of the total account
specified by accountid. When entering this format, you will replace accountid
by the Id of a specific total account.
@PYaccountid% 10 The current year as a percentage of the total account.
When entering this format, replace accountid by the Id of a
specific total account.
@CPBaccountid% 10 The current period budget as a percentage of the total account.
When entering this format, you will replace accountid by the Id of a specific total account. For example, if you specified a cost of sales total account, this formula could be run against various expense accounts in the gl report definition.
@CYBaccountid% 10 The current year budget as a percentage of the total account.
Replace accountid with the Id of a specific total account. For example, if you specified a cost of sales total account, this formula could be run against various expense accounts in the gl report definition.
@PPBaccountid% 10 The prior period budget as a percentage of the total account.
Replace accountid with the Id of a specific total account.
@RTBaccountid% 10 The prior period budget as a percentage of the total account.
Replace accountid with the Id of a specific total account.
@RTaccountid% 10 The prior period as a percentage of the total account.
Replace accountid with the Id of a specific total account.
@PYBaccountid% 10 The current year budget as a percentage of the total account.
When entering this format, replace accountid by the Id of a specific total account.
@VARP 10 This year's current period budget - actual.
@VARY 10 This year's budget - actual.
@PVARP 10 Last year's current period budget - actual.
@PVARY 10 Last year's budget - actual.
Hint: Total Lines are generated by specifying Total Accounts.
Also See...
GL AccountsGL_Accounts_Viewer GL ReportsGeneral_Ledger_Report_Viewer_(Old_Version) Print GL Report
The following text formats show how to enter a header at the left of the page, a centered header, and a line of dashes:
General and Administrative Expenses
General and Administrative Expenses
--------------------------------------------------------------------------------------------------------------------------
Example: Extraction Formula
The following extraction formula prints the account number, name, current period activity, and the current period as a percentage an account named '300', and the ending balance:
@ID @NAME @ACT @CP300% @END