GL Maintain Header 'B' type columns
The GL Maintain Header 'B' type columns screen is accessed by clicking Maintain in Maintain Report Parameters (GL05). This button is only activated when the 'Types of Headers' section is set to 'User Defined Columns (B)' in GL05.
The following list defines every field on the 'GL Maintain Header 'B' type columns' screen:
- Column - enter the Column number with which you want to work. If you are creating a Total line, click Total and a 'T' automatically displays in this field.
- Change Sign - is for display purposes only and does not affect calculations. When you select the check box, a leading minus sign is NOT printed on credit Account balances. This is appropriate for all Revenue, Liability and Equity Accounts. When this check box is not selected, a leading minus sign IS printed on credit Account balances. This is appropriate for Asset and Expense Accounts with a credit balance.
- Formula - Formulas consist of one or more of the following elements:
- a Column number
- a plus sign (+)
- a minus sign (-)
OR an upper-case 'P', which is used to indicate that Column is the total of previous Columns back to, and including, the last sub-total Column.
Note: If this Column is not a sub-total Column, the Formula field should be blank.
Here are some examples of how to use formulas:
- To add the values in Columns 1, 2 and 3 together, enter 1+2+3
- To subtract the value in Column 2 from Column 3, enter 3-2
- Header 1/2/3/4/ - enter up to 4 lines of Column Headers. Each Header can be a maximum of 10 alpha-numeric characters in length.
The following table outlines the functionality of each button on the 'GL Maintain Header 'B' type column' screen:
Button Label |
Icon |
Functionality |
Update |
|
Updates the information entered for the current Column.
|
Delete |
|
Deletes the information entered for the current Column.
|
New |
|
Clears all the fields on the screen allowing you enter new Column information.
|
GL Maintain Header 'B' type columns
|