GL Report Writer - Editing a Report Row Record

GL Report Rows are added and edited by right-clicking on a row on the Rows and Columns sub-tab of the Setup GL Reports window:

Field Descriptions

Item	Description
Report	The name of the selected report. This is displayed by default.
Sequence	Enter a number here to set or change the sequence that the row performs its defined action. Note: You can also use the and buttons on the Setup GL Reports window to re-order report rows, which changes their sequence numbers.
Action type	Determines the function that the row performs. The table below lists and describes each function.
Caption	The description that appears in the row of the report.
GL Account range	The GL Account range to be reported on.
To	The GL Account range to be reported on.
Normally debit/credit	Determines what sign (+ve or –ve) to be applied to the number being printed.
Branch	Determines if the row is to be branch specific. If branches are being used in columns this should be set to Acc.
SQL filter	Used as the where clause in a SQL statement. Note: By default, this filter does not apply to the Budget column (if one exists). To make the SQL filter apply to the Budget column, enter /B= followed by the SQL statement to be run against the GLBUDGETS table, e.g. GLTRANS.BRANCHNO = 1 /B= GLBUDGETS.BRANCHNO = 1
Reset after print	Used with Sub Total, Total and Grand Total lines to reset the accumulator after printing.

Action types

The following types are available from the Action type dropdown:

	Item	Description
01	Main Heading	The heading text for the report, which is displayed in bold.
02	Sub Heading	Subheading text is displayed in bold and underlined.
03	Narrative	Narrative lines are plain text with no emphasis.
04	Page Break	This will force a page break at this row. This overrules any page length setting made on the Settings page.
05	Single Account Group	Allows the user to specify a GL account to be printed in the report.
06	Single Account Group Conditional on Value	Same as single account group but it allows user to specify Normally Debit/credit (Normally Debit/credit combo box on the screen is enabled) as an extra criteria
07	Sequential Range of Account Groups	If selected this shows information of GL accounts that falls in between the specified GL account group range.
08	Single General Ledger Account	If selected this shows information of a single GL account
09	Single General Ledger Account Conditional on Value	If selected this shows information of a GL single account but it allows user to specify Normally Debit/credit (Normally Debit/credit drop-down list on the screen is enabled) as an extra criteria.
10	Sequential Range of Accounts	If selected this shows information for a range of GL account.
11	Profit and Loss Account Range Total function	Allows the user to print a total similar to a P&L Range Value but which gets added as a P&L Total.
12	P&L Subtotal	Prints the total of the list above it. If the previous subtotal has not been reset then the subtotal also includes any prior subtotals.
13	P&L Total	Prints the subtotals above the total. If the previous total has not been reset then the total also includes any prior totals.
14	P&L Grand Total	Prints the totals above the grand total. If the previous grand total has not been reset then the grand total also includes any prior grand totals.
15	Bal Sheet Range Tot	The same as the P&L Range Total except that it is used for a Statement of Financial Position.
16	Bal Sheet SubTotal	The same as the P&L Subtotal except that it is used for a Statement of Financial Position.
17	Bal Sheet Total	The same as the P&L Total except that it is used for a Statement of Financial Position.
18	Bal Sheet Grand Total	The same as the P&L Grand Total except that it is used for a Statement of Financial Position.
19	P&L Ledger Total	Used in the Statement of Financial Position to provide the user with the sum of the current year’s Statement of Financial Performance. In a technical sense it is the total of the GLTRANS where the GLACCS section = 0 for the current financial year.
20	P&L Range Value	Allows the user to combine GL accounts based on a SQL Filter.
21	Bal Sheet Range Val	The same as the P&L Range Value except that it is used for a Statement of Financial Position.
22	Opening Stock	Used in conjunction with periodic closing stock.
23	Closing Stock	Used in conjunction with periodic closing stock.