Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Year End Closing-GP2010

Posted on by Microsoft Employee

If you have never closed a year in GP2010 and need to start with the first year it was used (in this instance, 2012), do you change your system date to the date of last day of that period?  i.e.:  12/31/12?

Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Year End Closing-GP2010

    Thanks to iruser2 as well as Leslie and Bill!

    I appreciate the help.

    :-)

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Year End Closing-GP2010

    Hi Leslie, thanks for the reminder of the table lookup - I in my hast had forgotten the system will not allow you to skip years.  

    Thanks again.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Year End Closing-GP2010

    Hi Bill,

    I love it, you old dog!

    The system does read the date of the last closed year and closes the next year no matter what the system or user date may be. That's why you do not have to know the date of the year you are closing. In fact, you can't choose. Take a look at TWO, I think the only date it has closed is 2013. It won't let you skip ahead to 2015 and close that year without first closing 2014. Specifically, it looks at the value of the SY40101 table and picks the next year that is not closed - it's looking at the HISTORYR column. I went in and changed the data in SQL to see if I could confuse it, but it still picked the oldest unclosed year to close.

    Kind regards,

    Leslie

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Year End Closing-GP2010

    Leslie,

    We are old school for sure . . .

    So, you feel that the date of the close is not taken from the system, but from the end date of the fiscal period and that is good enough?

    I know that way back it was drummed into me to ensure posting to correct period you should change date.

    I will deferr to your considerable knowledge and research on the matter and will now reconsider.  But you know, it is almost impossible to teach a 'really old dog' any kind of new or better tricks, especially a 'male' dog . . . . my wife will kill me for that - but hey, live on the edge.

    Bill

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Year End Closing-GP2010

    Bill,

    I rarely disagree with you, but I do on this one. You know I'm about as old school as you can get, but I don't change either the user date - and especially not the system date - before closing the year. If the system is ever going to record the date it happened, I want it to be the real date. Not a big thing, but research-wise it might be helpful.

    Kind regards,

    Leslie

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Year End Closing-GP2010

    I am from the old school of thought and by default when I close a year I always change my user date to that end of year date.

    While it is not necessary - it is good practice.

    Advice on the balance sheet and P/L class for the COA is very good as well.

  • Verified answer
    iruser2 Profile Picture
    iruser2 2,046 on at
    RE: Year End Closing-GP2010

    No you don't need to change your system date.  As long as the fiscal year is set up properly the correct date will be used.

    Be more wary of checking to ensure that all balance sheet accounts are set and balance sheet accounts and income statement accounts are set as profit loss.  (smart list is a good tool for this).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans