Symptom
Payment outbound file created based on custom Payment File Structure XYZ has status Error in File Creation. While checking the application log, error is displayed:
'File format XYZ is not consistent'
XYZ means the Payment File Structure.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Go to the File Management view.
- Go to the Outbound Files subview.
- Show All Files and find the respective Outgoing File.
- Choose the File and Go to Attachment.
- Choose Display Log.
- Error is displayed:
'File format XYZ is not consistent'
Cause
The sum of the length of all fields in a custom payment file structure must not exceed 1500 characters.
In this case, the sum is exceeding this limit, hence the system is not able to create a payment file.
This can be checked as follows:
- Go to the Business Configuration work center.
- Go to the Overview view.
- Go to either Outgoing Wire Transfers (Real Time Bank Transfers) or Outgoing Bank Transfers activity.
- Click Edit payment file structures.
- Select File Structure ID XYZ and click Edit.
- Click Next button twice until step 3 Define Fields is reached.
- Under Fields, check for each field what is the Field Length defined under Field Content Definition tab -> Data Positioning section
- The sum of all field length must not exceed 1500 characters.
Resolution
Restrict the total field length to a maximum of 1500 characters. After that, the payment file based on custom format XYZ should be successfully created.
Keywords
Payment Structure, Payment File, Outbound File, Outgoing Bank Transfer, File Format is Not Consistent, field length, 1500
Product
SAP Business ByDesign all versions