Finance forum

Fixed Asset books and their respective depreciation

(1) Share

Report

Posted on by Michael agostini

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.

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?

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,

Categories:

Financial Management

All responses (10)

Answers (0)

Michael agostini 57 on at

Like (0)

Report

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 184 on at

Like (0)

Report

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 57 on at

Like (0)

Report

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 57 on at

Like (0)

Report

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 57 on at

Like (0)

Report

RE: Fixed Asset books and their respective depreciation

Thang,

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

Thanks
ThangNguyen 184 on at

Like (1)

Report

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 57 on at

Like (0)

Report

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.
Kamalkumarax 89 on at

Like (0)

Report

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 57 on at

Like (0)

Report

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,
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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