BeyondERP.Newsletter
Menu

Report page · Credit and collections

Customer balance list report

A report that shows, side by side, how customer balances changed during a subperiod and during a longer period.

Business process
Manage accounts receivable
Menu item
output:CustProvisionalBalance
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, side by side, how customer balances changed during a subperiod and during a longer period.
What you do hereUse this report to quickly analyze changes in accounts receivable, with debit totals (usually invoiced) and credit totals (usually paid).
ExampleFor example, you can compare how customer balances changed during the last month with how they changed during the current year.
Customer balance list 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 balance list report
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 itAt period end for reconciliation with the ledger, and whenever collections need aged balances as of a past date.
How oftenAt each period end, and on demand for collections.
What the output showsBalances per customer split into aging periods or date intervals, with transaction details when Details is on. Older periods that look too high often mean unsettled payments aren't positioned; turn on Payment positioning to see them.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Credit and collections > Inquiries and reports > Customers > Customer balance list report.
  2. Enter Aging as of for the current aging bucket and Balance as of as the cutoff date for transactions.
  3. In Criteria choose Transaction date, Due date or Document date, and select an Aging period definition with no more than six periods; Interval and Printing direction are used only without one.
  4. Turn on Details to list the transactions behind each balance, and Include amounts in transaction currency for foreign-currency customers.
  5. Set Exclude zero balance accounts, Negative balance and Payment positioning; with Payment positioning, unsettled payments show in the first column.
  6. Check that the report total matches the customer balance in the ledger for the Balance as of date.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
From dateDate used to calculate the Opening balance column.Microsoft Learn
Report period start dateStart of the period used for the Debit and Credit columns.Microsoft Learn
To dateEnd of the period; also used for the Closing balance column.Microsoft Learn
Group and sort byGroups the report by customer or by main account.Microsoft Learn
CriteriaWhich accounts to print: all, or only those with an opening balance, transactions or a closing balance.Microsoft Learn
Include detailsShows details for each main account when grouping by customer.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The aging report only reads customer transactions; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:CustProvisionalBalance 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, 13 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources