(CHN) Set up and calculate the bank payment fees
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
Follow the steps in this topic to set up and calculate the bank payment fees that you pay when you make a payment to a vendor.
Note
This topic does not apply to versions of Microsoft Dynamics AX 2012 prior to cumulative update 6 for AX 2012 R2.
Prerequisites
The following table shows the prerequisites that must be in place before you start.
Category |
Prerequisite |
|---|---|
Related setup task |
Set up bank groups. For more information, see Bank groups (form). |
1. Create a rule to calculate bank payment fees
Use the Bank rules for payment fee form to create a payment rule to be used to calculate bank payment fees that are deducted from the payment that the legal entity makes to the vendor. You can create a bank rule to track bank accounts that are located in different cities.
To create a bank rule, follow these steps:
Click Accounts payable > Setup > Payment > Bank rules for payment fee.
Create a bank rule.
In the ID field, type a short descriptor that identifies the bank rule. You select this descriptor when you set up the payment fee in the Payment fee setup form.
In the Name field, type a name or description for the bank rule.
On the General FastTab, add one or more of the following filters to create the bank rule.
Field
Description
Third party bank group
Select a field for the third party bank group that is used in the bank rule. For example, you can select the city of the third party group.
Relationship
Select the operator that indicates the relationship between the third party bank group and the company bank group.
Value
Assign a filter to compare the value in the Value field against the value that is selected in the Third party bank group field or the Company bank group field when calculating the bank payment fees. For example, to create a bank rule that applies to a particular bank that has a bank code of 001, select Bank code in the Third party bank group field, = in the Relationship field, and 001 in the Value field.
Company bank group
Select a filter value for the company bank group that is used in the bank rule. For example, to apply this rule when your bank and the vendor bank are located in different cities, select City in the Third party bank group field, <> in the Relationship field, and City in the Company bank group field.
2. Set up a payment fee
After you create the bank rule, use the bank rule to set up a payment fee in the Payment fee form. You can set up the payment fee amounts for banks, methods of payment, payment specifications, calculation methods, and currencies.
To set up a payment fee, follow these steps:
Click Accounts payable > Setup > Payment > Payment fee.
Create a payment fee record. For more information see Vendor payment fee (form).
In the Main account field, select the ledger account that is used to post the bank payment fee that you pay.
Click Payment fee setup to open the Payment fee setup form, where you can set up banks, methods of payment, payment specifications, calculation methods, and currencies. For more information, see Vendor payment fee setup (form).
On the Overview tab, in the Bank rule ID for payment fee field, select the identification code for the bank rule to apply the bank payment fee to.
In the Method of payment field, specify the applicable payment method.
On the General tab, in the Administration field group, in the Currency field, enter the currency for the payment.
In the Minimum field, enter the minimum transaction amount on which the bank payment fee is calculated. The bank payment fee can be a fixed amount or a percentage of the transaction amount, as illustrated in the following table.
Minimum transaction amount
Amount or Percent
Bank payment fees
5000 RMB
50 RMB or 1 percent
50 RMB
In the Maximum field, enter the maximum transaction amount on which the bank payment fee is calculated.
In the Fee field group, in the Percentage/Amount field, select Amount or Percent.
In the Fee amount field, enter the bank payment fee amount or percentage depending on what you select in the Percentage/Amount field.
In the Currency field, select the currency code for the fee amount.
Specify other details, if required.
3. Create and post a payment journal for a vendor
Use the Payment journal form to create and post a payment for a vendor. Microsoft Dynamics AX calculates the bank payment fees based on the association that you create between the bank payment rule and the payment fee.
To create a payment journal, follow these steps:
Click Accounts payable > Journals > Payments > Payment journal.
Create a payment journal, and then create a payment journal line for the payment amount. For more information, see Create and validate journals and journal lines and Journal voucher - Vendor payment journal (form).
On the Overview tab, in the Account field, select the account number for the vendor.
In the Offset account field, select the offset account for the transaction.
In the Method of payment field, select a method of payment.
On the Bank tab, in the Account identification field, enter the vendor bank account. Specify other details, if required.
On the Payment fee tab, the bank fee amount is automatically calculated based on the values in the Method of payment, Offset account, and Account identification fields.
Note
If you modify the vendor bank account in the Account identification field on the Bank tab, the bank fee is recalculated.
Click Functions > Generate payments to generate the payment.
Click Post > Post to post the payment.
When you post the payment, the bank payment fees are deducted from the vendor payment.