Announcements
No record found.
Hello,
I have a client that setup 2012 as 01/01/2013 through 12/31/2013.
How can I correc this? Did I mention they are on Great Plains 7.5?
*This post is locked for comments
You can simply go back to Setup->Company->Fiscal Periods and change the dates to 01/01/2012-12/31/2012 and then go to Utilities->Financial->Reconcile.
Now hopefully they have not posted anything into those periods. That would be a separate issue with which to deal.
Thanks for the reply,
We tried that and got "This date is not in the fiscal year". We tried this in the starting date and got the error then for each fiscal period and got the same error.
There was one GL transaction for 2012 that they tried to post. It posted to 12/31/2010 which is the last day of the most recent closed year.
OK, that makes sense since 2012 was defined as 01/01/13-12/31/13. Can you reverse that one entry that went to 2010?. Change the dates on FY 2012 and run reconcile. After you do that you should be able to post into 2012 with 2012 dates.
Thank you,
My issue now is that I cannot change the dates on FY2012 becasue of the error I mentioned. "This date is not in the fiscal year." I cannot manually change the dates in the fiscal period setup window.
You should be able to change this date and then click Calculate. Do not try to change the individual dates.
Still cannot:
"The date cannot be part of a different fiscal year"
Now I see what is the problem.
Step 1) Wait until all users have exited this company
Step 2) Backup your company database
Step 3) Run these scripts against your company database
delete sy40100
where year1=2012
delete SY40101
where YEAR1=2012
Step 4) Go back to Setup->Company->Fiscal Periods and set up FY 2012 with the correct dates
Step 5) Run Utilities->Financial->Reconcile.
You will still have that one J/E that went into 2010 to offset.
You may also need to add
delete sy40102
delete SY40103
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
