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.
The Enquiries menu allows access to the standard Ad-hoc enquiry facility on any one single file within the Sales 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 (SL.accts) which contains one record for every valid Sales ledger account.
Transactions: The prime file here is the Sales ledger transaction file (SL.trans). In addition to this file, the Accounts header file (SL.accts) can be linked to.
Archived transactions: The prime file here is the Sales Ledger transaction archive file (SL.atran). In addition to this file, the Accounts header file (SL.accts)can be linked to.
Payments: This shows items that have been paid in the Sales Ledger. A link to the account header file is available here.
Archived Payments: The prime file here is the Archived Payments file. Again, a link to the accounts header file is available.
