Wednesday, May 20, 2015

Regularly used important day-to-day commands in Finacle



CIF MODULE

 

ACCOUNT MAINTENANCE
Search CIF
CDEDUP
 
A/c Lien Marking
HALM
Create CIF/Modify/Verify
(For New CIF)
CCRC
 
A/c Freezing
HAFSM
Modify / Verify
(For Existing CIF)
CMRC
 
Stop Payment of Chq
HSPP
Merger of CIF
HCCA
 
Verify SPP
HSPPAU
Customer 360◦ View
HCRV
 
Stop Payment Report
HSPRG
SB Module
 
Standing Instructions Add
HSSIM
Open Account
CASBAO
 
Inquire SI
HSSI
Verify Account
CASBAV
 
SI Report
HSIETR
Modify before verify
CASBAOM
 
SI Register
HSIRP
Modify after Verify
CASBAM
 
TD/MIS Module
Cash Transaction
CTM
 
POTD / MIS A/c Opening
CMISAOP
Transfer Transaction
CXFER
 
POTD/ MIS Verification
CMISAOPV
Passbook Print
HPBP
 
Modify Before Verify
CMISAOPM
A/c Ledger Inquiry
HACLI
 
Modify after Verification
CMISAM
A/c Balance Details
HACCBAL
 
TD A/c Extension
HTDREN
A/c Inquiry
HACCDET
 
Inquire Details of TD/MIS
TDINQ
Find New A/c from Old A/c Number
CNAC
 
Closure of MIS/TD
HCAACTD
Closing A/c
HCAAC
 
Verification of Closure
HCAACVTD
OFFICE ACCOUNTS
 
SCSS Module
CASH Transfer
HTM
 
SCSS A/c Opening
CSCAOP
Cash Reports
HFINRPT
 
Verification of A/c
CSCAOPV
Teller Cash Report
HSCWRPTA
 
Modification before Verify
CSCAOPM
Teller Cash Position
HTCPIAE
 
Modification after Verify
CSCAM
Cash Position (All Tellers)
HTCPIAC
 
Transfer to Exception Scheme
HACXFRSC
Office A/c Inquiry
HACLINQ
 
Closure of SCSS A/c
HCAACTD
Office A/c Ledger Extract
HACLPOA
 
Verification of Closure
HCAACVTD
INVENTORY MANAGEMENT
 
NSC/KVP
Inventory Movement
HIMC
 
Open Account
CSCOAAC
Split Inventory             (own location)
HISAI
 
Verification of A/c opening
CSCOAACV
Split Inventory             (Other’s location)
HISIA
 
Modify A/c before Verify
CSCAACM
Merge Inventory
(Own Location)
HIMAI
 
Modify A/c after Verify
CSCACM
Merge Inventory
(Other’s  Location)
HIMIA
 
Printing NSC
HDRP
Inventory Inquiry
HIIA
 
Reprint NSC
HREDRP
Issue of Cheque Book
HICHB
 
Closing Account
CSCCAAC
Cheque Book Inquiry
HICHBI
 
NC$A Report
HFINRPT
Find A/c id from Chq No
HINQACHQ
 
AGENT PORTAL
Inventory Report
HISRA
 
Agent Transactions
HAGTXP
Print Reports
HPR
 
Create DSA ID
HDSAMM
HPO to SPO SOL Change
HCCS
 
Agent Inquiry
HDSAIP
Outward Clearing Module (SPO)
 
Inward Clearing Module
Enter Instruments
HOMSO
 
Open Inward Clearing Zone
HMICZ
Verify Instruments
HOMSO
 
Upload Chq
HRMI
Report Generation
HOMSOEX
 
Edit/Enter Instruments
HICTMO
Outward Clearing Module (HPO)
 
Validation Run
HMICZ
Enter Instruments
HOMSO
 
Verify Chq
HICTMO
Verify Instruments
HOMSO
 
Validation/Suspend
Post/Close/Inquire
Inward Zone
HMICZ
Report Generation
HOMSOEX
 
Inquiry of Lodged Cheque
HIOCLS
 
ECS Module

Open Zone

HMCLZOH

 

ECS Mandate Maintenance

HECSM

Upload File Generation

HOMSOEX

 

Create ECS Dump

HEGOC

Clearing File Upload

HCLUPLD

 

Settlement Process Run

HEOSR

Instruments Entry

HOCTMO

 

ECS Reject Processing

HEORP

Suspend Zone

HMCLZOH

 

Other Important Menus

Verify Instruments

HOCTV

 

Transfer of A/c to CBS PO

HACXFSOL

Release to Shadow

HMCLZOH

 

Transfer of A/c to Exceptional Schemes

HACXFRSC

Mark Pending

HMARKPEN

 

Financial Tran Inquiry

HFTI

Revoke Pending

HREVPEND

 

Financial Tran Report

HFTR

Regularise Zone

HMCLZOH

 

Audit File Inquiry

HAFI

 
RD Module
Open RD A/c
CRDOAAC
Verify RD A/c Opening
CRDOAACV
Modify before Verify
CRDOAACM
Modify after Verify
CRDACM
Printing RD Passbook
HPBP
Pending Instalment Inq
HPLIST
Funding RD
CRDP
Manually Extend RD
PRDCM
Close RD A/c
CRDCAAC
PPF Module
PPF A/c Opening
CPPFAO
Verification
CPPFAV
Modify before Verify
CPPFAOM
Funding of PPF
CPDTM
Withdrawal of PPF
CPWTM
Extend PPF
HCEXTN
Closure of PPF
HCAAC
Loan on RD
RD Loan A/c Opening
CAOLARD
Verification
CAOVLARD
Modify Before Verification
CAOMLARD
Modify After Verification
CACMLARD
RD Disbursal
LARDD
RD Loan Repayment
HLAUPAY
RD Loan
HPAYOFF
RD Loan Closure
CAACLA
Loan on PPF
Loan A/c Opening
CLPPFAO
Verification of PPF Loan
CLPPFAOV
Modify before Verify
CLPPFAOM
PPF Loan Disbursal
CPWTM
PPF Loan Repayment
CPDTM
PPF Loan Int. Run
HACINT
PPF Loan Process
CLPR
Closure of PPF Loan
HCAAC
Out Station Cheque (OSC) Module
OSC Maintenance (Lodge/
Verify/Realize/Dishonour)
HIRM
OSC Report
HINWREMI
Memo pad Lookup
HMEMOPAD
Memo pad Verification
HMPAU
Transfer File to PC
HTRFTOPC
Chq book issue Report
HCHBIR
Customer A/c Ledger Print
HACLPCA
Interest Table Inquiry
HINTTI
Int. Table Maintenance
HINTTM

 

























































 

Friday, May 8, 2015

USEFUL TIPS FOR FINACLE OPERATIONS IN DOP FINACLE APPLICATION


1. New A/c No. from Old A/c No. CNAC – SOL ID+scheme+Old A/c No.

2. A/cs linked to MPKBY agent. HDSAMM

3. Commission paid to agents. HFINRPT . HPR . Report 2 to 5 as per requirement.


4. TDS deducted from Agents. HFINRPT . HPR . Report 2 & 3 as per requirement.


5. New A/c No. (any scheme) not noted


HAFI .SOLID: Default SOLID . Ref. No.: Enter one or two spaces. Table Short Name: GAM .
General Ledger Subhead Code: as under . Authorize: Select the radio button 'Not Authorized.
Function Code: A (ADD i.e new Accounts opened): M (modified accounts) : Z (Closed A/cs) 
Following Are The GL Heads:


SB - 30001,PPF- 33001, NSS87 -30021, NSS92 -30022, SSA- 30042, MIS- 30016, NSC 10 year-
32003, NSC 5 year- 32001, RD- 30010, KVP- 32027, TD -30011.


