POSB Interest Calculator v3.5 Update 01/04/2014

RD/All TD/MIS/SCSS/SB/PPF etc.

1. Calculate premature closure./Claim Closure 
2. Calculate maturity closer with extended period. 
3. PMI Calculation. 
4. Loan Interest Calculation for RD/PPF accounts 
5. with all relevant rules./ Comparison view 

Download

Download

Developed By

Rajeev Sharma PA(SBCO) 
Kullu HO 175101

 

SANCHAY POST 7 MANUAL DATA ENTRY RELEASED BY INFOSYS

Posted by Admin 

Manual Data Entry Sanchay Post Software

This release contains the implementation of manual data entry for NSS87,SB Discontinued products (25 No PMI products and 1 with PMI products). This manual data Entry module has an independent UI and will appear as a separate menu item below Sanchay Post.

Prerequisite

1. Sanchay Post 7.0 or Sanchay Post 7.11 
2. SQL Server 2005/2008/2000. 

Download:

SDC Chennai:

Download

Arithmetic Overflow In Sanchay Post 7.0

Wednesday, January 15, 2014

SANCHAY POST 7 DATAWINDOW ERROR ARITHMETIC OVERFLOW OCCURRED

Posted by Admin 

Arithmetic Overflow In Sanchay Post 7.0

While Open New Form for Posting of NREGA Credict Entry in Sanchaya Post 7.0 it shows an error message

DataWindow Error Select error: Arithmetic overflow occurred

Solution

1. Download latest OT patches from PoTools.
2. Extract the same and Copy all files inside the folder.
3. Paste/ replace all the copied files into \SP5\OT Folder i.e D:\SP5\OT

Download

OT Latest Patches

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

Software Development Centre, Chennai

---

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

Unzip the file to DBAnalyzer folder in server. Logout of Sanchay Post from all the clients and server. Backup POST database Execute "MarchScs_Si.exe" This exe should be executed before day-end of 30/03/2013 The exe will display the total amount after finishing SI posting. This amount should be added to the counter transactions LOT. Click here to download patch file

SANCHAY POST FATAL DISK ERROR- Sality Remover

Fatel disk error comes when infected system by sality virus

Solution:

1. Download sality virus removal tools

2. Run Scan and Reboot

3. It will scan & remove while booting windows

4. Reinstall Sanchaypost 7.0


AVG Sality remover

Kaspersky Sality Remover

Account Classification SB to NREGA

This tool is to be used only by offices handling NREGS accounts. This tool is for classifying the NREGS accounts from the list of SB accounts and entering Job Card details. More details are available in the release document.
	Release Note / User Guide Exe (zipped) Last updated on: 22-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

SAVING BANK INTEREST & PLI PREMIUM CALCULATORS

