Import files from HO fixed at Sanchay Post Counter

Problem:
              While going to import Interest file from HO at sub office, 0304 Import files from HO not available at Sanchay Post counter.

Solution:

Method 1:

• Login as SUPERUSER in Sanchay Post Module.
• Go to Forms Option > 1. Assign Forms > Select Counter > Click Add.
• Assign Import files from HO form under Day Begin/End option.

Method 2:

• Download exe Attached patch file from potools.blogspot.in
• Execure Upg_Forms.exe from DB_Analyzer folder.
• Now Log-out All users from Sanchay Post and Do re-login.

Download

Source : http://potools.blogspot.in/

Sorry you can not run from client machine - Solution

While creating Database Error :  "Sorry you cant run from client machine ".

 

Solution : 

Go to Registry ( Regedit in the Run ) 

Check the following path 

[HKEY_LOCAL_MACHINE\SOFTWARE\POST\CONNECTION] 

Double Click the Server name and Give value data as ( Your SQL Server name) 

"Servername"="DOP" 

Eg. Here Your Server name = DOP )

SB Closure Error in Sanchay Post

Error:
        While do SB closure in Sanchay Post Module its open a New window as "Specify Filter" .

Solution:

• Do login in Sanchay Post as Super
• Go to 04 Initialization > 0410 Financial year >Configure as 01/04/2013 to 31/03/2014.

• Log out all sanchay post user and do re-login. Now Problem fixed.

Sanchaypost Interest Posting Procedure at SO

Step : 1
Take backup of all Database before doing the Interest Posting. 
Download the interest file belong to your office code available in your mail. 
Step : 2
Copy this file in to HO to SO folder available in Server machine.
Step : 3
Login in Counter -> Select the Day Begin/End form -> Select from No. 0304 Import files
from HO -> New Form….. The following screen will be appear. 

Step : 4
After select the Import files from HO form the following menu will be appear 
>> Select the SB Interest Posting Radio button -> OK

Step : 5
After select the SB Interest Posting Radio button -> OK the following screen will be appear. >> Click on Select file to import menu 

Step : 6
After Click on Select file to import menu following screen will be appear. 
>> Select the file from HO_to_SO folder belongs to your Sanchay Post Office Code -> Click
on Open -> Click on Import file. After import data noted the 1st and last account number
from the list and than Click on Save -> Send the form. 

Step : 7
Login as Supervisor in Sanchay Post Online Software. Select the SB Menu -> Select Form No. 1305 SB Interest Calculation. The following screen will be appear -> Click on Calculate Interest.

Step : 8
After click on Calculate Interest Menu following screen will be appear. Select Annual Interest Posting Radio Button -> Enter the Year 2012 and Press Enter 2013 will be automatically appear -> Enter the Start Account Number & End Account number which is noted earlier and Press OK -> Wait until Successfully message is not appear. 

Note : Before calculate the interest log out from all Sanchay post software and than follow the above step. Check the Interest Report for the year 2012-13 as well as Check in DB Analyzer for successfully posting of Interest in your database.



Interest Posting Procedure at SO :  View / Download

Thanks to Mr. Manish, Dnl. SA. Jamnagar HO

Tool for Posting Interest entries from Sanchay Post to V2SBCO

Tool for Posting Interest entries from Sanchay Post to V2SBCO

Download Link: https://www.dropbox.com/s/tn64ck6pl9rb7sy/SP2V2IntPosting.zip

Source:
SDC, Chennai website

Bridge Plugin Setup and Updates

Bridge Plugin Setup: Download and Install Bridge plugins 

Replace SB Plugins and V2Conversion Latest exe :  Download 

Updates:

SB Plugins v3.2 :  Download

V2Conversion 3.1 :  Download

Interest Calculation Cannot be performed at S.O

Error:

        While do interest calculation at S.O in Super at the time of open a new form it shows an error message as "Interest Calculation cannot be performed at SO" after loaded interest file from counter .

Solution:

• Press OK for Issue new form Message.
• Log out Super from Sanchay Post Online Transaction.
• Log in again by using Supervisor in Online Transaction.
• Select SB > Annual Interest Calculation > New form
• Now we can do interest posting without error at S.O

ADDENDUM to the Revision in Interest Rates of Small Savings Schemes w.e.f 1st April 2013

View the Order here

DBAnalyzer dated 02/04/013 for Sanchay Post

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.
 

Download : http://tamilnadupost.nic.in/sdc/xfiles/DBAnalyzer.zip

Patches for Sanchay Post Version 7.0 ( dtd 14/08/2012 )

Patches for Sanchay Post Version 7.0 is available in the following link : http://tamilnadupost.nic.in/sdc/patch7.htm

TDS Software New

TDS Software

Download 

Software Developed by
R.Karunagaran
System Manager
Tirupattur HPO – 635601
Mobile :9894213404
Email: Karunagaran78@Gmail.com

SO - HO Balance Agreement Tool

SO - HO Balance Agreement Tool
This tool can be used for listing SB / PPF / NSS accounts with differences between SO balance and HO balance as on 01-04-2012 (or 31-03-2012). Detailed Instructions are available in the User Guide.
	User Guide Exe (zipped) Last updated on: 14-06-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

DBAnalyzer for Sanchay Post

	Software Package (zipped) Revised Exe (zipped) Last updated on: 14-06-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

Negative list upto 30/04/2012 in Sanchay Post

The file 'NL_20120430.exe' should be copied to DBAnalyzer folder and executed after completion of day's transactions. This will update the negative list upto 30/04/2012 in Sanchay Post. (Corrections received upto 12/06/2012)

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.

Download from PTC FTP Site : ftp://ftp.ptcinfo.org/NegativeList/NL_20120430.exe

ANNUAL INTEREST CALCULATION 2011-12 in V2 SBCO Software

New V2 SBCO Software for Interest Calculation will expected 31/03/2012 today evening



ANNUAL INTEREST CALCULATION 2011-12in V2 SBCO Software

        The Directorate had issued order to run the annual interest calculation  2009-10 in Sanchay Post  in view of the proposed implementation of CBS as given below vide SB Order No:17-2009 No:76-01/09-SB Dt: 08.12.2009. As referred above, under modified POSB Vol-1-  Rule: 73, it is mentioned that “73.(1)  Now all HPOs are working on SBLAN in system Software and the interest is calculated by the system software in computer. After completion of posting of transactions of 31^st March of a particular year (including all SOs of 31^st March LOTs), command for calculation of IBB, calculation interest and then interest posting should be given by the Postmaster [Supervisor]. Printout of Interest Statement in duplicate for HO and triplicate in case of SOs and MDGs should be taken. One copy of interest statement should be transferred to SBCO and second copy should be sent to SOs and MDGs. Third copy should be kept in guard file as office copy. SBCO should charge the total amount of interest in statistical Registers of April”.

 As no direction has been received from Directorate for calculation of  Annual Interest Calculation and release of Interest Statement  2011-12, the procedure adopted  in the year 2010-11 may be followed. As such SBCO working V2 SBCO may also calculate Annual Interest calculation in V2 software

 “As the maximum limit of Saving accounts has been removed the  maximum balance should be corrected  as “99999999” from 01.04.2011 to 30.11.2011 and also  from  01.12.2011 to 31.03.2012. Otherwise IBB will be limited to Rs.1 lakh and 2 lakh only"

            Hence, it is kindly requested to run the discrepancy option in Bridge Software to identify the discrepancies before running the Annual Interest calculation in V2 software. After running the Annual Interest calculation, once again run the discrepancy option to identify the interest corrections between the annual interest of V2 software & Sanchay Post  software.

            The difference if any in (Interest) V2 SBCO may be corrected through Interest Rectification Register and (Difference in Interest) Sanchay post corrected  through OM/ Maintaining separate register . After reconciliation of this process , one copy of Annual Interest Statement should be sent to the sub office for necessary action.  In the case of minus balances, if it could not be reconciled at your end, please raise objections for reconciliation.

 I reiterate the procedure for running interest statement 2011-12 in V2 SBCO for ready reference  to our SBCO staff

            PROCEDURE FOR SB/NSS/PPF ANNUAL INTEREST CALCULATION IN V2 SBCO SOFTWARE