6. New PPF Loan A/c No. not noted. Suffix 1 to the original A/c.


7. New RD Loan A/c No. not noted. Suffix 1 to the original A/c.


8. Denomination & Serial No. of KVP/NSC issued to a Regd. No. CSCACM / NSCAM


9. KVP / NSC pledged. HACLI or HACLITD or HAFSM- Freeze A/c inquire


10. Inventory Transaction ID not noted OR which Inventory not authorized. HIMR . HPR or HIMI.
date. Go.find the Trans Enter but not authorized.


11. Transaction ID of deposit / withdrawal not noted


HACLI . A/c ID . Click on transaction date, details will be displayed. OR Use HFTI


12. Not noted Transaction ID of Salary / Pension uploaded

HACLI . A/c ID . Click on transaction date, details will be displayed.

13. Standing Instruction Serial No. note noted.

HSSII . Click on Serial No. Searcher & give A/c ID . Serial No. will be displayed.

14. Forget the instrument No. of HACXFSOL transaction (Inter SOL transaction)


Invoke HAFI . SOL ID . Enter the table name as ATT. Enter the Teller User ID in 'Entered by' 
field. Enter the Trans Date in 'Entered on' field. GO. 


This will list the instruction / instrument number.

15. Forget the instrument No. while converting: HACXFRSC (Exceptional transfer).

Invoke HAFI . SOL ID . Enter the table name as SCT. Enter the Teller User ID in 'Entered by'
field. Enter the Trans date in 'Entered on' field. GO

This will list the instruction number.

16. How to get A/c No. from POSB CQ. HINQACHQ (Supervisor menu)

17. Extension of PPF a/c: HCEXTN

18. Extension of SSCS a/c: HTDREN

19. How to view / print the ledger card of any A/c for a given range of date. HACLPOA

20. How to know an A/c has lien. HACCBAL

21. Ledger View of SCSS/MIS: HFTI.A/c ID.SOL ID + respective sundry a/c ID. in Ref. column give
respective original a/c ID.keep the start date blank.then GO

22. Find the before migration transactions details of any a/c: TIPM

23. How to fetch the interest of MIS/SCSS/TD through HTM when the exact amount in not known :
In the second part trans screen. do not enter any value in the Start Amt / End amt. fields (it
should be blank).give the a/c ID at Ref column and select the filter option as "select" and then submit.

Source : http://pofinacleguide.blogspot.in/

Wednesday, May 6, 2015

Post AD Migration Issues And Solution


Post AD Migration Issues And Solution

at the time of AD Migration we have to change the SQL Server Name. So that  we have to configure server name in all the DOP Softwares and SQL Server.

Issues 1
·         RPC error while Submit Point of Sale account.
·         MSDTC Services not Running
Solution
·         Go to Services (Control Panel > Administrative Tools >Services ) / Run > Services.msc
·         Start the service 'Distributed Transaction Coordinator' (MSDTC) with start up type as 'Automatic' and Log On As 'Network Service' 
Execute RPC Query at Once

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true' exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'

Note:  Replace 'myserver' with your servername in the above query.

Issues 2
POS booked articles not fetching in speednet module after changing the server name or formatting the server in SQL 2005 / 2008
Solution 1 : 
Run these two queries in SQL query analyzer one by one
sp_configure 'show advanced options',1
go
reconfigure
Then Execute
sp_configure 'Ad Hoc Distributed Queries',1
go
reconfigure
Solution 2
Right click on server name in SQL management studio->facets-> surface area configuration.
Set true to Ad hoc remote queries.



Courtesy : http://potools.blogspot.in/

PREPARATION FOR MOCK MIGRATION / GO LIVE UPDATED 01.05.2015



Preparation For Mock Migration


View / Download Latest Mock Document  Download


Preparation For Go-Live

Courtesy : http://potools.blogspot.in/