|
Title
BAI format bank statement test tool Purpose
Program RFEBKAT5 will generate a text file in BAI2 format which can beuploaded into the SAP system via the common statement loading process.
This program is one of the tool programs available for testing andimplementation of various bank statement formats. As a test tool, it islimited in function primarily to generate a text file of the properBAI2 format. Open item creation might be dependant on customizationrequirements not covered by the tool (business area, cost centers andother required fields.) Please refer to the below comments forsuggestions on how to accomplish those posting with the program. Integration
The program is capable of generating open-items on either the bankclearing accounts or designated customer receivable accounts. Thisprovides data for which bank statement customization can be tested.Posting rules which are targeted for clearing in the productiveenvironment can be tested in this fashion. Prerequisites
Substantial house bank account customization must be completed viatransaction FI12. Additional standard customization of bank statementprocessing is expected in order to properly process the generated BAI2bank statement file.
Should posting of open-items fail, please attempt to use the 'displayall screens' option to step through this posting. This may displayrelated customization which is required in order to sucessfullygenerate documents in the customized environment.
Additionlly, the user might manually edit the downloaded BAI2 bankstatement file to refer to already existing postings. Pay attention tothe statement date and time in records 01 to 03. A statement file canonly be loaded once into the bank data buffer. Features
The program is also capable of producing an balance summary report, orpolling data file. This file is used to bring balance information ontothe cash-position of the organization without generating postings ofline-items. It is commonly seen that a polling statement is receivedand processed to reflect balances on the position. Then on the nextbusiness day, the end-of-day bank statement is received and processedposting specific line items which were previously reflected on theposition via the balance summary. Example
Parameter Desciptions
File specifications: specify the file names to be created for eachstatement type.
Account details: Specify the GL account where all created open-itemsoffsetting entries should be made. The bank account and company codefor the generated statement is selected.
Statement data: Enter the date for the created statement and thedocments generated.
Document creation posting method: Select Display all posting screens tostep through the screens during the creation of each document. SelectDo not display posting screens if this is not needed or no documentgeneration error occurs.
Creating open items Customers/Business Partners: This is used togenerate open items on customer accounts. Note the external transactionfor the bank statement customer payments is required.
Creating open items Clearing accounts: Various common clearingaccount activities can be posted with these selections. The externaltransaction code of each clearing account item is required. Forcreating the open-items on the clearing accounts., the document type,posting keys, amounts and clearing account is required.
When the report is run, it will display the open-item postings made andgive the associated document numbers. Confirmation of the created BAIfiles will be made.
For example:
Outgoing checks
00001 FB01 SA 001 40 113100 USD 100.00-
002 50 113101 USD100.00
Document 100002882 was posted in company code 3000
Cash disbursement
00002 FB01 SA 001 40 113100 USD 120.00-
002 50 113106 USD120.00
Document 100002883 was posted in company code 3000 |