Options

Depreciation calc in navision

sudheersudheer Member Posts: 4
edited 2012-04-02 in Navision Financials
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.

Comments

  • Options
    ssinglassingla Member Posts: 2,973
    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.in
  • Options
    sudheersudheer Member Posts: 4
    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.
  • Options
    sudheersudheer Member Posts: 4
    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
  • Options
    ssinglassingla Member Posts: 2,973
    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.in
  • Options
    saiasysmbssaiasysmbs Member Posts: 2
    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
    Satya
    Satya
Sign In or Register to comment.