AGED

From Wiki
Jump to: navigation, search


AGED.PNG
Name Aged Debt Analysis
Shortcut AGED
Area Reports

See the NOVUS Walkthrough Guide for further information.


Aged Debt Analysis

The aged debt report puts transactions into different columns depending on the user-selected parameters.

The "ageing by" options are available:

I = Installment date P = Payable date A = Accounting date O = Original accounting date

Please note, if ageing by is set to the P option, the instalment date column is changed to payable by.

The ageing bands have default values but can be set to any date range that the user requires. The user can age by a date or a number of days.

The output can be for one, or all divisions, currencies, or suffices (roles).


Range type Field Description
Account Range First First account in the range
Last Last account in the range
Date Range Base Date: Base date for ageing
Acc Date Cut Off: Last date in the report
First Date: Over 30 days ago
Second Date: Over 91 days ago
Third Date: Over 365 days ago
Options Suffixes: (*) client, (.) insurer, (-) agency, (^) co-insurer, (+) company debtor, (:) company creditor, ABCDEFGHIJKLMNOPQRSTUVWXYZ!#
Division: Division code (or 'ALL')
Statement: Respects statement flagging settings Y or N
Aged By (Date Code:) Installment date ('I'), payable date ('P'), accounting date ('A'), original accounting date ('O')
Selected Currencies: Choose from the list of available currencies, search for a currency to add, or add all
Run Report button Report type Transaction Level, Section Level or Total


Report Output:

AGED Report.PNG

Default columns are available for:
• Account Org Group Code (Account Organisation Group (Parent) Code
• Account Org Group Name (Account Organisation Group (Parent) Company Name)
• Risk Client Org Group Code (Risk Client Organisation Group (Parent) Code)
• Risk Client Org Group Name (Risk Client Organisation Group (Parent) Name)
• Assured Org Group Code (Assured Organisation Group (Parent) Code)
• Assured Org Group Name (Assured Organisation Group (Parent) Name)

The report can be printed or saved in one of five formats. The results can be customised by dragging and dropping the columns to suit the required layout. The column customisation button can add and remove relevant columns from the report by using the click and drag feature.

The preferred grid layout can be saved in the system as an XML file in the 'P' Drive. Other configurations can be loaded from the P drive or the layout can be reset to default.

Note: The write off amount can never be outstanding, it is a debit/credit amount that has been written off - so by definition it cannot be outstanding.


Version History

v 6.4.0 – Updated to latest version
v 6.0.0 – Updated to latest version
v 5.0.0 – Updated to latest version
v4.1.0 – Updated to latest version
v23P - the latest version
v22K - custom output for MRS
v21K - startinterface not working for view &print - re instate startword, statie, startexcel
v17K - account field allow 00000 and ZZZZZZZZZ to give first to last accounts
v16K - KAY now have their own version
v15K - Accounting cut off date added. v14T - Added 'Respect Statement Flag' option.
v13K - First version of this form to use the. New style. No other updates except the restyle.
2.0.3 - Converted to .NET and new style, has a built-in grid.