Smart Pension Setup

SMART PENSION (SINGLE FILE SETUP – RE-POST)

All New software for Pension Automation.  Fully advanced, hassle fee & user friendly tool to manage all most all pension works.

System Requirements:

• A trouble free, smoother running, well maintained machine with
• Operating System Windows 2K or Higher. WindowsXP recommended
• A Minimum of 256 MB RAM, 512 MB recommended.
• MS SQL Server 7.0 or higher
• 130 Column Printer (Wipro 1040+, Wipro  LQDSI 5235, TVS MSP 345 or similar)

Download SmartPension Setup

SMART PENSION UPDATE UPLOADED ON 09.07.2014
SMARTPENSION FORM16 - PART B UPDATE  AS ON 08.03.2015

1.      Please download the attached ZIP file ‘PensionSetup.zip’ (Required Broadband internet connection).

2.      Download and Copy this file to the target machine (at first Choose a machine with SQL Server Installed, This is required, to create Database and other initial settings). Unzip and Double click (execute) the ‘PensionSetup.exe’. Please follow onscreen informations to complete the installations.

3.      Installation process is fully automatic. Setup will create all initial working environments, including new Database, DSN, and other settings. In Multiple SQL Server environments, setup will choose the default available server for DSN. When starting application from Client, if it is not starting, please check the DSN and name a correct server that you are using.

4.      You must install a copy of Smart Pension in your server machine, because DATABASE CREATION procedures are included along with the setup. During the final stage of installation ‘New Database Creation’ wizard will appear. This wizard will help you to create Pension Database. For test purpose you can also load sample data during this process.  You can also start this wizard from Smart Pension Program Group at any time after installation. Please cancel this wizard during client installations.

5.      After Database Creation wizard finishes it’s job, Setup will also start the Data Migration tool – a tool which help you to migrate your pension data from Microsoft Excel to SQL Server. A Microsoft Excel Template file is provided for this purpose.  You can open this file from the Smart Pension Program Group for later use.  This is a specified format file for the migration purpose and the format should not be altered. 

6.      Copy your pension details from your existing excel file and paste the same into the specified format file correctly.  Please note that certain ‘Comments’ (a red indication will be displayed in the top right portion of the cell) in the column labels of Excel sheet. Please read & understand all comments provided. Columns for Certain Codes are provided, namely PTYPE & PMODE. PTYPE is for pension type i.e. 1 for Service Pension and 2 for Family Pension.  PMODE is for Payment Mode, i.e. 1 for Through Bank, 2 for Money Order Board’s Cost and 3 for Money order Pensioner’s Cost.  Up to Column NP is considered as Basic Pension Details.  You can migrate to SQL server with these details. 

7.      Details such as Designation and Category are optional, but are required for printing Budgetary Control forms.

8.      Address details are optional for printing Money order forms and Pension Certificate, etc.

9.      It is a good idea to enter these details in the template file and migrate to SQL Server.  Because after migration process you have to update these details in PPO Number wise. i.e. Select one PPO and Update details, then select another PPO and so on.

10. Optionally you can do migration partly, i.e. in first part with basic payment details (columns up to NP) and Second part (for address details) with columns, PPONO, Name, Designation, Category, HName, Place, PO, PIN filled. Select the ‘Update Address only’ Check Box for this purpose. How ever before doing this (2^nd Part) you should migrate basic pension payment details. i.e. the first part should be done in advance.

11. The Software is password protected. Due to security reasons the password is not published here. Please ring to 9496804046 or mail at ashtami@sify.com for the default password. Please change your password in the first use for security.  You can also add additional users in the user settings screen.

For more information and support kindly contact me:

P.N. Manoharan, CA, Civil Circle, Pallom, 9496804046, ashtami@sify.com. Please be specific in your queries.

 

Thanking You

P.N. Manoharan

Ashtami, Vaikom.

 

Smart TA Bill - TA Bill Preparation Tool - Updated

Smart TA Bill - Updated

An Application for preparing TA Bills for Officers (TR 47) & Staff of Kerala State Electricity Board.  Program is now updated with Full Month activity preparation view and Importing Progress Report directly from Excel file with a Specified format.

How to Use:

1. EMPLOYEE DETAILS

1.   Before you start using TA Bill, Please furnish your ARU Settings and Office lists in the Settings Screen.

2.   Select the Month & Year of TA Bill to be prepared.

3.   Enter the PIN (Must be a Number) of an employee and furnish the following informations correctly:

a.       Name of Employee

b.      Office

c.       Category

d.      Designation

e.      Pay

f.        Scale of Pay

All these informations are required.

2. ACTIVITY DETAILS

4.   Next select the Activity Mode. It may be JOURNEY or HALT. Alternatively you can select from the previously prepared activities.  This will automatically fill the FROM, DESTINATION, KM, and RATE columns automatically.

5.   Enter Starting Date and Time.

6.   Enter Starting Location, Select Conveyance, Enter Purpose, Destination, KM and Rate.

7.   Enter Reaching Date and Time.

8.   Enter DA (limits will be displayed) and Click Add. If you are correcting an existing activity details, then Click Update instead of Add. You can also use Delete option to delete an existing Activity record.

9.   Repeat the steps 4 to 8 for adding more activity details.

Note: Activity Details Now include Full Month activity View: This will help to mark the following Activities quickly:    Attended Office, Leave, Holiday, etc

3. BILLED EMPLOYEES

10. Each billed employees will be added to this list.  The list is filtered for the selected month and year. However you can click the SHOW ALL EMPLOYEES button to list all Billed Employees. To quickly load the Details of an employee, you can Check ( Tick mark) that employee and Click the SELECT FOR BILL ENTRY (You can also enter the PIN and press Enter Key to load the details of an employee). To take outputs check all the employees who are included in the printouts.

4. OUTPUTS

11. Check the Employees list and Click following options for output:

a.      Progress Report                        -           to Print Progress Report

b.      Pint Bill                                      -            to Print TA Bill.

c.      Print Outer                                -            to Print TA Bill outer.

d.      Print Abstract                            -           to print Abstract of TA Bill.



DOWNLOAD SMART TA BILL UPDATED SETUP


Existing Users can Update by clicking the following link
Update Smart TA Bill (28.06.2016)

For more information kindly contact me.

Manoharan P N

Ashtami, Vaikom

9496804046