2017年1月16日 星期一

Oracle EBS: 折舊費用產生負數問題

問題:

  Cost: 520356
  Original Cost: 537680
  Salvage value: 86744
  Date in Service 31-OCT-2011
  Prorate Date: 01-OCT-2011
  Method: STL
  Life Years: 5

  在Dec-16出現 -242 的折舊.


說明:

此資產建立時, 有被輸入YTD_DEPRN = -7467
導致資產最後一期的折舊是7227+7467=14694

年度折舊: 86722(7227*12)     [7226.87*12]
2016年11月整年折舊為86964
所以2016年12月折舊才會是 -242

DEPRN_AMOUNT
  = YTD_DEPRN (7227*12) - Fact YTD_DEPRN (86964) ( back-calculate )
  = 86722- 86964
  = -242


Oracle support回覆:

Asset number 123456
New addition limit amount
YTD_DEPRN DEPRN_RESERVE LIFE ADJUSTED_COST
0 -7467 -7467 60 433612

AUG-2016 57816 418918

---
SEP-2016 is last period of life
DEPRN_AMOUNT = ADJUSTED_COST-DEPRN_RESERVE ( back-calculate )
= 433612 - 418918 = 14694

---
OCT-2016 The asset enter extended life
NOV -2016 YTD_DEPRN DEPRN_RESERVE
86964 447824

----
DEC-2016 is last period of Year
DEPRN_AMOUNT = YTD_DEPRN (7227*12) - Fact YTD_DEPRN (86964) ( back-calculate )
= 86722- 86964 = -242