Grouping of open items in automatic payment program
Open items can be grouped together in one payment due to different configuration and master data settings.
Open items are paid collectively using the automatic payment transactions only if certain fields are identical. Structure ZHLG1 specifies these fields. Important fields are:
- business partner (vendor / customer),
- payment method in the item,
- bank details in the item,
- instruction keys.
In this blog post an overview is given of the different other ways of grouping open items in the automatic payment program.
1. A grouping key is stored in the master record of the business partner (vendor / customer)
The fields according to which the payment program groups the documents are defined per grouping key in customizing transaction OBAP.
Example: group by payment reference
In the company code segment of the business partner role FLVN00 (FI Vendor) / FLCU00 (FI customer), the grouping key is assigned.
2. Single payment is flagged in business partner
In the company code segment of the business partner role FLVN00 (FI Vendor) / FLCU00 (FI customer), the single payment flag is available.
If this indicator is set, every customer/vendor open item is paid separately during automatic payment transactions. This means that open items are not grouped together for payment.
3. Open items which contain a payment method in the document
Open items, which contain a payment method in the document, are not offset against items without a payment method.
4. Separate payment for each payment reference
In customising transaction FBZP under data for paying company code, the ‘Separate Payment for each Payment Reference’ flag (T042B-XKIDS) is available.
When this flag is set, with one payment only invoices and credit memos are paid that have the same payment reference.
5. Single payment for marked item
In customising transaction FBZP under payment method for company code, the flag ‘Single Payment for Marked Item’ (T042E-XEIPO) is available.
When this flag is set, all items, for which the payment method thus flagged has explicitly been entered, are paid separately. If the payment method is not specified explicitly, but instead selected from the by the payment program, you can pay several items at the same time.
6. Payment per due date
In customising transaction FBZP under payment method for company code, the flag ‘Payment per Due Day’ flag (T042E-XZFAE) is available.
When this flag is set, with one payment only open items are paid that are due on the same day.
OSS note 305414 – F110: Unintelligible grouping of documents
OSS note 164835 – F110: Clearing credit memos and invoices
Blog post ‘Optimisation of F110 – Use of Grouping Key’
Excellent resource. Very useful! Thank you!
Thanks for your feedback 🙂
Thanks for the consolidated information, which I am looking for!
REALLY ITS HELPFUL SEND SOME MORE SCENARIOS ON ASSET ACCOUNTING PLEASE
Thanks for your feedback.
Open items of vendors and customers are paid via the automatic payment program. Whether this open item on vendor or customer is related to an asset, a service invoice, an invoice for goods delivered or others does not matter. All open items are handled and grouped in the same way regardless if it's asset related or not.
Thanks for this article, let me have the start point to trace the issue.
I share the special case in the Japan while the reference Key 3 with value grouping is not as expected below.
1757297 - F110: Grouping of documents with reference to Japan Country code