SAP Knowledge Base Article - Public

1882049 - Modification of Payment Method and File Format for a Bank Account

Symptom

By default a payment file format (for example, DTAUS) is maintained for one of your bank accounts. Now you want to switch to another format (for example, SEPA). However, when executing a payment run or triggering a manual payment you do not succeed in generating a file exhibiting the new format.

Environment

SAP Business ByDesign

Reproducing the Issue

You created a bank transfer either by executing a payment run in the Payables work center or by manually creating the payment for a payables item. Now you generate the bank file for transferring the resulting amounts.

  1. Go to either the Payment Management or Liquidity Management work center.
  2. Navigate to the Payment Monitor view.
  3. Choose candidate payment(s) in status Ready for Transfer.
  4. Go via Actions for Bank Transactions and choose Create Payment File.
  5. As a result the status of the payment will be In Transfer. Under Payment Data in the header data you observe that Payment Method Details and Payment Medium do not show the expected SEPA format.

In case a payment file has been generated you also notice that the file is not in SEPA format (for example, DTAUS).

Cause

For the purpose of this document the payment file format SEPA is used synonymously with other alternative payment file formats.

Various settings in the Business Configuration as well as the bank master data has to be maintained properly in order to produce a payment file in the desired format.

Resolution

If your system is live already you can find and edit all the below mentioned Activities from the Business Configuration Overview via Change Immediately.

As a pre-requisite for applying the new format SEPA has to be configured as a viable format in the Business Configuration.

  1. Go to the Business Configuration work center.
  2. Navigate to the Implementation Projects view, mark the First Implementation project and press Open Activity List. From here go to the Fine Tune phase.
  3. Find and open the Outgoing Bank Transfers activity.
  4. Here SEPA has to be maintained as a valid payment format at least in the categories Payment Correspondence Profiles, Payment Medium.
    Formats and Country Groups.

Another necessary requirement is to maintain SEPA as a payment format in your banking and bank account master data.

  1. Go to the Liquidity Management work center and choose My Banks in the Master Data view.
  2. Edit the relevant house bank and go to the tab Payment Formats.
  3. Here a valid SEPA Payment Medium Format Code has to be maintained (e.g. SEPA Credit Transfer).
  4. After the "payment format" formats have been saved on house bank level you can assign the desired format to house bank accounts under Bank Accounts and tab Payment Method.

It is recommended to maintain here only one of the major payment formats for each bank account (SEPA only instead of DTAUS and SEPA).

In addition to that settings have to be maintained again in the Business Configuration in order to prioritize payment methods and the resulting file format depending on applied business scenarios.

  1. Go to the Business Configuration work center.
  2. Navigate to the Implementation Projects view, mark the First Implementation project and press Open Activity List. From here go to the Fine Tune phase.
  3. Find and open the Global Settings for Payment activity. Under Payment Method Priorities you define a global prioritization for relevant localizations.
  4. Make suitable entries under Prioritize Bank Accounts and Payment Method based on Amount and Prioritize Bank Accounts and Payment Methods in order to facilitate the desired payment method and format depending on an applied business scenario. 

Starting with version 1302 (February, 2013), a monitor Bank and Payment Settings: Bank Transfer has been introduced which summarizes relevant settings for payment methods in one screen. You can access this view by editing any bank transfer which is not in status Confirmed in the Payment Monitor view (click View All --> click You Can Also --> Open Bank and Payment Settings). Via the Business Configuration Data tab you can directly access the relevant settings by clicking Open Activity.

Keywords

payment medium format; payment medium format code; bank statement; SEPA; DTAUS , KBA , sepa , format , dtaus , payment file , AP-BP-BPT , Business Partner Template , How To

Product

SAP Business ByDesign all versions