VERIFYING GPMS ENTRY AT ONCE (FOR THOSE WHO DOES THE GPMS ENTRY IN THE GP)

THIS IS FOR THE DEOs WHO MAKE THE GPMS ENTRY AT THE GP. ACCORDING TO ME THE MOST CUCUMBERSOME WORK IN GPMS IS VERIFYING THE TRANSACTIONS. SO HERE IS THE SHORTCUT METHOD BY WHICH YOU WILL BE ABLE TO VERIFY ALL THE TRANSACTIONS AT ONCE.

HERE IS THE STEPS YOU SHOULD DO

  1. AFTER COMPLETING AND CROSS CHECKING ALL THE TRANSACTIONS GO TO “UTILITY” MENU IN GPMS.
  2. CLICK “QUERY BUILDER”.
  3. CLICK “GENERATE SQL” TAB.

          NOW 

  PASTE THE EACH OF THE FOLLOWING LINES AND CLICK “EXECUTE”. NO MATTER WHICH MESSAGE YOU GET CLICK OK.

update texpenditure set varified=’Y’ where varified=’No’;

update tcollection set varified=’Y’ where varified=’No’;

update tbankadjustment set varified=’Y’ where varified=’No’;

update tbankdeposit set varified=’Y’ where varified=’No’;

update tbankwithdrawal set varified=’Y’ where varified=’No’;

update tchequeencashment set varified=’Y’ where varified=’No’;

update tledgeradjustment set varified=’Y’ where varified=’No’;

 

                        THATS ALL. YOU CAN NOW RUN “MONTH END”….

Subhrapratim De is a Data Entry Operator (DEO/VLE) under MGNREGA Scheme. He is working at the ground level (Gram Panchayat) since 2008 in West Bengal. He has strong background knowledge of computer system, network and operating system. He has knowledge of programming and databases too. Lastly he is a part time blogger.

1 Comment
  1. Totally Wrong Process . Pl. do not this wrong practice you have no right to verify any entry in this way. Remember any movement in GPMS automatically record in log file.
    pl. do this one by one. in front of EA & SEC.

    Leave a reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    DEO West Bengal