Friday, December 18, 2015

DM Utility 4.6-Failed to connect to database issue

Failed to connect to database issue in DM Utility 4.6. The problem has been fixed and the revised tool has been updated in the website.

Sharing *.exe files through google drive/gmail


  • Google drive allows to upload and share of "*.exe" files
  • But it could not be download by link due to security reasons of Google
  • Gmail should not allow uploading of "*.exe" files and also not allow to include google drive "*.exe" files as attachment


  1. Upload "*.exe" file to google drive
  2. Set sharing attributes to public
  3. Rename it as without extension. For example, "setup.exe" is your shared file. Then rename it as "setup"
  4. Include a text file to instruct downloading clients to rename it as "setup.exe" and then run it. 
for any queries mail to me: ""


New Features / Issues rectified and new features added

Point of Sale: 

New Features 
1. Incorporated the foreign tariff revision which is effective from 1.12.2015.
2. Incorporated the Swachh Bharat Cess.
3. Provision for adding mobile number while uploading bulk eMO files.

BNPL Parcel 

New Features
1. Swachh Bharat Cess @ 0.5% [As like Service Tax @14%] introduced and modifications done in the application to collect the SB Cess amount.


New Features:
  1. Configuration of Swachh Bharat Cess @ 0.5 % [As like Service Tax @ 14%] through Treasury Supervisor - Tools –Environment Option. 
  2. Provision for deducting the SBCess amount [As like Service Tax] from the amount being paid to the e-payment/COD billers through Treasury Payments.
  3. Modification in e-payment/COD Payment reports of the billers to show the SBCess amount deducted along with Service Tax from the amount paid to the Biller.
  4. Separate classification and accounting of SBCess amount collected for PLI/RPLI premia transactions done in POS module [wherever Service Tax is applicable] under the new account head 'sbcinsuranceser' with description 'SBC Insuran Ser' for the purpose of Daily Account/ Summaries/Cash book etc., [ Similar to 'ST Insuranc Ser']
  5. Separate classification and accounting of SBCess amount collected for mail transactions [wherever Service Tax is applicable] under the new account head 'sbccourierservs' with description 'SBC Courier Ser' for the purpose of Daily Account/ Summaries/Cash book etc., [Similar to 'ST Courier Serv']
  6. Separate classification and accounting of SBCess amount collected for Ebill/e-payment transactions [wherever Service Tax is applicable] under the new account head 'sbcbizauxser' with description 'SBC Biz Aux Ser'for the purpose of Daily Account/ Summaries/Cash book etc., [Similar to 'ST Biz Aux Serv']
  7. Modifications in POS submit account report to show the Swachh Bharat Cess amount collected towards mail/insurance/ebill transactions separately.
  8. While generating PLI/RPLI/EBill transaction files along with Daily account files at SOs through Floppy Upload option, additional field of SBCess is being captured to upload the data in Sub Accounts at HOs for fetching the same by Accounts PBS Module.

Sub Accounts:

New Features:

1) Provision for fetching additional column of SBCess while uploading daily account files of SOs at HOs through Floppy Upload option of PLI/RPLI/EBill text files for the purpose of Schedules.
2) Modifications for the purpose of Tally re-booked transactions of PLI/RPLI/EBill done at BOs.


New Features:
1) Configuration of AccountsMIS path in Accounts module for DAP Cashbook.
Do the following configuration, if not configured in the Accounts General module.

a. Select My Office -> environment -> Office Particulars.
b. Enter DDOCODE, if not added.
c. Select the AccountsMIS path through browse (DAPcashbookPath)
Ex: \\System Name\AccMIs\Data.
2) Provision for configuration of SBC for each and every PLI/RPLI policy for pay recovery.
Do the following for modify the existing policy
a. Login pay bill module -> Employees -> Registers -> Recoveries -> Other than Loans and advances -> select PLI/RPLI click -> select Modify -> select policy and update the policy details. Service tax and SBC will be calculated automatically based on Date of Acceptance.
Note: If Policy details are not updated then PLI /RPLI recovery details will not be updated.

AccountsPBS (Schedules):

New Features:

1. Automatic calculation of PLI/RPLI Swachh Bharat Cess for first year premium @ 0.12% and renewal premium @0.06%.
2. PLI/RPLI SBCess amount fetching from Subaccount and counter
3. Modification in PLI/ RPLI service tax report which shows Swachh Bharat Cess amount recovered.
4. Separate report for PLI/RPLI service tax.


New Features:
1. The issues / bugs reported in earlier version has been modified tested and new exe is prepared.

Installation / Upgradation Procedure of MM v7.9.4

General Instructions

  1. Please ensure that the applications are upgraded to Meghdoot Version 7.9.3
  2. Please take backup of all related databases after completion of the day’s work before proceeding for going for up-gradation of this update. 
  3. Up-gradation should happen preferably at the end of the day after completion of Day’s work.
  4. Please follow the below procedure for upgrading individual applications in the same order.


  1. Replace the existing ePaymentClient.exe with the new ePaymentClient.exe in installation path.
  2. Upgrade the eCounter database by running epayment exl file available in the ePayment folder.

Point of Sale 

  1. Rename the existing Pointofsale.exe and copy the downloaded Pointofsale.exe in the installation path.
  2. Upgrade the Counter database by running Counter.exl file using the script tool.
  3. Copy the EbillHOLib.dll to the Point of Sale Client installation path and register the file.
  4. Copy the Cash.Dll to the Point Of Sale Client installation path and register the dll file.
  5. Copy the WNX.Dll to the Point Of Sale Client installation path and register the dll file.
Note: Separate Point Of Sale exe is provided for McCamish rolled out offices where PLI transactions will not be available.


  1. Rename the existing Treasurer.exe and copy the new Treasurer.exe in the same location.
  2. Run the Treasury07122015.exl using the script tool.

Sub Accounts

  1. Replace the old Subaccounts.exe with the new SubAccounts.exe in the same location. 
  2. Run SUPPLYSUBACCOUNTS07122015.exl using script tool.


  1. Rename the existing PBC_Project.exe and copy the new PBC_Project.exe to the application installation folder.
  2. Run BNPLPARCEL794_1.exl and BNPLPARCEL794_2.exl using script tool.


  1. Replace Accounts.exe with the new one.
  2. Replace CashBook.dll with the new one and register the dll file.
  3. Run Accounts24112015.exl file using the script tool.

Accounts PBS

  1. Replace the old schedule.exe with new schedule.exe in the same location.
  2. Run schedule04122015.exl file using script tool.
  3. Run schedule14122015.exl file using script tool.

MO Compilation

  1. Replace the old MOCompilation.exe with the new one.
  2. Run MOCompilationVer7.9.4.exl file using script tool.

Special Campaign under Swachh Bharat Mission from 18th to 27th December, 2015 in Post Offices

No. 18-41/2014-Bldg
Government of India
Ministry of Communications and Information Technology
Department of Posts
(Estates Division)
Dated: 17th December, 2015
All Heads of Circles
Sub: Special Campaign under Swachh Bharat Mission from 18th to 27th December, 2015.
Respected Sir/ Madam,

As you are aware, Government attaches great importance to the need for improving cleanliness including in the Government offices. Under Swachh Bharat Mission, Circles and field units have been undertaking Action Plan for furthering the cause of cleanliness. Futher, special focus needs to be given to the regular cleaning and proper upkeep of office premises, review and weeding of records and disposal of obsolete and unused items as well as repair, paining and sprucing of the street letter box and Post Office signage etc. Digitization of records and documents would also ensure tidy workspaces.

Now Government of India had decided to observe a Special Campaign in all Ministries/Departments from 18th to 27th December, 2015. Accordingly, a day to day Action Plan for the said Special Campaign is enclosed compliance.

The undersigned is directed to request you to forward Action Taken Report (attached) from time to time as mentioned therein as per the enclosed format including through email( You are also requested to forward some good photographs of before and after action taken for uploading in social media and website. 
Yours faithfully,

(K.R. Sharma)
Director(E & MM)
Encl: (i) Action Plan


Special Campaign (18th to 27th December 2015)

Action Taken report to be sent by date
Cleaning of all  Post Offices(Departmental building)/RMS Units/Postal Staff College/Postal Training Centers(PTCs)/PSDs
18th to 27th   December 2015
28th  December 2015
Cleaning of Post Offices (Rented building) & RMS Offices
21st to 27th December 2015
28th December 2015
Cleaning of Branch Post Offices
18th to 27th December 2015
28th December 2015
Cleaning of Administrative Offices
19th, 20th & 23rd to 26th December 2015
28th  December 2015
Cleaning of Postal Colonies
26th and 27thDecember 2015
28th December 2015
Review & Weeding of Old records and obsolete/unused items with due procedure

19th to 24th December 2015
28th December 2015
Meeting for raising awareness of their Postal Staff (Post offices/RMS/Administrative Offices.
19th , 20th December 2015 and 23rd to 26thDecember 2015
28th December 2015
Display banners on ‘Special Campaign’ in Circle Offices/Regional Offices/ Major Head Post offices & major RMS units.
By 20th December 2015
21st December 2015
Joint cleaning of the surroundings of Postal units with Local authorities.
23rd & 24th December 2015
28th December 2015
Digitization of POSB and PLI/RPLI records
18th to 27th December 2015
28th December 2015
Tree Plantation
19th, 20th  & 24th, to 27th December 2015
28th December 2015

Action to be taken by CGM: Uploading of photographs of Special Campaign drive with field unit on Social media and website of the department.

Analysis and Recommendations of 7th Pay Commission on House Rent Allowance

Allowances related to Housing : House Rent Allowance (HRA) : Presently, HRA is payable at the following rates:
There are a large number of demands for paying HRA as a percentage of (Basic Pay + DA), instead of as a percentage of Basic Pay alone, as at present. Representations have also been received regarding enhancement of percentage rates and having only two classifications of Metros and Non-metros (instead of the present classification of X, Y and Z cities).

PBORs of uniformed forces have vehemently argued for doing away with the concept of Authorized Married Establishment and the requirement of a minimum age of 25 years for grant of Compensation in Lieu of Quarters (CILQ).

Analysis and Recommendations: Compensation towards the housing needs of Central Government employees is covered in three ways:

1. As a component of Basic Pay when it is initially fixed (based upon the Aykroyd formula)
2. As a constituent of Dearness Allowance [the AICPI(IW), on which the DA is currently based includes a weight of 15.27% towards housing], and
3. In the form of House Rent Allowance

In view of the fact that the DA calculation methodology that is being followed does include a certain weightage for housing, the demand to pay HRA as a percentage of Basic Pay + DA is not justified.

To arrive at the appropriate rates of HRA, the Commission used a two-fold approach: (i) It compared the rise in housing compensation with the cost of housing in major X, Y and Z category cities over the period 2006 to 2013, and (ii) It compared, de novo, the HRA after the rise in Basic Pay proposed with representative house rents in major X, Y and Z category cities.

For (i) above, the table of comparison (for a hypothetical employee whose Basic Pay was Rs.1000 in 2006) is given below:

As is clear from the above table, compensation for housing in 2013 was 1.79 times that in 2006 for Class X cities, 2.07 times for Class Y cities and 2.92 times for Class Z cities.

During the same period, the weighted (by population of cities) average rise31 in housing index for Class X cities was 1.69 times, for thirty most populated Class Y cities it was 2.10 times, and for twenty-five most populated Class Z cities it was also 2.10 times.

Thus, it can be safely concluded that the rise in housing compensation has largely kept pace with the rise in rental values in all categories of cities.

However, if a zero-based comparison of HRA with house rents is carried out the Commission observed that today there are websites that give a good idea of the prevalent house rents in various cities. From the information available on the websites, it was observed that with the increase in Basic Pay proposed (and consequent rise in HRA with the rationalized percentages), most of the employees will be able to afford a rented house as per their entitlement.

The Commission also took note of the link between increase in HRA and increase in house rent. There was a sharp rise in the index from the first half of 2009, immediately following VI CPC recommendations. The All India House Rent Index32 chart given below demonstrates this:

Considering all these factors, and in line with our general policy of rationalizing the percentage based allowances by a factor of 0.8, the Commission recommends that HRA should be rationalized to 24 percent, 16 percent and 8 percent of the Basic Pay for Class X, Y and Z cities respectively.

However, the Commission also recognizes that with the current formulation, once the new pay levels are implemented, the compensation towards HRA will remain unchanged until such time as the pay and allowances are next revised. Going by the historical trend this event is likely to be a decade away. Some representations have been received stating that towards the later part of the ten year period the HRA compensation falls considerably short of the requirement. Having regard to this, the Commission also recommends that the rate of HRA will be revised to 27 percent, 18 percent and 9 percent when DA crosses 50 percent, and further revised to 30 percent, 20 percent and 10 percent when DA crosses 100 percent.

Currently, in the case of those drawing either NPA or MSP or both, HRA is being paid as a percentage of Basic Pay+NPA or Basic Pay+MSP or Basic Pay+NPA+MSP respectively. HRA is a compensation for expenses in connection with the rent of the residential accommodation to be hired/leased by the employee and is graded based on the level of the employee, and therefore should be calculated as a percentage of Basic Pay only. Add-ons like NPA, MSP, etc. should not be included while working out HRA.

Keyword: HRA, House Rent Allowance, 7th CPC HRA, 7th CPC House Rent Allowance, 7th Central Pay Commission, 7th CPC Report, HOUSE RENT ALLOWANCE