Site::Finacle Site McCamish McCamish ECMS McCamish FileNet MostUsed::CBS Just for Info SBCO Utility Sanchay Post POSB Calculator

Any Queries related to Post Office(s)/ Latest Updates / your ideas can share with PoTools via

Feb 9, 2016

R Net Communication Error "The Microsoft.Jet.OLDEB.4.0 Provider is not registered on the Local Machine"

While running R-NET communication from client machine it is asking for Point of Sale folder path. However while trying to browse for the same the network does not show the SERVER. I tried to run the R-NET communication from the server itself but the following error is being displayed :MSJET OLEBDB4.0 is missing or not registered on the local machine. When I tried to look for the same in the SYSTEM 32 folder, it is not available. The O/S is WINDOWS SERVER 2003 (64 bit). 


  1. Error "The Microsoft.Jet.OLDEB.4.0 Provider is not registered on the Local Machine" occurs when R Net Communication is installed on Server (i.e. Server OS) 
  2. From following link please download the Microsoft Jet OLEDB Engine for your Operating System and install where R Net communication is installed. 

Features of Rural ICT Handheld Device Supplied to Branch Post Offices

As a pilot phase Department of Post has started using solar powered, biometric hand-held devices in rural post office with connectivity along with the application software in selected circles viz. Bihar, UP and Rajasthan. This move was the outcome of Rural ICT project declared by the Government of India.

Following re the important features or benefits of Hand-held device supplied to Branch Post Offices.

1. Electronic transactions- Booking and delivery of Speed Post, registered mail, money orders, sale of stamps and postal stationery will be done through these devices and paper receipt shall be generated

2. Instantaneously thereby eliminating chances of overcharging and other problems associated with manual transactions. Savings Bank deposits & withdrawals, PLI/RPLI premium deposits and loan/claim payments will also be done electronically on these devices.

3. Immediate uploading of transaction data and financial reconciliation- Using mobile connectivity, data pertaining to all transactions done on the hand-held devices shall be uploaded onto the central server. E-Money order will reach the destination post office instantaneously unlike present day where the money order is digitized at the nearest computerized Post Office and leads to delay in delivery. All financial transactions shall also be reconciled immediately without any manual intervention and Cash on Delivery amount collected in the village shall be immediately credited to the account of e-Commerce Company. Similarly the artisans would be able to fulfill e-commerce orders and receive immediate payment for their sold products online. This will have a positive impact on the overall economy of the villages.

4. Automatic track and trace- Speed Post and Registered letters/parcels and money remittances will be trackable at the Branch Post Office level and booking/delivery information will also be uploaded to central server immediately.

5. Fraud and leakage elimination- As Savings Bank and Postal Life Insurance transactions will be done on a real-time basis and through immediate generation of receipt and voice message, chances of fraud would be eliminated. Biometric authentication of MNREGS and social security beneficiaries at the time of pay-out would also reduce leakage in the schemes

6. Post Offices as Common Service Centres- Branch Post Offices shall be able to work as Common Service Centres and offer services such as Railway Reservation, online bill payment for electricity and water utilities, mobile and DTH recharge, insurance policy premium payments & transactions for partner banks/insurance companies/mutual funds etc

MNOP Hub Updation in Speed Net for receipt / despatch of Bag

The Nation Speed Hub (NSH) details not found in Receipt & despatch of bag in Speed Net Module. CEPT is advised to download and update the Hub details in Speed Net as given beow.

Please do the following and check: 

a) Download the office master file of respective circle (viz., North East and your Circle) from SPCC Office Configuration site (can also be downloaded from -> Tools -> Download Master Data with default login credentials) and update this data using SpeedNet Communication -> Tools -> Update Office Data option -> browse and select the downloaded file to update the office data. 
b) Under Supervisor -> Master -> Offices -> Add Additional Offices -> Click on "UPDATE OFFICES DATA" button. 
c) Download attached zip file and unzip it.
d) Take full database backup of POSPCC database .
e) Run SpeedNet_MNOP_HUB_UPDATE_29012016.exl file using Meghdoot ScriptTool.exe 
f) Check the script execution log file and if script is executed successfully then check the Closing of SP Bags option

Download Speed MNOP Hub Update 29.01.2016

Special postal covers on Gandhi's life events released

To commemorate various events in the life of Mahatma Gandhi, the postal department today released four special covers for philately lovers. 

The covers, designed by Alok K Goyal, who runs the online stamp shop www.Stamps-n-stamps.Com, are based on the route to India followed by Gandhi in 1914 from South Africa, arrival in 1915, last meeting with Netaji Subhash Chandra Bose in 1940 and Gandhi attending the second Round Table Conference in London in 1931. 

Mit Kumar, Deputy Director of India Post, said "It is an excellent initiative in commemorating 76 years of Netaji's last meeting with Gandhiji along with other special covers."
  1. These covers have been issued in a very limited number of 1,000 each. 
  2. The covers are affixed with different materials like canvas, wool, silk, wood, etc. 
  3. Earlier in October 2015, the department had issued two covers during the West Bengal Philatelic Exhibition (Daker Saaj 2015). 
  4. Goyal said they have tied up with the postal department to release a total of 33 such postal covers, each one marking different events in Gandhi's life.

BO name correction in CSI BO Mapping Tool


Office Name Correction in CSI BO Mapping Tool 

If you found any Branch Office Name Correction in CSI BO Mapping Tool do the following to correct the BO Name.

Steps to Correct BO Name through HDMS

Please see the PIN code of these offices as available at India Post PIN code directory at
If any Addition / Deletion / Correction is required, the same is to be incorporated in the PIN code directory. 
1. For Addition / Deletion / Correction in PIN code directory, please provide the information in the proforma available for download at duly signed by the Divisional Superintendent by raising a ticket in"PIN & Office Modification" module of HDMS 

7th Pay Commission Matrix Calculator from 01.01.2016

New Basic Pay - 7th CPC news

7th Pay Commission Pay & Allowance Calculator

Enter Band Pay
Select Grade Pay
Select HRA
Select TA

Calculation on 7th CPC Recommendations as on 1.1.2016

Your Basic Pay
Your Pay Matrix Level
Your Index Level
Your HRA
Your TA
Your Revised Pay
Thank you - Admin, PoTools

Print the above calculation report using below link

NJCA Decided Indefinite Strike From 11th April 2016



Meeting of the National Joint Council of Action (Railways, Defence, Postal, Confederation) held on 08th February 2016 unanimously decided to serve indefinite strike notice on 11th March 2016 and to commence indefinite strike from 11th April 2016.

Further details will follow.
Secretary General
Confederation of
Central Govt. Employees & Workers

Coaching Class for IPO Examination at Chennai


Shri. P.Karunanithy, Supdt. of Pos (Retired) will conduct coaching class for five days from 20.02.2016 to 24.02.2016 for ensuing IPO examination at Chennai as detailed below:

Venue: Rajiv Gandhi Memorial Telecom Training Centre, next building to Meenambakkam Post Office Chennai 600 27
Subject to be taught
CCS (Conduct) Rules, FR & SR, Pension, Leave and TA
CCS (CCA) Rules, 1965
 All Law subjects of Paper III
GDS matters, SB matters, FHB Vol I & II

1. The candidates can come by bus or electric train. stop is OLD AIRPORT BUS STOP OR MEENAMBAKKAM RAILWAY STATION.

2. Fees: Fee for coaching class Rs. 300/- per day
Hostel Accommodation fee Rs. 200/- per day
Meals and Tiffin around Rs. 150/- per day 

3. Separate accommodations are available for male and female candidates.

4. Coaching classes will be conducted from 0930 hours to 1700 hours.

5. Study materials will not be available in the coaching class. Study materials at serial numbers 1, 4, 5, 14, 17, 18, 19, 20, 21 and 22 from the list of IPO exam books are necessary in the coaching class. The candidates are requested to attend the coaching class with note book, pencil and pen.

6. The candidates are requested to obtain the study materials by post from Jeevajegan Publishers, No. 5, Moovendarnagar East, Madurai Reserve Lines Post, Madurai 625 014.

7. The candidates are requested to inform the following the particulars early.
(a) Name, male or female, designation and Division
(b) Whether the candidate wants accommodation for five days
(c) Whether the candidate wants accommodation on the previous day on 19.02.2016

Willing candidates are requested to send a SMS regarding above particulars in Cell No: 94433 29681 early.

Further details please contact Shri. P.Karunanithy,B.Sc., Supdt. of Post Offices (Retired), No. 5, Moovendar Nagar East, Madurai Reserve Lines, Madurai 625 014. 
(Cell number : 94433 29681).

Empanelment of Writers in Philately Division of Department of Posts

Empanelment of Writers in Philately Division of Department of Posts who are interested in writing on the subject matter of the stamp

F. No. 33-1/2015-Phil
Government of India
Ministry of Communication & IT
Department of Posts
(Philately Division) 
Dak Bhawan, Sansad Marg
Dated 08.02.2016 

Advertisement for Empanelment of Writers in Philately Division of Department of Posts

Department of Posts issues Commemorative Postage Stamps on various subjects, themes, institutions, personalities, events, etc. With the release of Commemorative Postage Stamps, this Department also issues Brochures and First Day Covers. A brief write up of about 700-1000 words on the subject matter of stamp and technical data is included in the Brochure. Specimen of brochure is enclosed.

2. Philately Division, Department of Posts invites applications from individuals who are interested in writing on the subject matter of the stamp. The suitability of the applicants for the job will be judged based on their credentials and work experience such as published work, articles, write-up in Newspapers and Magazines, etc.

3. The Remunerations will be paid as per the prescribed rates of the Department of Posts as given below:
Work assigned
Brochures writing (both in English and Hindi)
Commissioning fees
Adoption Fees
Rs. 1,700/-
Rs. 5,000/-

4. The format of the application is enclosed herewith. Complete application should reach within 10 days from the date of the publication of this advertisement to the following address.  

Director (Philately),
Department of Posts,
Room No. 332, Dak Bhawan,
Sansad Marg,
New Delhi – 110001.
e-mail :

Click here to download the Application Form and other details

Feb 8, 2016

India Post releases booklet

Member (Planning), Postal Services Board, Shekhar Kumar Sinha, going through the booklet 'Aikya' brought out by India Post along with the First Day Cover and Commemoration Stamp on the International Fleet Review-2016 in Visakhapatnam on Sunday.—Photo: C.V. Subrahmanyam

India Post that released a First Day Cover and stamp to commemorate the International Fleet Review 2016 has gone one step ahead and published a booklet on the relevance of the event.

Releasing the booklet – Aikya – at a function here on Sunday, Member (Planning) Postal Services Board Shekhar Kumar Sinha appreciated the efforts taken by Visakhapatnam Post Master General Sharda Sampath and her team on putting together the information and photos on previous Fleet Reviews conducted in India and also the first edition of the International Fleet Review conducted in 2001.

The Philatelic Department had taken up activities beyond simple publication and sale of commemorative stamps and first day covers, he said.

The Philatelic Bureau was organising an annual letter writing contest for students in October. The India Post was asking the principals of schools to organise regular letter writing competitions to help in character building of students.

The wait for letter to be delivered once it is posted helps inculcate patience, secondly once the letter is in the post box one has to have faith in the Postal Department this inculcates a value of trust among the students, Mr Sinha explained.

He called upon the philatelists and philately organisations to actively encourage the next generation to take to the king of hobbies – Philately – and disseminate their passion to the next generation, he said.

Post Master General Visakhapatnam Region Sharda Sampath explained the efforts that went into compiling the book and acknowledged the cooperation of Command Education and Welfare Officer Commodore Amit Vikram, Captain Dorai Babu and Commander Murthy in getting the official information on past events.

While the underlying theme of IFR was unified through oceans marking unity among the navies, the organising of the event played a major role in bringing together different government departments, Post Master General Vijayawada Region M. Sampath remarked.

The booklet not only carries information on the event but also has a crossed stamped First Day Cover, it is available at the Philatelic Bureau outlets in the city.

Member (Planning) Postal Services Board Shekhar Kumar Sinha appreciates efforts taken by Visakhapatnam Post Master General Sharda Sampath and her team on putting together the information and photos on previous Fleet Reviews conducted in India and also the first edition of the International Fleet Review conducted in 2001

36 lakh central govt. employees to go on indefinite strike from March 10

Over 36 lakh central government employees including Railways, Postal and Defence will go on indefinite strike from March 10, against NDA-led BJP government’s anti-labour policies.

Mr. Shiva Gopal Mishra, General Secretary, All India Railwaymen’s Federation and Convenor, India Railwaymen’s Federation (AIRF) said that the Central government is not according any priority to resolve long pending demands of its employees.

Railway employees will go on strike on February 11 & 12 to press their long pending demands.

Source :

NCCPA National Secretariat meeting at New Delhi on 07.02.2016

The National Secretariat meeting of the NCCPA was held on 07.02.2016 at New Delhi in library hall AIRF. Chairman Comrade Shiv Gopal Mishra, Com. KKN Kutty, SG and other members of Secretariat were present. 

The meeting discussed about the present situation after submission of recommendations by 7th CPC and formation of ECoS under Cabinet Secretary 

Com. KR, GS, AIPRPA and Comrades H.L.Sidhu (Treasurer); I.S.Dabas (ASG) also represented AIPRPA in this meeting.

Postal Directorate writes to DDG (Tech) to solve difficulties of employees in CBS/CIS migrated offices

Department starts acting on the letter written by SG, NFPE to Hon'ble Minister Communications & IT regarding untold sufferings by the staff of CBS & CIS roll out offices
Letter No.10-01/2016-SR dated 03.02.2016

CEPT Solution for Invalid Column Name

Sub Account Error invalid column Name 'sbcbizauxser'
  1. Up-gradation to Meghdoot 7.9.4 is not done properly at the PO as mentioned in the Release document. 
  2. Treasury database upgradation (In General-Upgradation to any meghdoot Update) has to be done at the end of the day's work at the PO. Otherwise, it can be done after doing day begin in Subaccounts /Treasury applications on the next day morning. 
  3. This may not be followed at the PO while doing Up-gradation to Meghdoot 7.9.4. Hence, the issue. Run the Treasury07122015.exl file of Meghdoot Update 7.9.4 once again to settle the issue from today onwards. 

MM Modules connection write error and Solution

While accessing the MM Application it may shown the error message like Run-time error '2147467259(80004005)' : Connection write (Wrapper write error).
The above error due to non accessing the databases from its application. please do the following to recover the database.
1.Update your system with latest updates for windows and SQL. 
2.Delete the old records after taking backup. 
3.Shrink the database using the utility available in ftp. 
4.Run the following query after taking backup of counter database. 
ALTER DATABASE counter SET SINGLE_USER dbcc checkdb ('counter',REPAIR_REBUILD )

Non Updation of Status of Meghdoot v7.9.4 in Parcel Net MIS


Solution for Status upgradation of MM 7.9.4

Some of the offices were listed in Non Updation list under ParcelNet MIS due to the some technical issue. If MM7.9.4 upgraded successfully and need to update in Parcel Net MIS , do the following which is given by CEPT.
  1. Please ensure that your office details configured in r net related modules are same as your office details available in r net central master data as the RNet Communication software communicates with the Server based on the pincode, nd code and Office Type selected in Point of Sale. 
  2. Please login to ...Go to Other Reports -> Offices Not Upgraded to Version 7.93 on the "click here" hyper link to download the zipped file containing the scripts to be run. After downloading, unzip the file and run the scripts using the script tool . 
  3. Please see the MIS next day morning. 
If the upgrdation status is still not updated,

please send copy of R Net Communication folder and PoS office details configuration screen through google drive for analyzing the issue. 

Book of Information 2013-2014 - Department of Posts


DOP Book of Information 2013-14

Browser setting for Viewing documents from McCamish


1.Adding URL in Trusted Sites:

Step 1: Go to “Tools” à “Internet Options”
Step 2: Select“Security”tab and then select “Trusted Sites”. Click “Sites” button.
Step 3: Uncheck the “Require server verification (https :) for all sites in this zone”, if it is checked. 
Step 4: Add following URLs in the “Add this website to the zone” one by one.
Step 4: Click on Close

2.  Paste the below URL on address bar and then enter.
Step 1: Go to “View” à “Webpage Privacy Policy”.
Press “ALT” + “F” on the keyboard if “Menu Bar” is not available

Step 2: Select any of the dms URL and click on ‘Summary’
Step 3: Select the option ‘How should cookie be handled as ‘Always allow this site to use cookie’. Click OK
Step 4: Click on ‘Setting’ button:

Step 5: Reduce Privacy setting to Accept all Cookie.

Step 6: Click OK and Close browser and reopen with PLI McCamish URL to view the documents from McCamish if required.

eDarpan, January 2016, news letter from CEPT is published

e-darpan, January 2016, news letter from CEPT is published for information of employees of the Department. The news letter contains the following
  • Bulk Closure of Complaints
  • Auto Status Updates for Complaints in CCC
  • Meet the Programmer Video Conference.
  • Release of Post Info 1.3
  • Release of Meghdoot 7.9.4
View /Download the news letter January 2016 edition

Latest CSV Uploading Process - PLI/RPLI McCamish


1. Pre-requisites for successful file upload: 

1) Pay Deduction and Meghdoot cash files are to be uploaded separately. If a single file has policies for pay deduction and cash, the policies will be reported in error. 
2) The PAO code of the pay deduction file should be correctly updated in the pay deduction file.
3) Prior to uploading Pay Deduction file, collection for the special group should be done through the collection module. 
4) Naming convention to be followed before uploading any file, so that any particular file can be identified easily. Every file should be named as ‘Office name_Schedule month_PAO Code (PAO code or Meghdoot)_XX(running number from 01).csv 
5) Every file, should be restricted to 1000 records, so that the files can be processed quickly thereby reducing the waiting period.
6) In Case of pay deduction file upload the policy should be a part of the special group, any policy which is not a part of special group will be error out. Special group search to be done before creating a new special group. 
7) In cases of Death, Maturity, Surrender, Survival claims it is advised to ascertain the premium in the respective policies and in case premium has been either deducted through pay deduction or entries are present in PRB, then the user first makes use of File upload functionality to upload the premium and once the premium is updated in McCamish the user indexes the above said claims. 
8) The policy statuses supported in the file are: AP, VL, IL and PM.

2. Out of scope functionalities 

1. Loan repayment will not be handled through bulk upload 
2. Policies for which service requests like Death claim and surrender requests have been indexed will not be handled, unless the requests have been withdrawn 
3. For pay recovery policies, if any extra amount is collected by DoP, then the same will not be uploaded by the csv once these validations are effective. 
4. Excess premium related validations are effective only on the new uploads. Any extra premium which is already uploaded in the system will be handled either through collection screen or through excess premium while doing any claim calculation.

3. Collection – Pay Deduction

Ø Click on the collection icon on Dashboard

Ø On the collection screen, select the ‘Special Group’ radio button and then select the ‘Renewal’ radio button
Ø Search the special group for which collection has to be made
Ø Select the schedule month and enter the payment details
Ø Click on the submit button to complete the payment for the special group
  • If Payment made through Cheque then select Cheque/DD

  • If Payment is through Book Adjustment (PLI Recovery Schedule given by Accounts branch) then select 
  • Book Adjustment
Ø Once the collection for special group is made, the user can upload the Bulk Pay Deduction file

4. Pay Deduction File upload 

Ø The user can upload the pay Deduction and Meghdoot file from the ‘Bulk Policy Upload/Group Policy Maintenance’ icon present on the system administrator’s dashboard.
Ø Two options will be provided to the user to go ahead with the file upload process, 

1. Special Group Number – If the user clicks on special group search and enters a special group number, the load file screen along with the transaction details of the special group will appear. 

From here the user can upload the pay deduction file. 
2. Office code - If the user enters the office code and clicks search, then the user can upload the Meghdoot file.

4.1 Process for Pay Deduction File Upload 
Ø Search the special group by name or number. 

Ø The transaction details of the collection made against the special group will appear in a grid below. 
Ø The user can proceed to upload file by clicking on the Load File Screen button.

Ø On the load file screen the user has to enter the billing dates and upload the pay deduction file which has to be in CSV format only. 
Ø On clicking the submit button, the upload file request will be submitted and a confirmatory message will be displayed to the user. A batch process will process this file. 

Ø The user can view the historical files by clicking on the View History button. The status will be changed from pending to complete once the batch is executed. The upload, success and error files can be viewed by clicking on the hyperlinks respectively.

  • All the policies which are not migrated and are uploaded through the file will be kept in a separate error file at the end of the day. 

5. CSV Uploading for Cash Policies 

Ø To upload Meghdoot file, the user has to search by office code. 

Ø The load file button will appear, on clicking the button, the user will be taken to the file upload screen. 

Ø The user can upload the Meghdoot file which has to be in CSV format only. On clicking the submit button, the CSV file upload request will be submitted. 

Ø The system will do UI validations on the file and throw errors for the impacted rows. 
Ø A batch process will upload and process the collections mentioned in the CSV file. 
Ø The user can see the historical files from the History tab.

6. UI Validations 

  • When the user uploads the file, the system will do the initial checks of the file and throw errors for the incorrect records. 
  • System validations will be made for all the mandatory fields. If any mandatory field is left blank or the format is incorrect, a validation message with the error description and the corresponding row and column will be shown on the screen.
  • The file will not be uploaded until all the validations are corrected and records are updated. Once all validations are clear then the file will be uploaded and a message will be shown that the file is successfully saved. 
  • For Pay recovery policies system will match the total amount for the group in suspense against the total premiums in the file. If the suspense amount is less than the total of premiums in the file, then a validation message will be thrown – suspense amount, total amount in group collection suspense is less than the total premiums in the file. 
  • This file will be in pending status only till the batch will process these payments.

7. CSV fields and UI validations

 Field Name
Acceptable formats
UI Error messages
Conditional Mandatory
Mandatory if the file belongs to special group policies
Policy number cannot be blank
Only alphabets
Premium amount can’t be blank
dd-mm-yyyy dd-mmm-yyyy
From date can’t be blank/
Invalid date
dd-mm-yyyy dd-mmm-yyyy
TO date can’t be blank/
Invalid date
Total receipt Cann’t be blank




dd-mm-yyyy dd-mmm-yyyy
Date_transaction can’t be blank/
Invalid date
Transaction date can’t future date
P - for Pay
C - for Cash
Transaction Type cannot be blank


Can be null or numeric
1. If transaction date>= 1 Jan 2015 and either FY tax or Renewal tax is not updated, then error message to be displayed- Service tax is required
2. If data type is other than numeric – Only numeric value accepted
Can be null or numeric
1. If transaction date>= 1 Jan 2015 and either FY tax or Renewal
Conditional Mandatory
(Required if first year tax/renewal year tax is present)
1 for first year tax
2 for renewal year tax
3 for first year as well as renewal year tax
1.If FY tax/Renewal tax is updated and Tax Type is blank, then display error message - Tax Type is required
2. If data type is other than numeric – Only numeric value accepted
1. If the file format is of more than 28 fields, then display message – Invalid file. This will be a UI validation. 
2. The total receipt will be inclusive of total premiums + Interest – Rebate 
3. McCamish does not calculate if rebate/interest is correctly calculated. The system matches the total premiums + interest – rebate with total receipt and returns error if this amount is not found matching. 

4. If the total number of records in Meghdoot file are more than 1000, then an error message will be shown – ‘Maximum number of records to be uploaded should not be more than 1000’.

8. Batch Validations

Error Description
Payment Record Creation Error
When the amount field is other than acceptable values like 'Null' or '0' or a decimal this error would come
Payment Record Creation Error
When there is any issue with the format of date field this error would come. Acceptable date format is DD-MMM-YY or DD-MMM-YYYY or DD/MM/YYYY or DD/MM/YY
Policy Not Available
If policy number is missing
PaidToDate does not match with From_Date
From date is not match with policy, paidtodate +1
Invalid Policy Status for Applying Premium
Policy status is not PM, AP, AL
Policy not Part of given Special Group
Policy not Belongs to the Special Group
Feed File Premium Amount or Total Receipt is zero
Amount Paid Is Zero
Feed File From_Date or To_Date is null
Feed File i.e. from_date or to_date is null
From_Date is not First Day of month or To_Date is not last day of month
From_Date is not First Day of month or To_Date is not last day of month
Total_Amount not matching with interests and rebates
TotalAmount in Feed file is less than Actual TotalAmount calculated from Application
Error creating PendEvnt
System related errors
Error updating PendEvnt
System related errors
Error updating Suspense
System related errors

8.1 Other Error messages 
1. If the amount of service tax is incorrect, then display error message – Service tax amount incorrect. This will be done in batch processing. 
2. If tax type 1 is updated with renewal tax and tax type 2 is updated with first year tax or if tax type 3 is updated with first year tax or renewal year tax, then display error message – Tax Type incorrect. This will be done in batch processing. 
3. If the total receipt amount does not include service tax, then update error message in the file as – Total receipt amount does not include service tax. 
4. The Meghdoot / Bulk upload batch will do validations on the uploaded file to check if any excess premium is uploaded.
5. In case of excess premium, the record will be rejected and the policy record will be updated in the error file with the following error description – “Total Premium is more than the frequency premium”. 

9 Service tax related changes 

> New columns to be added for Service Tax and Sales tax in Meghdoot Upload File and Bulk Upload File. The file template which can be downloaded from the screen to be changed. 
> The last three columns of existing file will be utilized for these 3 new fields. 
> Either Service tax or Sales tax column to be validated if the Transaction date(Receipt Date) is after 1 Jan 2015 
> Value in this column needs to be saved in Data base without any calculations involved if uploaded through Meghdoot Upload 
> No Accounting will be done for the service tax/sales tax if uploaded through Meghdoot. 
> For Bulk Upload, service tax/sales tax amount should be calculated and validated as per issue circle and rate mentioned as per the upload date. 
> The total_receipt column in the file should include the service tax component as well. 

Error message to be updated in the file if the total receipt amount does not match. 
To upload service tax and sales tax through upload file, the file format will be modified and three new columns will be added- 
1. First Year Tax 
2. Renewal Year Tax 
3. Tax type 
The validations for these fields are covered in Section 8. 

11 Excess Premium Validations 

11.1 Existing Business Process 
According to the current business process if the user uploads extra premium through the csv upload, the required premium amount is adjusted towards the premium for the months selected and the rest is kept in policy suspense. 
This suspense amount will be used when the user tries to pay future premiums through collection screen. If no further premium payment is made then this amount is shown as excess premium when the policy is settled towards claims. 

11.2 Problem Statement 
Many times users are uploading excess amount through csv upload. There are various reasons for this error: 
1. User mistake while uploading files when incorrect amount is entered 
2. Extra premium uploaded when policy frequency is changed 

11.3 Proposed solution 
To stop uploading excess premium from the csv, new validations will be built in the batch. If any excess premium is entered in the file which is more than the frequency premium, then the record will be rejected in the batch. 
An examples is mentioned below to upload the file in the correct manner: 
1. Policy no - R-TN-TC-EA-288371 
2. Paid to Date – 30-JUN-2006 
3. Policy Issue date – 1-APR-2006 
4. Frequency 
§ Monthly - 01-OCT-04 to 30-JUN-15 
§ Quarterly from 01-JUL-15 
5. Monthly Premium - 164 
6. Frequency Premium - 491 

The above mentioned policy has two frequencies since it was migrated as monthly policy and then it got converted to quarterly. 
To upload the premium for this policy correctly, user should create two records in the file. One record will have premium record for only monthly premium payments. The second record should have only quarterly premium payment record. 
Ø For the record with only monthly premium. ‘To Date’ and ‘From Date’ should be selected accordingly. The total premium (Total Receipt) should be equal to the number of months multiplied by the monthly premium amount. 
Ø To upload the quarterly premium, user should create another record and the select the ‘To Date’ and ‘From Date’ based on the quarterly frequency. The premium amount should be equal to the number of quarters multiplied by the quarterly premium. 

In the example --- 
Monthly premium is Rs.164 and no. of months to be updated are 108. So in total receipt column 164*108 = Rs.17712 will be updated. 
Similarly when quarterly premium has to be updated, the quarterly premium amount which is Rs.491 is multiplied by the number of quarters. Hence it is 491*1 = Rs.491. 
Ø This similar method will be used when premium frequency is half-yearly or annual. 

12 Transferring from one special Group to another special group 

Ø In case the special group of the policy is changed, the same can be updated in the system by the pay Deduction file. 
Ø The premium collection should be done on the new special group and the file should be uploaded using this group number only. 
Ø The new PAO code can be entered in the pay deduction CSV file and the system will change the PAO code of the policy.

PoTools Followers

Some Important Tags at PoTools

