to select, the starting value for the
range you want to include. If you select All or From Beginning in the Range
Option field, this field will be unavailable. Use this screen to print a report that lists all outstanding billed receivables by project or customer and ages the receivable amounts based on the due date. The information this screen uses is updated by the Billing and Cash Receipts Journals. Although multiple users can access this screen, only one specified user ID can run a report at a time.
Run this report any time after posting billings and cash receipts. Additionally, you should always run this report as part of the closing process for each accounting period as support for billed accounts receivable. The report should be reconciled to the general ledger balances for accounts receivable as part of the month-end closing process.
The final Accounts Receivable Aging Report for each accounting period should be retained in support of the general ledger receivables balance.
Use this drop-down list to select the grouping by which you want the report sorted. Options are Customer Account, Project, Customer Type, Project Type, Account, Organization, Customer Name, and Project Manager.
Select this check box if you want a page break after each group.
Enter, or use the drop-down list to select, the range of information you want to see on the report. Options are All, One, Range, From Beginning, and To End. The default for this field is All.
Enter, or use to select, the starting value for the
range you want to include. If you select All or From Beginning in the Range
Option field, this field will be unavailable.
Enter, or use to select, the ending value for the range
you want to include. If you select All, One, or To End in the Range Option field,
this field will be unavailable.
Select this check box to create a customized, non-contiguous list in the list box. The list mode function is different from using a Range because the list mode allows for a custom selection that will include or exclude any item of your choice.
Click this push button to add an item or a range of items to the list box. You must select the List Mode check box for this push button to be available.
Click this button to remove an item or a range of items from the list box. You must select the List Mode check box for this button to be available.
Use this drop-down list to select the grouping by which you want the report sorted. Options are Customer Account, Project, Customer Type, Project Type, Account, Organization, Customer Name, and Project Manager.
Enter, or use the drop-down list to select, the range of information you want to see on the report. Options are All, One, Range, From Beginning, and To End. The default for this field is All.
Enter, or use to select, the starting value for the
range you want to include. If you select All or
From Beginning in the Range
Option field, this field will be unavailable.
Enter, or use to select, the ending value for the range
you want to include. If you select All, One, or To End in the Range Option field,
this field will be unavailable.
Select this check box to create a customized, non-contiguous list in the list box. The list mode function is different from using a Range because the list mode allows for a custom selection that will include or exclude any item of your choice.
Click this button to add an item or a range of items to the list box. You must select the List Mode check box for this button to be available.
Use this push button to remove an item or a range of items from the list box. You must select the List Mode checkbox for this push button to be available.
This field is available only if you select Account or Organization in the Select By drop-down list. Enter the account level at which you want the report printed; all lower levels will be rolled up for the report. The larger the level number, the more detailed the report; the smaller the number, the less detailed. Enter zero to include all levels of detail. To view the number of levels available, see the Account Structure group box in the G/L Settings screen in Costpoint General Ledger.
This field is available only if you select Account or Organization in the Select By drop-down list. Enter the organization level at which you want the report printed; all lower levels will be rolled up for the report. The larger the level number, the more detailed the report; the smaller the number, the less detailed. Enter zero to include all levels of detail. To view the number of levels available, see the Account Structure group box in the G/L Settings screen in Costpoint General Ledger.
This field is available only if you select Project in the Select By drop-down list. Enter the project level at which you want the report printed; all lower levels will be rolled up for the report. Enter zero to include all levels of detail.
Enter, or use the drop-down list to select, the correct fiscal year for this report.
Enter, or use the drop-down list to select, the period for which you are running the report.
Enter, or use the drop-down list to select, the subperiod for which you are running the report.
This non-editable field displays the subperiod ending date you have selected.
on the toolbar after you have entered your report
selections. Enter an appropriate ID and description for the report, and
click OK to save. Stored report
parameters are especially useful if reports are to be run through Process
Manager. Use this group box to choose the method by which to age sort report data. You have the option to age your outstanding receivables by invoice date or due date.
Select this option to age the receivables by the invoice date.
Select this option to age the receivables by the invoice's due date.
Enter the date from which you want to age your receivables.
Click this button to open the Report Options subtask.
Click this button to open the Currency subtask.
The Accounts Receivable Aging Report is taken from the following tables:
AR_DTL_HS (AR Detail History)
AR_HDR_HS (AR Header History)
MU_UNREAL_G_L_HS (Multi-currency Unrealized Gain/Loss History)