Showing posts with label Softwares. Show all posts
Showing posts with label Softwares. Show all posts

Wednesday, 16 July 2014

Tool for registering DLL files




Whenever Meghdoot patches are installed, we need to register the DLL files replaced. Here is a tool created from the coding provided by Mr. Nordin Rahman. The original coding is not known.

All OCX,DLL,TLB files in a directory can be registered/unregistered.
Courtesy : http://srfix.blogspot.in/

Thursday, 3 April 2014

POSB Interest Calculator - updated - 01/04/2014)

http://sapost.blogspot.in/

(Last updated - 01/04/2014)
Click Here to Download


Features in this File:
        Updated on 01/04/2014:
  • New Interest rates w.e.f. 01/04/2014 configured for RD, TD schemes. Old interest rates can also be calculated by entering the concerned Date of opening 
  • RD PMC Calculator link is added in the Main page of Calculator.
  • Option for calculation of "Maturity Amount for Discontinued/Extended RD accounts" is provided in RD-View more Link.
  • "Print Tables/Forms" link is provided in Main calculator page to Print Ready reckoner tables for RD/TD/MIS and Pamphlet, Forms. (Ready reckoners and tables have been updated for new interest rates w.e.f 01.04.2014)
  • Changes have been made for PMC of TD accounts before 1 year.


      Updated on 12/05/2013: (As per suggestion/request received from users)

  • In SCSS "View more" link, Initial partial interest and Final partial interest payable (for fraction of days) according to the date of opening will be displayed in addition to the quarterly interest payable for SCSS deposit. For SCSS PMC also, final partial interest applicable will be displayed. 
  • Possibility of extension of SCSS account will be displayed along with the interest rate applicable for such accounts. 
  • To calculate maturity amount of Discontinued/Extended RD accounts, option has been included In RD "View more" link, and the the same will be displayed if 5 years completed. 
  • Navigation link to "Home page" has been uniformly placed in all pages at bottom.
    
     Updated on 28/04/2013:
  • "MIS Total Interest" shown in the table for Today's date (i.e.,Date of Opening is not entered and left as blank cell) has been corrected for 60 months instead of wrongly calculated 72 months in old calculator. 
  • (But, If you enter Date of opening in MIS, it will correctly calculate "Total Interest" for 60(or)72 months according to the entered Date of opening, even in old calculator)
  • "PPF Loan/Withdrawal" calculation link and "MIS to RD Automatic credit Maturity" calculation link have been included in main table; 
  • Welcome message will be displayed at the bottom of calculator (according to the time of opening calculator file)
Updated on 15/04/2013:
  • In the Link "PPF Interest Calculation", Provision has been added to find out Eligible Loan and Withdrawal amount that can be taken in PPF account.
  • In the Link "Print Tables/Forms", Claim Forms for SB/SC and Application for Reinvestment of Maturity value, and Interest Rate Table (in Tamil) and link to access "Indiapost Forms page" are included.
Updated on 01/04/2013:
  • New Interest rates w.e.f. 01/04/2013 configured for all schemes. 
  • Old interest rates can also be calculated by entering the concerned Date of opening 
  • RD PMC Calculator can be downloaded from RD "View More" link
  • "Print Tables/Forms" link is provided in Main calculator page to Print Ready reckoner tables for RD/TD/MIS and Pamphlet, Forms.
Updated on 06.11.2012:
  • Validation for KVP Date of Purchase (Now Date can be entered only from 01.03.2003 to 30.11.2011)
  • Feedback form modified.
Updated on 31.10.2012
  • Option for Entering Date of Opening of Accounts
  • Their Respective Maturity/Interest Amounts, A/c periods, Date of maturity,etc.,
  • Current status of A/c for Closure/PMC/extn., etc.,
  • Reduced Int. for TD, Bonus, Deductions, PMI details,etc.,
  • KVP discharge value calc,
  • SB,PPF,PMI calc,
  • PPF approx maturity value calc,
  • Easy Initialisation of Interest rates for schemes, if changed...
  • Option to download the latest excel calculator (if any), right from this excel file itself...  
Prepared by :
M. Dhamotharan, CDL,

POSTING OF INTEREST ENTRIES FROM SANCHAY POST TO V2SBCO

This  tool  is  intended  for  posting  the  interest  entries  generated  in  Sanchay  Post,  to V2SBCO  database files.  This tool should be used before the SBCO data is upgraded to the next financial year, but after generation of annual interest in V2SBCO software.

Download(Size : 25MB)

PoTools(Google Drive)

Download

SDC Chennai:(Dropbox)

Preparatory Work

  1. Take a backup of SBCO files.
  2. Regular process  for generation of  annual  interest  in V2SBCO should be  done upto IBB calculation. Upgradation Process in V2SBCO should not be done at this stage.
  3. View  the  reports  to  check  whether  interest  is  generated  in  V2SBCO  using  the  option Reports > Annual Reports. If interest is generated in V2SBCO then continue the below mentioned  steps  otherwise check  the  reason  for  non-generation  of  interest  with  the V2SBCO software technical person for solution.
  4. Take a print out of Interest (63) report  in V2SBCO  before proceeding further  without fail for future reference. 

Interest Posting Procedure


  1. Unzip SP2V2IntPosting.zip and run the setup.exe to install the tool.
  2. Enter Sanchay Post Server name, SQL user name, SQL password and click on OK.
  3. Enter the SBCO folder path and click on OK.
  4. If any error is thrown in step  2  or step  3, verify the correctness of  data  entered  in the respective fields. 
  5. Select the Sanchay Post Office Name and its respective V2SBCO office name.
  6. Click on Start Posting. 
  7. After  the  message  showing  completion  of  postings  is  displayed,  ensure  that  the  error report  is checked  by  clicking  on  ‘View  Error’  button.    The  error  report  will  list  the accounts for which interest is  not posted.    Take a print out of the error report  separately for each office for future reference.
  8. Steps 5,6 & 7 should be repeated for each office.
  9. Take a print out of Interest  (63) report  in V2SBCO  and compare with the report printed earlier, to check whether Sanchay Post interest entries are posted in V2SBCO database. 

Upgradation of V2SBCO data to next year

After completiong of posting interest entries from Sanchay Post for all the offices, V2SBCO data should be upgraded to next financial year. 


Source: aisbceuchq.blogspot.in