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 the Ad-hoc enquiries option, refer to the Ad-Hoc enquiries on-line help. Hence the actual formulation and running of the enquiries are not discussed in this topic, instead some detail is provided on the files that appear on the menu.
To access the menu:
From the Autoline master menu select the company you require and then select the Nominal Ledger option in the module list.
Select the Reports and Enquiries option.
Select the Enquiries Menu option.
The Enquiries Menu form is displayed.
The Enquiries menu allows access to the standard Ad-hoc enquiry facility on any one single file within the Nominal Ledger module structure. It also contains options where specific file relationships have been logically 'joined together' for you as follows. In this case, the field names are preceded by a number to denote from file they are being accessed in order to avoid possible conflict or duplication, and you are prompted as to whether these file links should be kept open. Up to four files can be treated in this way, and are displayed on the menu:
Account header: The prime file here is the Accounts header file (NL.accts) which contains one record for every valid cost centre/Expense code combination. In addition to this file, the Cost centre file (NL.ccent) and the Expense code file (NL.expen) are available as files 2 and 3 respectively.
Transactions: The prime file here is the Nominal ledger transaction file (NL.trans). In addition to this file, the Accounts header file (NL.accts), the Cost centre file (NL.ccent) and the Expense code file (NL.expen) are available as files 2, 3 and 4 respectively.
Archived transactions: The prime file here is the Nominal Ledger transaction archive file (NL.atran). In addition to this file, the Accounts header file (NL.accts), the Cost centre file (NL.ccent) and the Expense code file (NL.expen) are available as files 2, 3 and 4 respectively. If the set up uses them, accounting divisions are also available for selection when using this
Previous Transactions: This shows previous transactions which have not been archived. The year required and the division [if applicable] are available for selection here.
Cost centres: The prime file here is the Cost centre file (NL.ccent) which contains one record for every valid cost centre. In addition to this file, the Cost centre group file (NL.ccgrp) and the Nominal Ledger divisions file (NL.divsn) are available as files 2 and 3 respectively.
Expense codes: The prime file here is the Expense code file (NL.expen) which contains one record for every valid Expense code.
