To Create a Sales Aged Debt Report
Separate Reports Tick Box
If the report is to be run on more than one event/publication, tick this box if you would like the reports separated out.
Tick this box if you would like the report listed by transaction code rather than company code.
Cut off Date
Enter a cut off date for the transactions reported on. This will be defaulted to today's date but can be changed to produce a back dated aged debt report. Allocations are not represented on back dated reports.
Include Final Items Only
This box is ticked by default to only include transactions that have been finalised. To look at all transactions, untick this box.
Show ExRt Dif
Show exchange rate differences. This box is ticked by default.
Include debts in the report. This box is ticked by default. Untick to exclude debts.
Include credits in the report. This box is ticked by default. Untick to exclude credits.
Enter an amount if you would like the report to only list debts over a certain value. The second fields is for credits over a certain value.
Oldest Debt Age Range
You can specify what timeframe you would like the report run on, e.g. 30-60 days, 60-90 days. If these are left at 0, the report will run on all debts.
There are different output options depending on how you would like the report to be presented, tick one of the boxes to have the report
Print in Foreign Currency?
Tick this box if you would like the box if you require foreign currencies to be printed.
To run the report, click on the output button. Right clicking on this button brings up the options of
|Sent to Screen (can then be printed)|
|Sent to Printer|
|Exported to Excel. Clicking on this button brings up anAdditional Infotick box which includes; the percentage of the total debt outstanding, the number of days the oldest debt is outstanding, contact details, the last Accounts communication and the date it was created.|