BeyondERP.Newsletter
Menu

Job page · Credit and collections

Age customer balances

A periodic job that creates an aging snapshot, which calculates aged balances for a group of customers at a point in time.

Business process
Manage credit and collections
Menu item
CustAgingSnapshot
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 periodic job that creates an aging snapshot, which calculates aged balances for a group of customers at a point in time.
What you do hereUse this periodic task to refresh the aged balances shown on the Aged balances list page and the Collections page, for all customers or for one customer pool.
ExampleFor example, you can run it as a recurring batch job with Today's date so that each run ages balances as of the day it runs.
Age customer 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.

When to run it

When to run itBefore collectors work the Aged balances list page and the Collections page, which show only customers with an aging snapshot.
How oftenAs a recurring batch job, as often as your collectors need current aged balances.
Batch settingsSchedule it in batch with Aging as of set to Today's date. Set Maximum number of batch tasks for Age customer balances in Accounts receivable parameters to between 12 and 20, and never above 30.
What the output showsAn aging snapshot per customer with balances in the periods of the aging period definition, shown on Aged balances and Collections. A customer missing from Aged balances usually had a zero balance with Include customers with zero balance set to No, or isn't in the pool.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Credit and collections > Periodic tasks > Age customer balances.
  2. In Aging period definition, select the definition the snapshot uses; you can have one snapshot per definition.
  3. Leave Pool ID blank to age all customers, or select a customer pool of type Aging snapshot to age only those.
  4. In Criteria, choose Transaction date, Due date or Document date, and in Aging as of choose Today's date for a recurring batch or Selected date for a fixed date.
  5. Set Include customers with zero balance to No and Bypass credit limit calculations during aging to Yes when you want the fastest run.
  6. On Company range, select the legal entities set up for centralized payments.
  7. Open Aged balances and check that the customers and aging periods look right.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Aging period definitionThe aging period definition the snapshot uses.Microsoft Learn
Pool IDOptional customer pool that limits which customers are aged; leave blank for all customers.Microsoft Learn
CriteriaWhether transactions are aged by transaction date, due date or document date.Microsoft Learn
Aging as ofThe date the aging periods are calculated from: today's date or a date you select.Microsoft Learn
Update collection statusChanges Promise to pay to Promise to pay broken when the promised date has passed.Microsoft Learn
Include customers with zero balanceIncludes customers without a balance; leave it off to run faster.Microsoft Learn
Bypass credit limit calculations during agingSkips recalculating credit figures such as Credit available, to make aging faster.Microsoft Learn
Company rangeLegal entities to include; only those set up for centralized payments can be selected.Microsoft Learn

Test checklist

  1. Aged balances lists the customers you expect.
  2. Aging periods match the aging period definition.
  3. Credit available in the FactBox is updated when Bypass credit limit calculations during aging was No.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNot needed: The next run replaces the snapshot. Collection statuses changed by Update collection status stay as Promise to pay broken. Microsoft Learn
If you change it laterReplaces the aging snapshot for the aging period definition; with Update collection status set to Yes, it also changes Promise to pay to Promise to pay broken when the promised date has passed. Microsoft Learn
Technical architect

5Technical

Menu itemCustAgingSnapshot Checked in Dynamics 365
FormCustAgingSnapshot Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itCollections manager CollectionLetterCollectionsManagerCollections agent CollectionLetterCollectionsAgentGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources