Finance | Project Operations, Human Resources, ...

Multiple Fixed Asset Books with different depreciation methods

(0) Share

Report

Posted on by Michael agostini

Dear Microsoft D365 Finance Community

I have a case open this issue but I am opening a new one FOR further clarification.

SCENARIO

Require thee fixed asset books
Require three deprecation methods STATE 200 % declining balance, FEDERAL 200 declining balance with special deprecation rule, LOCAL GAP straight line service life.
The assets are acquired via an acquisition journal
Need to report the deprecation for each method but it does not have to be in a separate layer but can be.
I am using derived books and it works but all deprecation methods are SL. Microsoft even gives a warning that this will happen.

QUESTION

How do I calculate depreciation based on the three methods and not just the one method SL.?

All responses (5)

Answers (0)

Jack Liszewski 15 on at

Like (0)

Report

RE: Multiple Fixed Asset Books with different depreciation methods

I realize this is an outdated thread, but I don't still don't see an answer that effectively answers the question, so I'll chime in here.

The issue that you are facing is due to the derived book setup that you shared in your second screenshot. When using different depreciation methods across books, the transaction type depreciation should NOT be added to the derived book for SL.

The way derived books work - whenever a transaction is posted to the head book layer, the SAME transaction (amounts and all) will be posted to the derived book as well.
brjo on at

Like (0)

Report

RE: Multiple Fixed Asset Books with different depreciation methods

Hi Michael,

For my message above, both were posted in the same layer (Current).
Michael agostini on at

Like (0)

Report

RE: Multiple Fixed Asset Books with different depreciation methods

I see what you have.

I went over the config so many times and was not able to get it to work as expected.

Did you set up top post in another layer?

If not are you able to run a report with the multiple dep methods?

Thanks
Suggested answer

saurabh bharti 15,033 Super User 2025 Season 1 on at

Like (0)

Report

RE: Multiple Fixed Asset Books with different depreciation methods

Normally as product behaviour, system posts depreciation for each book based on mapped depreciation profile.

So, in you case it will be all three different. Can you if it is because of depreciation frequency monthly or yearly??
Suggested answer

brjo on at

Like (0)

Report

RE: Multiple Fixed Asset Books with different depreciation methods

Hello,

I used demo data // created a fixed asset // with several derived books, all with different depreciation methods.

One of the books has straight line as the depr. method:

The other derived book has a 150% declining depr. method:

In my above example, I acquired the asset in late 2020 // and ran depreciation proposal thru the end of 2021.

We can see that the amounts change (i.e. both books are using different depreciation methods).

Let me know if you have any questions -- and perhaps I'm not understanding your exact ask.

Thanks!