Depreciation calc in navision

sudheer
Member Posts: 4
Hi,
I have created an asset with the following details.
depr start date:01/Jan/2011
No of depr yrs:5 yrs
depr calc :Straight line.
Posted a closing balance as on 31/Dec/2010 with type acquisition of 1,000,000 and depreciation as on 31/Dec/10 with amt 10,000. So net book value as on 31 Dec 2010 is 990,000.
Now done automatic calculation of depreciation using the batch job for the period 2011. Given the fa posting date and posting date as 31 Dec 2011 for auto calc of depreciation . The resulting FA GL journal is populated with amount 198,000 instead of 200,000 . Is there any problem in the setup or is this the way the system calculates. Thanks in advance.
I have created an asset with the following details.
depr start date:01/Jan/2011
No of depr yrs:5 yrs
depr calc :Straight line.
Posted a closing balance as on 31/Dec/2010 with type acquisition of 1,000,000 and depreciation as on 31/Dec/10 with amt 10,000. So net book value as on 31 Dec 2010 is 990,000.
Now done automatic calculation of depreciation using the batch job for the period 2011. Given the fa posting date and posting date as 31 Dec 2011 for auto calc of depreciation . The resulting FA GL journal is populated with amount 198,000 instead of 200,000 . Is there any problem in the setup or is this the way the system calculates. Thanks in advance.
0
Comments
-
The system has calculated on the basis of information entered by you. 5 year depreciation from 01/Jan/2011 should calculate 198000/-. What was the amount that you were expecting?CA Sandeep Singla
http://ssdynamics.co.in0 -
is it not possible to hv 200,000 depreciated for the first 4 yrs and for the last yr the remaining amount i.e 190,000 to be depreciated.0
-
also when i post any appreciation entry during the period let us say in 2011 and when calculating the depreciation for the period 2011 then the system is showing inconsistent data for the depreciation calculated0
-
sudheer wrote:also when i post any appreciation entry during the period let us say in 2011 and when calculating the depreciation for the period 2011 then the system is showing inconsistent data for the depreciation calculated
System will calculate depreciation from the Appreciation Date. Any depr. till the date of appreciation should be calculated and posted before appreciation.CA Sandeep Singla
http://ssdynamics.co.in0 -
As per your details:
Acquisition value as on 31/Dec/2010 is 1,000,000
Depreciation as on 31/Dec/2010 is 10,000. So, now book value of the asset becomes 990,000 as on 31/Dec/2010.
If you run automatic depreciation calculation system will calculate based on book value ie., 990,000
No. of years is 5
So 990,000/5 i.e., 198,000.
Best Regards
SatyaSatya0
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