SAP Knowledge Base Article - Public

2699628 - How to Create Single Payment File for Multiple Transactions Using Custom Payment File Structure

Symptom

You have created a custom payment file structure. You notice that system creates different payment files for each transaction when you create the output file. However, you are expecting that Payment ID's are pooled together in single Payment File when you create payment file.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Payment Management Work Center.
  2. Go to the Payment Monitor View.
  3. Search for Payments In Transfer.
  4. Search for Document ID 123 and select the Document ID's in transfer.(123 represents the Document ID)
  5. You can see the Outbound File ID's are different.

(or)

  1. Go to Liquidity Management work center.
  2. Go to the Payment Monitor View.
  3. Search for Payments In Transfer.
  4. Search for Document ID 123 and select the Document ID's in transfer.(123 represents the Document ID)
  5. You can see the Outbound File ID's are different.

Cause

You need to select 'Multiple Payments Allowed' checkbox in the business configuration settings, so that the payment medium format allows several payments in a single file.

You need to adjust the granularity of the payment media format so that a new logical message within the same file is open for all payment ID's.

Sort Sequence and Granularity of Payments tab controls the payments will go into one file or into many files. If you select check box:Open new File / Payment Medium, it will create new file for each transaction and if you select check box:Open new Logical Message / Batch, it will create single file for multiple transactions.

Resolution

  1. Go to the Business Configuration workcenter.
  2. Go to the Implementation Projects view.
  3. Open the activity list.
  4. Open the activity Outgoing Bank Transfer.
  5. Click Edit payment medium formats.
  6. Highlight the concerned payment medium format that uses your file structure.
  7. Go to General tab and select Multiple Payments Allowed check box.
  8. Click tab Sort Sequence and Granularity of payments.
  9. Select the check box: Open new Logical Message / Batch, it will create single file for multiple transactions.
  10. Enter for which payments within the payment file a logical message should be generated.
  11. Click on Save tab.

You need to re-create the bank transfers and generate the outbound file.

Keywords

Payment file, payment medium format, Single file , KBA , payment file for multiple transactions , custom payment file structure , single payment file , AP-PAY , Payment Processing , Problem

Product

SAP BUSINESS BYDESIGN 1902 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811