When running the aged debtor/creditor reports you have the
option to run them aged by either months or days.
If ageing by months, it is only the month part of either the
transaction date or due date (depending on the system switch
setting) and the month on the PC date that affect where the
balances appear.
For example, a transaction with a due date of the 31/3/06. Run the
aged report on the 28/02/06 and the balance will be in the
not due column. Run the same report on the
01/03/06 and it will be in the current column; run
on 01/04/06, and the balance will be in the 1
Month column
The system switch in IRIS Accounts Office 'Age by Invoice Date'
(not Due Date) is defined as: By default the aged balances on
a statement are calculated by comparing the due date with the
current system date. This switch allows you to change this
calculation by comparing the invoice date with the current system
date.
The options are:
- Do not age both sales and purchase by due date
- Sales ledger age sales by invoice date and purchase by due
date
- Purchase ledger age purchase by invoice date and sales by due
date
- Sales & purchase age both sales and purchases by invoice
date
Example
If the option is set to Sales & Purchase, a SIN with a
transaction date of the 31/3/06, run the aged report on the 31/3/06
and the balance will be in the current column. Run
the same report on the 01/04/06, and the balance will be in the
1 Month column. You would not get a
transaction in the 'Not Due' column unless future
transactions have been entered.
Similarly, if ageing by days, it is only the day part of the
transaction date and the day on the PC that affects the report.
For example, transaction entered 31/3/06, run the report aged by
30 days on the same day and the balance will be in the
current column. Run the same report on the
following day and the balance will still be in the
current column as the debt is not yet 30 days
old.
