Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Can we Undo Fixed Asset Closing for a certain year?

Posted on by 14,849

Dear 

The closing for the fixed assets module was done by mistake; is there any routine than run to Undo the closing ?

*This post is locked for comments

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: Can we Undo Fixed Asset Closing for a certain year?

    Hi Thomas

    thank you for your help, my only concern was not to run with any issues after i do the update on FA40200

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Can we Undo Fixed Asset Closing for a certain year?

    Hi Patrick,

    I just wanted to see if you have any additional questions on this issue.

    Please don't hesitate to ask, we are always happy to help!

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Verified answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Can we Undo Fixed Asset Closing for a certain year?

    Hi Patrick,

    Unfortunately, Dynamics GP does not have a Routine to reopen Fixed Asset year. If this is a case where it might have been closed twice in a row you would want to make sure that no depreciation was posted to the latest open year. If no depreciation has been posted you can update the FA40200 table. As you already note this is an unsupported method.

    Please let me know if I can provide any additional guidance on this issue!

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can we Undo Fixed Asset Closing for a certain year?

    https://community.dynamics.com/gp/f/32/t/74246

    "If you catch the fact that you closed 2 years instead of 1 before you have tried to depreciate anything, you can go into the table and change the current year using SQL. I was amazed to find out it was that easy." - Leslie

     

    if you have not Depreciated all assets through the last day of the current fiscal year and not performed the GL Posting (GL Interface) process you should be able to change the current year.

     

    Cheers!

     

  • Abdo Khoury Profile Picture
    Abdo Khoury 14,849 on at
    RE: Can we Undo Fixed Asset Closing for a certain year?

    i have run a fixed asset closing and the only field that i noticed updated is in table FA40200 field is CURFISCALYR

    if i update this field back one year will this be enough?

    note: i realize that the Microsoft doesn't recommend doing this from SQL but we don't have a backup option

    appreciate your feedback

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans