Sunday, October 11, 2015

ACCOUNT FREEZE (HAFSM) IN DOP FINACLE

HAFSM is command is used for Account Freeze in case of Death / Pledge / Court Order. HAFSM stands for A/c Freeze status Maintenance 
Menu Shortcut - HAFSM - A/c Freeze status Maintenance 

Follow The Below Procedure 

In Operator

A/C ID - Account ID
Freeze Code - Total Freeze
Freeze Reason Code - Select from Searcher
GO
Submit

Login as supervisor

Menu Shortcut - HAFSM
Function - V-Verify
A/c ID - 
GO
Submit

Wednesday, October 7, 2015

SIFY Helpdesk Contact Details

SIFY Help Desk Contact Details

Sify is network integration partner of India Post. The look after of  network is facilitated by Sify. If there is any problem related to network. Any Post office can contact to Sify through telephonic, web portal or email. The detail of both telephone no., web portal & email are given below.

PHONE/TELEPHONIC

Phone No : UAN – 1860-345-8888
Phone No : 044-22540985 ( CHENNAI)
Phone No : 022-26100113 ( MUMBAI )

COMPLAINT WEB PORTAL

Site : http://servicedesk.indiapost.gov.in:8080
Site : http://172.16.5.16:8080/CAisd/pdmweb.exe (In Active Directory)
Helpdesk Email To: dop.helpdesk@sifycorp.com CC: helpdeskcept@indiapost.gov.in.
 
THANKS TO : POTOOLS.BLOGSPOT.COM
 
 

Tuesday, August 18, 2015


Aug 18, 2015

Print Point of Sale Receipt in Dot matrix printer via USB

Meghdoot Millennium Print Via USB 

  • To enable USB Printing for Meghdoot Applications. follow the below steps
  1. Install DMP Printer with USB Port.
  2. Right Click on Required Printer then select Port Tab
  3. Click on Enable printer pooling, then click yes for prompt window.
  4. Select LPT1 and click on Apply/OK.
  5. Your printer is configured with usb port.
  6. Then Just Share the Printer(This is very important. USB printing from Meghdoot softwares supports only if the printer is shared).
  7. After sharing Just logout form Meghdoot Modules then relogin and print the reports.

Print Meghdoot Reports/Receipts via USB Port

  • Share the Printer name( in the Printer attached System)
  • Open Notepad Copy and paste Below Command, save as USBPrint.bat
NET USE LPT1: \\SYSTEMNAME\SHARENAME /PERSISTENT:YES
Add the ( USBPrint.bat )Batch file into Windows startup menu in the All PC including Printer attached system
Ex:NET USE LPT1: \\DOP\EPSON
USB Printer does not support Point of sale Submit Account . Default port configured as LPT in POS software itself.

Friday, July 17, 2015


Windows 2003 share issue solution
This document has been created to address the client-server communication issue currently being faced in the post offices. System Administrator has to follow this to overcome the issue.
  1. Update the latest security patches on Windows 2003 servers

We have observed that the security patches are mostly missing from the system. Follow the steps below to update the security patches.
To update a Critical Operating systems patches, Please follow below process.
  1. Check Sufficient free disk space available in C:\ for patch installation
  2. Open the Internet Explorer Browser
  3. Click on Tools Option
  4. Click on Windows Update option
  1. Select Custom Option for patch selection
  2. Select Windows 2003 server patches only (.Net patches and IE are optional)
  1. Installed selected patches
  2. Restart the Server
  3. Check the installed patches in ‘Add Remove programs’
  1. Create a user and set complex passwords to all users

It has been observed that most of the servers are having simple or blank password set for Administrator user. Create a normal user in Local Active Directory \ User Management console
  1. Set Complex password ( Inclusive of minimum 8 character, Special character, numbers and Capital letter) to users created
  2. Set the complex password of Administrator user
  3. Remember the password set to all user ID’s
  1. Remove open shares and limit sharing access to restricted users

After installation of OS security patches and creation of user ID, there is a need to restrict the open shares.Follow the below steps to restrict the open shares
  1. Right click on My computer icon present on desktop
  2. Click on Manage Option
  3. Expand Shared Folders option
  4. Click on Shares option
  5. Go to Security tab
  6. Go To Advance
  1. Remove Allow inheritance from the parents
  1. Remove permission to Everyone and Users group and keep below users in security permission
    1. SYSTEM
    2. CREATOR OWNER
    3. Administrators
  1. Add new created user in security permission
  1. Assign a full control new user and click on ‘Apply’ &‘Ok’
  1. Apply the same security permissions to all Shared folders, Except ‘Sysvol’ & ‘Netlogon’
  1. Map the Shared Folder on client side with restricted user access

