My Oracle Support Banner

WS: 12: User Defined Depreciation Program Writes the Journal Entry for the Last Reported Asset with the Incorrect Asset Number, Period, Fiscal Year and Century (P12855) (Doc ID 2859392.1)

Last updated on JUNE 01, 2022

Applies to:

JD Edwards World Fixed Assets - Version A9.4 and later
Information in this document applies to any platform.

Symptoms

The Compute UDD Depreciation program (P12855) is writing the depreciation journal (DP document) for the last asset on the report incorrectly. The general ledger date is correct, but the asset number, fiscal year, and in some cases the period and century are incorrect. 

Steps:

  1. G09411/2/Company Numbers & Names (P00105) - Create new Company 00721 on a July - June fiscal date pattern, date pattern code A.
  2. G09411/3/Business Units by Company (P0006A) - Add business units 721 (Balance Sheet) and 721A (Income Statement) to Company 00721.
  3. G09411/18/Copy Accts to Business Units (P09804) - Create chart of accounts, copy from Business Unit MD (Model BU) to Business Unit 721 Accounts 1000-9999; copy from Business Unit MD to Business Unit 721A Accounts 5000-9999.
  4. G90/3/User Defined Codes (P00051) - Inquire on System Code 12, User Defined Codes DM, Add UDD method Code SL with 1 in the Special Handling Code field.
  5. G1232/2/Depreciation Rule Revisions (P12851) - Inquire on Depreciation Method 01, Life Periods 84, Initial Term Apport Y and Compute Direction I to use as a template to Add UDD Methods SL 84/Y/I and SL 360/Y/I (change the Yr Thr to 31 for 360 life month method).
  6. G1241/7/Depreciation Account Rules (P12002) - Add Depreciation Account Rules for three asset accounts/accounting class:
    721.2030 | 721.2130 | 721.8441 | ACL1 30
    721.2060 | 721.2160 | 721.8441 | ACL1 60
    721.2090 | 721.2190 | 721.8441 | ACL1 90
  7. G1241/8/Ledger Depreciation Rules (P12003) - Add Ledger and Depreciation Rules for the three asset accounts/accounting class:
    721.2030 | ACL1 30 | AA/SL/360/Y/I  
    721.2060 | ACL1 60 | AA/SL/84/Y/I
    721.2090 | ACL1 90 | AA/SL/360/Y/I
  8. G1211/4/Master Information (P1201) - Add Asset 7057 to 721.2030 in FY02, date acquired 08/17/02, no cost added.
  9. G1211/4/Master Information (P1201) - Add Asset 7058 to 721.2030 in FY06, date acquired 06/18/06, no cost added.
  10. G1211/4/Master Information (P1201) - Add Asset 7059 to 721.2090 in FY20, date acquired 06/30/16, no cost added.
  11. G1211/4/Master Information (P1201) - Add Asset 520662 to 721.2090 in FY15, date acquired 06/30/16.
  12. G0911/2/Journal Entry (P09101) - Capitalize Asset 520662 in FY20, enter journal entries for cost to account 721.2090 (see below), post to the general ledger (G0911/8/P09870) and post to fixed assets (G1212/3/P12102):
    G/L Date 10/08/20 34,137.75
    G/L Date 11/01/20 31,000.00
    G/L Date 12/01/20 14,317.64
    G/L Date 01/01/21 5,516.72
    G/L Date 02/01/21 4,383.80
    G/L Date 03/01/21 8,953.41
    G/L Date 04/01/21 523.90
    G/L Date 05/01/21 114,639.81
    = Total Cost 213,473.03
  13. G1221/3/Compute UDD Depreciation (P12855) - Run in final mode through 06/30/21 (P12 FY20) = P12855/R12855 report OK; depreciation journal DP document for Asset 520662 OK.
  14. G1211/4/Master Information (P1201) - Add Asset 7060 to 721.2060 in FY18, date acquired 07/01/18.
  15. G0911/2/Journal Entry (P09101) - Enter journal entry for cost to account 721.2060 in the amount of 18,000.00, post to the general ledger (G0911/8/P09870) and post to fixed assets (G1212/3/P12102).
  16. G1221/3/Compute UDD Depreciation (P12855) - Run in final mode through 06/30/19 (P12 FY18) - R12855/R12855 report OK; depreciation journal DP document is not. The DP document for the last asset, 7060, is written with Asset 520662 (F0911 GLASID = 520662) and although the g/l date is correct (06/30/19), the fiscal year of 20 is wrong, it should be 18.
Note: The DP document as reported also has an incorrect period and century (in addition to the incorrect asset and fiscal year). 

 

Changes

The issue started appearing after applying A9.4 Bug 29878148

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.