Reset GL balances if GL EOM Roll is forgotten or done twice by mistake

If a user rolls the GL EOM twice or forgets to roll it forward or manually keys in a new period and then changes it back, the GL balances in the GLMAST are out of sync and/or all zeros. This is normally discovered when the user sees incorrect balances on the GL820- GL Trial Balance Report.

To correct it, we have to run several QDs.

Procedure: 

 1) CPYF GCMAST and GLMAST.

      Copy the files for safekeeping so we have a save of what they looked like before we did anything.

   Key in CPYF on the command line and F4 to Prompt it.

2) Next, have the user verify that NO users will be doing anything with journal entries, creating, editing and/or posting

    until further notice.

   Have  the user verify the company/district he is signed on as.

   Have the user verify the period/year of the last CORRECT PERIOD.

   Have the user verify the company/district of the FIRST INCORRECT PERIOD.

3) Run a GL820- GL Trial Balance Report on the current system so you have a BEFORE picture of the GL Balances

    You can also go into GL420-Chart of Accounts FM to display the account balances using F13-Display Actual

4) CALL GL445 to set the GL Period/Yr to the one you want to correct because once you key in the QD command there

    is no prompt to change it there (in QDGLMSTCL).   

5) When all of this is done, key in CALL QDGLMSTCL to correct the Balance Sheet accounts and press enter through the screens.

     (Note:  You can rerun the GL820- GL Trial Balance Report at this time to see if the balance updates or you can wait until you                    have  run the other two programs.)

6) Key in CALL QDGLPLCL to correct the P&L accounts and press enter through the screens.

7) Be careful on this last program because you have to key two fields and  and the period must be for the PREVIOUS PERIOD            FROM THE ONE YOU ARE FIXING

.So in this example, I am fixing period 03 and here I will key in period 02 because that is the previous period.

 key in CALL GL251CL to correct the Retained Earnings and press F4=Prompt.

 Key in the parameter as the Company number '01' two digits in single quotes.

And key in a + for Additional Parameters 

Then Page down 

Note: Getting to the next page was a problem so be sure to go to the GREEEN SCREEN and put in a + (plus sign) and then page down to get to the field for the second parameter!!!!

After paging down, key in the second parmeter for the period PRIOR to the one being fixed.

It should be two digits in single quotes.

For this example, I have keyed in '02' since it is the prior period to period being fixed which is 03. 

Also, notice the first parameter for company '01' carried over. Leave that alone.

Then press enter through the next screens to process the change.

8) Next, you can run the GL Trial Balance (GL820) and GL Balance Sheet to see verify the changes.

9) CALL GL445 to set the GL Period back to what it should be for the current period

10) Notify the user that they can run the GL Financial reports to verify the balances and if ok, let users resume normal GL               activity.

11)  Remember to delete the saved files B4gcmast and B4glmast after some time (maybe until the next month end                         is completed.