Finacle Training lesson 6 [ 2 Steps, 4 States]

Finacle Training lesson 6 [ 2 Steps, 4 States]

Recap:

In the previous lesson we have learnt about the basic terminology which is used in Finacle. If you have not already read the previous lesson please read it and come back to start reading this lesson.

In this lesson we will learn about the basics of all the transnational procedures. This lesson is very important in this training series. So please pay a bit more attention.

There are two steps in the completion of transaction in Finacle.

Yes there are two steps in the completion of a single transaction in Finacle. In the first step Counter PA does the transaction in his/her login. In the second step Supervisor verifies/authorizes the transaction in their login. This concept of one person doing the transaction and other person verifying is called as maker-checker concept.

Why verification is necessary?

• The answer is simple. Verification is necessary to prevent frauds, to check for errors and to prevent any misappropriations.
• This verification concept is not new for us. We use to clear forms in the supervisor login of Sanchay post also. But verification had no significance in Sanchay post. Only because we cannot generate LOT without clearing the forms, we used to clear those forms.
• But in finacle verification is mandatory. A transaction is completed only after the verification. Without verification of transactions we cannot perform day end operation.
• So remember there are two steps in completion of any transaction. The transaction can be cash transaction or non cash transaction; it has to be verified by the supervisor.
• Note: There is only one transaction which does not require any verification. It is SB withdrawal up to Rs.5000/-

The Four states of a Transaction

In the above section we have learnt that a transaction is not completed until verification is completed. So before verification a transaction will be in unverified state. In this unverified state there are 2 stages/states.

They are

1. Entered State

2. Posted State

After counter PA does a transaction in Finacle, it can be in either Entered state or in Posted State. After verification, the transaction changes its state to Verified State.

So totally there are 3 states for a transaction.

1. Entered State

2. Posted State

3. Verified State

Now let us see what is meant by Entered state, posted state and verified State.

1. Entered State: If a transaction is in entered state, it means that the deposit or withdrawal relating to that transaction has not yet been affected in the ledger of the account.

It means that, the transaction takes place but it will not affect any of the ledgers, be it the account ledger, teller cash position or LOT. Only after verification all these will be affected and the transaction will change its state to Verified State.

The transaction which will be in entered state before verification are a) RD deposit, b) SB withdrawal above 5000 and c) New accounts in which transaction is required.

We cannot modify any transaction once it is done.

We can delete transactions which are entered state. So if you do any mistake in transactions which are in entered state, we can delete that transaction and do that transaction again correctly.

Deleting does not mean that the transaction completely vanishes from the system. It will be available in the system as a deleted transaction.

2. Posted State: If a transaction is in posted state, it means that the deposit or withdrawal relating to that transaction has affected the ledger of the account.

It means that, the transaction has affected the account ledger, teller cash position and it will also appear in the LOT.

The transactions which will be in posted state before verification are a) All transactions which are not in entered state b) all transactions which are not in verified state and c) transaction whose state is modified from entered state using HTM menu before verification.

We cannot modify or delete a transaction which is in posted state.

3. Verified State: A transaction is said to be verified only after verification is done by supervisor. But there is one exception. SB withdrawal up to Rs.5000/- does not require verification. It will be in verified state by default.

We cannot modify or delete a transaction which is in verified state.

4. All transactions which are deleted will be in deleted state. Only the state changes from entered to deleted state. The transaction will still be available in the system for inquiry.

So these are the four states of transaction. I hope you are following me.

Since this is not a live training session. I will give you some work which you have to do in office. From this lesson onwards you will have some observations to do in the office. If you do these observations or work which I give you at the end of each lesson from now onwards, you will understand more clearly what I’m trying to teach.

Observation to be done at office:

1. Collect some SB, RD, PPF and SSA transactions which you have done in the day.

2. Invoke the menu HFTI (Don’t worry I’ll teach about HFTI menu in detail in later lessons).

3. A new screen will appear. In that screen you will see field “A/c Id” ( See the image below)

In the A/c Id field enter the account numbers which you have collected in the first step, one by one. For example, enter SB account number of the transaction and Click on Go button.

4. When you enter the account number and click on GO, the following screen will come.

5. Repeat the same process with the vouchers of all transactions.

What you have to do is observe the status of each transaction before verification and after verification.

So that’s it for today’s lesson. See you again tomorrow.

Points to remember in this lesson:

1. There are two steps in completion of a transaction. Counter PA does the transaction and supervisor verifies the transaction

2. There are three states for a transaction. They are Entered State, Posted State and Verified state.

3. Do not forget to observe the status of the transaction in the counter tomorrow.

Read more

DOP Finacle Tips for Multiple Login and Menu shortcut

DOP Finacle Tips for Multiple Login and Menu shortcut

1) To Login SU Finacle user without logout of CPA user, just goto "File" menu in Internet Explorer and click on "New Session". And Login as SU.

2) Instead of remembering all menu shortcuts in Finacle you just add frequently used menus to "Favorite's". For that Just right click on a menu and click on add to "Favorites!".

For example: Exapand CIF Menus button and choose "CIF Modification", Right click on it and click on " Add to Favorites ".

Finacle Training Lesson 1 [Menus]

Finacle Training Lesson 1 [Menus]

In this lesson we will learn the most basic concepts about finacle. Finacle is very easy. Yes it is very easy. Many people who come for training at my WTC say that they will take voluntary retirement because of the fear of finacle. No sir, if you know the full power of finacle you will want to work a few more years after your retirement. Yes, you will want to work more because finacle handles the major burden for you. You will feel more relaxed and enjoying that you will not want to leave the work. All this is possible when you know everything about Finacle. 

Not only finacle even in our real life this rule applies. You will be afraid of driving a car in the beginning. You will be afraid of making an accident. At the beginning, we are not really perfect. But once we know perfectly we will drive the car as easily as drinking water. Same is the case with Finacle. Once you know everything about finacle you will do transactions so fast that you yourself will be amused with your speed. 

So just concentrate on what I am teaching, practice the tips which I give you and you will become finacle master in no time.

Sanchay Post is very easy. Is Finacle easy?

Of course Finacle is easy. But Sanchay post is very very easy. Yes I agree with you on this point. But Finacle is highly secured. It can handle millions of transactions with ease (Daily almost 30 lakh transactions are taking place all over India in finacle offices). No chance of frauds. Can we say these things about Sanchay post? No. Sanchay post is not secured. Anyone can easily do frauds in Sanchay post. And it cannot handle large number of transactions. 

Finacle has many advantages too. It gives customers various other channels of making transactions. They need not come to post offices to complete their transactions. They can do transactions by themselves. They can use ATMs to withdraw money. There are cash deposit machines to deposit money. They can use internet banking facilities to check balances, print account statement, transfer amount to different accounts all by themselves.

So in an year or two we will observe a huge decrease of people coming to counters to do transactions. That means fewer transactions at counter. Isn’t it great? 

Since less people come to counter it gives us opportunity to start new business ventures. We can sell mutual funds, stocks and life insurances. We can handle forex (foreign exchange) services. The possibilities are unlimited. We can become a major contributor of income to GDP of our country. We can be proud of what we are doing. People will once again start respecting us.

I think many of you have faced this question.

“Oh you work in Post office? That’s great! No work at post offices is it! You might be enjoying a lot because nobody is using letters now a day’s”

I feel like hitting hard in their face to whoever says this to me. But we can’t do that. Can we? We have to give a tight slap to them by our work. We will work hard and prove to our country what we are capable of.

Finacle will give us this strength. It will give the wings to fly high. Let’s learn Finacle with lots of love towards it. Yes many officials are suffering due to this CBS. But all those technical problems our administration will soon overcome. By that time we should become Finacle experts. 

Let’s get into the lesson now. Auditors (SBCO staff) can also follow this training. Because to understand what auditors should do, it is essential that auditors should know what counter staff are doing. Even though we don’t know completely how auditors should work in finacle, we know the basics of what auditors should do. We will start a separate training for auditors after completion of counter staff training. But it is essential that auditors should know all this. So we advise auditors staff also to follow this training closely. 

Differences between Sanchay Post and Finacle. 

Because we already know how to work with Sanchay Post, Let’s learn Finacle from Sanchay post itself. In Sanchay Post everything was readily available on screen. For any transaction we just click on the item which we want and a new screen opens with required form. Then we enter the fields in the form and click on SEND button. And the transaction is done.

But Finacle is different. Nothing is visible on the screen. See the image below. After you login into finacle the screen will appear as below.

See, there is nothing on the screen. Then, what should we do to deposit amount in to an SB account? How should I close an SCSS account? How can we do transactions when nothing is visible on the screen? See the picture below now.

If you look on the top most right side of the screen, you will notice a field named as “Menu Shortcut:” Beside menu shortcut there is an empty box. This empty box is used to do all transactions in finacle. Through this box we can talk with Finacle. Yes! we can talk with Finacle. 

Since Finacle is computer software it will not understand our languages. If we say “Finacle babu jara SB depojit ka screen open karo”, it won’t understand anything. It’s simple isn’t it? We cannot talk in Hindi with a Chinese person. That Chinese person will only understand Chinese Language. 

Similarly Finacle will only understand its own language.

Finacle can only understand a language of codes. If you want to talk with Finacle we should know the codes that it understands. If you want to open an SB account, then enter CASBAO code in the menu shortcut field and click on GO. See the image below and you will understand.

Finacle only understands these codes. After clicking on go it will open a new screen where you will enter some more information and open the account.

These codes which Finacle understands are called as MENUS

To do any transaction in Finacle you have to enter a menu in the Menu Shortcut field. Finacle will read this menu and it will open a new screen where you can complete the transactions. 

Let us imagine that Finacle is a ROBOT. Robots are designed to do predefined works. You give commands to robots and they will complete the work. Similarly we have to give commands (MENUS) to make it work for you. 

To do any transaction, we have to enter a menu in the menu shortcut field. For every transaction there will be a menu. There are almost 200 menus in finacle which are available for counter staff. There will be so many other menus which are available for users with higher roles. I’ll give you some examples.

1. Menu for SB Deposit is CTM.

2. Menu for SB Account opening is CASBAO.

3. Menu for SB to RD standing instruction is HSSIM.

4. Menu to initiate Day end is HISCOD and so on.

You need not remember all these menus immediately. As the time goes you will remember all menus by heart. For beginners, I’ll give you a list of most commonly used menus in the counter at the end of this lesson. You can download it and use it in the counter. 

Because we are using menus to do transactions in Finacle, Finacle is called as a menu driven web interface.

So,that’s it for today’s lesson. In the next lesson we will learn how to login into finacle. I will explain in detail about everything which you see on the screen in the next lesson. 

Points to Remember: 

1. Finacle can only understand the language of codes. 

2.These codes are called as MENUS

3. For every transaction in Finacle there is menu.

4.To do any transaction in Finacle you have to enter the corresponding menu in the menu shortcut field.

8 Mistakes which you should never do in DOP Finacle

8 Mistakes which you should never do in DOP Finacle

8 Mistakes which you should never do in DOP Finacle

1) Never close the browser window without logging out.

2) Never do any transaction in Supervisor login

3) Do not use complicated passwords

4) System could not get response from server

5) No multiple CIFs for same customer

6) Do not forget HCASHPND transaction after cashclosures.

7) Do not forget to verify transactions

8) Do not share your password

https://drive.google.com/file/d/0B5ceVEjyB3diSVdkam9vY194YWc/view

CSV PREPARE TOOL for SOs & CPCs

Working Procedure

Highlights:

Import Policy details from Excel(optional)

ST calculated automatically.

Total Receipt including ST calculated automatically.

Type of ST,i.e,type-1,2,3 shown automatically.

You can change ST details, Circle, PAO details as per your required.

You can export single policy for csv, bulk policies and date wise also which is your convenient.

All necessary formulas for CSV file format were used.

User friendly and highly graphical interface. 

Note: 

1) Rename the attached file as " OCR_TOOL.rar "

2) Extract it to D:\ drive only.i.e., "D:\OCR_TOOL\"

Find video, for setup guide and working procedure.

tool for ssa lot

https://drive.google.com/file/d/0B81TXzQRVmqLSUhIMnZTczVCWDA/view

VERIFICATION OF ALL ACCOUNTS IN FINACLE BEFORE END OF FINANCIAL YEAR INTEREST CALCULATION

Important instruction: verification before End of Year interest calculation 

We are nearing the end of the financial year when interest calculation and posting are due for SB accounts. 

Post Offices advised to verify all the accounts which have been modified but verification is pending since interest posting for such accounts will fail resulting in complaints and tickets being raised for non-posting of interest. 

Unverified accounts can be listed by respective offices using the HAFI menu. Following are the fields to be entered in HAFI for finding out unverified transactions: 

Procedure to view the unverified accounts

Invoke the menu HAFI and enter the following details as mentioned below
Enter the SOL ID ____________
Enter the Table Short Name as "GAM"
In the Ref NO files "give two balnk spaces"
Enter the General Ledger Subhead code as _________
Enter the function code as "M" 

Select the Authorized option as "Not authorized" as mentioned in the below screen shot 

Following are the Genearl Ledger Subhead codes 

SB - 30001
PPF - 33001
NSS87 -30021
NSS92 -30022
RD -30010
TD 1 YR - 30011
TD 2YR - 30012
TD 3YR - 30013
TD 5YR - 30014
TD EXCEPTION - 30015
MIS - 30016
MIS EXCEPTION - 30017
SCSS DEFENCE - 30018
SCSS VRS - 30019
SCSS GENERAL - 30020.

After entering all the details then click on Go then the system will show the list of unverified accounts as shown in the below figure. 

