Describing Payment Runs for Bank Accounts

Objective

After completing this lesson, you will be able to execute a payment run for a bank account

Payment Run for Bank Account

Flowchart depicting the payment process with components like contract, contract account, business partner, customizing, and parameters leading to test run and payment run. It includes steps for handling payment data exceptions, generating payment media, and producing accompanying sheet and lists.

The process flow of the payment program is as follows:

  1. Open items are selected and grouped for payment.
  2. Open items requiring special processing are determined.
  3. The payment methods and bank details are determined.
  4. The payments are posted and payment media are created.

If desired, you can execute a test run of the payment program prior to the actual payment run. The test run creates a payment list, but no payment documents (tables DPAYH, DPAYP).

Payment data and payment exceptions can be viewed (but not changed) in the payment list.

Payment media (in electronic form or as printouts) is created based on the payment data.

Payment runs use the technique of parallel processing.

You can specify for each item, whether an item is to be placed in the clarification list.

The data that controls the payment run is specified in the master data, in the document, in customizing, and in the current payment run parameters.

Visual representation of run parameters with a side note indicating posting date and reconciliation key. The parameters listed include company code, business partner, contract account, payment method, and others.

You can use preselections for a set of master data in the payment run by choosing Technical PreparationsDefine Preselection.

Selection according to company code is mandatory. Payment methods are country-specific. For this reason, it's only possible to select company codes within a country that has the same currency in each payment run.

The posting date of the payment run is applied as the baseline date for determining the due date, except in the following cases:

  • If a deferral date has been entered in an item, it's always used to determine the due date.

  • If the cash discount date is prior to the posting date, the cash discount due date is used to determine the due date and the item is paid minus the cash discount.

  • If the cash discount period has expired, the due date for net payment is used.

The due date for an item that is determined in this manner must fall within the due date interval entered in the General Selections tab of the payment run parameters for the item to be paid.

You can restrict the payment run to one payment card type. You can then run separate payment runs for each payment card type, even though the payment method category of Card Payment is always the same.

Grouping of Open Items

  • Business Partner

  • Alternative Payer

  • Contract Account

  • Payment Method

  • Payment Term

  • Payment Lock

  • Currency Key

  • Paying Company Code

  • Application Area

Business partner items are grouped together into payable groups. Items can only be grouped together if business partner items are not restricted by the selection of a contract account.

The paying company code and the account being offset are determined using the assigned contract account in the document.

The application area can enter data in its own grouping field in the designated event 0600. This data could include reference details from the contract. This event can also be used to lock items while the payment program is running.

An icon of a bank is followed by three steps: validating payment methods, copying the business partner bank details, and selecting the house bank per payment method.

You can specify multiple payment methods for outgoing payments in a contract account’s or contract object’s master data. In this case, the checks outlined in the figure above are carried out for each payment method until a valid payment method is found.

If payment optimization is not required, the house bank with the highest priority is always selected (see bank selection in parameter maintenance).

A table displays company codes, payment methods, currencies, house banks, account IDs, and rankings, with one ranking cell magnified. Each row shows 1010 for company code, S for payment method, and GIRO for account ID.

The payment program is implemented as a mass activity.

Once open items have been grouped, the system determines the appropriate payment method, and selects a bank from the bank parameters entered in the payment run.

Currently, it's only possible to prioritize banks for bank selection optimization. It's not yet possible to enter available amounts for each of the respective bank accounts. You can maintain bank selection for all company codes simultaneously.

For cross-company-code postings, the company code belonging to the contract account must also be the responsible company code for the company codes in the line items.

If other company codes are billed using the contract account, incoming payments on receivables in these company codes are always posted to a company code settlement account in the responsible company code first (same procedure for outgoing payments).

Choose figure 162 payment list, Course IUT240, Col 62, see also file iut240_en_col62_fv_inst_a4.pdf

A screenshot of a Payment Data List highlighting an exception and item indicator. The red annotations point to a payment exception label and an item indicator circle containing a key for the exception reason.

You can exclude items from payment within the payment run as well (in addition to setting processing locks on a contract account or in a document).

You can define payment lock reasons in customizing to exclude items from payment.

You can review all items that cannot be paid automatically in the exception list.

A diagram explains the relationship between Payment Method, Note to Payee Type, and Note to Payee Structure, along with key details. Below it, a table titled Note to Payee Configuration lists language, notification type, line number, and note to payee information.

You can specify that payment media is to be created in the language of the business partner. If this indicator is not selected, the system searches the content table (depicted in the preceding figure) for a blank language key and uses the parameters specified for this table entry. It's, therefore, important to enter a language key for each note to payee category in the table.

You can use the SAPFKPY3 report to determine whether or not this indicator has been selected.

Execute a Payment Run for Bank Account

Business Example

Your business partner uses direct debit to pay his invoices by bank account.

You have to collect all direct debit payments via a payment run.

You have to transfer the payments to the house bank.

Note

In this exercise, the value ## should be replaced with your group number.

Task 1: Maintain Bank Account Details in the Master Data

Steps

  1. Start the SAP Fiori Maintain Business Partner app (transaction BP).

    1. Choose the Masterdata tile group.

    2. Choose the Maintain Business Partner tile.

  2. Maintain the IBAN and SEPA of business partner ac240-##b using the following data:

    Bank Details

    FieldValue
    ID01
    CountryDE
    Bank Key10040000
    Bank Account471100##

    SEPA Data

    FieldValue
    Mandate Reference01##
    Valid Fromcurrent Date
    Valid To31.12.9999
    1. On the Maintain Business Partner screen, choose Open BP.

    2. In the dialog box, enter business partner ac240–##b.

    3. Choose Enter.

    4. On the Display Person screen, choose Switch Between Display and Change.

    5. In the Change in BP Role field, choose the role MKK Contract Partner.

    6. Go to the Payment Transactions tab.

    7. In the Bank Details table, enter the values from the Bank Details table.

    8. In the Bank Details table, choose IBAN.

    9. In the Information dialog box, choose Continue.

    10. In the IBAN dialog box, check the IBAN and choose Continue.

    11. In the Bank Details table, select your new ID 01.

    12. Choose Mandates.

    13. In the SEPA dialog box, choose Yes.

    14. On the Default screen, enter the mandate reference 01## and choose Continue.

    15. On the Detail screen, enter the values from the SEPA Data table.

    16. Choose Supplement Data.

    17. Choose Continue.

    18. In the Information dialog box, choose Continue.

    19. Choose Save.

    20. Choose Back.

  3. Start the SAP Fiori Maintain Contract Account app (transaction CAA2).

    1. Choose the Masterdata tile group.

    2. Choose the Maintain Contract Account tile.

  4. Change the incoming payment method of contract account ac240-##b to SEPA.

    Allocate IBAN and SEPA of business partner ac240-##b to this payment method.

    1. On the initial screen, choose Change.

    2. In the Contract Account field, enter ac240-##b.

    3. Choose Continue.

    4. In the Information dialog box, choose Continue.

    5. Go to the Payments/Taxes tab.

    6. Go to the Incoming Payments area.

    7. In the Incoming Payment Method field, choose A Direct Debit.

    8. In the Bank Details Incoming Payment field, choose ID 01.

    9. In the Mandate Reference field, choose 01##.

    10. Choose Save.

    11. Choose Back.

Task 2: Execute a Payment Run for a Bank Account

