BeyondERP.Newsletter
Menu

Setup step on the Aging period definitions page · Credit and collections

Set up Aging period definitions

Use this page to set the aging periods that become the columns on the Aged balances, Collections activities and Collections cases list pages and on aging reports.

Business process
Manage credit and collections
Menu item
CustReportInterval
Data entity
AgingPeriodDefinitionEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page for aging period definitions, which are used to analyze how old customer and vendor balances are, based on a date you enter.
What you do hereUse this page to set the aging periods that become the columns on the Aged balances, Collections activities and Collections cases list pages and on aging reports.
ExampleFor example, you might use a green indicator for the current period, yellow for 30 days past due and red for 90 days past due.
Aging period definitions page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Aging period definitions1 screen

Use this page to set the aging periods that become the columns on the Aged balances, Collections activities and Collections cases list pages and on aging reports.

  1. Screen 1

    Create an aging period definition

    Go to Credit and collections > Setup > Aging period definitions

    1. Select New
    2. Enter the definition code and description
    3. Review the default periods and change the interval and aging indicator for each if needed
    4. Select Save
    1Aging period definitionBEAT-AGE
    2DescriptionAging
    Periods90+, 90, 60, 30 and Current (the defaults), 30 days apart
    Create an aging period definition (zoomed on the outlined fields)
    Show the full screenCreate an aging period definition
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Credit and collections > Setup > Aging period definitions.
  2. Select New, and enter the Aging period definition and a Description.
  3. Select Add below to insert an aging period.
  4. In the Period field, enter the description to show on aging reports.
  5. In the Unit field, enter a number, and in the Interval field, select an option.
  6. In the Aging indicator field, select an option.
  7. Update the top period so it describes the oldest period, and then close the page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
PeriodDescription of the aging period shown on aging reports.Microsoft Learn Heading
UnitNumber of intervals; the line with 0 is the date the analysis is run.Microsoft Learn Qty
IntervalSize of the period: ledger period, day, week, month, quarter, year or unlimited.Microsoft Learn IntervalType
Aging indicatorIndicator that represents the period on the Collections page and list page.Microsoft Learn AgingIndicator
Printing directionOrder of the columns on the Customer aging and Vendor aging reports.Microsoft Learn PrintDirection
Aging period definitionThe code that identifies the aging period definition.Microsoft Learn 30-60-90Name
DescriptionA short text that describes the aging period definition.Microsoft Learn AgingDescription
PeriodsThe aging periods in the definition, each with a name, unit and interval.Microsoft Learn 90+, 90, 60, 30 and Current (the defaults), 30 days apart

Test checklist

  1. Create a definition with six or fewer periods and set it as the aging period definition in Accounts receivable parameters (Collections).
  2. Run Age customer balances with that definition.
  3. Open Aged balances and check the columns match the periods and the indicator shows the oldest period.
  4. Print the Customer aging report and check the column order follows Printing direction.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Aging period definitionsKeep the default definition (the one in Accounts receivable parameters) to six periods or fewer, and use Today's date when aging runs in batch.No more than six aging periods can be used on external statements, aging snapshots or the Collections list page, and a default definition with more than six periods isn't respected.Adding a seventh period to the default definition: it can no longer be used for snapshots or the Collections list, and the default is ignored.
Solution architect

5Design impact

Can it be undoneReversible: Definitions can be edited at any time; the change shows after the next Age customer balances run. Ledger period intervals can't be mixed with day, week, month, quarter or year intervals.
If you change it laterA definition with more than six aging periods can't be used on external statements, aging snapshots or the Collections list page. Microsoft Learn
Technical architect

6Technical

Menu itemCustReportInterval Checked in Dynamics 365
FormCustVendReportInterval Checked in Dynamics 365
Data entitiesAgingPeriodDefinitionEntityAging period definitions Microsoft data model
Roles to set it up and use itTo set it up or change itCollections manager CollectionLetterCollectionsManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting supervisor LedgerAccountingSupervisorTo use itCollections agent CollectionLetterCollectionsAgentAccounting manager LedgerAccountingManagerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkGive people one of these roles. On this system, 12 roles can open this page.Checked in Dynamics 365
Actions on the pageOptionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustReportInterval
Integrate withAgingPeriodDefinitionEntity data entity Microsoft data model
Everyone

8Sources