SAP Knowledge Base Article - Public

2805089 - Wrong Payment File Amounts in Downloaded Payment File

Symptom

You download a Payment File. After downloading it you notice the wrong amounts are displayed in the Payment File.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management Work Center.
  2. Go to the Outbound Files View.
  3. Show all Outbound Files and search for Payment ID XXX (where XXX is the Payment File number).
  4. Download Payment File ID XXX and open it.

You can see that the Payment Amounts are wrong.

Cause

These amounts are internally maintained as decimals with a certain amount of digits after the decimal. Since the File mapping has been maintained as just for example 10 Character Field Length without any Data Conversion Rules, the Payment Amounts are getting truncated after deciphering it from right to left.

You need to create a new Payment File Structure. You need then to extend the Character Field Length and maintain a proper Data Conversion Rule.

Resolution

  1. Go to the Business Configuration Work Center.
  2. Search for the activity Outgoing Bank Transfers and edit it.
  3. Click edit Payment File Structures.
  4. Press New.
  5. Enter a File Structure ID.
  6. Press Next.
  7. Press Add Row and enter a Record Definition name and Level.
  8. Press Next.
  9. Under Fields enter a Field Name at Bank and define an appropriate Field Length and a Data Conversion Rule.
  10. Press Save and confirm the New Payment File Structure.

Assign the new Payment File Structure and create a new payment file ID. This time the downloaded amounts are correct.

See Also

2550211 - Payment Outbound File not Correct

Keywords

Payment File structure, Field Length, Character, Payment File ID, Payment File Amount, Payment File Download , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem

Product

SAP Business ByDesign all versions