Dec 20, 2014

Meghdoot (MM 7.9.2) Update for SOs


Meghdoot 7.9.2 fo Sub Office Update

Download Meghdoot Update 7.9.2 for SO from PoTools. This version is not applicable for Head Offices.

Download SO Update 7.9.2

Size : 30MB
Host : Google Drive
Thanks to Silambarasan DSM

Meghdoot 7.9.2 Released by CEPT on 20.12.2014


MM 7.9.2 Released by CEPT

All the Modules were revised by CEPT and Released on 20.12.2014. Software Fully tested around 5 circles without any issues.

Direct Download Link from FTP

MM 7.9.2

Parcel Net 1.1


Note: If any error found while upgrade database, kindly raise the ticket with CEPT for Solution.

Dec 19, 2014

CBS Migration Document Updated on 17.12.2014


View / Download Updated Document 17.12.2014

CBS Live



Tool to Configure Holidays 2015 by PoTools

  • Click on Sql Configuration to enter Server Details.
  • Using Admin Login you can Also Create new database for your circle.
  • View list is used to check your Circle Holiday List 2015

Holiday List 2015 Configured in

  • Point Of Sale, Sub Account, Sanchay Post.
  • Developed by Admin, PoTools.


  • Configure holidays 2014 in Three Modules with one click.
  1. Point Of Sale.
  2. Sub Accounts.
  3. Sanchay Post.
No Need to Configure Weekly holidays separately.


Andra Pradesh


Odisha Revised 18.12.2014 11:00AM


Tamil Nadu Revised




West Bengal


Note: Just Verify Holiday List of your circle using View List Menu.

Dec 18, 2014

Release Document of Meghdoot v7.9.2 and Parcel Net v1.1 and Check List


Release Document and Check list of Meghdoot 7.9.2

Release Order 

After successful completion of testing, the software is now ready for deployment. lt is proposed to release the new software on 20-12-2014.

Release Document for MM and Parcel Net

Check List for System Administrator : 

Meghdoot version 7.9.2 

Parcel Net v1.1

Major Modification in Software

Download / View Annexure 

Download All the above Documents using below link

Procedure to Change name of depositor in Finacle : India Post


Procedure for changing the name in Account details 

In case of name change, use menu:



A customer has changed the name in Gazette and wants to change the name in all the accounts.
1.    Invoke the menu CMRC and select the function MODIFY
  • Change the required Last name, Preferred name and short name
  • Click on Submit

2.    Verify the modified details using CMRC menu

3.    The Name change done in CIF will not get effected in Account level as this CIF has already been linked.

4.    Now to correct the name in account details, invoke the menu HAALM from operator
  • Select the function MODIFY
  • Enter the account number wherein the name change has to be done
  • Click on GO

5.    The old account details will be displayed

6.    Required name to be changed in A/c Name and A/c Short name fields

7.    An exception will be thrown, click on Accept

8.    Verify the same using HAALM in Supervisor login

9.    An exception error will be thrown. Click on Accept

Name has been changed successfully in the PPF account

New Features of Meghdoot 7.9.2 Update


Meghdoot 7.9.2 New features

The following new features are incorporated in Meghdoot 7.9.2.

