SAP Program RFEBSE00 - Convert Swedish Bank Statement to MultiCash Format


DEFINE &MULTIC_REP& = 'RFEBKA00'

Description
Program RFEBSE00 converts Swedish bank statements to Multicash format.The following formats are supported:
bank giro OCR
bank giro LM (Automatisk avprickning)
bank giro Autogiro
postal giro OCR
postal giro TIPS (Total Integrated Payment System)
postal giro Autogiro
RESET N1
Depending on the option you select, this program reads input data fromeither the PC or the file system, and generates two files in Multicashformat. The statement file contains information about thestatements, such as the statement number, currency, and bank accountnumber. The line item file contains the individual cashtransactions on a statement.
Credit memos can be cleared as long as the the credit memos that arealready posted in the system can be accessed using the referenceinformation from the data medium. Credit memos cannot be cleared,however, when the "postal giro TIPS" format is used.
To import generated Multicash files, you should use the standardprogram &MULTIC_REP&. For more information on this program see thedocumentation.
IF &DEVICE& EQ 'SCREEN'.
Import bank statement: Multicash, SWIFT_MT940.
ENDIF.

Notes on Configuration
Program RFEBSE00 uses the standard configuration from electronic bankstatements. For more information on the electronic bank statementconfiguration see the Implementation Guide.
IF &DEVICE& EQ 'SCREEN'.
Specifications for electronic bankstatement
ENDIF.
Allocating Banks to Transaction Types
By using transaction types that are freely definable, you can combinebank accounts in which the same external transactions are made. To dothis, you must allocate a transaction type to each house bank accountyou use. This bundling reduces the number of entries in the "Allocateexternal transactions to internal transactions" table.
House Bank and House Bank Accounts
A bank account cannot be defined in more than one company code. Youhave to specify the bank account currency since some banks use the sameaccount numbers and only the currency key can differentiate theseaccounts. You must also define the G/L account to post to for each bankaccount.
With a unique bank account, the program automatically determines thehouse bank that belongs to it.
Processing Credit Memos
Credit memos are defined in the same manner as outgoing payments aredefined in the system. First maintain an internal transaction code forposting credit memos. To do this, use "Posting type 7: clearingsubledger account with debits".
Allocate the external bank transactions for credit memos to thistransaction code.

Specifying the Business Transaction Codes
There are no external transaction codes defined in the bank's datamedium. To allocate these transactions to internal transactions,however, you need these codes.
For each payment receipt and disbursement, specify on the selectionscreen an external business transaction code with which the customerand vendor items should be posted.
RESET N1

Errors in Generating the Multicash Files
Multicash files cannot be generated in the following situations:

  • The bank account number in the data carrier cannot be uniquely
  • allocated to a house bank.
    • The calculated total digits do not match the total digits in the file.

    • You can simulate the posting procedure to determine whether the
    • configuration is complete. The system will list the transactions thatneed to be maintained and the type of maintenance required.
      The bank or the receiver can reject individual autogiro bankstatements. The reason for declining the statements is recorded in thedata medium sent by the bank.
      You can obtain a list of the decline codes from your bank.
      The program logs any data records that could not be executed so thatyou can further process them later.
      Credit memos in the postal giro format TIPS cannot be processed by theprogram.
      Posting Currency
      The system uses the ISO code for the Swedish krone (SEK) as thestatement currency.

      Configure Taxes and G/L Accounts
      You must allocate the external transaction for taxes to a tax account(tax code "<"). The system then posts taxes directly to the taxaccount. You must define the G/L account allocated to the costtransaction as not tax relevant.
      RESET N1
      Access Multicash Program &MULTIC-REP&
      After converting the input data, use the Multicash program &MULTIC_REP&in order to process the data in the system.
      To do this, maintain a variant for specifying on the selection screen.
      The following parameters are automatically filled with current valueswhen program &MULTIC_REP& is accessed, and therefore do not have to bemaintained when you define the variant.
      Statement file
      Line item file
      Format "M"
      PC upload

1595064Bank statement: Potential directory traversal
106121Electronic bank statement formats