BeyondERP.Newsletter
Menu

Setup step on the Aging period definitions page · Accounts payable

Set up Aging period definitions

Define the user-defined intervals that aging lists and reports use to analyze the maturity distribution of vendor balances.

Used by
Accounts payable manager, Auditor, Accounting manager and 1 more role
Business process
Analyze accounts payable effectiveness in Dynamics 365 Finance
Menu item
VendReportInterval
Main table
StatRepInterval
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 user-defined aging intervals for vendor accounts.
What you do hereUse this page to define the intervals that analyze the maturity distribution of vendor accounts.
ExampleFor example, a typical definition has periods such as Current, 31-60, 61-90 and Over 90 days, where Over 90 includes transactions dated more than 90 days before the aging date.
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

Define the user-defined intervals that aging lists and reports use to analyze the maturity distribution of vendor balances.

  1. Screen 1

    Create the aging period definition

    Go to Accounts payable > Setup > Aging period definitions

    1. Select New and enter the definition and description
    2. On the Periods FastTab, use Add below to add each period
    3. Set Printing direction to Forward
    1Aging period definitionBEAT30
    DescriptionAging - 30 day buckets
    Period90+ (Unit -1, Interval Unlimited)
    Period90 (Unit -30, Interval Day)
    Period60 (Unit -30, Interval Day)
    Period30 (Unit -30, Interval Day)
    PeriodCurrent (Unit 0, Interval Unlimited)
    Printing directionForward
    Create the aging period definition (zoomed on the outlined fields)
    Show the full screenCreate the aging period definition
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Setup > Aging period definitions.
  2. Select New to create a definition, or select one in the list on the left.
  3. Enter the Aging period definition and the Description.
  4. In the Periods section, select Add above or Add below to add a period, then fill in the Period, Unit, Interval, Aging indicator and Icon.
  5. Use Up, Down or Remove to reorder or remove a period.
  6. Choose the Printing direction.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
PeriodThe column heading shown for each aging period on inquiries and reports.Microsoft Learn 90+ (Unit -1, Interval Unlimited)Heading
UnitA number for the length of the period: zero for the aging date, negative for the past, positive for the future.Microsoft Learn Qty
IntervalThe length of each unit, such as day, week, month or unlimited.Microsoft Learn IntervalType
Printing directionThe order in which the periods are shown.Microsoft Learn ForwardPrintDirection
Aging period definition30DAYSName
DescriptionA short description of the aging period definition.Checked in Dynamics 365Aging - 30 day bucketsDescription

Test checklist

  1. Create a definition with periods for current, 30, 60 and 90 days and Printing direction Backward.
  2. Run the Vendor aging report with that definition and Criteria Due date.
  3. Check that each column matches the open invoices by due date for a test vendor.
  4. Check that a definition with seven periods can't be used on the printed report.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Aging period definitionsSix periods or fewer for any definition used on the printed Vendor aging reportAging period definitions with more than six periods (columns) can't be used on the printed Vendor aging report.Building one detailed definition with many buckets and then finding it can't be selected for the printed report.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: The definition is selected each time the report runs, so a change affects the next run only.
If you change it laterA definition with more than six periods can't be selected on the printed vendor aging report. Microsoft Learn
Technical architect

6Technical

Menu itemVendReportInterval Checked in Dynamics 365
FormCustVendReportInterval Checked in Dynamics 365
TableStatRepIntervalShown as “Statistics” in Record infoChecked in Dynamics 365
Data entitiesAgingPeriodDefinitionEntityAging period definitions Microsoft data model
Who can open itPrivilegesMaintain accounts payable aging period definitions VendReportIntervalMaintainView accounts payable aging period definitions VendReportIntervalViewDutiesInquire into invoice and payment policies VendInvoiceInvoicePaymentPoliciesInquirEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnable
4 security rolesAuditor AuditPolicyManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts payable manager VendInvoiceAccountsPayableManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounting manager LedgerAccountingManagerAuditor AuditPolicyManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=VendReportInterval
Integrate withAgingPeriodDefinitionEntity data entity Microsoft data model
Data migrationAgingPeriodDefinitionEntity (Aging period definitions): loaded for each company, in Microsoft's default template 120 - Accounts payable.Load order: Microsoft's default template 120 - Accounts payable loads Aging period definitions at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionStatRepInterval columns and relations Microsoft data model
Everyone

8Sources