BeyondERP.Newsletter
Menu

Report page · Credit and collections

Customer aging report

A report that shows the balances customers owe, sorted by date interval or aging period.

Business process
Manage accounts receivable
Menu item
output:CustAgingBalance
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that shows the balances customers owe, sorted by date interval or aging period.
What you do hereUse this report to see how much each customer owes in each aging period as of a date you choose, with or without transaction details.
ExampleFor example, to see aging by week, enter 7 in the Interval field and select Day in the Day/Mth field.
Customer aging report 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

Business processManage accounts receivable
Menu pathCredit and collections › Inquiries and reports › Customers › Customer aging report
Set up firstAging period definitions Microsoft Learn
Related pagesCustomer aging data storage Microsoft Learn
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.

When to run it

When to run itBefore a collection run or a cash forecast, when you need the customer payments due by a date.
How oftenOn demand, before each collection run.
What the output showsA detailed list of customer transactions due on or before the As on date, per customer. A transaction you know is paid but still listed usually has a payment that isn't settled against it.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Credit and collections > Inquiries and reports > Customers > Customer aging report.
  2. Enter the As on date; customer transactions due on or before it are listed.
  3. Filter on the customer accounts a collector is responsible for, to get one list per collector.
  4. Compare the due amounts with the Aged balances page and follow up on the oldest items first.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Aging as ofDate used for the current aging bucket.Microsoft Learn
Balance as ofCutoff date for the customer balances.Microsoft Learn
CriteriaWhether the report is based on transaction date, due date or document date.Microsoft Learn
Aging period definitionAging period definition for the report columns; when selected, Interval is not used.Microsoft Learn
Print aging period descriptionPrints the aging period descriptions as column headings.Microsoft Learn
IntervalNumber of days or months in each period when no aging period definition is used.Microsoft Learn
Printing directionWhether balances are shown for past (Backward) or future (Forward) periods.Microsoft Learn
DetailsLists the transactions behind the balances.Microsoft Learn
Include amounts in transaction currencyAdds transaction currency amounts next to accounting currency amounts.Microsoft Learn
Negative balanceIncludes customers with negative balances.Microsoft Learn
Exclude zero balance accountsLeaves out customers with a zero balance.Microsoft Learn
Payment positioningShows unsettled payments in the first column.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The due date list only reads open customer transactions; it changes nothing. Microsoft Learn
If you change it laterAn aging period definition with more than six aging periods can't be used on the printed report. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:CustAgingBalance Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itCollections manager CollectionLetterCollectionsManagerCollections agent CollectionLetterCollectionsAgentAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorGive people one of these roles. On this system, 12 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:CustAgingBalance
Everyone

7Sources