BeyondERP.Newsletter
Menu

Report page · Accounts receivable

Customer account statement

The Customer account statement report page, which produces statements you can send to customers.

Business process
Manage accounts receivable
Menu item
Output:CustAccountStatementExt
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 isThe Customer account statement report page, which produces statements you can send to customers.
What you do hereUse this page to generate account statements that notify customers of their balance due and transaction activity for a period, with options such as only open transactions, credit limit, and maturity distribution.
ExampleUsing Show due until to add a separate section with the amount, transactions and due date of the customer's next payment to the statement.
Customer account statement 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 pathAccounts receivable › Inquiries and reports › Customers › Customer account statement
Set up firstAging period definitions 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 itWhen a customer or collections agent needs a statement outside the regular periodic statement run, for example during a collections call.
How oftenOn demand, per customer request.
What the output showsA statement for the selected customers with the transactions from the From date to the To date, the balance due and the aging at the bottom. If the aging columns are missing, the aging period definition has more than six periods.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > Customers > Customer account statement.
  2. Enter the From date and To date, or a Date interval, for the customer whose statement you need now.
  3. Turn on Only open, Include reversed or Show credit limit depending on what the customer asked for.
  4. Choose an Aging period definition with six periods or fewer for the maturity distribution, then run it and send the statement to the customer.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
From dateOnly transactions dated on or after this date are printed.Microsoft Learn
To dateOnly transactions dated on or before this date are printed.Microsoft Learn
Only openPrints only unsettled transactions.Microsoft Learn
Include reversedIncludes reversed transactions on the statement.Microsoft Learn
Balance other than zeroLeaves out statements whose closing balance is zero.Microsoft Learn
Show credit limitShows the customer's credit limit on the statement.Microsoft Learn
Show maturity distributionPrints the aging of the balance at the bottom of the statement.Microsoft Learn
Aging period definitionThe aging periods used for the maturity distribution; definitions with more than six columns can't be used.Microsoft Learn
Use print management destinationUses the customer's print management destination when the statements are generated.Microsoft Learn
Include company logoAdds the company logo for report designs that show it; leaving it off saves database space.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The statement only reads customer transactions. Microsoft Learn
Technical architect

5Technical

Menu itemOutput:CustAccountStatementExt Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounting manager LedgerAccountingManagerCollections manager CollectionLetterCollectionsManagerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkGive people one of these roles. On this system, 11 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources