Electronic Account Statement Implementation Tool (SAP Library

Electronic Account Statement Implementation Tool

Program RFEBKATX supports you during implementation of the electronic account statement, helping with Customizing and giving you a feel for the options available in the electronic account statement.

Background

One of the functions of the electronic account statement is automatically to assign payments received by/made from house bank accounts (whether by check, bank transfer, and so on) to the appropriate open items (which items have already been posted in the system).

There are two main obstacles in Customizing to quick and efficient installation of the electronic account statement:

Creating the files UMSATZ.TXT and AUSZUG.TXT is a complex process. Experience has shown that many implementation errors arise from incorrect creation (format errors) of these files. Using actual files from the bank is also difficult as the files are usually very big.

The open items to be found and cleared using the electronic account statement must usually be entered into the (test) system manually and with correct clearing information. This information must also exist in the correct fields in the individual line items in the UMSATZ.TXT file (for example in the note to payee fields).

You can use program RFEBKATX to create open items in a company code and the related (MULTICASH) account statement files for a house bank account. You can import these directly using program RFEBKA00, and so test both your Customizing settings and the general functions provided by program RFEBKA00.

Prerequisites

You may first have to create a house bank account (for which the account statements are to be generated) in your company code. Important: The G/L account must be maintained in the house bank account master record (G/L account 113100 for example).

You may first need to create those customers for whom you want to test creation of open items in the company code.

You must create a G/L account as a substitute account for the postings that you carry out to generate the open items in the customer accounts. The number of this G/L account must be identical to the number of the G/L account of the house bank account, except for the last two figures that must be "19".

Example:

G/L account: 113100

Substitute account: 113119

Caution

Running test program RFEBKATX creates a payment on account labeled "Customer to substitute account" (for the purposes of creating open customer items). Although, in accounting terms, this is not correct for an invoice posting to a customer account,

the correct update of customer invoices to revenue accounts is not the purpose of this program, which must only be run in your test system.

To generate open items in clearing accounts, you must create G/L account for these clearing accounts. These accounts are numbered similarly to the method for substitute accounts, although the final digits are as follows:

Outgoing checks: '01' (in our example: 113101)

Incoming checks: '08' (in our example: 113108)

Cash out: '09' (in our example: 113109)

In the master data for these accounts, set the indicators for "Open item management" and "Line item display".