SAP Knowledge Base Article - Public

2834944 - Payment Items Missing in Custom Payment File

Symptom

You have created a custom payment file structure.

The payment file created with this payment file structure does not show the multiple document items you have selected in this payment.

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 Payment ID ABC (ABC is the payment ID) and select it.
  4. Click the same to open it, then View All.

Payment Medium Format Code: XYZ File Format (XYZ is the file format name).

The File ID is DEF

The payment is in Reference to Items with the following Document IDs:

HIJ1; HIJ2; HIJ3; HIJ4 (HIJ1; HIJ2; HIJ3 and HIJ4 are the different document IDs selected for payment).

  1. Click the File ID DEF to open the same and then View All.

The attached file is "PayFile_DEF".

The details in the file are as follows:

"XXXXX;XXXXX;XXXX;XXX;XXXXX;;HIJ1" (XXXXX;XXXXX;XXXX;XXX;XXXXX is the rest of the data in payment file).

You see that only document ID HIJ1 is displayed. The Documents IDs HIJ2; HIJ3 and HIJ4 are missing.

Resolution

  1. Go to the Business Configuration work center.
  2. Go to the Overview view.
  3. Search and select Activity Outgoing Bank Transfers.
  4. Click Change Immediately.
  5. Click Edit payment file structures link.
  6. Select Payment File Structure ID XYZ File Format.
  7. Click Edit.
  8. Click Next until Step 2 Define Records.
  9. Add Row with Level Payment Item.

Screen1.png

  1. Click Next to Step 3 Define Fields.
  2. Select the Record with Level Payment Item.
  3. Add row with Data Source as Payment Item - Document ID.

Screen2.png

  1. Click Save.

Create a new payment file with multiple document IDs. You see the document IDs displayed correctly in the payment file.

Keywords

Zahlungsdatei; custom payment file , KBA , AP-PAY-GLO , Cross-Country Extensions , How To

Product

SAP Business ByDesign all versions