How to read BAI2 bank statement format

How to read BAI2 bank statement file format

In this post we will see in detail how to read a BAI2 bank statement file format in detail by ourselves.

Organizations are uses a variety of bank statement file formats from their bank about their monthly/ yearly activities in a given account. The most common bank statement file formats which are available and used by all is MT940 and BAI2 file format for bank statement. Today in this blog we will see how to read a BAI2 bank statement file format in a easy manner.

BAI2 bank statement file format/specification in detail

How to read BAI2 bank statement format

In this post we will see a sample BAI2 bank statement in detail and will also see how to read a BAI2 bank statement format in detail. We will also see all BAI2 bank statement format specifications in details.

Sample BAI2 bank statement file format/Specifications

First of all lets see an example of sample BAI2 bank statement file. How does MT940 bank statement/format file looks like.

Below is the sample BAI2 bank statement file format file for oracle

How to read BAI2 bank statement file format

Now Let us know How to read BAI2 bank statement file format in detail

All tags in BAI2 bank statement format are explained below in detail

01 : File Header

01,BOFXX22XXX,169550,190904,08:54:22,1080363,80,,2/

02: Group Header

02,169550,BOFX22XXX,1,191010,2400,,2/

How to read BAI2 bank statement file format

03: Account Identifier

03,60087,GBP,010,-5655975,,,015,3734274,,,045,3734274,,,040/

088: Additional information

88,75114973,,,072,0,,,074,0,,,075,0,,,100,17689,,/

This line consists of additional information and this can follow a 03 line or 16 line.

16: Transaction detail

16,699,1700,,,216462,TEST

49: Account Trailer

49,92401704,3/

How to read BAI2 bank statement format

98: Group Trailer

98,4188040765,1,6/

99: File Trailer

99,4188040765,1,8/

How to read BAI2 bank statement format | BAI2 bank statement specifications || BAI2 sample || BAI2 bank statement format || BAI2 bank statement sample file|

How to setup document sequencing in oracle Payables invoices

Today in this post we will see how to setup or define document sequencing in payables invoices in oracle cloud/fusion.

What is document sequencing?

Document sequencing is a very common requirement for any business in real time scenario. This is usually done from audit and control point of view. This helps us in finding any missing or deleted transaction/ invoice in the system. Hence this serve as a tracking purpose as well.

How to setup document sequencing in payables invoices

Below are the details steps given on how to define document sequencing in payables invoices in oracle cloud/fusion in details.

Document sequencing in oracle payables can be setup for different types of documents or document sequence categories. Let us consider an example, you have decide to assign the sequence of numbers to the Payables document category Standard invoices Invoices. Then, each standard invoice you create will have a unique voucher number assigned as per the sequence.

Below are the some of the predefined categories that are provided by oracle in Payables:

Standard Invoices
Credit Memo Invoices
Debit Memo Invoices
Interest Invoices
Electronic Payments
Check Payments
Clearing Payments

How to setup/define document sequencing in oracle Payables invoices

Step 1: Login to Oracle and Navigate to Setup and Maintenance

how to setup document sequencing in oracle payables invoices

Step 2: Select setup as financials >In search task search for " Manage Payables Document Sequences" and click on the task. Payables document Sequencing window will open up.

how to define/configure document sequencing in oracle payables

Step 3: Select Application as Payables and click on search to see any existing sequence in the system

Document sequencing in oracle payables

Step 4 : To create a new document sequence for payables in oracle click on the Plus Icon.

Give the sequence name, Application , Module , Sequence type, Start date , End date. Provide the Initial value for the sequencing ( if you are keeping the sequence manual or Gapless)

Under Assignment Provide the document category for which this sequence will be applicable also provide start date and ledger name.