You’re offline. This is a read only version of the page.
10
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.
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?
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (