3273670 - Automatic Payment Program - Transaction F110 - Standard behaviors guide and How-to scenarios
Version 1 from 16.12.2022 in English
Component:FI-AP-AP-B
Priority:Normal
Category:How To
Release Status:Released to Customer
(Article is not rated)
Symptom
This document aims to clarify questions about the Payment run, which are related to the standard system behaviors, and troubleshooting. It contains a large list of SAP Notes, KBAs, and related documents, separated by topic.
Payment Program: Basics
Attributes that influence self-initiated payments
Main tasks of the Payment Program
Customizing
Proposal/Payment list: RFZALI20
Grouping
Double payments
SEPA
Workflow
Environment
SAP ERP Central Component
SAP ERP
SAP enhancement package for SAP ERP
SAP enhancement package for SAP ERP, version for SAP HANA
SAP S/4HANA
Resolution
The purpose of the automatic payment program is to clear as many open items of vendors and customers as possible, according to parameters maintained in Transaction code F110.
By scheduling it a background job is generated.
Once the payment run has been carried out, the payment file/DME in different formats can be created to send the payments to the bank (component FI-AP-AP-B1).
F110 Payment Program
Basics
Business partner payments Who? -> Master data
Vendors
Customers
One-time accounts
Payments of open items What? -> Transactional data
Invoices
Credit memo
(Down) payment requests
…
Self-initiated payments How? ->Customizing
Outgoing
Incoming
Master data maintenance (Transaction BP, formerly FK01, FK02, FD01, FD02, XK01…)
General data
– LFA1, KNA1 Address, language and communication (e.g. for payment advice)
(BUT000…) Instruction key
(LFZA) Alternative payer/payee (customer ↔ vendor, alternative – permitted – individual)
– LFBK, KNBK Bank account -> IBAN, SEPA mandate (for customer, see transaction FSEPA_M4)
(BUT0BK)
Company code data
– LFB1, KNB1 House bank, payment terms, ~ block, ~ method supplement (to pre-fill items)
Allowed payment methods (if not specified in item)
Alternative payer/payee (head office ↔ branch, alternative)
Grouping and single payment (also relevant for posting)
Accounting clerk
EDI payment advice
• One-time account
• BSEC If indicator XCPDK is set in general data
Attributes that influence self-initiated payments
F110 Open Items
–BKPF Entry date
References (XBLNR usually contains document number of business partner)
Company code, currency
–BSEG Amount in document currency, tax
Payment amount and payment currency
Payment terms (cash discount), payment block, payment method and supplement
House bank and house bank account
Alternative payer/payee (from list of permitted)
References, text, long text
-BSEC Address and bank data of individual payer/payee or one-time account
F110 Customizing
Payment methods
Bank determination
House banks and house bank accounts
Parameters entered in F110
1910306 Exclude a customer/vendor from the payment run
1922538 Automatic setting of a parameter in F110
1944818 F110: Payment Identification length
1964942 F110 - Free selection doesn't work as expected
2308915 F110 - Free selections F4 Search Help Display
2500645 Inserting Company Codes into the Parameters tab
2560861 F110: Log could not be found Message no. F0215
2706294 Using exchange rate different from the one on Run Date in F110 (posting date is the important parameter)
2947127 Error Message no. FU056 (Field * <== is not defined) in F110 "Free selection" tab
2958366 Document type created from F110 when it is 0 clearing
2958428 Value date in T-CD F110
2960283 House bank option in free selection of F110 is not working
2969078 Selection of items based on arrears days in f110
3023460 Account group free selection not working correctly in F110
3002413 F110 : Customer invoices are not picked during proposal/payment run
Main tasks of the Payment Program
• What and when has to be paid? (selection of open item items, determine due date)
• To whom is the payment made? (Specify payee)
• How is the payment made? (Select payment method)
• From where is the payment made (Select a bank and bank account)
The logic of the payment program for the selection of the open items is explained in the following SAP Note:
20484 Payment program does not clear due items
• In the customer/vendor master record
• In the line items
• Via configuration of the payment program (FBZP)
• With individual specifications for each payment run (F110)
The payment method is the procedure such as check, transfer or bill of exchange, by which payments are made.
545340 FAQ: Payment run F110
1588392 Branch, Head account bank details during F110
1705609 F110 - Payment Run successfully executed but not all documents are paid
1907777 F110: Assignment field in bank G/L account is empty
2116298 F110 - Documents contained in a bank file not posted (B1?)
2230933 F110: Deadlocks in payment program
2359682 F110 - Partial Payment not Allowed
2381712 Profit center wise restriction in F110
2481087 F110 is clearing customer or vendor line items before due date
2535516 Field REGUH-UBNKL is not filled after payment proposal
2536671 Perform a partial payment with F110
2542411 Multiple Paying Company Codes in F110
2570334 Maximum cash discount is always considered in F110 process
2589144 F110 amount limit not checked for payment method when editing the proposal
2787843 Partner bank selection in F110
2813072 Vendor/Customer is not selected in F110 proposal 2798234 - F110: How to schedule payment runs sequentially?
2817199 Credit memo is selected in F110 although the payment run posting date <= baseline date
2933686 Creation of payment media for payments from financial accounting: overview of possible alternatives
2983466 Incorrect Partner Bank Type (BVTYP) is selected by Automatic Payment Program
• The date of the next payment run (F110V-NEDAT) which is specified for each specified for each payment run. This date is used to determine whether an item has to be paid in the current or in the next payment run.
• Free selection criteria, fields ‘Docs entered up to’ (F110C-GRDAT) or ‘Customer items due by” (F110V-FDEBI) when maintaining parameters in F110.
• Due date of the items which is basically determined via the baseline date and the terms of payment in the open item.
• Company code-specific grade periods for payables which are added to the due date calculated. Consequently, the payment can be made later.
At the time of running the payment run, it is recommended to activate the logs, so that in case of errors, they can be displayed in the proposal/payment logs.
1662257 F110 - Payment proposal cannot be deleted - Vendors are blocked
1703252 FZ 349 Vendor XXXX is contained in proposal XXXX'; no editing
1741973 F110 error FZ390 'No valid payment method found' appears in the Job log
1758455 F110 - Error FZ352 for e.g., "12 items (curr EUR &, pmnt method T) cannot be distributed on the forms
1786450 F110 error FZ003 'Company codes &/& do not appear in proposal & &; correct' appears in the Job log
1873725 FZ793 Factory calendar EU is not valid
1888866 Credit/Debit balance exists FZ328
1896498 F110: Error BFIBL02167
1908205 F110: error FZ660
1977244 Message MC 601 occurs in T-code: F110
2004041 F110: error FZ659
2190425 F110: Error FZ 314: G/L Account does not exist in the company code
2205988 Changes in documents in Payment Proposal are not considered
2241532 F110 - Payment error F5 353
2312908 Error FZ677 in the F110 proposal log
2330799 F110: delete proposal low performance
2331667 F110: FM FI_PAYMENT_BANK_CHAIN_SET, exception: CONVERSION_ERROR
2342602 F110 items in exception due to error FZ525, FZ732
2378558 Error FZ 636: Item split for enhanced individual payment not possible
2441668 F110 - Error FZ 872 appears while reallocating line items in payment proposal
2464674 Message 'Unconfirmed change to master record' in T-code F110
2466091 F110: Incorrect GL selected for cash discount documents-Error FS 218
2477942 F110: Local Processing flag does not work
2524805 F110 error F5354
2576190 F110: Error FZ 618 - Payment amount is not within the limits allowed
2626160 SEPA: open item is blocked by direct debit pre-notification
2677970 Bank determination in T-CD F110
2689115 House bank selected in F110 is different from house bank specified in customer master data
2816372 F110 Error FZ 769 despite using bank chain
2816766 Error F0248 in T-CD F110
2827983 Error in F110 - FZ765 : Bank details & / & / &: IBAN is not valid
2928806 Error message FZ372 in F110
2948056 Error FZ389 in F110
2958153 Error FZ634 : Payment amount cannot be distributed in payments to maximum of (example 12,500 EUR)
2966684 FZ324 in transaction F110
2974693 F110 : Issue with House Bank derivation in Automatic Payment Run
Customizing
The required customizing settings should be maintained in transaction FBZP or in the payment run transaction (F110) itself (Environment-> Display configuration/Maintain configuration) or via SPRO transaction.
...