SAP Note 24546 - Manually processing the account statement in the UK

Symptom:

As of Release 3.0, it is possible in Great Britain to store bank transactions with different execution days in a telepay file. The creation of payment advice notes using DME management, which is common in other countries, can generally not be used in Great Britain because the bank gives a confirmation for each execution day but not for the entire file.

Cause and prerequisites

The creation of payment advice notes in DME management creates a payment advice note for each data carrier. However, for different execution days this only applies to some data records.

Solution
When creating the telepay file, payments are already grouped together to one day and identified by a unique reference number. The new report RFFODTA1 creates a payment advice note for such a reference number.
Procedure:
A created TELEPAY file can contain payment orders for several execution days. For each execution day, at least one CONTRA record is created in this case which is uniquely identified by identifier "SAPBACS" + 10-character reference number.
Example: Payment to vendor Adams : DM 1000,00 12/15/199x
Payment to vendor Blithe: DM 2000,00 12/15/199x

Payment to vendor Miller: DM 1100,00 12/17/199x
Payment to vendor Norman: DM 2200,00 12/17/199x

Payment to vendor Adams : DM 1110,00 12/19/199x
Payment to vendor Miller: DM 2220,00 12/19/199x

CONTRA 12/15/199x DM 3000,00 SAPBACS0000123410
CONTRA 12/17/199x DM 3300,00 SAPBACS0000123511
CONTRA 12/19/199x DM 3330,00 SAPBACS0000123612

After the bank has made the payments for one day, the reference number in question is passed on to the client. To simplify the clearing, you can now create a payment advice note with the affected items in each case using report RFFODTA1.
Example:
Payment advice note 070000123511 is created for reference number "0000123511" which contains the two items of December 17th. When posting the outgoing payment of DM 3300.00, the affected items are selected by specifying the payment advice note number.

Additional key words

Bank reconciliation, RFFOGB_T, RFFODTA1, TELEPAY