BeyondERP.Newsletter
Menu

Transaction page · Accounts payable

Payment transfers

A page that lists vendor payments sent to the bank and shows their payment status, which is updated from the bank return file.

Used by
Accounts payable clerk, Accounts payable manager, Chief financial officer and 6 more roles
Business process
Manage payment transfers in Dynamics 365 Finance
Menu item
VendPaymReconciliation
Main table
LedgerJournalTrans
Data entity
CustomerPaymentJournalLineEntity
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 isA page that lists vendor payments sent to the bank and shows their payment status, which is updated from the bank return file.
What you do hereUse this page to import the bank return file for vendor payments by selecting Return file - vendor, so that the payment status is updated.
ExampleFor example, a company that sends ISO 20022 credit transfer files to its bank can import the bank return messages here.
Payment transfers 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.

Steps from Microsoft

  1. Open the Payment transfers page in Accounts payable.
  2. Select Return file - vendor.
  3. Select the method of payment that is set up for the bank's return file, and select OK.
  4. Select the file format to import, and select OK.
  5. Enter the parameters and the file path, and select OK.
  6. Review the imported payments and their status on the Payment transfers page.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Payments statusThe payment status, updated from the bank's return file.Microsoft Learn
Fee IDCreates payment fee lines when the bank file includes charges.Microsoft Learn
New journal nameThe journal that processed transactions move to; new voucher numbers are given there.Microsoft Learn
Settle transactionsSettles imported vendor payments with matching invoices already in the system.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Technical architect

5Technical

Menu itemVendPaymReconciliation Checked in Dynamics 365
FormCustVendPaymReconciliation Checked in Dynamics 365
TableLedgerJournalTransShown as “Journal lines” in Record infoChecked in Dynamics 365
Data entitiesCustomerPaymentJournalLineEntityCustomer payment journal line Microsoft data model VendorPaymentJournalLineEntityVendor payment journal line Microsoft data model BankJournalLineEntityBank journal line Microsoft data model CustInvoiceJournalLineEntityCustomer invoice journal line Microsoft data model ExpenseJournalLineEntityProject expense journal lines Microsoft data model LedgerReportingCurrencyAdjustmentJournalLineEntityReporting currency adjustment journal line Microsoft data model RAssetJournalLineEntityFixed asset journal lines (Russia) Microsoft data model VendInvoiceJournalLineEntityVendor invoice journal line Microsoft data model VendInvoiceRegisterLineEntityVendor invoice register line Microsoft data model VendInvoiceRegisterLineV2EntityVendor invoice register line V2 Microsoft data model AssetJournalLineEntityFixed asset journal line Microsoft data model LedgerJournalLineCDSEntityCDS Ledger journal line entity Microsoft data model LedgerJournalLineEntityJournal lines Microsoft data model
Who can open itPrivilegesMaintain vendor payment transfer journals VendPaymReconciliationMaintainView vendor payment transfer journals VendPaymReconciliationViewDutiesMaintain vendor payments PaymVendorPaymentsMaintainInquire into vendor payment status PaymVendorPaymentStatusInquire
9 security rolesChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts payable payments clerk PaymAccountsPayablePaymentsClerkTo use itAccounts payable manager VendInvoiceAccountsPayableManagerAccounting supervisor LedgerAccountingSupervisorAccounting manager LedgerAccountingManagerAccounts payable clerk VendInvoiceAccountsPayableClerkChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 9 roles can open this page.Checked in Dynamics 365
Actions on the pageButtons: Return file - vendor, PostChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=VendPaymReconciliation
Integrate withCustomerPaymentJournalLineEntity data entity Microsoft data model
Table definitionLedgerJournalTrans columns and relations Microsoft data model
Everyone

7Sources