Debtors Report

Use the Debtors Report to produce a list of the outstanding customer debts as at today, aged according to the length of time the debt has been outstanding. Ageing values are displayed for up to four foreign currencies on the customer account. Unallocated cash is shown as a total only.

If you need a report that displays your debtors position as it was on a specified date, you can use the Retrospective Debtors Report for this purpose.

Box	Description
Sequence	The sequence you want for the report. You can produce the report in 'Account', 'Region', 'Territory', 'Customer Type' or 'Balance' sequence and use the From and To lists to define the range of records you want included.
Currency	The currency in which you want company debt totals to be displayed in addition to the home currency debt total. A maximum of 20 currencies can be included on the report. If you select a specific currency, the report will include the total debt in that currency in addition to the home currency total. If this report is saved as a spreadsheet, it displays foreign currency values only if one currency is selected. If more than one currency is selected the values are displayed in the home currency.
Total Debt	Includes accounts where the total debt exceeded the level you enter. In the Over list, select whether the total debt exceeds a zero balance or exceeds the credit limit.
Due Dates	The range of due dates to include in the report.
Show Transactions	When selected the report displays the transaction detail for each account.
Advanced Transactions	When selected the report displays the advanced transaction details. If the Advanced Transactions box is ticked, allocated advanced transactions are included in the appropriate ageing columns on the report. Unallocated advanced transactions are included in the Unalloc column. If the Advanced Transactions box is not ticked, advanced transactions are shown in the Advanced column on the report.

Open the Sales Ledger folder and then click Reports - Debtors Report or click the Financials tab and then click Sales Ledger - Reports - Debtors Report on the Ribbon Bar. Or click Sales Ledger - Credit Management and then click Action - Reports - Debtors Report.

In the Sequence list, select the sequence option you want. You can produce the report in 'Account', 'Region', 'Territory', 'Customer Type' or 'Balance' sequence then use the From and To lists to define the range of records you want included in the report.
In the Currency list, select the currency in which you want company debt totals in addition to the home debt total. The default is 'ALL' (a maximum of 20 different currencies included on the report). If you select a specific currency, the report will include the total debt in that currency in addition to the home currency total.
Select the Total Debt option to include accounts where the total debt exceeds the level you enter in box provided. In the Over list, click to select whether the total debt exceeds was above a zero balance or above the credit limit.
Under Due Dates, use the From and To boxes to enter the range of transaction dates to include in the report.
To show the transaction detail for each account included in the report, select the Show Transactions option. To include advanced transactions (those posted to a future period), select the Advanced Transactions option.
Click OK.
On the Publisher form, click the tab to select the output device you want to use and then complete any settings or options you want to apply to the output device. To process the output, click Publish.

To save this report in Opera 3 as a Microsoft Excel spreadsheet, select Excel Report from the Report Layout box on the Publisher form.