After restricting the security permission on shared folders in server, we need to perform remapping of these folders for all clients with restricted user access.
Please follow below process to map the restricted shares at client.
  1. Open ‘Windows Explorer’ > Go To Tool> Click on ‘Map Network drive’
  2. Choose a Drive letter and Provide a network path of folder from server
  3. Check the box ‘Reconnect at Logon’ and Click on ‘Connect using Different user name’
  1. Provide a user name and password of newly created users (Domainname\username)
  1. Click on ‘OK’ , ‘Finish’ and check for mapped drive in Windows explorer
  1. After completion of Drive mapping, Check the application functionality of shared drives (e.g. Speednet, Point of Sale)

Friday, July 10, 2015

McCamish Settings

All McCamish Settings available at One Place like Printer Settings, Desktop Setting, Creation of Account Head in Treasury and Point of Sale

Desktop Settings

Printer Settings

Creation Of Account Head

(Give the date in "DDMMYY" format, Like, "010515" for the date 01-05-2015)

(This exe will create the head in transaction Master. So Add the PLI-RPLI transaction in POS >> Treasury >> Add Transaction) 

Internet Explorer 8 

Internet Explorer 8.0 (For Windows XP

Friday, May 15, 2015

May 14, 2015

RECOVER SUSPECTED SQL DATABASE USING QUERY

SQL Suspected Database Recovery

exec sp_configure 'allow updates',1
above run in master 
reconfigure with override 
above run in master 
begin tran update master..sysdatabases set status=32768 where name='post'
if @@rowcount = 1
begin commit tran raiserror('emergency mode set',0,1)
end
else
begin rollback raiserror('unable',16,1)
end
dbcc rebuild_log('post','d:\post.log')
 above run in master

CERTIFICATES DISCHARGE ERROR IN DOP FINACLE

  • When we close the KVP or NSC certificate then we will face the error " A/C balance is not equal to Repayment account" 
  • This error usually we face when we try to discharge the certificates by using the bulk closure option i.e., CNSBCV. 
  • This is a technical error this should be handled at the back end by the Help Desk team. 
  • The error can be viewed in HPR(PRint Report) menu as shown in the below figure 
Raise the ticket for the above problematic accounts with the Infosys HD(Help Desk) team.

Solution For The Above Problem:-

Infosys HD team will correct the balance and then they will inform to execute the command HUHNU (This menu is accessible to CEPT team only. 
  1. CEPT team will run the command HUHNU for the problematic accounts. 
  2. Then after this step user can discharge the certificate and verify in the supervisor.

THANKS TO:  POTOOLS.BLOGSPOT.COM

Monday, May 11, 2015


T. F. DEONAR POST OFFICE 
CBS GO LIVE -  11.05.2015 








DIFFERENCE IN PROCESS: SANCHAY POST AND CBS FINACLE – MAJOR ISSUES


Issues
Process in Sanchay Post
Process in Finacle
1. A/c Open
A/c opening with CIF
No Customer Information File (CIF) concept in Sanchay Post.
CIF has to be created for every depositor. On migration, CIF is created for each depositor or guardian
Funding of accounts
Deposit is accepted at the time of A/c opening and purchase of certificates.
Deposit is called Funding. Account can be funded either at the time of opening or after opening.
2. Cash Certificate
Issue of certificate
1. Certificates are issued against new registration No.
2. On issue of certificate stock is reduced & certificate No. comes.


1. On migration, account is created for each certificate. One account is opened against each certificate. Under one Registration No. 25 A/cs (certificates) can be opened / issued.

2. Stock is linked to printing of certificate. User has to invoke the menu of printing a certificate to issue certificate & get certificate Number. Then the stock gets reduced.

Certificate transfer / Name change
For Certificate transfer from one person to another or single to joint or joint to single, old certificate is to be discharged and new certificate is to be issued.
CIF is to be created for new depositor and then CIF of earlier depositor is to be suspended. New CIF is to be attached to the existing certificate. On the physical certificate, name of old customer is to be rounded and new customer to be added. In case of single to joint, name of new customer is to be added on the existing certificate.

NC4a issue
If certificates are not in stock, NC4a receipt is issued from Sanchay Post and amount is accounted against certificate issue. Later, certificates are issued on receipt of stock against this NC4a receipt.
Receipt from NC4(a) has to be issued indicating denominations selected in A/c opening (denomination selected cannot be changed later). An account is opened against each certificate and Counter PA has to enter the NC4(a) receipt number in the relevant field. On of stock, the Counter PA has to print certificates against account created under NC4(a).
3. Cheque Transaction
Cheque clearance
Cheques are entered against A/c Nos. and for new A/cs marking as New Account against A/c No. Lists are printed at SOs and sent to HO with cheques. In HO, cheques of SOs and HO are entered in Sanchay Post and combined list is handed over to Treasurer along with cheque for clearing. After clearance, HO Counter makes accounts of his own cheques, accounts for SO cheques as Part-II and sends intimation to SO under part-III for posting in SO ledger.
Cheque clearance is totally different from Sanchay Post. It has a full-fledged Cheque Clearing Module. Cheque for Savings A/cs, can be lodged/entered against the relevant account. Cheques for other schemes are to be lodged against specified Office Account.
Till CSI, comes, the cheque clearance will be handled by the Treasurer as earlier. Treasurer will be handed over two lists, i.e one of Sanchay Post and another of Finacle.Posting of cheques lodged in Finacle will be done in Finacle at HPO level.
When SOs will come in Finacle, there will be no need to send any intimation to SO for posting. In case of new accounts, SO can see the credit happen in Office Account of HO and can open and fund/make deposit in account from the office account putting date of credit as value date.
Once CSI comes, the clearing house activities will be handled by Treasurer by using Finacle CBS cheque clearing module.
Account opening through cheque
Account opened through cheques can be opened and credited by selecting the cheque details from the list of cheques cleared in Sanchay Post.
Cheques of other Banks cannot be lodged against the scheme or account number. These are to be lodged in Office A/c. On receipt of credit, the account can be funded /deposited by debiting/withdrawing amount from that Office A/c.
While opening new accounts, cheque details to be filled in Remarks field so that the same comes in remarks column of LOT.

Subsequent deposits through cheque in RD & PPF A/cs
These cheques can be lodged/entered against the RD and PPF accounts and on receipt of clearance, deposit can be given by just selecting the relevant cheque number from the list.
Cheques have to be lodged against designated Office Account and on clearance, each and every deposit is to be made in the relevant RD and PPF account by debiting relevant office account. There are chances of mistakes and the procedure is time consuming also.
4. Death Claim
Death Claim closure
The Counter PA has to enter date of death and all other calculations are done by the Sanchay Post system.
Different processes are followed for different death claim cases. CIF of the deceased has to be suspended.
In case, nominee or legal heir wants to continue account, his/her CIF has to be created and existing account has to be attached with new CIF.
All the nominees or legal heirs have to come together to claim amount as there is no provision to keep the amount in the account for the nominee or legal heir who does not claim along with other one.
5. Inventory
Inventory process
Inventory process is for local office and maintained for Cheque, KVP/NSC & Passbook with facility to enter invoice number details.
There is no provision for Passbook inventory. Process of inventory of certificates and cheque books is also different.
6. Office A/c
Maintenance of Office accounts
There is no concept of Office Accounts as it is based on Single Entry system.
It is based on Double Entry Accounting system. Every entry has two legs i.e Debit/withdrawal and Credit/Deposit. Many Office Accounts have been opened for taking care of the second leg of posting. LOTs are also printed based on the second leg of posting and General Ledger Balances/Scheme-wise Balances in an office are also created with the second leg of posting. Some of the Office Accounts are to be operated by Counter P.As and Supervisors and some are maintained by the System itself.
Many of these accounts have to be watched by SBCO or Postmaster or Division/Region/Circle/DAP Offices in the shape of reports.
7. RD
RD agent portal
There is a provision to attach RD Accounts with an identified MPKBY Agent and when agent presents List (LOT), amount of List can be accepted pending its posting. Amount of all such Lists are reflected in RD LOT and posting against pending LOTs can be done at a later date with date of presentation of List as date of deposit.
There is no provision to accept RD List (LOT) without posting at the counter. Once account is attached to the agent (migrated from Sanchay Post or opened in Finacle), deposit cannot be accepted at the counter in that account unless depositor gives in writing to cancel the attachment with agent.
For bulk acceptance of RD deposits from MPKBY Agents, an Agent Portal has been developed which can be accessed through DOP website using internet.
All MPKBY agents are allotted Login ID and Password to operate Agent Portal. On login into Agent Portal, all live RD accounts attached with the agent are visible to the agent. Agent can select the installment month and default fee or rebate will be calculated by the system. MPKBY Agent can prepare List (LOT)s in three different modes i.e cash with limit of Rs.10,000/-, by POSB Cheque and by other Bank Cheque. One MPKBY Agent list should contain maximum 50 A/cs.
System generates one reference number on the printed List (LOT). On presenting the list, Counter PA enters the reference number and compares the entries in the printed LOT and does the needful. System once again validates the entries and accepts the deposits. If any deposit is rejected, Counter PA can print the revised LOT and return the excess money to agent. Counter PA will save the transaction posted and then Supervisor has to validate the posting. In case of other Bank cheques, no posting is done until clearance of cheque. On credit receipt, the List can be accepted for posting by debiting that Office Account.
There is no provision to keep the posting of RD pending. Agent commission automatically gets credited into Agent’s Savings account after deducting the TDS. All entries of all agent LOTs will be printed in the Counter LOT. Therefore, it is advised that only one counter should be identified for accepting agent LOTs.
8. Savings A/cs
Savings /NSS /PPF A/c closure
Savings A/c closure, all calculations of closing interest are done by the software.
The balance is to be made Zero by withdrawal. Then closing interest to be viewed, if required to be calculated. Closing interest has to be seen by going through transaction details or by invoking print report. Supervisor while authorizing closure is not able to see any amount.
9. Specimen Signature
Shifting of signature scanning and other related work to CPC.
Signatures are scanned at the Post Office counter. There is no provision of signature scanning in SOSB and also no provision for photo scanning in Sanchay Post.
Earlier Process: ECMS document scanning and storage system was implemented. Counter PA has to take additional signatures on the perforated slip of new Account Opening Form (AOF) and paste the same in SS Book after tearing from AOF. AOF with KYC documents was sent to CPC daily. At CPC, AOF & KYC documents were matched and on acceptance, these were scanned in ECMS and uploaded into Finacle Core. The scanned images were available in ECMS and CBS Finacle both and any CBS post office is able to view. Photo and signature were separately stored & available in the shape of an icon called “SVS” for Finacle withdrawal and closure screens. Physical documents are sent back to concerned Post Office by CPC along with rejected documents showing the objection for rectification. Post Office will get the rectification done and resubmit the documents with AOF to CPC.
Process from 1st April 2015: New simplified 1 Page (back to back) Account Opening/Purchase of Certificates Application Form (AOF) is to be used. The new customer has also to fill (for one time), KYC Form in duplicate and put photo and signature on the same. AOF, KYC Form (one copy) and KYC documents (New / existing customer & returned from CPC) should be preserved at Post Offices in A4 size Ring Binder date-wise. One copy of “KYC Form” is to be sent to CPC for scanning. At CPC, photo and signatures are attached with CIF & account level. “KYC Form” received at CPC will be preserved at CPC.
10. Term Deposits
Payment of interest in MIS,TD, SCSS etc.

1. Interest is credited into the MIS/TD/SCSS Accounts and also paid from the A/cs.
2. Interest is credited to the customer’s Savings A/c on written request called Standing Instruction (SI) – Auto transfer.
3. Interest is paid for the day of account opening and not for the day of closure.
4. Rounding off was being done every quarter / month as the case may be, to the higher side of a rupee if interest is in 50 paisa or more.
5. Interest is calculated equally for every month.

1. Interest is not credited to the MIS/TD and SCSS A/cs. Interest of these accounts is calculated and credited into specific office Sundry A/cs. Interest is also has to be paid from the Sundry Account.
2. Interest is credited to customer’s Savings A/c on due date automatically on specifying the repayment A/c. It is desired that all such customers should be requested to open Savings A/c and link as repayment A/c.
3. Interest is not paid for the day of account opening and is paid for the day of closure. Total interest in both the cases will be same.
When account is opened in Sanchay Post and closed in Finacle, one day’s interest will be paid extra. Therefore, this extra interest is being deducted in Finacle during first payment after migration.
4. Finacle adjusts rounding off every quarter/month to restrict total interest to the actual rate of interest. Therefore, any extra interest already paid in Sanchay Post due to higher rounding off is also deducted during interest credit of first quarter/month after migration.
5. Interest is calculating on basis of number of days in a month from the date of opening of account. That is why the interest amount differs from month to month / quarter to quarter.
11. Transfer of A/c
Transfers between finacle and non finacle offices
There is a provision to transfer any account to any post office and it generates Advice of Transfer along with Transfer journals.
The account transfer in / out can be done among CBS post office only. There is no need to generate any AT or Transfer Journals or do the pairing. Only, the post office, after satisfying the genuineness of depositor, has to change the home SOL(post Office) of the account and account will be transferred on the spot. A report can be generated showing accounts transferred from one SOL to another in all CBS post offices. Only PPF & SCSS can be transferred between CBS & non-CBS Post Offices.

Courtesy: CPC & WTCs Odisha