Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Fixed Asset books and ...
Finance forum
Suggested answer

Fixed Asset books and their respective depreciation

Posted on by 43

Dear Microsoft D365 finance community

I have two questions around fixed assets.

QUESTION 1

I have created three books one for the GL straight line one for Federal depreciation rates and one for State deprecation rates - please see below for the state and regular GL books.

I have set up the derived books under the Straight line deprecation book.

pastedimage1637717389966v1.png

pastedimage1637717565908v2.png

Based on this configuration you can see that the FEDS and STATE books are not calculating deprecation at 200 declining balance.  Instead it is at straight line.

Any ideas what I may be doing wrong?  

pastedimage1637717767371v3.png

QUESTION 2

Below you can see how I have configured the  STATE book.  I have set the book to calculate deprecation and I also have it to post to the operating layer.

My question is do I need to post to the GL to get the deprecation to work on the STATE and FED books.  I just need to be able to run the fixed asset book compare report to get all the information I need.  I do not necessary need it to go to the GL under a different posting layer.

But if I do not set it to post to the GL based on my current config it does not calculate deprecation on the fed and state books.

Thanks very much,

pastedimage1637718056086v4.png

  • Michael agostini Profile Picture
    Michael agostini 43 on at
    RE: Fixed Asset books and their respective depreciation

    Thang and Ludwig

    I listened to Ludwig's video and understand everything he said.  Great video by the way it was good to put a voice to the photo.

    In his example he had three books but they all had the same depredation profile straight line (SL).

    My example guys is it is NOT the same depreciation method but D365 calculates it as though all three books are SL when I use derived values.  That is the issue at hand...

    How do I resolve this issue?  is it a bug?

  • ThangNguyen Profile Picture
    ThangNguyen 184 on at
    RE: Fixed Asset books and their respective depreciation

    Hi Michael,

    You can refer to this topic:

    community.dynamics.com/.../1211176

    In my opinion, you can create 3 fixed asset journals corresponding with 3 layers and then run depreciation separately.

  • Michael agostini Profile Picture
    Michael agostini 43 on at
    RE: Fixed Asset books and their respective depreciation

    Ludwig Reinhard,

    Do you have a video on how to do Fixed assets with 3 different  depreciation menthols?

    Thanks,

  • Michael agostini Profile Picture
    Michael agostini 43 on at
    RE: Fixed Asset books and their respective depreciation

    If I remove the derived books from the main depreciation method Straight line service life then I do not see nay deprecation calculations occurring.

    Thanks

  • Michael agostini Profile Picture
    Michael agostini 43 on at
    RE: Fixed Asset books and their respective depreciation

    Thang,

    This is very helpful.  I will review and let you know my findings.

    Thanks

  • ThangNguyen Profile Picture
    ThangNguyen 184 on at
    RE: Fixed Asset books and their respective depreciation

    Here is the instruction from Microsoft, may it be helpful for you:

    "Depreciation posted in the derived book will be the same amount that was posted for the primary book. If the depreciation methods are different between the books, you should not generate depreciation transactions using the derived process."

    docs.microsoft.com/.../post-derived-value-models

  • Michael agostini Profile Picture
    Michael agostini 43 on at
    RE: Fixed Asset books and their respective depreciation

    here is the deprecation journal looks good to me.  But I am expecting it to calculate 200 * DB for the two operating layers.

    pastedimage1637953445872v1.png

  • Kamalkumarax Profile Picture
    Kamalkumarax 89 on at
    RE: Fixed Asset books and their respective depreciation

    Could you please review the journal type? Have you selected the right posting layer in journal?

    Please confirm.

  • Michael agostini Profile Picture
    Michael agostini 43 on at
    RE: Fixed Asset books and their respective depreciation

    Ludwig,

    Here are the profiles and balances on the asset.

    Not sure why the balances screen shows Straight line for all three books.

    You can see the fixed asset compare report appears to be wrong as well.

    I must be missing something here.

    Thanks,

    pastedimage1637804991043v6.png

    pastedimage1637805079579v8.png

    pastedimage1637805391190v9.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fixed Asset books and their respective depreciation

    Hello Michael,

    For Q1:

    Can you share screenprints/details of the profile of your FA?

    You can find details by opening the different books and pressing the profile button.

    Wonder what you see there.

    For Q2:

    Whether or not you post to GL depends on what you try to analyze later on.

    If you need your data in finance reports / trial balance then post to GL; otherwise, you can just use the standard FA reports to see the FA values, depreciation amounts, etc. That can, however, be a semi-manual experience.

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans