This option allows the creation, editing and deletion of report formats. These formats are used to tailor the standard financial reports produced to your own requirements, taking into account company and department structure, special analysis levels and, within each report, such items as heading, totalling, columns and other presentation features. Producing summary reports is also a feature of the format language.
What do you want to do?
This form is displayed when you click Nominal ledger > Reports & enquiries > Edit Financial report formats.
Formatting Language Area
This area contains the formatting language commands to be used by the Financial Report.
Tip: In order to use the formatting language, specific training is required. Some users are happy to let their Software consultant produce the required formats on their behalf. Equally, other users, particularly where management reporting requirements are under on-going development, find it more convenient to learn the technique.
Buttons:
Open: Open an existing Financial Reports format.
Save: Save the current Financial Reports format.
Save As: Save the current Financial Reports format as a new report format.
Exit: Exit the Edit financial reports format function.
Help: Displays this help topic in a web browser.
No format selected Area - Buttons
Verify format: Verifies the current Financial Reports Format.
Delete format: Delete the current Financial Reports format.
Commands: List and select the available format commands.
Format fields: List and select the available format fields.
Clicking the Open button displays Open File Form
This form is displayed when you click Nominal ledger > Reports & enquiries > Edit Financial report formats > Open button.
Module Area
This area list all of the available module areas.
Format Report Area
This area lists all of the existing report formats
Fields
File name Defines the selected report format name.
Mask: Defines the file name suffix mask (.tb).
Push Buttons:
OK: Accept the selected report format for maintenance and populate the Formatting Language Area of the Edit Financial Report Form
Cancel: Cancel the selection of an existing Report format.
Clicking the Save button saves the current Report format to the selected report format name.
Clicking the Save as button displays Open File Form
This form is displayed when you click Nominal ledger > Reports & enquiries > Edit Financial report formats > Save as button.
Module Area
This area list all of the available module areas.
Format Report Area
This area lists all of the existing report formats
Fields
File name Enables the entry of a new Financial Report file name, replace the * with the new Financial report identifier.
Mask: Enables the entry of a new Financial Report mask identifier.
Push Buttons:
New: Accept and create the new Financial report format.
Cancel: Cancel the creation of a new Report format.
Clicking the Verify button performs a verification check on the Report format to ensure the correct and valid command usage.
Note: Messages will be displayed if any errors are identified or if the verification is successful.
Clicking the Delete button removes the current Report format from the system.
Clicking the Commands button displays the Commands Form
This form is displayed when you click Nominal ledger > Reports & enquiries > Edit Financial report formats > Commands button.
Note: In order to use the formatting language, specific training is required. Some users are happy to let their Software consultant produce the required formats on their behalf. Equally, other users, particularly where management reporting requirements are under on-going development, find it more convenient to learn the technique.
Commands List Area
This area list all of the available format commands, below is a summary example of the format commands.
NEWLINE: Indicates the a newline is to be inserted into the report.
TITLE: Defines the title heading for each page of the report
NEWPAGE: Indicates that a new page is to be inserted into the report.
PRINT: Defines that the report is to be printed.
EPRINT: Indicates the print is ito be in an extended format.
PAGE: Defines the report page number.
BREAK: Defines the point at which the report willstop printing.
START: Defines the point at which the report will start to print.
TOTAL:
PERCENT: Indicates that the percentage values are to be evalualted.
UNDER: Indicates that the printed line is to have a single under line format.
DOUBLE: Indicates that the printed line is to have a double under line format.
SIGN: Indicates that all values atre to be printed based upon the entered signage (+ / - ).
QUIT: Indicates that all printing is to stop.
DETAIL: If set to ON the report prints details lines (expense codes and balances), If set to OFF the report stops printing the detail ilnes.
GROUP: If set to ON the report is sorted into Group sequence with headings and subtotals.
FORMAT: Defines the column layout of the report.
HEADER: Defines the free format column headings
COSTCENT: Defines that only cost centre balances are to be selected for the report.
DIVISION:
ERROR: Defines that error messages are to be displayed when dividing by zero calculations occur.
IF: A Reserved word used within function logic processes, to define slection criteria.
DO: A Reserved word used within function logic processes, to define an action to be taken.
ENDDO: A Reserved word used within function logic processes, to define when a DO action to be stopped.
ROUTINE: Defines the name of the routine to be actioned.
RETURN: Indicates the functionality is to return back to the report.
CALL: Defines that a predefined programmed routine is to be activated.
SCALE: Indicates the the details lines are to be m,ultiplied by a scale factor.
SELECT: Defines the report selection criteria and general processing rules.
Note: If no selections are specified the report defaults to Select All expense codes and all balances.
NOT: A Reserved word used within function logic processes, to define that another reserved word is NOT to be actioned.
DIV:
PRINTER: Indicates that a report has been selected.
SCREEN: Indicates that a screen view has been selected.
THEN: A Reserved word used within function logic processes, to define the an action is to be actioned if function logic has met previous criteria.
ON: Indicates the a logic switch is to be set to Yes / ON
OFF: Indicates that a logic switch is to be seyt to No / Off.
BEGIN:
END:
PL: Indicates that only profit and loss balcnces are to be used.
BS: Indicates that only balance sheet codes and balances are to be used
BANK: Indicates that only bank accounts are to be used.
NOTBANK: Indicates that balance sheet codes except bank accounts is to be used.
ALL:
POSITIVE: Indicates that only items where the C/F is positive and non zero are to be used.
NEGATIVE: Indicates that only items where the C/F is negativee and non zero are to be used.
NONPOSITIVE: Indicates that only items where the C/F is negative or zero are to be used.
NONEGATIVE: Indicates that only items where the C/F is positivee or zero are to be used.
NONZERO: Indicates that only items where the B/F or current value is set to zero is to be used.
YEARBF:
Push Buttons:
Copy:
Cancel: Cancel the selection of a format command.
Clicking the Format fields button displays the Select From List Form
This form is displayed when you click Nominal ledger > Reports & enquiries > Edit Financial report formats > Format fields button.
Field List Area
This area list all of the available format commands, below is a summary example of the format fields.
Expense code:
Description:
Currency code:
B/forward (base):
Period (base):
C/forward (base):
Credit (base):
B/forward (currency):
Period (currency):
C/forward (currency):
Push Buttons:
OK:
Cancel: Cancel the selection of a format field.
Help: Displays this help file in a Web browser.