Symptom
- The data source for certain fields in the outbound payment file needs to be identified in the file output.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Go to the Outbound Files sub view within the File Management view.
- Find the relevant file and select Download File action button.
Cause
Payment file formats can be customized, such as for specific banks or countries where a localized version of the solution is unavailable. The exact data source for certain fields in the file format needs to be identified.
To determine this, the corresponding payment medium format for the relevant outgoing bank transfer document ID must be identified. These formats are configured through Business Configuration, where the payment file structure assigned to the payment medium format can be edited. The content of offset, and positioning of the data source can be defined in the "Define Fields" tab.
Resolution
To figure out corresponding payment medium format of Document ID,
- Go to the Payment Management work center.
- Go to the Payment Monitor view.
- Show the All Payments and find relevant Payment.
- In the Payment data, Payment Medium Format displayed is XXX(XXX represents the payment format ID).
To define the field data source and related settings,
- Go to Business Configuration work center and find the activity Ougoing Bank Transfer.
- Select the Assignment of Payment File Structures to the Payment Medium Formats and open it.
- Find the corresponding file structure ID of payment format IDXXX .
- Close the view to go back.
- Click the Edit payment file structures and open the another view.
- Find the corresponding File Structure ID and choose Edit.
- In the New Payment File Structure view, navigate to step no.3 step Define Fields.
- Here, select Add Row to define data source of a field name at bank.
For example, field content definition for country code can be set to return the 5th and 6th character of the Swift code.
Keywords
Data Source, Outbound files, Download, Position of fields, Payment Medium Format, Non-Localized. , KBA , AP-PAY , Payment Processing , How To