Recap:

In the previous lesson we have learnt how to login in to finacle system. If you have not read the first 2 lessons please read them first and then start reading this lesson.

In today’s lesson we will learn about everything which we see on finacle screen.

Before we start today's lesson we have a request. Can someone translate our lessons into other languages? 

Languages like தமிழ், हिंदी, తెలుగు, മലയാളം, বাঙালি, मराठी, ગુજરાતી, etc.

Can someone help us in this task? We want to translate these lessons into our mother tongues so that all of us can easily understand. By translation we mean both translate and type in the corresponding language. If anyone is willing you can please contact us by sending an email to poupdatesblog@gmail.com. 

What are those things which we see on Finacle screen?

Before I say anything please see image below and we will discuss each item in detail.

In the picture I have labeled each item with a number. Let’s see each item in detail number wise.

1. Item no 1 shows today’s date. After you login into finacle, do not forget to check the date . It must show the date of current working day. But as you can see in the image the date is shown as 26/12/2013. I have taken the screenshot on 31/03/2016. This is because the day end of 26/12/2013 is not yet completed in my office. (Don’t worry my office is training center and we don’t do day end here). But in your office it must show today’s date only. If it is not showing current working date we should not do any transaction until Day end is completely over. Don’t worry I have only faced such situation only once when I was in counter. Very rare situation it is.

2. Item no 2 and item no 12 shows the details of user who is currently logged in. If you are logged in, it will show you user id. It is important to keep an eye on this field. In single hand offices the same user will be given Counter PA id and Supervisor ID. While doing transactions it is important to keep in mind that you should not do any transactions in Supervisor ID. If you do so then it may become difficult to verify those transactions. So keep an eye on the user name before clicking the submit button.

3. Item no 3 will show the SOL ID of the office in which you are currently working. Suppose if you go to a different office on deputation you have to inform your CPC to change your office. Otherwise all the transactions which you do in deputation office will be reflected in your parent office. That will create chaos. So please be careful when you are going to work in different offices.

4. Item no 4 shows the menu shortcut field. In this field you have to enter the menus to do various operations.

5. If you click on item no 5, item no 11 will appear on the screen. This menu list can be configured just like our Sanchay post so that you need not remember all the menus. But we do not recommend using item number 11. Please try to remember all the frequently used menus. 

6. Memo pad is just like reminder or alarm. Suppose if you want some information from certain customer then simply create a memo pad entry for the account number of the customer and finacle will alert you when that customer comes for a transaction to your office. (System will show an exception while doing the transaction that a memo pad entry for the account exists)

7. Background Menu is used for doing 2 transactions at a time. For example while opening any new account through POSB cheque if you forget to deposit the amount in SB, you can use background menu to deposit the amount without losing information you entered in account opening screen. 

8. CCY converter can be used to check currency rates. Since we are not dealing with any foreign exchange services we don’t need it at the moment.

9. Item no 9 is used to change your password. If you click on that key image a new screen will open where you can change your existing password.

10. Item no 10 is the logout button. If you click on it you will logout from finacle. Do not forget to logout before leaving your system or do not close the browser without logging out.

11. Item no 11 is a shortcut screen for all menus. It will appear on screen when you click on item no 5. But we strictly do not encourage these menu shortcut options.

12. Item no 13 shows the time zone in which we are presently working. Since Finacle is made for international customers. It can operate at various time zones. Here in India we will have our time zone as IST.

13. Item no 14 shows the welcome message on the screen.

14. Item no 15 shows the number of reports available in HPR menu. Delete those reports if you have already printed them.

15. Item no 16 is scrolling message. Sometimes some important messages are displayed in that scrolling. Like “Stop working and sleep because finacle wants to sleep” LOL. Just joking. It will show messages like “Today CCRC menu will not work”, “Complete day end by 0430pm” etc.

So this is the information about all the items which we see on the screen. It’s essential to know everything about Finacle.

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

I’m trying to keep lessons short because it will be easy to remember. It won’t take more than 5 minutes to read a lesson. I can compile all the lessons as a single book instead of short lessons of 5 minutes per day. But I bet nobody will read the book for more than 10 pages.

So we have decided to make lessons short so that it won’t take more than 5 minutes to read. Just spend 5 minutes daily, learn to use finacle and get rid of all the problems.

Point to remember in today’s lesson.

1. Always check the date on the screen. If it is not today’s date do not do any transaction.

2. Always check the currently logged in user. Do not do any transactions in supervisor login.

3. If you are going on deputation to other office make sure you request CPC to change your SOL. And after completion of deputation and coming back to home office again request CPC to change your SOL.

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;