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
- AFTER COMPLETING AND CROSS CHECKING ALL THE TRANSACTIONS GO TO “UTILITY” MENU IN GPMS.
- CLICK “QUERY BUILDER”.
- 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”….
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.