1) Provision for doing Sale of Philately Stamps (Point of Sale module)
2) Provision for capturing the mobile number of the Addressees of a Speed Post, Registered, Parcel, Flat Rate box and eVP articles (Point of Sale module)
3) Provision for doing AirMail - Bulk Bag booking (Point of Sale module)
4) Provision for doing SAL - Bulk Bag booking (Point of Sale module)
5) Barcode series starting with ‘”R” has been made mandatory while booking the following types of foreign (Airmail, Seamail, SAL) articles. For these kind of articles, the Parcel series barcode is prescribed earlier (Point of Sale module).
6) Closing of foreign Registered Packets (booked with R series barcodes) in Parcel Bag and allowing them to be dispatched to Parcel Hubs (Despatch module)
7) Provision for deletion of old Special Journal booking data (Despatch module)
8) Provision for capturing the Addressee mobile number for the articles booked through Special Journal option (Despatch module)
9) Advance Customer Facility for Parcels (BNPL Parcel module)
10) Expansion of Express Parcel service throughout the country (BNPL Parcel module)
11) Provision at Head Post Offices to capture the details of COD parcels delivered at non ePayment SOs (Postman module)
12) New report showing the status of each COD Parcel pending at the delivery Post Office (Postman module).
13) Transmission of article receipt (registered letters and parcels) event to the Server so as to bring accuracy in Tracking even though dummy bag barcodes are used Office (Postman module).
14) Separate Head of account for Philately Stamps (Treasury module)
15) Accounting for Philately Stamps sale separately in HO Accounts and also in AccountsMIS Reports (Treasury module and AccountsMIS module)
16) Implementation of new Income Tax Slabs (Accounts module).
17) Generation of Cash Book File from each Head Post Office and transmission of the same to CEPT for further processing and onward transmission to DA(P) concerned (Accounts, AccountsMIS modules).
18) New option for exporting the pension data to csv file (AccountsPBS module). 

Dec 17, 2014

Send your Circle Holiday List to Develop a New Tool

Dear Friends,
                    Kindly Send your Circle Holiday List to to develop a Holiday Configuration Tool.

I Plan to Publish Holiday Configuration Tool for all Circle Configuration, So kindle co-operate me to develop a this Tool.

Kindly submit in Excel Format if possible to easy access

Thank you so much

SBCO - CBS Utility Updated on 16/12/2014


SBCO CBS Utility Updated 16.12.2014

New features :