.Net Removal Tool ( 2) .Net setup ( 3) Aadhar Software ( 5) Accounts ( 17) accounts error ( 9) Accounts MIS ( 8) accounts PBS ( 7) AD Rollout ( 10) Adware Removal Tool ( 4) Allowance ( 11) android indiapost ( 19) Annual Property Returns ( 6) antivirus ( 27) Atal Pension Yojana ( 14) ATM ( 16) Bhuvan India Post ( 5) BNPL ( 16) BO Account verification Tool ( 2) BO Tag ( 7) Bonus News ( 18) Bootable USB ( 6) branch office ( 5) BSNL ( 6) Bulk eMO Payment ( 1) CBS ( 108) CBS Addon ( 14) cbs dataentry ( 2) CBS Migration ( 15) CC Bridge ( 2) ccleaner ( 9) Central Government Employees ( 17) CEPT FTP ( 6) Certificate ( 4) Child Care Leave ( 4) Children Education Allowance ( 3) Chrome Addon ( 5) Circular and Orders ( 8) COD ( 83) Collection of SB Orders ( 8) Config file generator ( 3) Data Profiling Tool ( 35) DB Tools ( 8) DBA Updater ( 10) DBAnalyzer ( 69) despatch ( 28) despatch error & Solution ( 29) Discrepancies tool ( 25) Discripencies tool ( 1) DOP Browser ( 3) DOP Clients Configuration ( 4) dop news ( 29) DOP Order ( 26) DOP Tools ( 27) Downloads ( 3) drivers backup ( 5) eMO ( 38) eMO Client ( 21) ePayment ( 28) ePayment Cheque ( 4) ePayment error ( 7) ePayment updates ( 2) ePost ( 13) finacle ( 268) General ( 67) Greetings ( 6) IMO ( 10) Income Tax ( 23) India Post ( 60) interest calculator ( 12) interest Posting ( 16) interest Rate ( 10) Internet Explorer ( 7) McCamish ( 71) MM 7 Update 8 ( 12) MM 7 Update 9 ( 44) MM Update ( 19) MM Update 7.9.3 ( 17) MM Update 7.9.4 ( 6) MM Updater ( 12) mm7.3 errors ( 24) MO Compilation ( 4) Mobile Money Transfer ( 5) Mobile tracking ( 4) Negative List Updation ( 18) New Pension Scheme ( 5) New Services ( 2) newupdate ( 118) NREGAEMO error ( 5) Parcel Net ( 33) passbook printer ( 10) Pay Commission ( 356) Payments Bank ( 13) PDF Converter ( 1) PLI Calculator ( 9) PO Tools ( 54) point of sale ( 39) POSB Calculator ( 14) Postman ( 79) postman error ( 42) printer ( 23) PT Tools ( 8) R Net Communication ( 29) RD Customer Package ( 2) rd Deposit error ( 3) Recruitment ( 20) RNet Communication ( 9) Sanchay Post ( 62) Sanchaypost error ( 27) SB46 Intimation tool ( 7) SBCO Utility ( 43) sdc updates ( 10) Signature Tools ( 13) softwares ( 22) SOSB Tools ( 8) SP Patch updater ( 34) SPCOD ( 37) Speed Net 4.1 ( 9) Speed Net 4.1.1 ( 9) Speed Net 4.2 ( 49) SpeedNet error ( 22) Speednet update ( 24) SpeedNet Update Status ( 3) speedpost tariff revision ( 4) SQL 2000 Suspect ( 8) SQL and windows ( 37) sql backup ( 9) SR Tools ( 16) Sub Account ( 19) sub accounts ( 9) Supplementary ( 5) Swachh Bharat Service Tax ( 5) symantec ( 14) sysadmintools ( 9) System Utilities ( 6) tariff revision ( 4) TDS Software ( 6) Tool for Holidays 2014 ( 3) Tool for Holidays 2015 ( 2) Tool for Holidays 2016 ( 6) Transfer ( 9) treasury error ( 12) usefulpost ( 110) VP Intimation ( 8) Weblink ( 33) windows 2003 server update ( 8) windows error ( 10) windows troubleshooting ( 43) Windows XP ( 10)

Google+ Followers

CBS Migration Update Zone : Exclusively for System Administrators

Any Queries related to Post Office(s)/ Latest Updates / your ideas can share with PoTools via

Contact Form


Email *

Message *

Useful Forms

Total Pageviews

Live Users