Depreciation Table Card and depreciation Method user defined not working

(0) Share

Report

Posted on by JohnnyLM

187

Hello BC-Forum,

I want a depreciation of 30% of the bookvalue every year. Example:

2744 * 30% = 823.20 / 12 months = 68.60 per month depreciation. Next year:

1920.80 * 30% = 576.24 / 12 months = 48.02 per month depreciation. And so on.

I tried different depreciation methods, but I cannot get to 68.60 per month. So I tried user defined with a depreciation table code. See my print screens.

When I try to fill in an ending date, I get an error which is understandable because of the choosen method.

When I calculate depreciation I get the error: fill in a date...

How can I get 30% per Year of book value (823.20) and 68.60 per month automatically booked every month?

Thanks in advance!

Greetings,

John

I have the same question (0)

All responses (4)

Answers (2)

Marco Mels on at

Like (0)

Report

Hello John,

You may have seen this one already:

Depreciation Methods for Fixed Assets - Business Central | Microsoft Docs

If not then that is a good start.

Thanks.

Was this reply helpful? Yes No
Verified answer

TWBlaisdell on at

Like (3)

Report

Hi John,

Thank you for posting on the Forum.

You should not need to add a Depreciation Table for this. On the FA Card, click Add More Depreciation Books:

From the reflected options, select Declining Balance 1, where the 1 indicates that the Declining Balance annual depreciation should be equally allocated per month.

Then, enter the 30% and Depreciation Starting Date of 01/01/2021, for example.

Make sure Fixed Asset Depreciation Book is not using rounding to get the decimal calculation.

As you run Calculate Depreciation for each month, the Fixed Asset General Journal will populate with the correct allocated monthly depreciation.

I hope this helps.

Was this reply helpful? Yes No
JohnnyLM 187 on at

Like (0)

Report

Hello Marco,

thanks for your short answer. Yes I have seen this article and tried all the methods. None of them give me the calculation required. That is why I have posted my question on the BC Forum...

Greetings,

John

Was this reply helpful? Yes No
Verified answer

JohnnyLM 187 on at

Like (0)

Report

Hello Tom,

This answer is exactly what I needed. Especially the do not round and the Declining Balance 1 option was very helpful.

Thanks a lot!

Greetings,

John

Was this reply helpful? Yes No