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

Fixed Assets - Calculate Depreciation - NAV 2017

(0) Share

Report

Posted on by CsB78

Hi Everyone,

I'd like to use the Fixed Asset Module in NAV for our Fixed Assets that are currently managed on an Excel spreadsheet.

I have successfully imported the Static Data and the Transactional Data (Acquisition Costs and Depreciation to date) into our NAV UAT company using the standard Configuration package tools and the book values for all assets are matching. I have also done the Fixed Asset Setup including the FA Classes, Subclasses, Locations, Posting Groups, Depreciation Books & Tables etc however when I run the Calculate Depreciation process the calculated depreciation charges in the generated Fixed Asset G/L journal are different from our Excel FA Depreciation Schedule.

For example:

Net Book Value - £509,896.00

Monthly Depreciation Charge should be (£509,896.00 x 25%)/12 = £10,622.83

I've tried various depreciation methods, using depreciation table and other things to achieve this figure but I haven't manage to get the expected result.

Can someone please advise what is it that I am missing or doing wrong?

Many thanks in advance.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

If you do not get further traction from the community, feel free to raise this issue to Microsoft via your partner or CSP.

Thanks.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (1)

Report

Hi, Here are the specific calculations for each depreciation method, hope this helps.

https://docs.microsoft.com/en-us/dynamics-nav-app/fa-depreciation-methods

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

What depreciation method are you using?

Was this reply helpful? Yes No
CsB78 10 on at

Like (0)

Report

Hi,

Many thanks for the link.

Was this reply helpful? Yes No
CsB78 10 on at

Like (0)

Report

Hi Kim Dallefeld

I've checked the link about the specific calculations for each depreciation method and it looks I've managed to figure out what is causing the problem.

I am using the Straight-Line Depreciation method with a fixed yearly percentage of 25%. The problem is that the formulas that calculate the depreciation amounts use the Depreciable Basis amount (which is the same as the Acquisition Cost, please see below screenshot) and not the Book Value. Is there anything that can be done about this?

Was this reply helpful? Yes No