News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Remaining Years of Life

Small and medium business | Business Central, N...

Answered

Remaining Years of Life

(4) Share

Report

Report

Posted on by JE-20081519-0

1,481

Hi:

For a Fixed Asset in Business Central, is there a field in any of the tables that calculates Remaining Years of Life?

Thanks!

John

Categories:

Dynamics 365 Business Central

All responses Img

All responses (6)

Answers Img

Answers (1)

Suggested answer

YUN ZHU 81,415 Super User 2025 Season 1 on at

Like (0)

Report

Reamining Years of Life

As several other experts mentioned, without this field, this can only be calculated manually, so we generally customize a dedicated report for customers who use the fixed assets module. . . . .

Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas

Thanks.

ZHU
gdrenteria 17,496 Most Valuable Professional on at

Like (1)

Report

Reamining Years of Life

Hi, good day
I hope this can help you, and give you some hints.

Fixed Assets Remaining Life in Year and days.

Depreciation Methods for Fixed Assets - Business Central | Microsoft Learn

How to Manage the Complete Life Cycle of Fixed Assets in Dynamics 365 Business Central

Best Regards
Gerardo
Verified answer

Mansi Soni 1,715 on at

Like (2)

Report

Reamining Years of Life

In Business Central, there is no direct field that calculates the Remaining Years of Life for a Fixed Asset. However, you can derive it using the Depreciation Ending Date on the FA Depreciation Book page. By comparing this date with the current date, you can estimate the remaining life.

For a calculated approach, you can use the Depreciation Method, Depreciation Start Date, and No. of Depreciation Years fields to manually determine the remaining years.

Regards
Mansi Soni
Suggested answer

Khushbu Rajvi. 14,482 Super User 2025 Season 1 on at

Like (1)

Report

Reamining Years of Life

Hope this helps as well:https://learn.microsoft.com/en-us/dynamics365/business-central/fa-depreciation-methods
Suggested answer

Jainam M. Kothari 6,004 on at

Like (1)

Report

Reamining Years of Life

Hello,

No, There is No Such Field in Any of the table to Calculate Remaining Years of Life.

However, you can determine this by using the asset's depreciation information.

The remaining life can be calculated based on the asset's depreciation period and the amount of depreciation already recorded.

And As per Mr. Ramesh Kumar Sir said, You can use fields like the Depreciation Ending Date and the Depreciation Starting Date to manually calculate the remaining years.

Thanks
Ramesh Kumar 3,298 on at

Like (0)

Report

Reamining Years of Life

Hi John,

You have the Depreciation Start Year, End Year, and the Vehicle Year (the year of purchase), but I don’t see a column for the remaining years. You’ll need to add a column and create a custom flowfield for that.

Thanks

Ramesh

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,120 Super User 2025 Season 1

#2

Martin Dráb 232,871 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans