• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
DEOWB_LOGO_192X192

DEO West Bengal

The DEO Education Channel

  • Home
  • New Updates
  • Tutorials
  • ORDER
  • PAYMENTS
  • ISGP
  • UTILITY
  • Videos
You are here: Home / PAYMENTS / VERIFYING GPMS ENTRY AT ONCE (FOR THOSE WHO DOES THE GPMS ENTRY IN THE GP)

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

April 30, 2012 by Subhrapratim De

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

Filed Under: PAYMENTS

Reader Interactions

Comments

  1. A. majumder says

    July 18, 2012 at 1:15 pm

    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.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Footer

About Us

DEOWB (Data Entry Operators - West Bengal) was started in 2009 as deowestbengal.wordpress.com to help all the DEO/VLEs working under MGNREGA schemes. With times things have changed to this. If you are a DEO/VLE, you are at the right place. This is the ultimate DEO Education Channel..!!!

Social

  • Facebook
  • YouTube

© 2009–2023 DEO West Bengal