I had a weird one the other day. A client called up and said their year end close was a foul. The year end close report indicated it did not tie out. I stopped them immediately from processing and had them restore to a backup and we tried it again. Same issue. I’ve seen a lot of issues relating to year end close but not for a while. I remember in older versions of GP if you double clicked on the close year button it would close out two years. The funniest year end close thing I ever saw was someone closing out four years, and didn’t have a backup. We had to contact MBS to open the years back up for them at a high price tag.
So after verifying the numbers looked correct on the TB I decided to bring in MBS to look at it and they scratched their head a bit and finally admitted this was the third time they’ve seen it this week. The year end close actually processed correctly but the report was off.
After troubleshooting the cause MBS thinks they have it figured out.
Here is the fix MBS sent to me.
In our testing, it looked like the GL40000 (GL Setup) table is not consistent with what you see in the General Ledger setup window.
If you have ever selected to close to divisional account segments and clicked OK, the DIVACTSG field in the GL40000 table is updated.
If you then go back into the window and uncheck the option to close to divisional account segments, the table does not get updated and still holds a value other than 0 in the DIVACTSG column.
To correct, please run the following update statement and try the year end close again on your TEST system and you should hopefully find that the issue is resolved:
update GL40000 set DIVACTSG = 0
Many users probably won’t notice this until they go to close out their year in January. This client upgraded to GP 2010 a few months back and they have a late fiscal year end so ran across the issue early.