

Customers have transferred the money directly into Bank Account without providing details.Suppliers not depositing the checks on a timely basis.The Bank is not providing Bank statement on a timely basis.This will also help BSA’s who are working on Oracle Applications.Īll corporate faces the issue of Reconciliation between Book Bank Balance vs Bank Balance. This document will help the Organizations where Oracle Application is already implemented, and not importing the Bank statements or those wanting to move from other ERP/legacy system to Oracle Applications and wanted to Import Bank Statements. All fields are required.Ĭommonly used BAI2 Transaction Codes in Oracle Applications. The File Trailer record provides file control totals. The Group Trailer record provides group level control totals. The following 88 record may continue with the next field. If a non-text field is begun in one record, it must be completed in that record. Do not split non-text fields between records. If the preceding record did not end within the text field, the 88 record continues with whatever field follows the final field in the preceding physical record. If the preceding record ended within a text field, the text continues in the 88 records. The format is exactly the same as in the preceding record. The “Record Code” field is followed by a continuation of the preceding record. The Account Trailer record provides account-level control totals. This record reports transaction detail with accompanying text and reference numbers.

03 records cannot report transaction detail. And 03 record must be used to identify each account. Summary information may be accompanied by an item count and funds availability distribution. This record identifies the account number and reports summary and status information. The group header identifies a group of accounts, all of which are from the same originator and include the same As-of-Date. It identifies the sender and the receiver of the transmission, and it describes the structure of the file The file header marks the beginning of a file.

It contains the data related to AP Payments (negotiable and void status) and Receipts (remittance status).īelow mentioned are the Record Types used in BAI2 format: BAI2 file format is a standardized set of codes which comes in text format. BAI2 format is one of them and the same has been successfully adopted by all the ERP’s and Oracle Applications is not an exception.īAI2 format is getting used by Corporates to import the Bank statements in the system and will be used for reconciliation. Now Banks have accepted common formats across the globe which is not only benefitting them but also to their customers. sending hard copies of Bank statements to customers has been changed and the bank started providing the bank statements in electronic formats. With digitization in every field, traditional methods of Banks have been drastically changed. To have uniformity in the Bank formats, BAI (Bank Administration Institute) developed a generic format and it is widely accepted by most of the Banks in USA. However, the challenge that emerged was that, if you change your ERP/ Accounting system or change the Bank, you need to develop the new format as the existing format may not be useful or meaningless.

With the change in technology, Corporates developed their formats (custom) to import the Bank Statements into their system and reconcile the payments and receipts. Some years ago, it was a tedious job to reconcile the Book Bank Balance vs Bank Balance manually, due to a large volume of transactions. ****************************************************************************** * Compilation: javac NFA.java * Execution: java NFA regexp text * Dependencies: Stack.java Bag.java Digraph.java DirectedDFS.java * * % java NFA "(A*B|AC)D" AAAABD * true * * % java NFA "(A*B|AC)D" AAAAC * false * * % java NFA "(a|(bc)*d)*" abcbcd * true * * % java NFA "(a|(bc)*d)*" abcbcbcdaaaabcbcdaaaddd * true * * Remarks * - * The following features are not supported: * - The + operator * - Multiway or * - Metacharacters in the text * - Character classes. Below is the syntax highlighted version of NFA.java
