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.
- Select AR Customer Project Aging Report.
-
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.
- In the Report Distribution section, select a distribution list and export type for AR Customer Project Aging Report.
- Click Submit.