Customer project 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.
  1. Select AR Customer Project Aging Report.
  2. Specify this information:
    Finance Enterprise Group
    Select the finance enterprise group.
    As of Date
    Specify a date for aging transactions. This date is used to age transactions that are based on status as of a specific date. All records that are in an Open status on this date are included.
    Qualify Future Applications
    Select whether to include applications that were created after the As of Date. To reduce processing time, select No if you do not have future dated applications and if the As of Date is today's date. Select Yes if you do have future dated applications and the As of Date is not today.
    All Projects
    Select Yes to select all projects. The default value is No.
    Projects
    If the All Projects selection is No, select up to six projects.
    Project Contracts
    If the All Projects selection is No, select up to six project contracts.
    Aging Method
    Select whether to age by due date or transaction date.
    Age Credits
    Select a credit memo aging option. Indicates the column in which credit memos are aged.
    Age Payments
    Select a payment aging option. Indicates the column in which payments are aged.
    Age Disputes
    Select a disput aging option.
    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.
    Expanded Aging Periods
    Select whether to expand the aging periods for the report.
    Current Days, Periods 1-4
    Specify the amount of current days and corresponding periods to include in the report.
    Future Days, Periods 5-7
    If you chose to expand aging periods, specify the amount of future days and corresponding fields to include in the report.
    Detail Transaction
    Select whether to print transaction detail in the report.
    Include Gain, Loss
    Select whether to include unrealized gains and losses.
    Report Sequence
    Select the sort order for the report.
  3. In the Report Distribution section, select a distribution list and export type for AR Customer Project Aging Report.
  4. Click Submit.