Issue in depreciation calculation-Legacy asset upload

[former_member186064]

Hi Experts,

I have an issue in depreciation calculation for the asset which was uploaded as legacy balance using AS91.

I have uploaded the balance upto the 4th period of the current fiscal year. Fiscal year is Sep to Aug.

Asset acquisition date is 01.09.2011 as per legacy system records so when I created asset master using as91,

I have given expired useful line 1 year and 4 months (as on 31.12.2012) and depreciation key SLN with 33.33% day basis

(means use full life  is 3 years). This means remaing uselful life is 20 monts for this asset (36 months - expired life 16 monts= 20 months)

Out of 20 monts 8 monts fall under FY 2012 becasue till 4th period, I have uploaded the opening balance and remaing 12 monts fall under FY-2013.

Acquistion value is 270,712.00 so depreciation per month should be 7520 (270,712 / 36 months)

Opening balance uploaded upto 4th period is 16 x 7520 = 120,320. (including 4 periods of current fiscal year.)

Per year depreciation 270,712 / 3 = 90237=00

Now since I have updated opening balance upto 4th period in AS91 then the remaining balance for the year 2012 should be

8 x 7520 = 60,160 and planned depreciation should be shown as 7520 per month from 5th to 12 the period in AW01N (Asset Explorer)

Issue:

System is dividing the remaining usefull life and depreciation amount as follows:

Year 2012                                                           Year 2013

Depr. Amt- 90237  (it should be 60160)                   Depr.Amt - 60160

Periods     - 8  (Per month- 11279.63)                     Periods- 12 (per month 5013)

When I see AW01N, system gives break-up for 8 periods for 2012 but it divides the entire years amount in 8 periods i.e. 90237.

Where as system should have divided the amount 60160 for the 8 periods in 2012 and for the next year 2013, it should have

divided 90237 into 12 periods.

Please suggest me if I need to do some change in depreciation key or some other setting is misssing.

Thanks in advance.

Regards,

RKS

[Former Member · Accepted solution]

The legacy transfer date is 31.12.2012, right? From your description, I think the AS91 takeover value should be like this:

Cum. acquis.val.   270,712

Accm.ord.deprec    90,237(accumulated for previous depreciation. The expired useful life should be 1 year if currentl year is 2012..)

Ord.dep.posted      30,080(4 period posted in year 2012)

Then in AW01N, there will be depreciation of 90237 for every year from 2011 to 2013.

[former_member186064 · Accepted solution]

Hi Hannah Gao,

Thanks A lot for your response.

Acutally later on I myself found out the reason why system was calcualting strage value.

I have mistaken in AS91, I have updated both accm.ord.deper value as well as current year depreciation value in only one field i.e. accm.ord.deper.

Then I have segregated the amount as you have suggested.

Now system is calculated proper depr amount.

Regards,

RKS