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