BeyondERP.Newsletter
Menu

Setup step on the Payment summary by vendor report page · Cash and bank management

Report bank payments by vendor

Show what was paid to each vendor from the bank accounts.

Business process
Issue and settle supplier payments
Menu item
output:BankPaymentByVendor
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 bank payments made to a selected range of vendor accounts.
What you do hereUse 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.
ExampleFor 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.
Payment summary by vendor 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

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 what was paid to vendors from the company's bank accounts, for example at period end or when a vendor questions a payment.
How oftenOn demand, when you review vendor payments.
What the output showsBank 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.

Source: Microsoft Learn

Setup steps on this page

Report bank payments by vendor

Show what was paid to each vendor from the bank accounts.

Steps from Microsoft

  1. Go to Cash and bank management > Inquiries and reports > Payment summary by vendor report.
  2. Under Records to include, set a filter on the range of vendor accounts, for example one vendor that asks about a payment.
  3. Add a filter on Pending cancellation to leave out payments whose reversal isn't posted yet, so the totals show only payments that stand.
  4. Run the report and compare the amount paid to each vendor with that vendor's transactions for the same period.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Pending cancellationFilter on this to leave out payments whose reversal isn't posted yet.Microsoft Learn No
Vendor accountThe 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

MessageWhat to do
The vendor 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 bank payments by vendorFilter Pending cancellation = No and the vendor range you are asked about.Payments with a reversal waiting for review would otherwise be counted as paid.Include payments with pending reversals?Reading the vendor total without the Pending cancellation filter while a reversal waits for review.Test: Vendor total without a pending reversal

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 bank transactions of the current legal entity. Microsoft data model
Can it be undoneReversible: The report changes no data.
If you change it laterA 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 itemoutput:BankPaymentByVendor 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:BankPaymentByVendor
Data migrationLoad 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
Everyone

8Sources

To cite this step: CB-RPT-220, Report bank payments by vendor. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CB-RPT-220