Creditors Aged Debt Dept Report

The Creditors Aged Debt Dept Report provides an analysis of Creditor's aged debt on a Department by Department basis.

This Report processes all finalised outstanding transactions, which have affected the balance for a Creditor, and groups them by Department and then by Creditor, totalling the amounts into columns defined by the number of days that the amounts are overdue.

The Report also includes total amounts for each Creditor for transactions that are not yet due as well as for those that are in credit.

There are 4 Overdue Days parameters on the Job Request that defines the overdue days that are utilised on the Report. The default values for these parameters are 30, 60, 90 and 120 and these can be changed, if required.

Where the days entered for each of these parameter are left as their default, the following transaction amounts will be displayed in columns on the Report:

Total of any transaction amounts that are in Credit
Total of any transaction amounts that are not yet due
Total of any outstanding transactions where the amount is overdue by less than 30 days
Total of any outstanding transactions where the amount is overdue by 30 days and up to and including 59 days
Total of any outstanding transactions where the amount is overdue by 60 days and up to and including 89 day
Total of any outstanding transactions where the amount is overdue by 90 days and up to and including 119 days
Total of any outstanding transactions where the amount is overdue by 120 days or more

An example of the Report that includes the default values in these parameters is displayed below:

To run the Report the following options should be added to these fields on the CR Job Request form:

Report Master: Creditors Aged Debt Dept Report
Report Folder: All Styles
Report Style: Creditors Aged Debt Dept Report

Click on the button and the following Parameters and Criteria will be displayed in a Grid at the bottom of the form:

Parameters:

The following parameters will be displayed in the Parameters tab:

Overdue Days_1: The Parameter Value for this parameter will default to 30 days and can be changed if required.

Any transaction where the amount is overdue for less than the number of days in this field will be included in a <[Parameter Value] column on the Report. For example where the default value is used, i.e. 30, any transactions with an amount that is overdue by 1 day and up to and including 29 days will be added to a <30 days column.

The value added to this parameter is also used in conjunction with the value added to the Overdue Days_2 parameter, detailed below. Any transaction where the amount is overdue by the value in the Overdue Days_1 parameter, e.g. 30, and up to but not including the value added to the Overdue Days_2 parameter, e.g. 60 will be included in the next column on the Report, e.g. 30 - 59 days.

Overdue Days_2: The Parameter Value for this parameter will default to 60 days and can be changed if required.

The value added to this parameter is used in conjunction with the value added to the Overdue Days_3 parameter, detailed below. Any transaction where the amount is overdue by the value in the Overdue Days_2 parameter, e.g. 60, and up to but not including the value added to the Overdue Days_3 parameter, e.g. 90, will be included in the next column on the Report, e.g. 60 - 89 days.

Overdue Days 3: The Parameter Value field for this parameter will default to 90 days and can be changed if required.

The value added to this parameter is used in conjunction with the value added to the Overdue Days_4 parameter, detailed below. Any transaction where the amount is overdue by the value in the Overdue Days_3 parameter, e.g. 90, and up to but not including the value added to the Overdue Days_4 parameter, e.g. 120, will be included in the next column on the Report, e.g. 90 - 119 days.

Overdue Days 4: The Parameter Value for this parameter will default to 120 days and can be changed if required.

Any transaction where the amount is overdue for the number of days that is equal to or greater than the value for this parameter, e.g. 120, will be included in the next column on the Report, e.g. 120+.

Pre Process: This parameter field is used to specify the process that will be run before the report has been produced. For example, setting up temporary tables used by the report. For this Report Style this should default to @CR_SP_AGED_DEBT_REPORT and cannot be changed.
Post Process: This parameter field is used to specify the process that will be run after the report has been produced. For example clearing down temporary tables used by that report. For this Report Style this should default to @CR_SP_AGED_DEBT_REPORT_POST and cannot be changed.

Criteria Fields:

The following fields can be added to the Criteria tab and are used to filter the information on the Report:

Account No: This field will allow you to filter the Creditors using their Creditor Number.
Creditor Status: This field will allow you to filter the Creditors using the status of the Creditor.

The following codes can be added manually to the Value field on the tab:

CRCR01: Add this code to filter Creditors that have a status of Unauthorised.
CRCR02: Add this code to filter Creditors that have a status of Authorised.
CRCR03: Add this code to filter Creditors that have a status of Being Entered.

Department Code: This field will allow you to filter the Departments using the Department Code.
Name: This field will allow you to filter the Creditors using their full name.
Section Code: This field will allow you to filter the transactions using the Section Code included on the transactions.
Type of Creditor: This field will allow you to filter the Debtors using their Type, where appropriate, e.g. Creditor, Employee, etc.
Payment_Total_Outstanding: This field will allow you to filter the outstanding amounts, e.g. is greater than, is less than, or by adding a range of amounts.

Adding fields to the Criteria tab and adding conditions to these fields are further detailed in the Criteria tab section.

Click on the button.