Sales and Purchase Ledgers - Flipbook - Page 166
Report Generator
This is an extremely powerful tool used to create reports on the system. It is normally recommended that new
users have at least 6 months experience of using the system before contemplating attending Report Generator
courses.
Enquiries Menu
This option gives access to the Ad-hoc reporting tool. This is effectively a cut down version of Report Generator
and is an excellent introduction to the report writing facilities of the system. Quite powerful and useful reports can
be produced using this tool even though it is reasonably easy to use. Reports may be saved for individual or
group use as appropriate. Extensive help files assist greatly when beginning to use this tool.
Daily Operating Controls
This report will display or print a daily Sales Ledger control totalling invoices, credit notes, payments on account
etc. The report can be selected for a single or a range of days.
Currency Revaluation Report
This report is used when operating multi currency functionality.
Name and Address List
This report gives names, addresses, short names, nominal control account, area code, account type/category,
analysis/discount codes, telephone, and fax and telex numbers for the selected Sales Ledger accounts.
Aged Debtor Analysis
The Aged Debtor Analysis not only gives the aged balances for the selected customers but also allows reporting
of customers who are over their credit limit, have a non-zero balance, have overdue invoices, have unallocated
cash and/or are on stop. The report can be produced on a number of selection criteria.
Accounts List
This report gives the account number, name, short name, post code, area code, telex, telephone and fax
numbers. It is in effect a condensed version of the name and address list and can be selected by account type.
Turnover Analysis
This report details account number, name, area code, and the number of outstanding items on the account
together with the current balance, the total turnover on the account to date, for the year and the total for the
period. It also prints the credit limit for each account and is sorted by account type.
Note – the turnover may be inclusive or net of VAT depending on a system parameter.
Outstanding Items (Current)
The body of this report lists the items outstanding on the selected Sales Ledger account(s) together with a total
for each individual account.
Reports and Enquiries - Sales Ledger
01.01.600.01i – pwise – 01/06/06
Page 166 of 342