To download Click here
*****************************************************
(Prepared by Warrant Officer AB Kantharaja, Army Postal Service, Inspector Posts in Somwarpet Sub Division, Karnataka, http://abkantharaja.blogspot.in, email ID- abkantharaja@gmail.com)

Execution of SCS - SI entries for 29/09/2012

• Unzip the files to a subfolder in SP5 folder in server or any one of the clients.
• Logout of Sanchay Post from all the clients and server
• Backup POST database
• Execute "scs_si.exe". Click on 'RUN SCS SI'
• This exe should be executed before day-end of 29/09/2012
  
  
  Click here to download patch

Sanchay Post Updater - 27.09.2012

 

This contains all patches with DB Analyzer dated 27.09.2012 for Sanchay Post 7

Known Issues - Sanchay Post Version 7.0

1. NSC IX Issue 10years No provision for handling NSC IX Issue has been made in Sanchay Post. So, as per SB order no.30/2011 dated 30/11/2011 NSC IX Issue (stock maintenance & certificate issue) should be to be done manually.   2. SCS Extended Accounts Closure For SCS Accounts closed after completion of 8 years (extended accounts), interest for no. of days elapsed from date of maturity to date of closure is erroneously calculated at the rate of 9%. Post Maturity has to be paid for completed months only at SB rates of interest. Post Maturity Interest should be calculated manually at the time of closure. 3. SCS accounts extended after April 2012 For SCS Accounts extended after 01/04/2012, the interest rate should be at the prevailing rate, i.e. 9.3%. Software will calculate interest based on the date of opening of the account, i.e. 9%. For these accounts, use 'Miscellaneous >> Updation of interest in extended SCS accounts' option in DBAnalyzer for solution. 4. Transfer-in of SCS extended accounts For SCS extended accounts opened as transfer-in, open the SCS account as transferred-in with 21 withdrawals through online module. If one year has elapsed from the date of maturity, then use 'Miscellaneous >> Extension of transferred-in SCS accounts' option in DBAnalyzer for solution.   5. Maturity Date of NSC VIII Issue - 5years No modification is done in Sanchay Post regarding the calculation of maturity period in respect of NSC VIII Issue - 5 years certificates. The maturity date of NSC VIII Issue certificates issued in Sanchay Post will be calculated on the basis of 6 years only and displayed as such in the case of 5 years certificates also.

Frequently Asked Questions - Sanchay Post Version 7.0

1. For SCS Accounts closed after completion of 8 years (extended accounts), interest for no. of days elapsed from date of maturity to date of closure is erroneously calculated at the rate of 9%. Post Maturity has to be paid for completed months only at SB rates of interest. Post Maturity Interest should be calculated manually at the time of closure. 2. After entering the details in SB >> ECS Debits & Credits form, the transactions are not reflected in LOT. After entering the details in the COUNTER login, the transaction should be authorized by the Supervisor. Only after the transaction is authorized by the supervisor, it will be reflected in the LOT.   3. Cleared RD PRSS/agent cheques are not shown in ‘RD PRSS Post Entries’ form for selection. While preparing the cheque list, select the scheme as ‘RDPRSS’ in case of agent’s  providing softcopy of the list created through ‘RD Customer Package 3.0’ provided by SDC with version 6.6.1 . These RD PRSS cheques will be displayed in ‘Post RD PRSS Entries’ form for selection after clearance.   4. RD Bulk cheques are not shown in ‘RD Bulk Acceptance’ form. While preparing the cheque list, select the scheme as ‘RDBULK’ if the list is to be entered manually through ‘Bulk Posting’ form. RD Bulk cheques will be displayed in ‘RD Bulk Acceptance’ form after clearance.   5. An error message ‘Total amount does not tally’ is received when the cheque is selected for RDPRSS posting/RD bulk acceptance. What is the procedure for calculating cheque amount in case of RD PRSS/RD agents? RD cheques collected from customers / agents should be for amount payable after deduction of rebate and inclusive of default fee, if applicable. A separate cheque should be collected for each list.   6. We are unable to enter transactions for BPL accounts. For entering transactions in BPL accounts use the SB >> ECS - Debit and credit form (1310) >> Select manual and category as BPL. You will have to select category as INDP for INDP accounts, INWP for INWP accounts and so on.   7. While performing discharge in  'Encashment of other office KVP / NSC', an error 'To select type of discharge' is displayed. Download Discharge_661.zip, unzip and run the patch from DBAnalyzer folder.   8. While posting the transactions through 'RD >> Post PRSS Entries' form (Form no.1123) using the file generated through RD Customer Package, error message 'The application has failed to start because MFC30.dll was not found. Re-installing the application may fix this problem' is displayed. Download MFCDLL.zip, unzip and copy the files to 'SP5 >> Comm' Folder.   9. In 'Reports >> NSC Reports >> Certificates Purchased through Agent' form, an error message 'No transactions available for this day' is displayed even when transactions are available for the day. Download Reports2008.zip, unzip and copy the file to DBAnalyzer folder and run it once from the same location.   10. While viewing RD Passbook in Online module, an error message "Select error: attempt to bind to a non-existent column" is displayed. Run DBAnalyzer and click on the button "Version 6.6.1".

Fatal error in Sanchayapost

Solution1.Run latest DBAnalyzer. Select 'DBUtilities >> Check Database Consistency' option and run it for all databases
The problem relates to corrupted tables in the BPRO database. .
The first option is to restore a fairly recent backup in which the DBCC Checkdb command does not report errors and then to update the database with transactions for the subsequent days.

The second option is to run the query given by us through query analyser.This solution given may result in a certain degree of data loss proportionate to the corruption of data.The extent and amount of data loss cannot be determined before running the query. Run the query given below from SQL Query Analyser after taking a backup and after obtaining permission from your divisional \ regional offices and informing them of the data loss which might occur.

sp_dboption 'bpro', 'single user', 'true'
go
dbcc checkdb ('bpro', REPAIR_ALLOW_DATA_LOSS)
go
sp_dboption 'bpro', 'single user', 'false'
go

Fatal error in Sanchayapost

n one of our suboffice   an error is comming while taking withdrawal in SB, MIS, andNSC Encashment. The Screen shot of the error is given below.

Solution1.Run latest DBAnalyzer. Select 'DBUtilities >> Check Database Consistency' option and run it for all databases
The problem relates to corrupted tables in the BPRO database. .
The first option is to restore a fairly recent backup in which the DBCC Checkdb command does not report errors and then to update the database with transactions for the subsequent days.

The second option is to run the query given by us through query analyser.This solution given  may result in a certain degree of data loss proportionate to the corruption of data.The extent and amount of data loss cannot be determined before running the query. Run the  query given below from SQL Query Analyser after taking a backup and after obtaining permission from your divisional \ regional offices and informing them of the data loss which might occur.

sp_dboption 'bpro', 'single user', 'true'
go
dbcc checkdb ('bpro', REPAIR_ALLOW_DATA_LOSS)
go
sp_dboption 'bpro', 'single user', 'false'
go

 

source : sysadmin dop

Sanchay Updates 19.04.2012

Sanchay Post 6.6.1 all patches up to 19.04.12 (9 MB) available in the following link.


DOWNLOAD

The Error message displayed while running the Patch for SP User

The Error message displayed while running the Patch for SP User

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 )

