Creating an aging report

Use this procedure to create a transaction aging report for activity-based parameter selections. The report is created as of the date you specify for an accurate aging for non-historical transactions at any point. Only records with an open status on the specified as of date are included.
  1. Select AR Customer Project Aging Report.
  2. Select the finance enterprise group.
  3. Complete the applicable parameters.

    These fields may not be self-explanatory:

    Qualify Future Applications
    Select Yes to include applications that were created after the As of Date.
    • To reduce processing time if no future dated applications exist and the as of date is today, select No.
    • If you have future dated applications and the as of date is not today, then select Yes.
    Projects
    If the All Projects field is No, then select up to six projects.
    Project Contracts
    If the All Projects field is No, then select up to six project contracts.
    Age Credits
    Select a credit memo aging option. This option indicates the column in which credit memos are aged.
    Age Payments
    Select a payment aging option. This option indicates the column in which payments are agreed.
    Age Disputes
    Select an option for dispute aging.
    Display Date
    Select whether transaction date or due date is displayed on the report. This option is not related to the aging method option. Select whether disputes are aged in the current column or aged respective to date.
    Current Days, Periods 1-4
    Specify the number of current days and corresponding periods to include.
    Future Days, Periods 5-7
    If you chose to expand aging periods, specify the number of future days and the corresponding fields.
  4. In the Report Distribution section, select a distribution list and export type for AR Customer Project Aging Report.
  5. Click Submit.