Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Fixed Asset Import and Depreciation

(0) ShareShare
ReportReport
Posted on by

Multiple assets were entered manually after which I used the Fixed Asset Import utility to import Book information.  YTD and LTD balances were imported through Nov 2015 and the depreciated to date was imported as 1130/15.  I processed depreciation for prior years through 11/30/15.  I then attempted to depreciate the Dec 2015 only.  It appears to process but when I go through the GL Posting routine I receive a message that 'There are no transactions matching these restrictions'.  The records in FA00904 show 4 entries for each asset all related to the prior period depreciation; 2 debits and 2 credits resulting in net depreciation of zero.  The only thing that I see that could be an issue is none of the asset cards have a Yearly Depreciation Rate. Any help appreciated.

*This post is locked for comments

  • Suggested answer
    Heather Roggeveen Profile Picture
    9,146 on at
    RE: Fixed Asset Import and Depreciation

    No, that doesn't need to be imported during the process.

    Have you tried running a projection - that could be worth doing - it would at least show whether anything was going to calculate ever!

    Tools --> Routines --> Fixed Assets --> Projection

    Do a date say 1 year from now.  Run the process and then go to the reports area to print a report.

    Reports --> Fixed Assets --> Projection

    The projections are pretty reliable - if you get a report with depreciation amounts - then that is what will depreciate for the periods indicated - if you don't get any values, then depreciation won't run either.

    If you get nothing, maybe you could post a screenshot of one of the assets - I might be able to spot something.

    Cheers

    Heather

  • Community Member Profile Picture
    on at
    RE: Fixed Asset Import and Depreciation

    Thanks for the response Heather.  All of the suggested fields are correctly populated which should include depreciation.  Just to restate since I think it's note worthy.  This is the first month we are attempted to depreciate in the system.  Do you know if the Yearly Depreciation Rate field on the Book record should have been populated during the import/macro?

  • Suggested answer
    Heather Roggeveen Profile Picture
    9,146 on at
    RE: Fixed Asset Import and Depreciation

    Hi

    So the system uses a number of factors to determine whether an asset should be included in a depreciation run - all of the factors need to apply.

    - Depreciated to date - if the depreciation date is greater than the depreciated to date, it can be included.

    - Remaining Life - the asset must have a remaining life to be included.

    - Fully depreciated flag - the must be N.

    - Depreciation method - anything other than No Depreciation.

    - A Net book value.

    Check your assets for all of these fields.

    Cheers

    Heather

  • Community Member Profile Picture
    on at
    RE: Fixed Asset Import and Depreciation

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans