BeyondERP.Newsletter
Menu

Report page · Credit and collections

Customer balance list with credit limit report

A report that prints the balance of each customer account together with its credit limit.

Business process
Monitor customer credit
Menu item
output:CustBalanceList
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 prints the balance of each customer account together with its credit limit.
What you do hereUse this report to compare each customer balance with the credit limit and see any amount over the limit.
Customer balance list with credit limit 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 credit and collections › Monitor customer credit
Menu pathCredit and collections › Inquiries and reports › Customers › Customer balance list with credit limit 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 itWhen you analyze how receivables changed during a subperiod and a longer period, for example quarter to date against year to date.
How oftenOn demand, usually at period end.
What the output showsFor each customer or main account: opening balance, debit totals (usually invoiced), credit totals (usually paid) and closing balance. A closing balance that doesn't follow from the columns usually means the dates overlap in an unexpected way.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Credit and collections > Inquiries and reports > Customers > Customer balance list with credit limit report.
  2. Enter the From date for the Opening balance column, the Report period start date for the Debit and Credit columns, and the To date for the Closing balance column.
  3. Choose a Currency and, in Group and sort by, group by customer or by main account.
  4. In Criteria, choose all accounts or only those with an opening balance, transactions or a closing balance; turn on Include details to show main account details when grouping by customer.
  5. Check that opening balance plus debit minus credit gives the closing balance for each customer.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
As ofDate and time the balances are shown for.Microsoft Learn
Exceeded LimitShows only customers that are over their credit limit.Microsoft Learn
Zero balanceIncludes customers with a zero balance.Microsoft Learn
Solution architect

4Design impact

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

5Technical

Menu itemoutput:CustBalanceList 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:CustBalanceList
Everyone

7Sources