OT83
http://wenku.baidu.com/view/a4a24fd53186bceb19e8bb6e.html
SAP电子银行对账单
House Bank Accounts in SAP FICO
Published by David Schenz UnderBank on February 25, 2013
House Bank Accounts (HBAs) in SAP are often configured incorrectly during an implementation. This improper configuration causes problems later when additional sub modules such as Electronic Bank Statement (EBS), Cash Forecasting, and Check Reconciliation are brought into scope. In this article, we explore how House Bank Accounts connect to physical bank accounts, some key settings, and common pitfalls to avoid.
House Bank Account
A house bank account represents a bank account that the company has opened with a bank. There should not be a house bank account for customer, vendor, or competitor bank accounts. HBAs should only be setup for a company’s own bank accounts. Second, each HBA should represent one single bank account and one bank account should only be represented by one HBA. If there are multiple house bank accounts with the same account number, check clearing and EBS operations will be negatively affected.
It’s also important to note that when a bank account is opened, it is opened by a single legal entity. So if a company with fifty legal entities opens a bank account, the account is still owned by one entity inside that company. We see this relationship in SAP in that a single company code is assigned to the HBA.
House Banks
If a house bank account represents a company’s bank account, then the House Bank (HB) represents the bank that the account is maintained at. So suppose a company has account 523552 at Bank of America with routing number 52389593, then the house bank account will be tied to account 523552 and the house bank will be tied to routing number 52389593. Let’s suppose that you have multiple Bank of America accounts with different routing numbers. Should you have a different HB for each routing number? Yes – SAP only enables one routing number per house bank.
Naming House Bank Accounts
SAP gives us four characters to name each House Bank and each House Bank Account. That of course means that we must be pithy and smart about our naming convention. Most companies only have one or small number of banks that they have accounts with. At the same time, there may be a few routing numbers for the same bank. Thus, multiple house banks may be required for the same bank. With that information, a sensible naming scheme for house banks seems to be AAA# where AAA is an abbreviation for the bank name – such as BOA for Bank of America or FTB for Fifth Third Bank – and # is a sequential number for each routing number at that bank.
Similarly, we must be careful about naming house bank accounts. Best treasury practices suggest that accounts should be segregated to only have one type of activity. So disbursements should be executed out of one account and collections should be in a separate account. Thus, a reasonable practice would be to use an abbreviation for the type of activity and a sequential number. I would do AA## with AA being the short hand for the activity type and ## being a sequential number.
GL Accounts for House Bank Accounts
Most flows in bank accounting revolve around recording a companies cash activity and then reconciling against how the bank recorded that activity. As part of a monthly close operation, bank statements and internal accounting records should be reconciled against one another.
The standard recipe in SAP for cash accounting flows is that say when a payment is issued, a clearing account tied to the house bank account is credited and the vendor account is debited. Then, when the payment shows up on the bank statement, the clearing account is debited and the G/L tied to the HBA is credited. That means that the account tied to the HBA should always represent the reconciled activity (and match the balance per the last statement date), while the clearing accounts represent unreconciled activity.
Usually, there are more than one clearing accounts used depending on how much activity is flowing through the account. If the HBA GL account is 444440, then clearing accounts should be numbered 444441,444442,…,444449. If the account has low volumes, then only a clearing account for incomings and another for outgoings may be required. If the account has high volumes, then a separate account should be used for each type of activity (lockbox, ACH payments, check disbursements, etc).
Configuring House Bank Accounts
First, the house bank must be setup as a bank in FI01. The bank really is just used so that SAP is aware that the bank’s routing number is valid and to have a consistent address for the bank. Often times, a file is prepared and mass loaded with all of the known banks in a country to avoid having do to this step every time.
(1)
Next, the house bank is setup in FI12. First, we’re prompted for the company code of the house bank. Next, a code is assigned to the house bank as previously detailed. The country should be denoted as well. If there is a need for additional payment settings, these can be entered under the DME section. (2)
Once the house bank is created, the house bank account should be configured. Key information here is the Account id, the description, the account number, the GL account, and the currency.
(3)
Once all of this information is saved, then the house bank account is ready for use in other cash flows such as lockbox, EBS, cash forecasting, and so on.
Questions? Comments? Please leave feedback!
T-Codes, Config Paths, etc
Tags: Bank, Cash, FICO, GL, Treasury
General information
You have created a search string. After uploading the bank statement file, you notice that the target field (ex: posting rule/interpretation algorithm) is not populated based on the search string created.
Simulating the Search String
You can submit an existing bank statement to the string search in order to test the search (Transaction FEBSTS).
If the result is not in the simulation screen, then you should check table FEBRE via SE16. The search string uses the information contained in FEBRE table, so it
will not work if the information to be located is not in the table.
If this is the case, please check if your bank is sending the note to payee in the correct field.
Debugging the search string
In case the the info is in FEBRE table, then you should debug the search string process. Insert a breakpoing in the Function Module BSPS_PATTERN_SEARCH.
Check the contents of HITS table in the following code
The system writes no value into the target field if there are several hits for a target field (exception: the note to payee target field).
If this is the case, then you should review and correct the search string use in transaction OTPM.
EBS
EBS Search String Config usage to Posting Rule
此问题未回答。
Sandra Miner
2012-6-4 下午6:27
I have a situation where my client needs to post to differnt GL accounts for the same BAI code. In addition, there are 2 BAI codes that use the same search string text. The search string rule is not taking into account the BAI code when posting. I have set up configuration for both search strings and a default rule in the global settings. I have performed an upload of the bank statement and came up with incorrect results. Here's the specifics:
Search String config
BAI code 165 contains search string "PAYMENTECH TRANSFER" and maps to rule D900.
BAI code 455 contains search string "PAYMENTECH TRANSFER" and maps to rule C631.
Global Parameters
BAI code 165 default posting rule set to D910.
BAI code 455 default posting rule set to C003.
I'm using the standard algorithm 001 in the search string set up and in my default global parameters. All search strings are active. No clearing needs to take place in these postings; just debits and credits to house banks and GL accounts defined in my posting rules. I'm on R/3 4.7e. I have other similarly configured search strings and all post with same result.
In my test upload, both BAI codes utilizing above mapped search strings found posting rule D900; instead I want to post BAI code 455 to posting rule C631.
I assumed that the BAI code would be taken into consideration when finding the search string rule to post against. Is there anyone else who has come into this issue and solved? I'm hoping I don't need to employ a user exit or custom develoment for this work.
Any advice would be helpful.
Regards,
Sandy
1129 浏览次数
平均用户评级
(0 评级)
Re: EBS Search String Config usage to Posting Rule
Cristiano Silveira 2012-10-31 上午12:38 （回复 Sandra Miner）
Hi sandra,
HAve you check your configuration in transactions OT50 and OT51?
Regards,
Cristiano
Alert Moderator
喜爱 (0)
Re: EBS Search String Config usage to Posting Rule
Jignesh Kansara 2013-1-12 上午11:41 （回复 Sandra Miner）
Hi Sandra,
we had a similar requirement and also requirement for triggering automatic posting in In house cash area. we have achieved it through Z Table and User exit. In Z Table, we have defined default BAI code and code which should replace it for a combination of House Bank+Company Code+AcctID+Posting rule in SPRO setting + Posting rule which should replace SPRO + Keyword 1 from statement file+ Key word 2 from Statement file.
on execution of FF.5, an userexit will trigger, this userexit will check the table and if it will find an entry for perticular posting item, then it will overwriteSPRO posting rule by table maintained posting rule for same BAI CODE / BTC
this will be posted to diff. GL Account.
for eg.
Company code - 0001
House Bank - SBI01
Act ID - INR01
BTC / BAI COde - 155
posting rule (as per SPRO) - D910
posting rule (whichshould replace) - D900
Text 1 - PAYMENTECH
txt 2- TRANSFER
Acct identifier - +
TRANSACTION TYPE - SWIFT 940
...