Steps

  1. Start the SAP Fiori Display Account Balance app (transaction FPL9).

    1. Choose the Information tile group.

    2. Choose the Display Account Balance tile.

  2. Display the account of business partner ac240-##b using the following data:

    Initial Data

    FieldValue
    Business Partnerac240-##b
    List TypeALLES ALL Items
    Line Layout013 Line Item Display
    1. On the initial screen, enter the values from the Initial Data table.

    2. Choose Continue to check the basic list.

      There are three overdue items 6000/0010 displayed.

    3. Choose Back twice.

  3. Start the SAP Fiori Payment Run / Debit Memo Run app (transaction FPY1).

    1. Choose the Payment Run tile group.

    2. Choose the Payment Run / Debit Memo Run tile.

  4. Execute a payment run for bank account only for business partner ac240-##b.

    Copy the template with the date 15.10.2018 to run ID P1## and the current date.

    Run Parameters

    FieldValue
    Destination Date IDcurrent date
    Destination Run IDP1##

    Selection Data

    FieldValue
    Open Itemsselect
    Business Partnerreplace ## with your group number
    Company Code1010
    Due Date Fromcurrent date minus 4 month
    Due Date Tocurrent date
    Posting Datecurrent date
    Payment MethodA Direct Debit
    Reconciliation Keyproposed by the system

    Log Data

    FieldValue
    Problem Class4 Additional Information
    Business Partnerreplace ## with your group number

    Bank Data

    FieldValue
    Paying Company Code1010
    Payment MethodA Direct Debit
    CurrencyEUR
    House BankBANK 1
    Account IDGIRO
    Ranking Order1

    Payment Medium

    FieldValue
    Payment Medium FormatSEPA_DD
    Payment Medium VariantSEPA_DD_AC240
    1. In the Run ID area, choose F4 in the Date ID field.

    2. In the Date ID dialog box, select the row with the date 15.10.2018.

    3. Choose OK.

    4. Choose MenuProgram RunCopy.

    5. In the Copy dialog box, enter the values from the Run Parameters table.

    6. Choose Continue.

    7. In the Parameter Change dialog box, choose Yes.

      You access the Payment Run / Debit Memo Run screen.

    8. On the General Selections tab, adopt the values from the Selection Data table.

    9. On the Logs tab, adopt the values from the Log Data table.

    10. On the Bank Selection tab, check the values from the Bank Data table.

    11. Choose MenuEnvironmentPayment Medium.

    12. In the Payment Medium table, check the values from the Payment Medium table.

    13. Choose Back.

    14. Go to the General Selections tab.

    15. Check that you have selected only your own business partner ac240-##b.

    16. Choose Save.

    17. Choose MenuProgram RunSchedule.

    18. In the Schedule dialog box, select Start Immediate and choose OK.

    19. Do not close the app.

  5. Check the result of the payment run in the application log.

    Display the payment list and the payment medium XML file.

    1. You're still on the Payment Run / Debit Memo Run screen.

    2. Go to the Logs tab.

    3. Choose Refresh until the payment run is completed.

    4. Choose Application Log.

    5. In the Info Messages column, select the number.

    6. Note the clearing document number.

    7. Note the clearing amount.

    8. Choose Back twice.

    9. Choose MenuEnvironmentPayment List.

    10. On the selection screen, enter identification P1##.

    11. Choose Execute.

    12. Check the payment list.

    13. Choose Back twice.

    14. Choose MenuEnvironmentDME Administration.

    15. In the Data Medium table, select the row with identification P1##.

    16. Choose Display DME Contents.

      You access the XML file of the payment data medium, which is sent to the bank.

    17. Choose Back three times.

  6. Start the SAP Fiori Display Account Balance app (transaction FPL9).

    1. Choose the Information tile group.

    2. Choose the Display Account Balance tile.

  7. Display the account of business partner ac240-##b using the following data:

    Initial Data

    FieldValue
    Business Partnerac240-##b
    List TypeALLES All Items
    Line Layout0C1 Clearing Information
    1. On the initial screen, enter the values from the Initial Data table.

    2. Choose Continue to check the basic list.

      The three fully cleared items 6000/0010 are displayed.

      The clearing item 0600/0010 is displayed and linked.

    3. Choose Back twice.

Log in to track your progress & complete quizzes