1. Clear all the minus balances before running the IBB calculation
2. Raise objections for the remaining minus balances accounts for reconciliation with passbook.
3. Clear all the Un-posted items through the option .1. – Transaction – Modification – LOT – F6 option – Option .2. Account creation –enter the account number – enter the binder number instead of ‘UP’ binder
4. Enter the IBB for transfer-in accounts and Revival accounts thro option – Utilities –IBB entry

5.      Delete the duplicate account number through the ‘SBX’ software – Misc option –Delete duplicate number – Delete the second record one by one by using Ctrl + T key

RECONCILIATION: Before running annual interest statement, run the discrepancy once again to pair the balances of v2 sbco & Sanchay post balances.

1.      After tallying the SB63 office wise figure with V2 grand summary figure, do the backup in HDD and CD.

2.      Check up the financial year as 01.04.2011to 31.03.2012 in the option – Master Maintenance – System Admn – 3.HO Details

3.      Check up the Interest Rate –

i)                    SB/JA/JB/PEN –  01-04-2011 to 30.11.2011 =3.5% and

                                         01.12.2011 to 31.03.2012   = 4 %

ii)                  PPF – 01-04-2011 to 30.11.2011   =  8% and

                      01.12.2011 to 31.03.2012    = 8.6 %

iii)                 NSS87/92 – 7.5%

4.      No interest for the Public A/c, Security A/c , MVSD , TA  w.e.f. 01.01.2006

5.      Change the Financial year setup as given below , before running annual interest calculation for SB /PPF/NSS87 & 92 categories

CATEGORY	FROM DT	TODT	INTEREST	NO OF MONTHS	MIN BAL	MAXBAL
SA	01-04-2011	30-11-2011	3.5 %	8	20	99999999
	01-12-2011	31-03-2012	4 %	4	20	99999999
JA&JB	01.04.2011	30-11-2011	3.5 %	8	20	99999999
	01-12-2011	31-03-2012	4 %	4	20	99999999
TP	01-04-2011	30-11-2011	3.5 %	8	20	99999999
	01-12-2011	31-03-2012	4 %	4	20	99999999

REMARK: The interest period from date and to date for the previous financial year is to be deleted.

NOTE:  While checking 5% interest and comparing with Sanchay Post Interest , If IBB for any  period from 01.04.2011 to 30.09.2011 exceeded the limit of Rs.100000 for SA and for Rs.200000 for JA &JB ,necessary I.A. correction may be given.

CALCULATION OF INTEREST:

1.      Run the index service for all offices

2.      Run the update option for all offices

3.      Again, run the index services for all offices

4.      Run the IBB CALCULATION  - select the option Office wise / Yearly for all offices [To run Annual interest]

5.      Again, run the update option & Index services for all offices

6.      Run the service charges option – Report – Annual Report – 4.Service charges

a.      Before given ‘Yes’ i.e. deduction of service charges, take service charge print out, since after given ‘YES’, for the deduction of service charges, due to software problem, the service charges for some accounts are not displayed in the print option.

7.      Give “Yes” to deduct the service charge [The service charge will be automatically adjusted in the office wise Register SB63 on 31.03.2012 as With – Part II ]

8.      Again, run the update option & Index service for all offices     

    9.  Now, the Interest statement is ready to print

SERVICE CHARGE

1.      Separate service charge list for each office is not required, since the same is shown in Annual Interest Statement.

2.      Take a print of grand summary of service charge THREE COPIES – Report – Annual Report – 6.S.Charge [SB63] - [SBCO – SB BRANCH – ACCOUNTS to adjust under UCR]

RECONCILIATION: After running annual interest statement, run the discrepancy once again to pair the balances of V2 SBCO & Sanchay post balances

ANNUAL INTEREST STATEMENT / SILENT LIST PRINT OUT

1.      Take Interest statement    one  copy   and keep it with SBCO after comparing  with the interest  received from Sanchay post.

2.      Take “SBCO DIRECTORY’ backup in CD and sent to AO, ICO

UPGRADATION

1.      Before running this option, run the index service for all offices

2.      Check the Financial year as 01.04.2011 to 31.03.2012

