BeyondERP.Newsletter
Menu

Setup step on the Payment fee page · Accounts payable

Set up Payment fee

Create and maintain the payment fees that are associated with vendors.

Used by
Accounts payable clerk, Accounts payable manager, Chief financial officer and 6 more roles
Business process
Define accounts payable policies
Menu item
VendPaymFeeInquiry
Main table
CustVendPaymJournalFee
Data entity
CustomerPaymentJournalFeeEntity
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 isThe page where vendor payment fees are defined; a fee is added to a vendor payment automatically when a set of conditions applies.
What you do hereUse this page to set up fees that are either charged to the vendor (posted through the vendor posting profile) or expensed to a main account when the Charge field is set to Ledger.
ExampleYour bank charges 1.00 for each wire transfer that you process, and the wire fee is expensed to a bank fee expense account.
Payment fee 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 processDevelop procurement and sourcing strategy › Define accounts payable policies
Menu pathAccounts payable › Inquiries and reports › Payment › Payment fee
Set up firstMethods of payment Microsoft Learn Vendor posting profiles Microsoft Learn
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.

Step by step, with screenshots

Set up Payment fee1 screen

Create and maintain the payment fees that are associated with vendors.

  1. Screen 1

    Set the payment fee amount

    Go to Accounts payable > Payment setup > Payment fee, Payment fee setup for BEAT-FEE

    1. Select the BEAT-FEE payment fee and open its Payment fee setup
    2. On the Overview tab, select New
    3. Fill in the fee row
    1Method of paymentBEAT-CASH
    Payment currencyUSD
    Percentage/AmountAmount
    Fee amount1.00
    Fee currencyUSD
    Set the payment fee amount (zoomed on the outlined fields)
    Show the full screenSet the payment fee amount
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Inquiries and reports > Payment > Payment fee.
  2. Under Select, choose the Bank account, Method of payment and Payment specification.
  3. Choose the Currency, which is required, and enter the Amount in transaction currency.
  4. Enter the Payment date and Due date, and choose the Remittance type and Journal type.
  5. Select Search to list the matching fees by Fee ID, Currency and Fee amount.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Fee IDA name that shows when the fee is used, such as for electronic funds transfers.Microsoft Learn FeeId
ChargeWho bears the fee: Ledger when your organization expenses it, Vendor when it is charged to the vendor.Microsoft Learn
Main accountThe account the fee is posted to; only needed when Charge is Ledger.Microsoft Learn
Fee currencyThe currency the fee is charged in.Microsoft Learn USDFeeCurrency
Method of paymentThe method of payment this fee applies to.Microsoft Learn CHECK
Payment currencyThe currency of the payment this fee applies to.Microsoft Learn USD
Percentage/AmountAmount
Fee amountThe amount or percentage charged for the fee.Microsoft Learn 1.00FeeValue

Test checklist

  1. Create a fee with Charge = Ledger, a bank fee expense main account and a Percentage/Amount value.
  2. In Payment fee setup, limit it to one method of payment, for example wire.
  3. Create a vendor payment journal line with that method of payment.
  4. Post and check the fee posts to the expense account; a line with another method has no fee.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Payment feeCharge = Ledger with an expense main account for bank fees you absorb; Charge = Vendor for fees that are added to the vendor's balanceLearn describes both uses: with Charge = Vendor the Main account is unavailable and the fee posts through the vendor posting profile; with Charge = Ledger you must give the main account, typically an expense account such as bank fee expense.Setting up the fee but not its criteria in Payment fee setup (method of payment, bank, currency): the fee is only added to a vendor payment when that set of conditions applies.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Fees are added to vendor payments created after the change; fees already posted with earlier payments stay as posted.
Technical architect

6Technical

Menu itemVendPaymFeeInquiry Checked in Dynamics 365
FormPaymFeeInquiry Checked in Dynamics 365
TableCustVendPaymJournalFeeShown as “Payment journal fee” in Record infoChecked in Dynamics 365
Data entitiesCustomerPaymentJournalFeeEntityCustomer payment journal fee Microsoft data model VendorPaymentJournalFeeEntityVendor payment journal fee Microsoft data model
Who can open itPrivilegesView vendor payment fee information VendPaymFeeInquiryViewDutiesInquire into vendor invoice status VendInvoiceVendorInvoiceStatusInquire
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 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: SearchChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=VendPaymFeeInquiry
Integrate withCustomerPaymentJournalFeeEntity data entity Microsoft data model
Data migrationCustomerPaymentJournalFeeEntity (Customer payment journal fee): loaded for each company.VendorPaymentJournalFeeEntity (Vendor payment journal fee): loaded for each company.Microsoft Learn
Table definitionCustVendPaymJournalFee columns and relations Microsoft data model
Everyone

8Sources