3679921 - The Total Number of Payments Data Source Displays Only Zeros in an Outbound File for a Custom Payment File Structure

In a custom Payment File Structure, in the Header/Footer level one of the fields was defined with Data Source Total Number of Payments.

The expectation is that the resulting outbound file would display the total number of payments in the respective field, but system shows zeros instead.

SAP Business ByDesign

1. Go to the Liquidity Management work center.
2. Go to the Outbound Files view.
3. Locate and open the respective File ID.
4. Click View All.
5. Download and open the file.
6. Notice that system displays only zeroes in the field that Total Number of Payments was expected.

For the respective custom payment file structure, record and field with Data Source Total Number of Payments, under the Field Content Definition tab, the Data Conversion Rule was set to "Character string: right-justified, leading 0, numeric chars". This configuration causes the Total Number of Payments data source to return zeros instead of the expected number of payment transactions.

The number of zeros that will be displayed is the number defined in Field Length (for example, eight).

The Data Conversion Rule should be set to ""Character string: right-justified, leading 0".

Steps to be followed:

1. Go to the Business Configuration work center.
2. Go to the Overview view.
3. Find and open the activity Outgoing Bank Transfers.
4. Click Edit payment file structures.
5. Select the respective file structure ID and click Edit.
6. Move to step 3 - Define Fields.
7. Select the row of the respective Record.
8. Select the row of the respective Field Name at Bank defined with Data Source Total Number of Payments.
9. Under the Field Content Definition tab, select the Data Conversion Rule as Character string: right-justified, leading 0.
10. Click Save.

Generate the outgoing file again (either manually or via Payment Media Run) and notice that the Total Number of Payments will be correctly displayed in the file.

Help Portal: Create a New Payment File Structure

payment file structure, total number of payments, trailer record, data conversion rule, sap business ByDesign, liquidity management, outbound files, payment medium run, Character string: right-justified, leading 0, Character string: right-justified, leading 0, numeric chars , KBA , AP-PAY-GLO , Cross-Country Extensions , How To