SCS-SI entry issue/ Patch released

Execution of SCS - SI entries for 30/06/2013

Unzip the file to DBAnalyzer folder in server. Logout of Sanchay Post from all the clients and server. Backup POST database Execute "JuneScs_Si.exe" This exe should be executed after day-begin of 29/06/2013 and before day-end of 29/06/2013. The exe will display the total amount after finishing SI posting. This amount should be added to the counter transactions LOT. This exe will work upto 06/07/2013. If executed after 29/06/2013, the SI amount will be reflected in the LOT of the date of execution. Click here to download patch file

source: http://tamilnadupost.nic.in/sdc/scs_si.htm

First Indiapost ATM at Bangalore

Post office saving bank account holders in Bangalore can experience new ATM card facilities shortly 

BANGALORE, INDIA: When you hear 'ATM', what is the first thing that you relate to it? I am sure, many of us, including me, relate it to savings bank ATM card.

How about an ATM card similar to a debit card/ATM card issued by a bank for postal account? Sounds different right?

Yes, the Department of Posts, in an effort to provide enhanced solutions to its customers is all set to launch the first Automated teller Machine (ATM) in Bangalore GPO premises shortly, through a core banking solution.

Data Profiling Tool (Infosys) Error

While running the Data profiling Tool (Infosys) it shows an error/messages.

It shows "could not find the main class: com.dop.dpt.DataProfiling Tool, Program will exists" and no file is created

solution : The error/message is due to the non installation of Java Run time Environment 1.7 (jre1.7). Please down load the same and install. After this you can start working

Click here to Download JRE 1.7

SB Order no 07/2013 : Admissiblity of Commission on TD Deposits to BPMs

Negative List Updation Patch - Updated upto 31/03/2013

This patch file updates the negative list available in Sanchay Post software. To confirm updation, use the "Database Discrepancies >> NSC >> Details of Negative List Updation" option available in DBAnalyzer software.

The file 'NL_20130331.exe' should be copied to DBAnalyzer folder and executed after completion of day's transactions. This will update the negative list upto 31/03/2013  in Sanchay Post.

In addition to Negative List, updations relating to PINCODE details are also done in the database. Hence, execution of this patch will take longer than the usual updation time. System Administrators should ensure that the server is not switched off till successful execution of the patch.

Downloadable from FTP site of PTC, Mysore.

SAVINGS BANK INTEREST RATES AT A GLANCE-Past 2 years

INTEREST RATE TABLE
Name of scheme	Period	Up To 30/11/2011	w.ef 1/12/2011	w.e.f 1/4/2012	w.e.f 1/4/2013
Savings Account	General	3.50%	4.00%	4.00%	4.00%
Time Deposit	I yr	6.25%	7.70%	8.20%	8.20%
	2 yr	6.50%	7.8%	8.30%	8.20%
	3 yr	7.25%	8.00%	8.40%	8.30%
	5 yr	7.50%	8.30%	8.50%	8.40%
Recurring Deposit	5 yr	7.50% 10-728.90	8.00% 10-738.62	8.40% 10-746.51	8.30% 10-744.53
M I S	5 yr	8.00% (6 Yr)	8.20%	8.50%	8.40%
S C S S	5 yr	9%	9.00%	9.30%	9.20%
P P F	15 yr	8%	8.6%	8.80%	8.70%

INTEREST RATES/TABLE W.E.R 01.04.2013

INTEREST TABLE W.E.F 01.04.2013

RD Maturity Value for Denomination of Rs.100

Maturity Value before 01.12.2011	Maturity Value w.e.f 01.04.2012 to 31.03.2013	Maturity Value w.e.f 01.04.2013
Interest @ 7.5 %	Interest @ 8.4 %	Interest @ 8.3 %
Rs. 7289/-	Rs. 7465/-	Rs. 7445/-

RD Maturity Value for Denomination of Rs. 100/-

in case of extension after 5 Years

Maturity Period	Interest @ 8.40 % 01.04.2012 to 31.03.2013	Interest @ 8.30% w.e.f 01.04.2013
5 Years	7465	7445
6 Years	9368	9338
7 Years	11436	11392

Interest Change Patch Error ???

