D365 – Setting up aging period definitions and aging report parameters

Period

Unit

Interval

Aging indicator

Description

Over 90

-1

Unlimited

Red X

Includes transactions whose dates are more than 90 days before the aging date.

61-90

-30

Day

Yellow triangle

Includes transactions whose dates are 61 to 90 days before the aging date. Note that the interval is -30, which starts with the first day before the subsequent aging period.

31-60

-30

Day

Yellow triangle

Includes transactions whose dates are 31 to 60 days before the aging date. Note that the interval is -30, which starts with the first day before the subsequent aging period.

0-30

-30

Day

Green circle

Includes transactions whose dates are 1 to 30 days before the aging date.

Aging date

0

Day

Green circle

Includes transactions whose dates are the same as the aging date.

Field

Description

Period

Enter text to display at the top of columns in analysis forms and on reports to identify the aging period.

Unit

Enter a number to represent the interval for the size or length of the aging period.

Interval

Select an interval for the aging period line.
Ledger period – The interval is the length of the period that is defined for the fiscal calendar that is selected in the Ledger form (Click General ledger > Setup > Ledger.).
Day – The interval is one day long.
Week – The interval is one week long. For a positive quantity, the interval is the number of days elapsed in the current week before today. For a negative quantity, the interval is the number of days remaining in the current week after today. The week starts on Monday and ends on Sunday.
Month – The interval is one month long. For a positive quantity, the interval is the number of days elapsed in the current month before today. For a negative quantity, the interval is the number of days remaining in the current month after today.
Quarter – The interval is one quarter (three months) long.
Years – The interval is one year (12 months) long.
Unlimited – For a positive quantity, the interval includes all days after the end of the previous aging period until the ending date. For example, if the previous aging period was 90 days, the unlimited interval includes dates 91 days past due until the ending date. The ending date is the last day of the last fiscal year that is created in the Fiscal calendars form, for the fiscal calendar that is used with the transaction. For a negative quantity, the interval includes all days from a blank starting date until the day before the following aging period.

Aging indicator

Blank – No indicator is displayed.
Green check mark – An icon that contains a green check mark is displayed.
Green circle – An icon that contains a green circle is displayed.
Yellow triangle – An icon that contains a yellow triangle is displayed.
Yellow exclamation point – An icon that contains a yellow exclamation point is displayed.
Red diamond – An icon that contains a red diamond is displayed.
Red X – An icon that contains a red X is displayed.
Blue – A blue rectangle is displayed.
Red – A red rectangle is displayed.
Green – A green rectangle is displayed.
Dark gray – A dark gray rectangle is displayed.
Orange – An orange rectangle is displayed.
Yellow – A yellow rectangle is displayed.

Icon

The aging indicator as it will appear in the Collections form and list page.

Printing destination

Forward – Print columns in the same order in which the headings appear in the table, starting with the top row.
Backward – Print columns in the reverse order in which the headings appear in the table, starting with the bottom row.

Field

Description

Billing classification

Select one or more billing classifications to include on the report.
For Public sector only

Include transactions without a billing classification

If this check box is selected, all transactions that do not have a billing classifications assigned to them will be displayed on the report.
For Public sector only

Balance as of

Enter the date to view the customer balances for. This is also known as a cutoff date for transactions.

Start date

Enter a date that is in the first period interval or aging period to include on the report.

Criteria

Select the type of date to base the report on.
Transaction date – The posting date of the transactions. For example, this might be an invoice date that is the basis for the calculation of the due date.
Due date – The due date of the transactions, based on the terms of payment.
Document date – A user-defined document date that is the basis for the calculation of the due date.

Note: for reconciliation of Gl vs SL the Transaction date options is recommended.

Aging period definition

Select an aging period definition.

Print aging period description

Select Yes to include aging period descriptions at the top of each aging period column on the report. Select No to print the report without column headers.

Interval

Define the period to use by entering the number of the day or month units in each period. For example, to view aging information by week, enter 7 in this field and select Day in the Day/Mth field.
The information that you enter in this field is used only if you have not selected an aging period definition.

Day/Mth

Select the unit, either Day or Month, that is used to define the period in the Interval field.

Printing direction

Select whether to calculate balances and print the aging report for past or future periods. The dates are evaluated relative to the date that is selected in the Balance as on field. Select Backward to show information for past periods. Select Forward to show information for future periods.

Details

Select this check box to list the transactions that are included in the balances that are shown on the report.

Include amounts in transaction currency

Select this check box to include amounts in the transaction currency in addition to amounts in the accounting currency. If this check box is not selected, the amounts on the report are displayed only in the accounting currency.

Negative balance

Select this check box to include customer accounts that have negative balances.

Exclude zero balance accounts

Select this check box to exclude customer accounts that have a zero balance.

Payment positioning

Select this check box to display payments that have not been settled. These are displayed in the first column of the report.

Customers

The information displayed in this field group is determined by your selections when you create a query.