box that enables you to set the priority required to execute the report.Standard pre-set reports are described in this topic, but the flexibility of configuration in Autoline may result in individual installations having extra pre-set options in the menu.
Note: Report Generator is covered in a separate on-line help topic.
To access the option:
From the Autoline Master Menu, select the company you require and then select the Nominal Ledger option in the module list.
The NOMINAL LEDGER Main Menu is displayed.
Select the Reports and Enquiries option.
The NL REPORTS AND ENQUIRIES MENU is displayed.
For the purposes of this help topic, it is assumed that you will not exit from this menu. How to select individual reports is not covered in detail.
Upon entry into this menu, all the pre-set reports are displayed, as well as the Ad-hoc and Report Generator facilities. This help topic is only designed as an overview of reports within the Nominal Ledger, rather than a detailed topic of how to write and run Report Generator reports.
To access a report, select the relevant report from the menu and click OK. For the majority of the reports, either enter some sort of selection criteria before continuing to run the report or click the OK button to process the report. Most reports can be either printed Immediately by clicking OK or in a Batch print by clicking the Batch button.
The Batch button option enables users to run several [often related] reports in a group at once (for example, to save time they may run the batch whilst away from their terminal).
To run a batched report:
Select the report you want to run, and fill in the relevant selection criteria, if any is required. If the report is available to be batched, there will be a button entitled Add to batch, which must be clicked to display a child window prompting you to enter a Report Group There is no search facility here but if you type in an entry that does not already exist, it will be created there and then, and if the entry does already exist, it will be added to the report group. There is also a box that enables you to set the priority required to execute the report.
When a report has been added to a group, the running of the batch can take place. This actually takes place by selecting the Report Generator menu option, and then selecting the Batched Reports option. Consequently you can select the report group required [Batch Identifier] with the box, and this will display all the reports in the selected group. At this point you can also Amend the selection criteria of a report, can Exclude it from the group at this time, or Remove it from the group completely. Alternatively, you can Run batch, Exit altogether, or access online Help.
To Schedule a report, enter the relevant selection criteria, then click the Schedule button on the form. This displays the Timed Operations form, and from there you can add the report to run at a time and frequency that is convenient. For more information, refer to Batch Printing.
What do you want to do?
Create an ad-hoc enquiry: For further information refer to Ad-Hoc Enquiries.
Interrogate files concerned with daybooks: Access any of five report generator defined options.
Locate a daybook: Interrogate the Nominal Ledger daybook log file (NL.daybk) for particular daybooks.
Display a daybook: Displays, for each daybook selected, all of the transactions, detailing the daybook number and item number within daybook, the sequence number, the cost centre and expense code, the suffix and Sales or Purchase Ledger account where appropriate, the source module and journal type, the document number and value (in base currency), and the VAT code. The daybook date AND daybook number must be entered to run this report successfully.
Print a daybook: Prints, for each daybook selected, all of the transactions, detailing the daybook number and item number within daybook, the sequence number, the cost centre and expense code, the suffix and Sales or Purchase Ledger account where appropriate, the source module and journal type, the document number and value (in base currency), and the VAT code. The daybook date AND daybook number must be entered to run this report successfully.
Print a journal sequence: Prints, for each daybook selected, all of the transactions, detailing the cost centre and expense code, the suffix and Sales or Purchase Ledger account where appropriate, the document number, the source module and journal type, the posting date, the journal reference and narrative, the value as a debit or credit value in two different columns (in base currency), and the VAT code. The report will subtotal the values on change of Journal sequence number, and subtotal with a new page on change of Journal type. Again the daybook date and number must be entered to run this report successfully.
VAT summary: Displays, for each daybook selected, a subtotal for each VAT code within Daybook number order. For each daybook and VAT code combination selected, the system will show the VAT code, the number of entries, the goods value and the VAT value. The report will subtotal the values on change of daybook number. Daybook date and number must be selected to run this report successfully.
Expense code audit print: The Nominal Ledger expense code (or chart of accounts) file is normally an audited file. This means that any additional codes created and any existing codes which are amended or deleted are written to an audit file with the before and after values of the fields that were affected.
View financial report: This option enables you to view a Financial Report/Trial Balance, using a variety of criteria [if required] to customise the report output.
Print financial report: This option enables you to Print a Financial Report/Trial Balance, in an identical manner to View Financial Report except that the output is printed.
Edit financial report format: This option enables the creation, editing and deletion of report formats.
Print financial report format: On selecting the option Print financial report format, a list of available formats is displayed. These may be selected and printed.
Transaction analysis by suffix: This report produces a list of Nominal Ledger transactions sorted by suffix for any one Nominal account code. A cut-off date and the ability to print the report in transaction detail or as a totals only [summary] report, allow for further customisation.
Bank transaction report: Provides printed output and interrogates the Nominal Ledger transaction file for a given expense code and all dates or a range of dates.
Chart of valid accounts: This report lists all the cost centres present on the system, and the expense codes that are validly linked with these cost centres. The report will be in cost centre sequence without breaks and will list relevant cost centre fields.
List of cost centres: This report lists all cost centres (departments/profit centres) which have been created on Autoline. The report will be in cost centre sequence showing the cost centre short name, description, the group to which the cost centre belongs and the management account code to which the cost centre is mapped.
HMC & E Reports (When Product Installed).