3.      Run the Up-gradation option – Master maintenance – Up-gradation – select all Offices – give ‘yes’

4.      After Up-gradation, logout from the SBCO menu, again Login and run the index service before first operation

Thanks to
Mr. T.RETNASWAMY
CS, AISBCE Union
TN CIRCLE.

Total CBS Ver 1.0/01.03.2012

Total CBS Ver 1.0/01.03.2012 (Sanchay Version)

TOTAL CBS  

(HO SANCHAY & SO SANCHAY BALANCE COMPARITION TOOL)

1. This Software aims at Total Solutions for CBS Reconciliation Work

2. Through this software Discrepency list can be generated at Head Office itself by obtaining Last Balance Report file (DAT files) from SO through e-Mails. By this,  physical movement of CBS Team members can avoided to the extent posible.  This reduces finacial incurrence in form of TA/DA.


3. Head office can have a check on SO balance whenever desired.  HO can save lot of man power and time by concentrate only on discrepent a/c.

4. This software compares the HO Sanchay Balance & SO Sanchay Balance

5. This software will not calculate any Closing Balance.  It uses the Last Balance Report of SOSB Sanchay & SO Online Sanchay Post.

6. This software will generate discrepency list as on a "Given Date"
 
7. Update all the patches in Sanchay software before generation of Last Balance Report.  Last Balance report file (SB.DAT/RD.DAT/MIS.DAT etc) will be usually stored at sub folder path "SP5\OT" if generated  through Online option, or  at "SP5\DE\RD" etc if generated using Data Entry Modules or at "SP5\SOSB" if generated using SOSB Module or at "SP5\SD\SB" ETC if generated using SOSB Data entry Module
 
8. This software treats "Non Listed Sanchay A/cs in Last Balance Report" as discrepency.  As such kindly give importance for "View Excluded A/cs" option in "Last Balance Report" and take corrective steps to include "Live A/cs" into the list.
 
9. At the end of the discrepency report a summary will be generated. The total number of a/cs in summary is "sum of HO Sanchay Live A/cs and Number of SO Sanchay A/cs in excess of HO Sanchay a/cs" as this software compares HO Sanchay Balance to SO Sanchay Balance and also SO Sanchay Balance to HO Sanchay Balance.
 
10. Excess of Sanchay a/c  Accounts are mainly because of
    a. non marking of Closed or Transfer remarks
    b. No entry in common index a/cs
    c. Non effecting of inward transfers either in HO or SO
    d. Listing of accounts having Zero Balance.
 
11. It is possible with this software to tally the Amount and also number of accounts at HO & SO.

12. At most care is taken before release of this software.  However if any drawbacks are found in the software please give your feed backs through any of the contact details provided in next window.

Note :  Download from the link below and extract the files to any location.  Create a shortcut for the Totalcbs.exe on the desktop


User guidence :


1. Generate last balance report for the required category for the range of account number and the date as on which you want discrepency report. A .dat file will be created.


2. Get the .DAT file from the sub office generating the last balance report for the same category and for the same account range and the date.


3. In the fetch data menu first show the path of HO Sanchay DAT file and then show the path of SO Sanchay DAT file


4. Process the file


5. Get the discrepency report.


Those who are already using CBSTOTAL Tool (V2 Version) can download and extract the file to any location and copy only Totalcbs.exe & Tothelp.hlp file to CBSTOTAL folder and create a short-cut for the Totalcbs.exe on the desktop.
 
                                            A T T E N T I O N


   ALL THE USERS OF THIS SOFTWARE ARE REQUESTED TO REGISTER THEIR E-MAIL IDs WITH THIS SOFTWARE'S E-MAIL ID   cbstotal@gmail.com FURTHER QUERIES/ENHANCEMENTS/UPDATIONS WILL BE DIRECTLY DELIVERED ONLY TO REGISTERED E-MAIL IDs.  AS SUCH REGISTER YOUR E-MAIL IDs WITHOUT FAIL.
   
                                             T H A N K   Y O U

TOTALCBS DOWNLOAD LINK : Total CBS Ver 1.0/01.03.2012 (Sanchay Version)

Courtesy : http://www.cbstotal.blogspot.in/