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.?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

brjo on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

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??

Was this reply helpful? Yes No
Michael agostini on at

Like (0)

Report

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

Was this reply helpful? Yes No
brjo on at

Like (0)

Report

Hi Michael,

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

Was this reply helpful? Yes No
Jack Liszewski 15 on at

Like (0)

Report

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.

Was this reply helpful? Yes No