Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / posting to closed year
Microsoft Dynamics GP (Archived)

posting to closed year

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I'm entering historical year monthly balances which were supposedly verified. After closing 2006, 2007 & 2008 it was noted that one JE in 2007 was incorrect.  I know that you can only post to one prior closed year and am also aware that MS can open a prior year for a price.  However,  I'm researching all options and am wondering if anyone has updated a closed year entry via SQL understanding that the YE close entry would have to be updated as well.  Would appreciate any thoughts.  Thx, Debi

*This post is locked for comments

  • Rich Mikolainis Profile Picture
    Rich Mikolainis 705 on at
    Re: Re: Re: Re: Re: posting to closed year

    That's what I thought, thanks Dan. Too bad the accounting department doesn't believe me. At least thats not too expensive.

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Re: Re: Re: Re: posting to closed year

    Then your only option is to go through Microsoft;.   If I recall is somewhere between 1 - 2K so not too much.  

    Dan Liebl | Senior Consultant | OTT,Inc

    dliebl@OTT-inc.com

  • Rich Mikolainis Profile Picture
    Rich Mikolainis 705 on at
    Re: Re: Re: Re: Re: posting to closed year

    All the previous years have been closed, its an existing company. This isn't a new company.

    I keep getting "'You cannot post more than one year prior to the first day of the earliest open year."

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Re: Re: Re: Re: posting to closed year

    You can import into prior years.   Just do not close until the trial balance for each year is tied out or all accounts validated.   You can have unlimited open years.    

    Dan Liebl | Senior Consultant | OTT,Inc

    dliebl@OTT-inc.com

  • Rich Mikolainis Profile Picture
    Rich Mikolainis 705 on at
    Re: Re: Re: Re: Re: posting to closed year

    I got the same error message. So if I want to import all our historical data from 2002 through 2009 (we are currently in fy 2011), we need to pay Microsoft or our reseller to do? Basically all we can do is import our beginning balances in 2010, then import as usual our GL data for 2011?

    ps..........I already went and unchecked everything in Fiscal Period Setup the "unclose" everything. (I am doing this in a test company first also!)

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Re: Re: posting to closed year

    [quote user="VictoriaYudin"]

    My 2 cents: if you absolutely positively need to do this, you will not save any money trying to do this yourself unless you have to do it constantly.  For most companies this is a one time deal and you are better off paying Microsoft to do this for you.

    [/quote]

    I have to agree with Victoria.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Re: Re: Re: posting to closed year

    My 2 cents: if you absolutely positively need to do this, you will not save any money trying to do this yourself unless you have to do it constantly.  For most companies this is a one time deal and you are better off paying Microsoft to do this for you.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: posting to closed year

    You are not missing anything... that has always been the case.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: posting to closed year

    When I attempt to enter the 2007 entry I receive the message 'You cannot post more than one year prior to the first day of the earliest open year.'  which has always been my understanding.  Is there something that I am missing and if so, could you explain?  As an added note the fiscal period is open and 'Allow Posting to History' is selected in setup.  The required correcting entry would be in Jan of 2007 and years 2007 and 2008 are closed.  Thanks for your input.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: posting to closed year

    You can always post to closed years, GP just does not roll the posting forward except from the one most recent year.  That means that you can make your 2007 entry, then make a like adjustment in 2008 (2008 will roll forward to 2009 assuming that 2009 is open).

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