(Contents) (Previous)(Next)

Reports and Enquiries

In the Reports and Enquiries menu, the fact that the Autoline Nominal Ledger is structured round a database approach to business applications should be apparent, including the facilities of the Ad-hoc enquiries option and the pre-set reports.

Note: The 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.

To Access the option:

  1. 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.

  2. Select the Reports and Enquiries option.

    The NL REPORTS AND ENQUIRIES MENU is displayed.

For the purposes of this help topic, we will assume that the user will not exit from this menu, hence, how to select individual reports will not be discussed in detail.

Upon entry into this menu,the user will be presented with all the pre-set reports, as well as the Ad-hoc and Report Generator report 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. Consequently the Report Generator menu option is not discussed in this topic. It is discussed, however, in System Utilities help topics.

OVERVIEW

To access a report, select the relevant report from the menu and click OK. For the majority of the reports, the user either has to enter some sort of selection criteria before being allowed to run the report or can simply 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 allows users to run several [often related] reports in a group at once. [e.g. to save time they may run the batch whilst away from their terminal] To run a batched report:

Select the report you wish to run, and fill in the relevant selection criteria, if any is required. If the report is available to be batched on, there will be a button entitled "Add to batch", which must be clicked to bring up a child window prompting the user to enter a Report Group There is no search facility here but if the user types 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 will allow the user to set the priority required to execute the report.

Once 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 the user 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 the user 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, the user can Run batch, Exit altogether, or access online Help .

To Schedule a report, the user will enter the relevant selection criteria, then click the Schedule button on the form. This will then bring up the Timed Operations screen, and from there the user 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? [Reports available to run]

ENQUIRIES MENU: The facilities of the Ad-hoc enquiries option are common to all Autoline software applications. These facilities allow you to create and formulate your own ad-hoc enquiry from any of the available files which will be displayed to you on entry into this sub-system. For further information on this topic, refer to the Ad-Hoc Enquiries on-line help.

Daybook enquiries: This option on the Nominal Ledger Reports and Enquiries menu provides access to a sub-menu with five report generator defined options to interrogate various files concerned with daybooks.

Locate a daybook: Allows you to interrogate the Nominal Ledger daybook log file (NL.daybk) for particular daybook(s).

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: This option 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: This option 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: This is the last option within the Daybook Enquiries sub-menu, and 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.

REPORTS ON THE MAIN MENU

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 allows you to view on the screen a Financial Report/Trial Balance, using a variety of criteria [if required] to customise the report output.

Print financial report: This option allows you to Print a Financial Report/Trial Balance, in an identical manner to View Financial Report except the output is printed.

Edit financial report format: This option allows 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 will be 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 will list 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.

Related topics:

Batch Printing

(Contents)(Previous)(Next)(Top of the Page)