Skip to Content
Technical Articles

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/

2 Comments
You must be Logged on to comment or reply to a post.