Dynamics GP 10.0 year end close issue - 'GL_account_SUM_HIST_View'

Ran into this yesterday and thought I'd post it as I didn't see any tech docs anywhere on it.

A client updated from Dynamics GP 8.0 to 10.0 in October. The client was just closing out the 2008 year but ran accross the following error message near the end of the close just before the report should print.

A get/change first operation on table 'GL_account_SUM_HIST_View'. Followed by "Number of results columns doesn't match table definition" after you click OK.

All the rows had moved from GL20000 to GL30000. The fiscal year period setup was not updated to be a historical year. Neither was the last close date adjusted to the new year in the GL Year End Close window under routines.

Here is the recommended approach to fix this issue:

1. Restore backup before year end close was attempted
2. Go to Dynamics GP>>Maintenance>>SQL
3. Choose the company database
4. Highlight Account Summary Historical View
5. Check off all boxes to the left (See screen shot below)
6. Run Tools>>Utilities>>Financial>>Reconcile on all years, starting with oldest first
7. Rerun year end close routine
8. Verify all BS balances have update and all P & L accounts have closed out to RE

>

If you don't have a backup to restore to you should be ashamed of yourself. Here is an alternative approach I used at first until I decided I'd be more conservative and restore from a backup first.

1. Back up company database
2. Check off historical year in the fiscal period setup window
3. Update LSTCLSDT in GL40000 to be date desired (12/31/2008 in our case). Script would be something like Select * from GL40000. Should only be one row in table. If so then use this script: UPDATE GL40000 SET LSTCLSDT = '12/31/2008'.
4. Go to Dynamics GP>>Maintenance>>SQL
5. Choose the company database
6. Highlight Account Summary Historical View
7. Check off all boxes to the left
8. Run Tools>>Utilities>>Financial>>Reconcile on all years, starting with oldest first
9. Rerun year end close routine
10. Verify all BS balances have update and all P & L accounts have closed out to RE

This second approach doesn't give you the normal report after the year end close since all the rows are already moved to GL30000.

Don't know what caused the issue. Guessing it's because of the upgrade. Maybe the GL10111 table got corrupted somehow. It happened on every company until we did the above process.