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 bank payments made to a selected range of vendor accounts.
What you do here
Use this report to see how much was paid to each vendor from the company's bank accounts, and leave out payments whose reversal isn't posted yet.
Example
For example, a vendor says that only 4,000.00 of 5,500.00 was received in September. You run the report for that vendor with Pending cancellation = No and see two payments of 2,750.00, so you can send the payment details.
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 what was paid to vendors from the company's bank accounts, for example at period end or when a vendor questions a payment.
How often
On demand, when you review vendor payments.
What the output shows
Bank payments grouped by vendor account, with the amount paid to each vendor from the company's bank accounts. A vendor total that is higher than expected often still contains payments that are pending cancellation.
Filter on this to leave out payments whose reversal isn't posted yet.Microsoft Learn
No
Vendor account
The range of vendors the report covers; the report reads bank transactions, vendor transactions and the vendor table.Microsoft Learn
One vendor that questions a payment
Common errors and fixes
Message
What to do
The vendor 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
Filter Pending cancellation = No and the vendor range you are asked about.Payments with a reversal waiting for review would otherwise be counted as paid.
Per company: the report reads the bank transactions of the current legal entity. Microsoft data model
Can it be undone
Reversible: The report changes no data.
If you change it later
A payment whose reversal is entered but not posted is still a bank transaction with Pending cancellation; it stays in the totals unless you filter it out. Microsoft Learn
Technical architect
6Technical
Menu item
output:BankPaymentByVendorChecked 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 Payment summary by vendor 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