web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Fixed Asset Table(s) R...
Microsoft Dynamics GP (Archived)

Fixed Asset Table(s) Restore

(0) ShareShare
ReportReport
Posted on by Jim Lines 4

Hi Again,

I ran a back up of the production database before my client ran depreciation on Fixed Assets.  The results were not as hoped and I need to restore the FA tables that were affected.  I can't do a full restore because they waited 3 hours before the ran depreciation and re-entering transactions is not an option.  Can anyone tell me which tables need to be restored?  The did NOT post through the GL (thankfully!!!).

Thanks in advance!

Jim

 

*This post is locked for comments

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,633 Moderator on at

    FA00200 (Asset Book Master) and FA0902 (Asset Financial Detail Master) are the tables that store depreciation records.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    FA00902 missed a zero

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Frank,

    Are any of these tables updated by the depreciation run?

    If any assets were acquired or sold, additional accounts may be involved.

    FA00903  FA_Summarize_Financial_DTL_HIST

    FA00904  FA_Financial_DTL_WORK

    FA00905  FA_GL_Interface_WORK

    FA01000  FA_Transaction_Source_MSTR

  • Verified answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,633 Moderator on at

    Leslie, the only one of those tables I've ever seen anything populated in is FA00905, which contains the GL Posting details.  Those records are overwritten each time you run the GL Posting Routine.  Based on Jim's original post, it sounded like he just wanted to restore the depreciation tables, but I may have misunderstood his intent.

    Thanks for pointing out my missing character in the FA00902 table!

  • Verified answer
    Jim Lines Profile Picture
    Jim Lines 4 on at

    Frank & Leslie, Thanks so much for your continued help.  You guys are great!  To be on the safe side I restored all of the Fixed Asset tables since there are not a lot of them.  We ran the depreciation after that and it came out correct.  Turns out that the client was running depreciation as of 8/31/2013 instead of 2012.  The are in their 2013 fiscal year and she just had a brain fart.

    Thanks again!

    Jim

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans