Question Re: Differance in Manual dep & SAP dep in Enterprise Resource Planning Q&A

Differance in Manual dep & SAP dep

Former Member — Wed, 10 Aug 2011 05:31:06 GMT

Hi Experts,

i have a Assets 90000 sub asset 1 & 2 , total life of assets 17 years, total days in life 6205 use ful life in Q-1 is 91 Days.

Gross block = 2,352,658,603 (Purchase Value)

SAP Calculates the dep

April - 8,417,895.67 April -2734177.25

May - 8698492.2 May -2825316.49

june-8417895.67 June- 2734177.25

Total dep is 33,827,955

when i calculates dep manually for the 91 days

Purchase value 2,352,658,603 * 91 (useful days) / 6205 (Total no of days) total dep is 34,503,132

Why this is the differance. please guide me.

Re: Differance in Manual dep & SAP dep

former_member205041 — Wed, 10 Aug 2011 09:36:07 GMT

Hi,

please go to AW01N and press the button display depreciation calculation.

Here you will find the answer to your question.

If you have the new depreciation calculation it could be also helpful to compare the old depreciation calculation in AW01_AFAR.

regards Bernhard

Re: Differance in Manual dep & SAP dep

Former Member — Wed, 10 Aug 2011 09:52:18 GMT

Hi Bernhard

Thanx for your reply. system calculate the dep 33,827,954.53 but when i calculate manually in excel sheet its 34,503,132 . i just want to know why ihis differance.

in SAP

2352658603 (Acquestion value)

April-11,152,072.92

May-11,523,808.69

June-1152,072.92 Total =33,827,954.53

Manually calculated

34,503,132

formula we apply = Acquestion value * usefullno of days / total life in years.

please help

Re: Differance in Manual dep & SAP dep

former_member205041 — Wed, 10 Aug 2011 09:54:02 GMT

Hi,

could you pleae give me the complete calculation of AW01_AFAR.

(If you press the button: "Display depreciation calculation")

regards Bernhard

Re: Differance in Manual dep & SAP dep

Former Member — Wed, 10 Aug 2011 10:17:09 GMT

Hi,

Cap date od. dep start date planned dep end book value

01/10/2010 03/10/2010 102698,327.19 565544212.72

please help

Edited by: Aadi sharma on Aug 10, 2011 3:47 PM

Re: Differance in Manual dep & SAP dep

Former Member — Tue, 16 Aug 2011 09:06:11 GMT

Hi Experts,

Depreciation key HLLF the multilevel method.

HL8, where set the indicator Yes for the remaining useful life. This means that the percentage is calculated from the remaining useful life.

The calculation is:

Remaining life 006 / 185

100/6,506 = 15,37%

calculating the depreciation asset 9900000 :-

Dep. Calculation for sub number 1 in 2011

=========================================================

Ordinary deprec. 102.698.327,19-

Automatic dep. calculation X

Calculation key N1

Base value 668.242.539,91

Percentage rate 15.3684210526

Dep. periods 366/366

Amount 102.698.327,19

In Assets Master

usefull life :- 17

Expired Useful life :- 10 / 180

Original useful life :- 17 / 4

please help me i am unable to calculate the days.

Edited by: Aadi sharma on Aug 23, 2011 6:02 PM

Re: Differance in Manual dep & SAP dep

Former Member — Tue, 23 Aug 2011 12:40:47 GMT

Hi,

Calculation of days resolve my issue....

thanx in advance

Aditya