Cash and bank managementInquiries and reportsDeposit slips
output:BankDepositByCustomer
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 is
A report of the deposits made by a selected range of customers into the company's bank accounts.
What you do here
Use this report to see how much each customer has deposited, and leave out deposit slip lines whose cancellation isn't posted yet.
Example
For 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.
The page in Dynamics 365. page title tab to open what to set or check
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 it
When you review how much each customer has deposited, for example at period end or before bank reconciliation.
How often
On demand, when you review customer deposits.
What the output shows
Deposits 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.
The customer deposit totals include payments whose reversal or cancellation is entered but not yet posted
Add 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
Per company: the report reads the deposit slips of the current legal entity. Microsoft data model
Can it be undone
Reversible: The report changes no data.
If you change it later
A 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 item
output:BankDepositByCustomerChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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
Load 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