Symptom
When processing bank statements in format ISO20022 Bank Statement line items usually come with payment references and descriptions associated with a recorded transaction.
These serve to identify payment purpose and related documents as invoices or existing payments recorded in the system.
As a result open due items shall be cleared, payments confirmed or on-account payments be recorded for later processing.
Such transaction-related information is parsed as Memo Line content.
You notice that content contained in a particular xml-filed, for example <AddtlNtryInf>, is not shown as memo line content in the application.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Liquidity Management work center go to Bank Statement view.
- Select the relevant posted bank statement.
- Select View All and navigate to the Transactions tab.
- Click on relevant Item ID and select the Memo Line tab.
The memo line content shown here is perpetuated in associated Payment Allocation in field Memo Line.
In the column Postprocessing, follow the link Required to access associated Payment Allocation.
Alternatively you can find affected Payment Allocations in the Payment Management work center under Payment Allocation view.
Select the relevant payment allocation of type Bank Statement.
Cause
Based on payment characteristics pertinent payment references and additional information is stored in various relevant xml-fields.
If these are present and filled will depend on applied ISO20022 camt-version, conveyed information in associated payment files as well as house-bank specific practices.
It also has to be considered that memo line content processed per line item and in a Payment Allocation is not unlimited. Depending on the presence of candidate fields information may not be parsed.
Resolution
Typically the following content contained in fields under <Ntry> (Entry), <TxDtls> (Transaction Details) can be expected to be parsed as memo-content from an ISO20022 bank statement transaction:
<Ntry>
-<NtryRef>
-<AcctSvcrRef>
-<TxDtls>
--<Refs>
--->AcctSvcrRef>
---<PmtInfID>
---<InstrID>
--<RltdPties><Dbtr><Nm>
--<RmtInf><Ustrd>
--<AddtlTxInf>
Keywords
KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem