Here is a description of the custom fields that make up an aged analysis definition.
Key: R – Read-only; * – Mandatory field
The number indicates the number of characters that are allowed in this text field, where appropriate.
| Field | Description | ||
|---|---|---|---|
| Aged Analysis Name | * | 80 | Unique name for the aged analysis definition record, such as "Aged Debt Report". This is also used as the heading at the top of the report. |
| Aged Analysis Type | * | Type of outstanding transactions to include on the resulting aged analysis report, outstanding values owed by "Debtors" or to "Creditors". |
Defaults
These fields enable you to provide default settings to use on the aged analysis report selection page.
| Field | Description | |
|---|---|---|
| Aged Analysis Currency | Choose either "Home" or "Account" mode. The default on this page is "Home". This custom picklist must remain fixed. Do not add or amend its values. | |
| General Ledger Account | Choose a default general ledger account. If left blank, the default at run time will be All. This field supports corporate and local GLAs. | |
| All Currencies | If set, no filtering by currency is performed by default at run time. | |
| Currency | * | Choose an active currency The currencies in which your Salesforce CRM organization does business. Sometimes called "organization" or "org" currencies. to filter by default at run time. Must be an accounting currency The currency in which your company does business. A company can have more than one accounting currency. owned by the current company The company in which you are working. This is represented by the company queue to which you, and new instances of objects you create, are assigned.. |
Predefined Columns
These are predefined, but optional, column definitions that you can choose to include on your report. If selected, their position on the report is fixed.
| Checkbox | Description |
|---|---|
| Total Outstanding | Indicates that you want to include a column that displays the sum of all outstanding values for the selected account. If selected, this column will appear on the report immediately after the last user-defined column. |
| Unmatched Cash | Indicates that you want to include a column that displays the value of all unmatched cash entries for the selected account. If selected, this column will appear on the report immediately before the first user-defined column. These cash entries will be excluded from the user-defined columns. That is, unmatched cash will not be aged. |
Columns 1 to 10
You can create up to 10 user-defined columns on each aged analysis definition record. Column definitions can overlap.
| Field | Description |
|---|---|
| Column N – Name | Column heading for up to 10 user-defined columns on the resulting report. For example, on a typical debt report, enter "Up to 30 days" to label the column containing the sum of values overdue for up to 30 days. On a typical credit report, enter "Due next 30 days" to label the column containing the sum of values due in the next 30 days. |
| Column N – From | Minimum number of days overdue or until due for outstanding values to be included in this user-defined column on the report. For example, on a typical debt report, on the "Up to 30 days" column, enter 1. On a typical credit report, on the "Due next 30 days" column, enter 1. |
| Column N – To | Maximum number of days overdue or until due for outstanding values to be included in this user-defined column on the report. For example, on a typical debt report, on the "Up to 30 days" column, enter 30. Leave this field blank to define an open-ended column such as "Up to 90 Days" or "Total Overdue". On a typical credit report, enter 30 for the "Due next 30 days" column or leave this field blank to define an open-ended column such as "Due later" or "Total not yet due". |