While Running interest patch on some offices before 01/04/2013  it shows an error . Error Code L1. It shows some primary key constraint error and interest patch cannot be done properly.

Solution: Run the interest rate patch once again on 01/04/2013. This will solve your problem.

Revision of Interest Rates for Small Savings Schemes With Effect from 1ST APRIL, 2013

Based on the decisions taken by the Government on the recommendations of the Shyamala Gopinath Committee for Comprehensive Review of National Small Savings Fund (NSSF), the interest rates for small saving schemes are to be notified every financial year, before 1st April of that year. Accordingly, the rate of interest on various small savings schemes for the financial year 2013-14 effective from 01.04.2013, on the basis of the interest compounding/ payment built-in in the schemes, shall be as under :

 

Scheme	Rate of Interest w.e.f. 01.04.2012	Rate of Interest w.e.f. 01.04.2013
1	2	3
Savings Deposit	4.0	4.0
1 Year Time Deposit	8.2	8.2
2 Year Time Deposit	8.3	8.2
3 Year Time Deposit	8.4	8.3
5 Year Time Deposit	8.5	8.4
5 Year Recurring Deposit	8.4	8.3
5 Year SCSS	9.3	9.2

DB Analyzer Revised Exe including Report Consolidator

DBAnalyzer exe dated 15/03/2013 has a new feature to generate a consolidated report of all discrepancies in the database. Unzip the additional exe & all the DLL files included in the DBAnalyzer zip file and copy to the DBAnalyzer folder.

Click here to Download the Latest Exe and Report Consolidator

PROCEDURE FOR RUNNING ANNUAL INTEREST CALCULATION IN SANCHAYPOST

Download the revised DB Analyzer Software. Run DB Analyzer software. Select ‘Database Discrepancies’

STEP 1
1. Ensure that previous financial year Interest Entry (2011-2012) is made for all accounts. (‘Ledger entries without previous year interest entry’ option will list the accounts without interest entry).Login to Data Entry Module as Data Entry Supervisor and insert the interest transaction for the previous financial year (i.e. for 2011-2012) with the transaction date as '01/04/2012' and transaction type as 'interest'.

2. Ensure that account type is available for all accounts. (Account numbers with blank account type’ option) Login as Supervisor. Use 'Common -> Account type Conversion' form. Select the correct account type and save

3. Ensure that ledger entries with Cleared Date as ‘01/01/1900’ are not available. (‘Ledger entries with LOT / Cleared Date as 01/01/1900’ option)

4. Ensure that account status is updated for all accounts. (Account numbers with blank account status' option) Select 'Database Discrepancies >> SB >> Account numbers with blank account status' option in DBAnalyzer and update the account status

Fess Charged for issuing Duplicate Passbooks/Certificates

            By Shyam Narayan Sharma,IPS,Ex-SSP (Deptt of Posts),Mau UP

SNo	Name of the scheme	Duplicate issue	Nomination (First Time)	Nomination Cancellation/Variation	Pledging/Releasing	Transfer from one person to another	Transfer from one office to another
1	SB Account	Rs 10(In shape of Postage Stamps)	Nil	Re 1(In shape of Postage Stamps)	N/A	N/A	Nil
2	Public Provident Fund Account	Re 1(In shape of Postage Stamps)	Nil	Re 1(In shape of Postage Stamps)	N/A	N/A	Nil
3	National Savings Certificates	Rs 5 for each number of certificates(To be credited in UCR)	Nil	Rs 5 per purchase application form(In shape of Postage Stamps)	Rs 5 for each number of certificates(To be credited in UCR)	Rs 5 for each number of certificates(To be credited in UCR)	Nil
4	Kisan Vikas Patra	Re 0.25 for each number of certificates of    Rs 100 denominations and Rs 5 for other denominations (To be credited in UCR)	Nil	Re 1 per purchase application form(In shape of Postage Stamps)	Re 0.25 for each number of certificates of    Rs 100 denominations and Rs 5 for other denominations (To be credited in UCR)	Re 0.25 for each number of certificates of   Rs 100 denominations and Rs 5 for other denominations (To be credited in UCR)	Nil
5	Senior Citizen Savings Scheme	Rs 10(In shape of Postage Stamps)	Nil	N/A	N/A	N/A	Rs 5 per Lac if the balance exceeds Rs 1 lac

                                                                                           

                           Collection Charges on Out Station Cheques

                             Upto Rs 1000 or part= Rs 30-00

    Beyond Rs 1000       = Rs 30-00 plus Rs 3-00 for each additional Rs 1000 or part

S B order No. 02/2013 : Enhancement of limit for verification of withdrawals from Savings Accounts made at Extra Departmental Sub/Branch Post Offices and Single Handed Post Offices

The  limit for verification of withdrawals from Savings Accounts made at Extra Departmental Sub/Branch Post Offices and Single Handed Post Offices is enhanced to 10000/- Instead of 5000/- w.e.f 01/01/2013

Click here to view the Order

Sanchay Post Violation of Primary key error

Error
In Sanchay Post while new forms withdrawal of MIS,SB,NSC it shows an error Issue New form (Database Error) "violation of PRIMARY KEY constraint 'PK_flow_table_1367E606'. Cannot insert duplicate key in object 'dbo.flow_table'." 

Solution:
1. Download attached patches.

SanchayPost - Negative List 31122012

The file 'NL_20121231.exe' should be copied to DBAnalyzer folder and executed after completion of day's transactions. 

This will update the negative list upto 31/12/2012 in Sanchay Post. (Corrections received upto 31/01/2013)

In addition to Negative List, updations relating to PINCODE details are also done in the database. Hence, execution of this patch will take longer than the usual updation time. 

System Administrators should ensure that the server is not switched off till successful execution of the patch. To confirm updation, use 'DBAnalyzer >> Database Discrepancies >> NSC >> Details of negative list updation' option. 

ftp://ftp.ptcinfo.org/NegativeList

Problem while updating the Negative list- "The Database pertaining to Negative List has been tampered"

In one of our office while updating the Negative list It shows an error. The Database pertaining to the Negative list has been tampered and negative list has not been upgraded. The Solution give by SDC chennai for the above error is below.

Click here to down load the solution

Negative List Updation Patch - Updated upto 31/10/2012

This patch file updates the negative list available in Sanchay Post software. To confirm updation, use the "Database Discrepancies >> NSC >> Details of Negative List Updation" option available in DBAnalyzer software.
	The file 'NL_20121031.exe' should be copied to DBAnalyzer folder and executed after completion of day's transactions. This will update the negative list upto 31/10/2012  in Sanchay Post. In addition to Negative List, updations relating to PINCODE details are also done in the database. Hence, execution of this patch will take longer than the usual updation time. System Administrators should ensure that the server is not switched off till successful execution of the patch.
Downloadable from FTP site of PTC, Mysore.
Email issues related to this software to sblansupport@hotmail.com

DBAnalyzer for Sanchay Post Dated 08-11-2012

DBAnalyzer for Sanchay Post
	Software Package (zipped) Revised Exe (zipped) Last updated on: 08-11-2012
Email issues related to this software to sblansupport@hotmail.com

---

Software Development Centre
O/o the Chief Postmaster General
Tamilnadu Postal Circle
Chennai - 600002
Phone: 044-65850861

Patches for Sanchya Post Version 7.0 dated (14-08-2012)

New patches for Sanchaya post version 7.0 is released on 14/08/2012. This patches can be downloaded from SDC chennai Website. The Downloading Link is given below.

http://tamilnadupost.nic.in/sdc/patch7.htm

Sanchaya Post Updation to 7.0-Error and the solution

In one of my office while upgrading to sanchaya post 7.0 an error occurs. The screen shot is given below. The error shows that
"The Device Activation Error.The physical file name NREGAEMO_data.mdf may be incorrect. Created database failed.Some file names listed cannot be created.Check Previous errors"
On consulting the error with SDC Chennai, They give the solution. 

Actually, the problem is due to the reason that you are having the POST database in the drive itself.

Logout of Sanchay Post in all systems. Goto SQL Enterprise Manager and Detach the POST database and then move the files to a folder (POST folder) created in the drive, preferably a drive in which you are not having your OS. Then, goto SQL Enterprise Manager and attach the POST database with owner SA. Then, run upgradation patch (after day end). You won't be facing the problem you have mentioned.