SAP ABAP IMG Activity REFXVC_T028 (Make Global Settings for Electronic Bank Statement)
Hierarchy
☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_CA_CU (Package) RE: Customizing (IMG) and Area Menu
IMG Activity
ID REFXVC_T028 Make Global Settings for Electronic Bank Statement  
Transaction Code S_ALN_01002355   (empty) 
Created on 20031030    
Customizing Attributes REFXVC_T028   Make Global Settings for Electronic Bank Statement 
Customizing Activity REFXVC_T028   Make Global Settings for Electronic Bank Statement 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name REFXVC_T028    

Use

Use

In this Customizing activity, you can make basic settings for the account statement. There are six main steps to be carried out:

  1. Create account symbol

    Specify G/L accounts (such as bank, cash receipt, outgoing checks) to which postings are to be made from the account statement. You assign account symbols to the G/L account numbers. These are required for the posting rules in step 2.

  2. Assign accounts to account symbols

    Define postings to be triggered by possible transactions in the account statement (such as bank transfer, debit memo).

    Note: In the posting specifications debit -> credit that you define here, use the account symbols from step 1, not the G/L account numbers. This prevents similar posting rules being defined several times, the only difference between them being the accounts to which postings are made.

  3. Create keys for posting rules

    Assign the posting rules to the possible transactions in the account statement file. A list of such assignments where one external transaction code is assigned to one posting rule is called a transaction type.

  4. Define posting rules

    Create a posting specification for each posting rule. You thereby specify how a given business transaction is to be posted.

  5. Create a transaction type

    Create the names and descriptions of the various transaction types you require.

    In this activity you assign (external) business transaction codes to an (internal) posting rule. As a result, you can use the same posting specifications for different business transaction codes.

  6. Assign bank accounts to transaction types

    Assign the bank details to a transaction type, for which the account statements are to be imported. All the house bank accounts at a particular bank are usually assigned to the same transaction type.

Requirements

You have already entered your house bank data for the account details. If not, define your house bank data in Customizing under Bank Accounting -> Bank Accounts -> Define House Banks.

Create account symbols

In this activity you create the account symbols that you later need for defining the posting specifications. Before the posting rule is used, the account symbols are replaced with the relevant accounts to which posting is to be made.

Example

Create the account symbols BANK and CASH RECEIPT so that you can later define a posting rule for cash receipt.

Activities

  1. Define an ID for each account symbol.
  2. Enter a description in the text field.

Assign accounts to account symbols

In this activity you define the account determination procedure for each individual account symbol.

Example 1:

Assigning G/L account 113100 to account symbol BANK

Chart of Accounts: INT (sample chart of accounts):

Account symbol    Acct mod.    Currency    G/LAcct

BANK    +    +    113100

Example 2:

To avoid having to define a separate account symbol for every single house bank account (with a different G/L account in each case), the G/L account field can contain a masked output.

Chart of Accounts: INT (sample chart of accounts)

Account symbol    Acct mod.    Currency    G/LAcct

BANK    +    +    ++++++++++

Here, the account determination replaces the account symbol BANK with the G/L account number of the house bank account defined in the house bank master data. The appropriate masking can also be used for the bank subaccounts.

Example 3:

Standard procedure for defining bank subaccounts

Chart of Accounts: INT (sample chart of accounts)

Account symbol    G/LAcct

BANK    ++++++++++

CASH RECEIPT    ++++++++01

INCOMING CHECKS    ++++++++09

You can influence account determination further by making entries in the Account modification and Currency fields.

Example 4a:

You wish to manage incoming checks in foreign currency (such as USD) in a different clearing account to incoming checks in local currency (such as EUR). You can do so by making the following setting.

Chart of Accounts: INT (sample chart of accounts)

Account symbol    Acct mod.    Currency    G/LAcct

INC. CHECKS    +    +    ++++++++09

INC. CHECKS    +    USD    ++++++++14

Example 4b:

You wish to process the business transaction credit memo for rent in a different account than is otherwise used for the credit memo posting rule. For this business transaction, you specify an account modification and the account to which posting is to be made (such as 99999).

Chart of Accounts: INT (sample chart of accounts)

Account symbol    Acct mod.    Currency    G/LAcct

INC. CHECKS    +    +    ++++++++09

INC. CHECKS    RENT    +    0000099999

In addition, the field FEBEP-KFMOD has to be filled for the given transactions, either in the function enhancement for the electronic accounts statement (see the Customizing activity Develop Enhancements for Electronic Bank Statement (General)), or by using the search string search with the target field Account Modification (see the Customizing activity Define Search String for Electronic Bank Statement).

Note
Note that masked entries (using a plus sign +) are always based on a ten character account number. If you are using a shorter account number (six characters, for example), the entries must be right-aligned.

Create keys for posting rules

In this activity you enter descriptions for the necessary posting rules. Each posting rule represents a business transaction from the SAP System that is included in the account statement, such as:

  • Incoming check
  • Credit memo
  • Debit memo
  • and so on

Example

You create the posting rule 0001 (cash receipt via interim account) for cash receipt.

Activities

  1. Define an ID for each posting rule.
  2. Enter a description in the text field.

Define posting rules

In this activity you create posting specifications for each posting rule. You use the posting specifications to specify how a certain business transaction (such as a credit memo) is to be posted.

Posting specifications consist of one or two posting records debit -> credit, where the first posting record is called posting area 1, and usually represents a G/L account posting (BANK -> CASH RECEIPT, for example). The optional second posting record is called posting area 2 (CASH RECEIPT -> CUSTOMER, for example).

Depending on whether a posting transaction affects bank accounting only, or also affects subledger accounting, define the posting rules either for the first posting area only, or for both the first and the second posting areas.

Example

For the transaction "check credit memo", you only need posting rules for G/L accounts because the customer account has already been cleared as a result of the check deposit. For a bank transfer, however, you will need a second posting area in addition to the posting rules for the G/L accounts in order to clear the customer account.

Activities

Define the posting rules for posting area 1 and 2:

  1. Enter the posting type (posting or clearing G/L accounts or subledger accounts, reversing clearing).
  2. Enter the accounts (that is, the account symbols) and posting keys for both the debit and credit sides of the posting record. Depending on the type of posting (clearing/posting), it may be necessary to leave the fields on either the debit or credit side blank. For example, with posting type 8 (credit clearing for subledger accounts), the system uses the note to payee information to try to identify and clear an appropriate open item. In this case, there is no need to specify the account and posting key beforehand since they will be determined automatically during the open item search.
  3. Specify the document type.
  4. If required, make entries in the optional fields for compression, special G/L indicators, and posting keys for payment on account.

Example

Posting rule 0001

PArea    PK (D):    Account (Deb.)    PK (C):    Account (Cred.)    DT    PstType

1    40    BANK    50    CASH RECEIPT    SB        1

2    40            CASH RECEIPT    DZ        8

Create a transaction type

In this activity yo

Business Attributes
ASAP Roadmap ID 204   Establish Functions and Processes 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG REFXVC_T028 0 ALN0000042 Rental Accounting 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
VC_T028 C - View cluster SM34  
History
Last changed by/on SAP  20031107 
SAP Release Created in 500