BeyondERP.Newsletter
Menu

Page · Credit and collections

Aged balances

A list page that shows customer balances and aged amounts by aging period, taken from an aging snapshot.

Used by
Auditor, Collections agent, Collections manager and 9 more roles
Business process
Manage credit and collections
Menu item
CustCollectionsPoolsListPage
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 list page that shows customer balances and aged amounts by aging period, taken from an aging snapshot.
What you do hereUse this page to see which customers have overdue amounts, open a customer's collections details and take action, such as writing off a balance.
ExampleFor example, you can mark the row for a customer such as Birch Company and write off its whole balance from this page.
Aged balances 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.

Steps from Microsoft

  1. Go to Credit and collections > Collections > Aged balances.
  2. Select a customer with a balance.
  3. Expand the Aging FactBox to see the aged balances.
  4. Expand the Contact and Credit limit FactBoxes to see the collections contact and credit information.
  5. On the Action Pane, select Collect to open the customer's collections details.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Amount due balanceShows the amount due, with an icon that shows the aging status of the account.Microsoft Learn SumOfAmountDueMst
AgingFactBox with the customer's aged balances.Microsoft Learn
Credit limitFactBox with the customer's credit limit and current balance.Microsoft Learn

Test checklist

  1. Run Credit and collections > Periodic tasks > Age customer balances with your aging period definition and Today's date.
  2. Open Aged balances and check a customer with an overdue invoice shows the amount in the right aging column.
  3. Check a customer that was not included in the snapshot does not appear.
  4. Mark a test customer, select Collect > Write off, then check the journal in General ledger > Journal entries > General journals has one line reversing the customer balance and the write-off account line.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneReversible: The page only shows the latest aging snapshot; run Age customer balances again to refresh it (one active snapshot per aging period definition). Write off from this page creates a write-off journal in General journals that you review there. Microsoft Learn
If you change it laterOnly customers that have an aging snapshot appear here, so run Age customer balances again to bring the list up to date. Microsoft Learn
Technical architect

5Technical

Menu itemCustCollectionsPoolsListPage Checked in Dynamics 365
FormCustCollectionsPoolsListPage Checked in Dynamics 365
Who can open itPrivilegesView collections customers pools list page CustCollectionsPoolsListPageViewDutiesReview collections process performance CollectionLetterCollectionProcPerfRevieInquire into collections status CollectionLetterCollectionsStatusInquirMaintain collections transactions CollectionLetterCollectionsTransMaintaiInquire into customer invoice status CustInvoiceCustomerInvoiceStatusInquire
12 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerk
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 open this page.Checked in Dynamics 365
Actions on the pageCollect: New, Manage, Journals, ViewCommunicateGeneralOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

6Developer

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

7Sources