1. for CBS offices we can enter the Total Deposit / Withdrawal / Debit / credit amount as single entry. ( Use Account No 1 for all transactions 
2. To find Total No of Accounts
3. Reports to find Accounts which are inactive for more than year 


  • Starting & Ending Account not necessary ( Zero is enough )
  • Cut off date top RD ( DLT) = 01/01/1999 or 01/01/2004
Password : RAJA

SBCO CBS Utility Updated on 16/12/2014


Download the CBS.EXE and paste into existing C:\CBS\ folder

Download and extract the CBS.ZIP and paste in to you local hard Disk C:\ or any other drive and run the software thro CBS.BAT file

This is useful for this purposes

1. To view / Print list of Minus balance

2. Change the Account Status into CLS / TFR

3. Close all "0" Balance Account

4. Simple OB correction

5. To view / Print Closed account with Balance

6. To change the Account Status into Closed / TFR

7. To change all Minus into 0 balance by OB Corrections

8. To view / Print the Closed / Transferred Account Details

9. To Modify Transactions for a particular Period ( From - To Date )

10. Statistical Report , Quarterly Report, etc

( Copy stt_ext.dbf & hpo_det.dbf already available in c:\sbco\sb\ into c:\cbs\ folder )

  • for CBS offices we can enter the Total Deposit / Withdrawal / Debit / credit amount as single entry. ( Use Account No 1 for all transactions
To find Total No of Accounts

Password : RAJA

Download : ( Updated on 16/12/2014 )

If any suggestions, please mail to

Tool for ePayment Transaction Report Viewer Revised


Tool for ePayment Transaction Billerwise

Total Number of Bills and total Amount will fetch from eCounter database using this tool.

Bug Fixed:

  • ePayment Transaction of Only Booked Transaction not cancelled transaction.
  • Exception from Symantec Antivirus deletion
Biller ID and Descriptions also view using this Tool.

Download ePayment Report Viewer Revised

Release of Meghdoot v7.9.2 and Parcelnet v1.1


Release of Meghdoot software v7.9.2 & Parcelnet v1.1

  • Meghdoot Software version Update 7.9.2
  • Parcel Net Version 1.1
Release Date : 20.12.2014
Director CEPT on updates on Meghdoot and Parcel Net proposed to be released on 20.12.2014 along with release documents.

Major Modification Related to:

  1. Updation of COD Articles - Postman, Despatch and Point of Sale, R Net
  2. ePayment Client
  3. BNPL Parcel Software.

Download Meghdoot 7.9.2 and Parcel Net 1.1

Register with PoTools Option is Re-Enabled


User Registration Option : PoTools

Last few weeks, Register with PoTools option was not able to access due to non upgraduation of Google drive Spread sheet document. Now it  had been migrated with Newer version of Spread Sheet.
Register with PoTools option Restored. Just Ignore if you are already registered.

Register User using Below Link

Note : Never Register Once again if you already register with PoTools.

Current year calculation for SBA accounts : Finacle


Current year calculation for SBA accounts

  • If we want to know the CYI(Current Year Interest) for SBA accounts(SB,PPF and NSS account) we can view the same in the menu HACCDET
  • If we are trying to close the SBA accounts(SB,PPF and NSS account) in Fiancle application, at the counter level the counter PA don't know the amount of interest(CYI) at the time of closure of SBA accounts.
  • After verification of SBA accounts closure only the counter PA will know the CYI by invoking the ledger inquiry(by using HACLI) for SBA accounts.
  • In order to view the CYI for SBA accounts the counter PA before closing the SBA accounts he can view the CYI by using the menu HACCDET.

HACCDET:- Stands for General Details of Account

  • Invoke the menu HACCDET enter the account number and click on GO as shown

  • Then the system will show the no of details such as
  1. CYI(Current Interest Year) of the SBA account.
  2. CIF id of the customer.
  3. Scheme code of the code
  4. Account status.
  5. Mode of operation.
  6. Total balance in the customer account as shown in the below figure

So make a practice to invoke the menu HACCDET to know the current year interest for SBA accounts before trying to close the account. 
Thanks to :

Dec 16, 2014

Sanchay Post Database Upgrade Patches from Version 6.5


Sanchay Post Database Up-gradation

Sanchay Post Patches for database up-gradation 

Download Patches for Upgrade DB Version from 6.5 to 7.5

KVP Patches and SP5 Folder

Thanks Rajesh H

Old Premigration Tool for SCS Discripancies


Old Premigration Tool for Clear SCSS Discrepancies

  • SCSS Ledger Remarks having Null in Remarks discrepancies
  • To clear SCS Null Discrepancies,
  1. Download attached Pre Migration Tool 
  2. Execute Once from backup Server 



Thanks to Rajesh H

Speed Net : BNPL Customer Configuration and Booking


BNPL Bulk Customer Configuration

  • Login as Supervisor in Speed net

  • Under BNPL menu select "Customer Details" option.

  • Now you will get the following Screen. 

Here fill up all details such as Name of the Company, Address, Account Number and Article type etc.

See the following screen for demo.

  • After completion of feeding Customer details, click on " Agreement " button.

Then you get the following screen, in that enter details such as Memo number , Bill raising office, Agreement date , Expected Business per month and Guarantee amount.

Note: Guarantee amount must be 4 times to Expected Business.
  • Now click on " Save" button.
  • Then you will get the following message box

  • Here click on "Yes" button.( If any corrections click on "NO")
  • Again you will get a Confirmation Message box. In that click on "Yes" button.

After this stage you should use "Flush data" option. if not Customer (details) will not appear while booking.

Precautions to be followed while Opening an account in DOP Finacle



The following observations I have while opening an account in Finacle.I want to share with you which will be really handy when we are in a real scenario.The following that can't be changed after opening an account by the counter PA but even before verification by the supervisor.They are as follows:-

  • CIF id can't be changed.
  • Amount can't be changed.
  • Agent can't be selected.
  • Value date can't be changed.
  • Agent can't be modified.


CIF id once entered at the time opening an account will not be changed even we invoke the respective modification before verification menu.

If any problem persists then we need to merge the CIF id and change the name of the account at the account level by using the menu HAALM (supervisor menu).


The deposit amount once entered will not be changed even in modification before verification menu also we can't change the deposit amount.

The only solution for this is make an error entry and close the account as "Exceptional Closure" after obtaining the approval only.

Again open the account with the correct deposit amount.


When the counter PA opened an account without selecting the agent then even we invoke the menu modification before verification then the system will not allow.

The only solution for this is make an error entry and close the account as "Exceptional Closure" after obtaining the approval only.

Again open the account by selecting the agent.


When the counter PA opened an account by selecting the wrong agent and even we try modification before verification then the system will not allow to modify.

The only solution for this is make an error entry and close the account as "Exceptional Closure" after obtaining the approval only.

Also in the above closed account the counter PA selected the wrong agent so commission will be credited to wrong agent so reverse it for reversal procedure click here.

Again open the account with the correct agent.


When the counter PA opened an account with wrong Value date and even we try modification before verification then the system will not allow to modify.

The only solution for this is make an error entry and close the account as "Exceptional Closure" after obtaining the approval only.

If the above closed account is linked to agent the commission will be credited to agent SB account so we have to reverse it for reversing procedure click here.

Again open the account with the correct value date.

The above scenarios are very important when we are opening an account in real scenario so the counter PA should be very careful to avoid mistakes.Note that without error entry and approval don't close any account for the above said scenarios.
Thanks to

Dec 15, 2014

Not able to Open New Account in TD Data Entry Module


Problem with TD Data Entry v7.5 Patch 8.1

After Update Patch 5 or Patch 6 or Patch 8 or Patch 8.1
  • Not able to Open New Account.
  • Could not click on Amount field.

Solution : TD Data Entry

In Sanchay Post 7.5 after service pack 1 update we are unable to access TD Data entry.

  • Use Data Entry Module alone in Sanchay Post 7.5
Note: This is only for TD Data Entry


SQL 2000 / 2005 / 2008 Management Studio Shortcut Keys


Run SQL window - shortcut keys

The following shortcut keys are active in the Run SQL window:
Ctrl + A
select all
Ctrl + B
change list-box position
Ctrl + C
Ctrl + D
clear text
Ctrl + E
Edit SQL using editor
Ctrl + F
Ctrl + G
show/hide data grid
Ctrl + H
view SQL history
Ctrl + I
go to line
Ctrl + L
lower case
Ctrl + M
capitalize text
Ctrl + N
open another SQL window
Ctrl + O
open query
Ctrl + P
print SQL
Ctrl + R
Ctrl + S
save query
Ctrl + T
switch to another table
Ctrl + U
upper case
Ctrl + V
Ctrl + X
Ctrl + W
line wrap
Ctrl + Y
Ctrl + Z
Ctrl + F5
go to results window
Ctrl + F7
export to table
Ctrl + F11
comment text
Ctrl + F12
uncomment text
Ctrl + Shift + F5
search table
build column list for query table
select current statement
run SQL
check syntax
export data
explain SQL
display query table
find matching bracket
Shift + F2
toggle bookmark
Shift + F3
next bookmark
Shift + F4
previous bookmark
Shift + F12
select to matching bracket
Shift + Delete
Shift + Insert



Follow the procedure as explained below to get prompt service.

  1. Download Form SB 10(b)
  2. Fill up the form in duplicate and submit it along with your original Post Office PPF Pass book, PAN card copy, your bank savings account Passbook along with a written request on a plain paper requesting your transfer of PPF account to the bank to the Post Master.
  3. Show the Instructions on PPF account given in the Post Office Passbook in case the post master claims that the transfer is not possible. (Usually at the first instance they will tell like that)
  4. Wait for minimum 10 days and enquire with the post office weather they transfered the PPF account to the bank.
  5. They will close the account making all the entries in passbook up-to-date. The interest upto 31st March of previous year will be added. They all the original documents available with them pertaining to your account to the bank which includes Passbook, original account opening application card, specimen signature, photo, a statement of all your transaction from the beginning along with a demand draft or cheque for the amount on closing the account.
  6. NOTE: The interest from the 1st April upto the date of closing will not be added to the cheque or draft nor be calculated by the post office. It has to be done by the bank and added to your account on 31st March of the current financial year.
  7. Usually bank will call you on receiving all the documents. But dont wait for that. Go and enquire personally.
  8. In bank you are supposed to fillup a new account opening form, nomination form and give your address proof and PAN copy.
  9. Make sure your the balance in your new PPF account is exactly the same as the closing in the Post Office.
  10. After transfer link the PPF account with your internet banking account and manage your PPF account online without going to bank.
  11. Give standing instruction for deposit into your PPF account so that you enjoy high interest since the interest in PPF is compounded annually.


  • Your original date of opening the PPF account in post office will be the opening date in bank.
  • Bank needs to enter the accrued interest from 1st April of current financial year upto the date of opening the account. This amount has to be entered in the coloumn as interest adjustment. This has to be done manually. (Bank officials are not aware of that)
  • You are not supposed to loose any interest at any cost due to delay in transfer of account.
  • All the transaction records in post office will not be reflected in your new bank passbook. So it is better to take photocopy of post office passbook before surrendering for transfer.
  • In case you have any problem download Post Office Manual and take printout of Rule No. 153 which talks about the procedure involved in Transfer of PPF accounts from post office to bank and vice versa.
  • The User interface of the Banks computer makes some procedure difficult. In such case ask the bank officials to call their superior. If you feel your unduly delayed of the procedure make a complaint in the website of the bank about the delay.

Microsoft SQL Server Version List and Download

This unofficial build chart lists all of the known Service Packs (SP), Cumulative Updates (CU), patches, hotfixes and other builds of MS SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 and 6.0 that have been released.

↓ SQL Server 2014
     codename Hekaton SQL14
↓ SQL Server 2012
     codename Denali
or 11.1.3000.0
or 11.2.5058.0
↓ SQL Server 2008 R2
     codename Kilimanjaro
or 10.51.2500.0
or 10.52.4000.0
or 10.53.6000.34
↓ SQL Server 2008
     codename Katmai
or 10.1.2531.0
or 10.2.4000.0
or 10.3.5500.0
or 10.4.6000.29
↓ SQL Server 2005
     codename Yukon
↓ SQL Server 2000
     codename Shiloh
↓ SQL Server 7.0
     codename Sphinx

All SQLServer service packs are cumulative, meaning that each new service pack contains all the fixes that are included with previous service packs and any new fixes.

Dec 13, 2014

Recover Corrupted SQL Database using Software


Recover SQL Database using Software

Most of the Software's are available in market to recover SQL database. All those software available only for paid customer. 
How to Work our Software

SysTool : SQL Recovery Tool

SQL Recovery Tool can recover the database having following error messages
  1. "Error 823: I/O error (torn page) detected during read at offset 0x00000027dc2000 in file."
  2. "Server can't find the requested database table"
  3. "Index '%ls' on '%ls' in database '%ls' may be corrupt because of expression evaluation changes in this release. Drop and re-create the index"
  4. "The process could not execute 'sp_replcmds' on Server"
  5. "The file *.mdf is missing and needs to restore"

Download Recovery Tool

Site : Official Site Download ; Size : 6MB

Procedure for handling Cheques presented at CBS SOs


AT CBS SUB OFFICE from where the Cheques are sent to CBS HO dealing with Clearing for clearance

• Invoke the menu HOMSO

• Select the function “Add”. Date will appear automatically

• Click on GO

• In case of subsequent deposit in Savings Account, Enter customer’s savings Account Number 
irrespective of where the account stands.

• In case of cheques presented through MPKBY Agent LOT, enter or select from searcher SO 
SOLID0017 as Account number.

• In case of RD Subsequent Deposit at counter, enter or select from searcher, HO SOLID0017 
as Account Number.

• In case of PPF Subsequent Deposit at counter, enter or select from searcher HO SOLID0017
as Account Number.

• For new accounts/certificates opened by cheque, enter or select from searcher, SO 
SOLID0382 as Account Number.

• Enter the amount of cheque 

• Enter the cheque number

• Enter the MICR code available in the cheque (this is mandatory)

• Enter the cheque date

• Enter the Tran Code as 10

• Click on Submit if only one cheque is available

• If multiple cheques are available, click on ADD and enter the cheque details of other cheques 
as detailed in above steps.

• Supervisor need to verify the cheques entered using same menu HOMSO

• Select the function VERIFY and enter the date

• Data verified successfully message will be displayed

• Take the report using the menu CHLR. This menu is accessible only for OPERATOR

• Report can be generated using menu CHLR

• Softcopy of cheques lodges can be viewed by clicking on the explode icon

• Copy the filepath from the above location

• Invoke the menu HTRFTOPC. Enter the source file name (the copied content can be pasted 
here) and the destination directory

• The txt file will be copied to the said location in the local drive.

• Send this txt file along with CHEQUES to HO

Note:- Same procedure will be followed by CBS HO not dealing with clearing house but attached with another CBS HO dealing with Clearing House.

Finacle Menu Option Updated List : Download from Google Drive


Download Finacle Menu Option updated

  • Download updated Finacle menu from Google drive which is uploaded by PoTools.


DPT Fix Version 4.1 Download from Google Drive


DPT Fix v4.1 Download

Developed by Rajesh C R
Version : 4.1 dated 12.12.2014

 More Options are added

  • RD Unpaid Default fee in DB Analyzer Discrepancies
  • RD Paid Unpaid DF in DBA.
  • RD Mismatch in month count.
  • Account Linked as agent but not having agent details.
Special Characters in name and address fields.

Download DPT Fix v4.1

Google Plus Followers :: PoTools ::

Some Important Tags at PoTools

Aadhar Software ( 3) BO Account verification Tool ( 2) BO Tag ( 4) Bootable USB ( 4) Bulk eMO Payment ( 1) CBS ( 70) ccleaner ( 5) Certificate ( 3) COD ( 48) Data Profiling Tool ( 23) DB Tools ( 6) DBA Updater ( 10) DBAnalyzer ( 63) despatch ( 18) despatch error & Solution ( 21) Discrepancies tool ( 16) Discripencies tool ( 1) DOP Browser ( 3) DOP Clients Configuration ( 2) DOP Tools ( 27) Downloads ( 2) drivers backup ( 5) eMO ( 19) eMO Client ( 8) ePayment ( 12) ePayment Cheque ( 1) ePayment error ( 4) ePayment updates ( 1) ePost ( 12) finacle ( 73) IMO ( 8) interest calculator ( 10) interest Posting ( 5) interest Rate ( 5) MM 7 Update 8 ( 12) MM 7 Update 9 ( 44) MM Update ( 19) mm7.3 errors ( 24) Negative List Updation ( 13) newupdate ( 111) NREGAEMO error ( 5) Parcel Net ( 21) passbook printer ( 7) PLI Calculator ( 3) PO Tools ( 47) point of sale ( 21) POSB Calculator ( 9) Postman ( 47) postman error ( 33) printer ( 9) PT Tools ( 8) R Net Communication ( 11) RD Customer Package ( 2) RNet Communication ( 9) Sanchay Post ( 37) Sanchaypost error ( 27) SB46 Intimation tool ( 7) SBCO Utility ( 36) sdc updates ( 10) Signature Tools ( 9) softwares ( 16) SOSB Tools ( 4) SP Patch updater ( 32) SPCOD ( 15) Speed Net 4.1.1 ( 9) Speed Net 4.2 ( 31) SpeedNet error ( 17) Speednet update ( 22) SQL and windows ( 34) sql backup ( 8) SR Tools ( 15) sub accounts ( 9) tariff revision ( 4) TDS Software ( 5) treasury error ( 9) usefulpost ( 110) VP Intimation ( 6) Weblink ( 26) windows 2003 server update ( 8) windows troubleshooting ( 19)

PoTools Followers

Contact Form


Email *

Message *

Useful Forms

Total Pageviews

Live Users