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”….

Previous

STRANGE ORDER FOR DEOs/VLEs FROM ADM(G)-HOOGHLY

Next

PRAYER FOR MINIMUM WAGES FOR DATA ENTRY OPERATORS (DEO) OF GPS

Subhrapratim De

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.