Fixed Asset depreciation calculation

MBClarke
Member Posts: 71
Hi,
We have a client that has a particular Fixed asset that they continue to add to. In other words, they post acquisitions to this asset as they upgrade it and so on. It would seem that when they do this, and run the calculate depreciation function, the system is only calculating depreciation from the last acquisition cost date, thus posting incorrect depreciation values.
Example: 10/12/16 - Acquisition for R10 000.
15/12/16 - Acquisition of R5000
20/12/16 - Acquisition of R 10000
When you run the calculate depreciation for 31/12/16, it only calculates for 11 days, using the last acquisition date and calculating depreciation on that value only.
Is there a way around this, so that it calculates correctly?
Also, if you run the depreciation calculation for December and it calculates it at 11 days, can you run it again forcing the days to 30, so it picks up the difference or do we have to reverse all those entries and re-calculate?
They are using NAV 2015.
Thanks,
Malcolm
We have a client that has a particular Fixed asset that they continue to add to. In other words, they post acquisitions to this asset as they upgrade it and so on. It would seem that when they do this, and run the calculate depreciation function, the system is only calculating depreciation from the last acquisition cost date, thus posting incorrect depreciation values.
Example: 10/12/16 - Acquisition for R10 000.
15/12/16 - Acquisition of R5000
20/12/16 - Acquisition of R 10000
When you run the calculate depreciation for 31/12/16, it only calculates for 11 days, using the last acquisition date and calculating depreciation on that value only.
Is there a way around this, so that it calculates correctly?
Also, if you run the depreciation calculation for December and it calculates it at 11 days, can you run it again forcing the days to 30, so it picks up the difference or do we have to reverse all those entries and re-calculate?
They are using NAV 2015.
Thanks,
Malcolm
0
Answers
-
[Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
I would recommend one of the 2 possibilities:
1) Post this automatically calculated depreciation for 11 days and then manually calculate and post the rest of depreciation (10 days on the first acquisition amount and 5 days on the second)
2) Delete this suggested depreciation amount and then manually calculate and post total depreciation (for all of the acquisitions: 21 days for the first, 16 days for the second and 11 days for the third acq. amount).
After this, the system will continue to calculate depreciation correctly.--
Ivica0 -
There is a field called 'Depr. until FA Posting Date' that's available on Purchase Lines and Journal Lines.
Tick this field when you add the additional acquisition cost.
When you post the additional acquisition cost, system will also calculate and post the depreciation for the period up to the new acquisition posting date.
Regards,
Ben0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions