BeyondERP.Newsletter
Menu

Setup step on the Deposit summary by customer report page · Cash and bank management

Report deposits by customer

Show the deposits of each customer for a period.

Business process
Process customer payments
Menu item
output:BankDepositByCustomer
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report of the deposits made by a selected range of customers into the company's bank accounts.
What you do hereUse this report to see how much each customer has deposited, and leave out deposit slip lines whose cancellation isn't posted yet.
ExampleFor example, a customer with a 10,000.00 credit limit says it paid 7,500.00 by check in October. You run the report for that customer with Pending cancellation = No and find deposits of 5,000.00 and 2,500.00.
Deposit summary by customer 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 › Process customer payments
Menu pathCash and bank management › Inquiries and reports › Deposit slips › Deposit summary by customer report
Set up firstCustomer payment journal (Use a deposit slip) Microsoft Learn
Used next byDeposit slips Microsoft Learn
Related pagesDeposit summary by date report Microsoft Learn
In this process Print the deposit slip
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 review how much each customer has deposited, for example at period end or before bank reconciliation.
How oftenOn demand, when you review customer deposits.
What the output showsDeposits per customer into the company's bank accounts. A customer total that looks too high usually still contains deposit slip lines whose cancellation is pending.

Source: Microsoft Learn

Setup steps on this page

Report deposits by customer

Show the deposits of each customer for a period.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Deposit slips > Deposit summary by customer report.
  2. Under Records to include, set the range of customers to report on.
  3. Add a filter on Pending cancellation to leave out deposit slip lines whose cancellation isn't posted yet.
  4. Read the deposit total per customer and compare it with that customer's payments in the same period.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Pending cancellationFilter on this to leave out deposit slip lines whose cancellation isn't posted yet.Microsoft Learn No
Customer accountThe range of customers the report covers.Microsoft Learn One customer

Common errors and fixes

MessageWhat to do
The customer deposit totals include payments whose reversal or cancellation is entered but not yet postedAdd a filter on Pending cancellation = No under Records to include. While a reviewer hasn't posted or rejected the reversal, the payment stays Pending cancellation. Microsoft Learn
Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Report deposits by customerFilter the customer range and Pending cancellation = No.Returned checks waiting for review would otherwise count as deposits.Include pending cancellations?Reading a customer's deposits while a cancellation waits for review, so a returned check looks paid.Test: Customer deposits without a pending cancellation

Feature management and licence

Licence or add-inIn this system 10 roles can open this page, among them Treasurer, Chief financial officer, Accounting manager and Financial controller.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the report reads the deposit slips of the current legal entity. Microsoft data model
Can it be undoneReversible: The report changes no data.
If you change it laterA cancelled deposit slip payment waiting for review is still in the totals unless filtered out with Pending cancellation = No. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:BankDepositByCustomer Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itTreasurer PaymTreasurerChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 10 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:BankDepositByCustomer
Data migrationLoad order: The Deposit summary by customer report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It reads posted bank data in each environment, so there is nothing to load for it. Migrate the transactions it reports on instead (for example open checks and deposits as part of the opening bank balances).Checked in Dynamics 365
Everyone

8Sources