Skip to Content
Technical Articles
Author's profile photo Jonathan Eemans

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),
  • currency,
  • receiver,
  • 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.

 

Useful references

OSS note 305414 – F110: Unintelligible grouping of documents

Link: https://launchpad.support.sap.com/#/notes/305414

 

OSS note 164835 – F110: Clearing credit memos and invoices

Link: https://launchpad.support.sap.com/#/notes/164835

 

Blog post ‘Optimisation of F110 – Use of Grouping Key’

Link: https://blogs.sap.com/2014/08/07/optimisation-of-f110-use-of-grouping-key/

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Bill Bartley
      Bill Bartley

      Excellent resource.   Very useful!  Thank you!

      Author's profile photo Jonathan Eemans
      Jonathan Eemans
      Blog Post Author

      Thanks for your feedback 🙂

      Author's profile photo yiwei fu
      yiwei fu

      Thanks for the consolidated information, which I am looking for!

      Author's profile photo kasanur dada
      kasanur dada

      REALLY ITS HELPFUL  SEND SOME MORE SCENARIOS ON ASSET ACCOUNTING PLEASE

       

      Author's profile photo Jonathan Eemans
      Jonathan Eemans
      Blog Post Author

      Hi,

       

      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.

      Best regards,

      Jonathan

      Author's profile photo CHENG-YAO LIN
      CHENG-YAO LIN

      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