Aged Balances Report

This report prints supplier aged balances, including transaction detail. You can determine the output and format of the report by selecting various options before the report runs.

Header Details

• Report process date and time
• Page number

Line Details

• Supplier code
• Supplier name
• Currency
• Total amount due
• Current period value
• Overdue 1 period value
• Overdue 2 period value
• Overdue 3 period value
• Overdue 4 period value
• Hold value
• Future value
• Branch

If the option to Show Detail is selected, this detail also displays for each transaction:

• Transaction date
• Transaction type (for example, invoice, payment, credit note, journal)
• Transaction reference
• Transaction amount
• Currency

The report displays sub-totals depending on the Group by/Print group summary options, and a grand total value is also displayed if the Print listing summary option is selected.

Age By

Select the aging intervals by setting a number and period — for example, 1/Months. This determines the intervals that are calculated and displayed in the top right of the form, and those on which the report output is based.

You can also edit the From/To dates if required to report on a date range that differs from calculated ranges using the Age By parameters.

Future/Past Intervals

You can specify the number of past/future intervals to include in the report. The maximum number of intervals is five, both future and past.

Criteria by transaction branch

If you select this option:

• The Branch Code filter is using the transaction branch. Otherwise, Greentree Desktop uses the supplier's branch.
• The Group by filter is disabled as Branch is assumed to be the default group option.