Armanino Blog
Article

Dynamics GP 10.0 year end close issue - 'GL_account_SUM_HIST_View'

February 05, 2009

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

Dynamics GP GL Year End Close SQL Maintenance>

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.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Women in Nonprofit Leadership Panel
Webinar
Aspiring nonprofit leaders should hear the insightful stories of these women industry leaders to empower their journeys.

December 14, 2021 | 10:00 AM - 11:00 AM PT
The Evolution of Gaming Companies
Webinar
From seed-funding to acquisition, position your gaming company for success.

December 9, 2021 | 01:00 PM - 02:00 PM PT