You’re offline. This is a read only version of the page.
Hello,
I am currently facing an issue where the user accidently run Fixed Asset Year End twice. Both 2015 and 2016 are closed when only intended to close year 2015. User has run Depreciation for year 2015 up to mid year. There is no backup thus restoration is not possible. Is there a way to undo FA Year End Closing?
Thank you in advanced.
Regards,
Vince
*This post is locked for comments
I have the same question (0)
Hi Vince,
Unfortunately, without a backup there is no real supported method to undo a FA Year End Closing. That being said I do have a unsupported method that would resolve the issue. If nothing has been done in the current FA year (2016) for the book you can do the following to reopen the year for the book. Please note this is a simple fix but it is not supported. If you use this fix you do so at your own risk. I highly recommend creating a backup of the company database prior to running through the steps below.
**Any testing of troubleshooting steps should be completed in a test company prior to a live company to verify the results.
871973 Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, or SQL Server 2012
[View:http://support.microsoft.com/kb/871973/en-US:750:50]
**Create a backup of the live database prior to running any troubleshooting steps on the live company.
1. Backup the company DB.
2. Run the following query against the company database to find the dex_row_Id needed. Replace XXX with the BookId.
select DEX_ROW_ID, * from FA40200 where BOOKID ='xxxxx'
3. Using the Dex_Row_ID from above run the following script. Replace xxxx with the year it should be set to and yyyy with the dex_row_id returned in the first script.
update FA40200 set CURRFISCALYR=xxxx where DEX_ROW_ID ='yyyy'
Again this is a unsupported method to reopen the FA Book year.
~Thomas Newcomb
------------------------------------------
Microsoft Dynamics GP Support
------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
Share
Report
All responses (
Answers (
1,810
