DBAnalyzer for Sanchay Post dated 22-03-2013

Software Development Centre, Chennai

---

DBAnalyzer for Sanchay Post
	Software Package (zipped) Exe including Report Consolidator (zipped) Solution Documents (zipped) Last updated on: 22-03-2013
DBAnalyzer 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. NOTE: Generation of Consolidated Report is a TIME CONSUMING PROCESS. All offices are advised to generate this report after completing the daily routines like DAY-END process, Database Backup, etc.
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

Weblink - Updated dtd 20/03/2013

Added Features:

• View fine.
• Data Copy utilities. 

To Download: Click Here

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

Speednet - Bulk Delivery Update Release for Sorting hub.

Bulk Delivery Update Release Notes

Important Note:

Post offices are not required to install this update. This update is specifically for Sorting Hub/IC Hubs.

After applying this update, the new Bulk Delivery options will be available to offices configured with Office Code starting with "S" or "R".

As such, please ensure the correctness of your Office Code and then proceed further.

A User manual with instructions on the operations relating to bulk delivery is also included. Please go through it thoroughly before starting the bulk delivery activity.

1) Download the SpeedNet Client zip folder and unzip it

2) Please take the backup of all the Databases and run the attached Script file using ScriptTool.exe in the following order:

            a) POSPCC15032013.exl

            b) POSPCCBACKUP15032013.exl

3) Rename the existing SpeedNet.exe

4) Rename the downloaded SpeedNet_exe file as SpeedNet.exe

5) Copy/overwrite the four DLLs and SpeedNet.exe files in to SpeedNet folder in all Client machines having SpeedNet

6) Register the four DLLs

7) Download the Setup files relating to SpeedNet Communication

8) Rename the existing file Setup_exe as Setup1.exe

9) Uninstall existing communication after copying the contents of EMSClient folder to another location

10) Install new SpeedNet communication using Setup.exe of SpeedNet Communication.msi file

Note: Pre-requisites for SpeedNet Communication are

(a)                .Net Framework 2.0 or higher version

(b)               Windows Installer 3.1 or higher version is required to install SpeedNet Communication using MSI file.

11) Copy the contents of old EMSClient folder to the new EMSClient folder

CLICK  HERE  TO  DOWNLOAD

ftp://ftp.ptcinfo.org/SpeedNet/BulkDeliveryUpdate/

eMO Client Error??? Error no 701 Login failed for user NRega

While running the emo client in update 5 and 6 an error or message occurs. It shows that "Cannot open database requested in login NREGAEMO. Login failed for user NREGA". While sending this error . The solution provided by CEPT mysore is given below.

Click here to download solution

Unzip the file and copy it to DBAnalyzer folder and run it from the same location. This will solve your problem.

NB. Please backup the database before running the solution

Courtesy : http://saparavur.blogspot.in/

PLI / RPLI Ledger View tool for Sub Office Use

Download


Thanks to :
R.Karunagaran
System Manager
Tirupattur HPO – 635601
9894213404
Karunagaran78@Gmail.com

Procedure for running Annal 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

STEP 2 

Login as ‘Supervisor’ in on-line module.

1. Check interest rates in initialisation group

2. Check the current financial year in the form (Form No.0410) ‘Initialisation >> Financial Year – SB / PPF / NSS’ (Financial Year should be 01/04/2012 – 31/03/2013

STEP 3 
From the menu
1. Select ‘Annual Interest Calculation’ form (Form No. 1305 / 1004 / 0904) to calculate interest for SB / PPF / NSS.

2. Select 'IBB Report' option to generate IBB Report

3. Select 'Annual Interest Calculation' option to carry out calculation.

STEP 4

After calculation is finished

1. Check the error files in SP5\OT folder to view the accounts for which interest was not calculated

2. If any of the errors listed can be rectified, rectify them. It would be advisable to rectify as many of the errors listed if not all and then re-calculate interest by selecting 'Annual InterestCalculation' option again, before interest posting. The process can be repeated any number of times till no accounts are listed in the error list.

3. Select the 'Annual Interest Posting' option to carry out interest posting

NOTE:

1. Interest calculation should be performed at HO only, for all SOs except for MDG

2. For SOs, interest calculation should be performed only after receiving and incorporating all the Supplementary Dates’ transactions in SOSB module

3. Ensure that the cleared cheque details received till 31/03/2013 are entered and posted. Also ensure posting of PPF cheques cleared till 31/03/2013 before posting PPF interest.

4. Interest if calculated and posted on any later date (after 01/04/2013) will also be appropriately posted in the ledger

Can Interest Calculation be done after 1st of April

Interest calculation for PPF can be done on any day after completion of transactions on the 31st of March and for other schemes it can be performed on any day after day begin has been performed for the 1st of April. Interest is posted (inserted) in the ledger with transaction date as per rules.

PLI / RPLI Ledger View Tool for the Use of Ac Branch at HO

Download

Thanks to:
R.Karunagaran
System Manager
Tirupattur HPO – 635601
9894213404
Karunagaran78@Gmail.com

Negative List Updation Patch - Updated upto 31/01/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_20130131.exe' should be copied to DBAnalyzer folder and executed after completion of day's transactions. This will update the negative list upto 31/01/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.
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

NEW DBAnalyzer and Negative List dtd 01-03-2013

Software Development Centre, Chennai

---

Sanchay Post		SB-related Software Applications
Version 7.0 (03/01/2013)		DBAnalyzer (01/03/2013)
Version 6.6.1		Negative List (01/03/2013)
Instructions / Manuals (13/07/2012)		CCBridge Version 6.0 (11/07/2012)
Patches for Version 6.6.1 (21/06/2012)		Signature Scanning Software
Patches for Version 7.0 (27/09/2012)		RD Customer Package (18/04/2012)
FAQ - Version 6.6.1 (30/08/2012)		SO Balance Agreement (24/12/2012)
FAQ - Version 7.0  (27/09/2012)		Account Classification SB-to-NREGA Version 2.0  (13/12/2012)
Known Issues - Version 7.0  (27/09/2012)		SP - Link Aadhaar Number (Beta Version)  (18/12/2012)
Offices upgraded to Version 7.0
Version 6.5R2 Webpage
Other Software Applications
ECS for Salary Credits (30/03/2012)
WUMTS Monthly Returns Version 2.1 (TN Circle only)

---

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

NEW DBAnalyzer and Negative List dtd 01-03-2013

Software Development Centre, Chennai

---

Sanchay Post		SB-related Software Applications
Version 7.0 (03/01/2013)		DBAnalyzer (01/03/2013)
Version 6.6.1		Negative List (01/03/2013)
Instructions / Manuals (13/07/2012)		CCBridge Version 6.0 (11/07/2012)
Patches for Version 6.6.1 (21/06/2012)		Signature Scanning Software
Patches for Version 7.0 (27/09/2012)		RD Customer Package (18/04/2012)
FAQ - Version 6.6.1 (30/08/2012)		SO Balance Agreement (24/12/2012)
FAQ - Version 7.0  (27/09/2012)		Account Classification SB-to-NREGA Version 2.0  (13/12/2012)
Known Issues - Version 7.0  (27/09/2012)		SP - Link Aadhaar Number (Beta Version)  (18/12/2012)
Offices upgraded to Version 7.0
Version 6.5R2 Webpage
Other Software Applications
ECS for Salary Credits (30/03/2012)
WUMTS Monthly Returns Version 2.1 (TN Circle only)

---

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