tag:blogger.com,1999:blog-3160669066424815487.post5584203609650737804..comments2024-03-29T05:21:41.514-07:00Comments on Dynamics GP Essentials: GP 2013 R2 – Reverse Historical YearMahmoud M. AlSaadihttp://www.blogger.com/profile/07632688723943735412noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3160669066424815487.post-83347067803453312602016-06-27T08:25:40.143-07:002016-06-27T08:25:40.143-07:00We have a lot of companies in our system and I onl...We have a lot of companies in our system and I only need to o the reversal in one company. Does everybody for all companies have to log off the system? barryhttps://www.blogger.com/profile/05034476740124980170noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-3284260443570855552016-03-31T00:51:14.067-07:002016-03-31T00:51:14.067-07:00Hello Christian
Technically speaking, this must be...Hello Christian<br />Technically speaking, this must be doable in prior versions too on the DB level, using SQL. I have provided some technical insight but has never tested it on prior version to check it validity. <br /><br />You might be interested in setting a test environment, and create the required SQL objects. <br /><br />If I had the chance to test this on the short-term, I will keep you posted.<br /><br />Your feedback is highly appreciated, <br />Best Regards, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-3585007764077794562016-03-30T15:47:15.433-07:002016-03-30T15:47:15.433-07:00Hi Mahmoud, I was checking out how to reverse hist...Hi Mahmoud, I was checking out how to reverse historical year in GP and I have a Question how can I follow this procedure in prior versions like GP2010.<br /><br />Could you please advise me how I can do this?<br /><br />I appreciate in advance your help<br /><br />ChristianChristian78https://www.blogger.com/profile/14083794127650245319noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-19018426805937634822015-02-10T08:47:04.741-08:002015-02-10T08:47:04.741-08:00I have a question about CLOSING & CHANGING FIS...I have a question about CLOSING & CHANGING FISCAL YEARS.<br />We recently changed our fiscal year to Calendar Year. You may also note that our fiscal Year ran from Oct 1, 2014 to Sep 30, 2014. On Sep 30, 2014 I ran the close year process.<br />Here are the steps we took:<br /><br />1) Make a backup of your data. <br />2) You cannot add open year data to a closed year - i.e. if you're changing from an Oct - Sep fiscal year to a calendar year, and you've closed your previous year, you can't add the Oct - Dec months to your closed year. You'll have to make the next year either 3 or 15 months long. <br />3) Years need to go in sequence, otherwise your report dates will be incorrect - i.e. if you called Jul 2011 - Jun 2012 the '2012' fiscal period, you should use an 18 month period if you want to change to a calendar year (instead of making a six month year 2013, then not having a name left for the calendar year of 2013). <br />4) Reconcile each year, (Utilities - Financial - Reconcile - Year). <br /><br />So we did that & It looks like it worked but when we tried to run our financials through FRX then the dates are all incorrect. Jan 1, 2015 is now showing Apr 30, 2015 & October 31, 2014 is showing January 31, 2015 financials.<br />I believed we need to close the year but when we tried to close it in Test Company it closed it as December 31, 2015. <br /><br />Are we missing a step somewhere?<br /><br />Please advise<br />Anonymoushttps://www.blogger.com/profile/17702625069943285014noreply@blogger.com