Note that if any verificaiton is pending in DOP Finalce application then the system will not calculate the interest for such unverified accounts.So kindly verify immediately. 

MAHIPUR SO , GOLIVE TODAY 29.01.2016

Mahipur SO under CBS plat form since 29.01.2016 . Inagurated by Bikash Kumar Pradhan , Ganeshwar Sahoo,Bibhu Prasad Mishra & Kabiraj Nayak , special thanks to all the CBS Team Puri Division.It's another grand success to the Dept. Of Posts.

JAVA

CLICK HERE

FINANCLE PRINTER SETTING

CLICK HERE

CBS WORK FLOW

CLICK HERE

Working Functional Keys in DOP finacle

Working Functional Keys in DOP finacle

The Functional / Shortcut keys are available in the Finacle software which is developed by Infosys. But the modified version of Finacle in DOP is limited to access the shortcut keys.

Some of the working keys are listed below 

In Date Field while Press the Ctrl + X to Enter the BOD/Current date. This option may not work in some of the fields which is not configured with above shortcut.

DOP Finacle Menu for Refund TDS Amount of SCSS Account

1. Invoke HRFTDS menu
2. Enter Report To - PM
3. Enter Refund CIF ID - SCSS A/C CIF ID
4. Enter From A/C ID
5. To A/C ID will appear automatically
6. Select Tran. Type - Transfer
7. Click on GO(F4)
8. Select the concerned month.
9. Click on Add each time for multiple months selection.
10. Enter Refund A/C ID for each selection

a) SOLID+0340 for cheque
b) Customer's SB A/C ID for SB Transfer

11.Click on SUBMIT(F10)

SQL PRIMARY KEY

SQL PRIMARY KEY Constraint on CREATE TABLE

The following SQL creates a PRIMARY KEY on the "P_Id" column when the "Persons" table is created:

MySQL:

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
PRIMARY KEY (P_Id)
)

SQL Server / Oracle / MS Access:

CREATE TABLE Persons
(
P_Id int NOT NULL PRIMARY KEY,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)

To allow naming of a PRIMARY KEY constraint, and for defining a PRIMARY KEY constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)

Note: In the example above there is only ONE PRIMARY KEY (pk_PersonID). However, the VALUE of the primary key is made up of TWO COLUMNS (P_Id + LastName).

---

SQL PRIMARY KEY Constraint on ALTER TABLE

To create a PRIMARY KEY constraint on the "P_Id" column when the table is already created, use the following SQL:

MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Persons
ADD PRIMARY KEY (P_Id)

To allow naming of a PRIMARY KEY constraint, and for defining a PRIMARY KEY constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Persons
ADD CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)

Note: If you use the ALTER TABLE statement to add a primary key, the primary key column(s) must already have been declared to not contain NULL values (when the table was first created).

---

To DROP a PRIMARY KEY Constraint

To drop a PRIMARY KEY constraint, use the following SQL:

MySQL:

ALTER TABLE Persons
DROP PRIMARY KEY

SQL Server / Oracle / MS Access:

ALTER TABLE Persons
DROP CONSTRAINT pk_PersonID

SQL CREATE TABLE Syntax

The SQL CREATE TABLE Statement

The CREATE TABLE statement is used to create a table in a database.

Tables are organized into rows and columns; and each table must have a name.

SQL CREATE TABLE Syntax

CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);

The column_name parameters specify the names of the columns of the table.

The data_type parameter specifies what type of data the column can hold (e.g. varchar, integer, decimal, date, etc.).

The size parameter specifies the maximum length of the column of the table.

Tip: For an overview of the data types available in MS Access, MySQL, and SQL Server, go to our complete Data Types Reference.

The SQL SELECT TOP Clause

The SQL SELECT TOP Clause

The SELECT TOP clause is used to specify the number of records to return.

The SELECT TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on performance.

Note: Not all database systems support the SELECT TOP clause.

SQL Server / MS Access Syntax

SELECT TOP number|percent column_name(s)
FROM table_name;

SQL DELETE STATEMENT

The SQL DELETE Statement

The DELETE statement is used to delete rows in a table.

SQL DELETE Syntax

DELETE FROM table_name
WHERE some_column=some_value;

SQL UPDATE STATEMENT

The SQL UPDATE Statement

The UPDATE statement is used to update existing records in a table.

SQL UPDATE Syntax

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

insert into in SQL

The SQL INSERT INTO Statement

The INSERT INTO statement is used to insert new records in a table.

SQL INSERT INTO Syntax

It is possible to write the INSERT INTO statement in two forms.

The first form does not specify the column names where the data will be inserted, only their values:

INSERT INTO table_name
VALUES (value1,value2,value3,...);

The second form specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);