ANNUAL INTEREST CALCULATION 2011-12 in V2 SBCO Software

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



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

Revised post office interest rates from 01/04/2012

Revised interest rates from 01/04/2012

view/ Download

SANCHAYPOST 6.6.1- Missing table Error

As per the release document in Sanchyapost 6.6.1 when we go for checking the missing tables option in Db Analyser. While checking the BPRO database I got an error. Two missing tables in BPRO database.The tables list is below

usp_indexing

usp_reindex

while discussing this matter with sdc chennai. They give a solution. An update exe.

Unzip the attached file and copy it to DBAnalyzer folder and run it from the same location. Then, once again check for missing tables using DBAnalyzer.

DOWNLOAD

Problem with Sanchay post 6.6.1

(Q) Transactions in BPL accounts cannot be done in sb form no 1309 i.e sb deposit?
Solution: Use the form number 1310 ECS-Debits and Credits

(Q) While accepting RD bulk acceptance (i.e for opening new acccount) a error comes?








Solution: Use RD bulk setup (rd form no:1110), Add new accounts to the agent, after alloting the number of account to the agent the number will be correctly displayed for the new account


Note: Correct procedure is not yet all given by SDC Lan, while doing new accounts to the agent, the number of accounts alloted to agent will automatically taken from General account number, thus those account become unallocated and you have to change the run number  from supervisor>>intilisation>>rd a/c , nominee, AT (form no0453). This step has to done for all agents and have to do daily

source:satirur.blogspot.in

sanchaypost new version 6.6.1

SANCHAYPOST 6.6.1

DOWNLOAD