E1: 12: SMART Fields for Fixed Asset Report Writer Reports and other Hints (Doc ID 835124.1)

Last updated on JUNE 19, 2015

Applies to:

JD Edwards EnterpriseOne Fixed Assets - Version XE and later
Information in this document applies to any platform.
Report Writer Reports-
R1200001
R1200002
R1200003
R1200004
R1200005
R1200006
R1200007
OMW
RDA


Goal

Information Center: Overview of JD Edwards EnterpriseOne Fixed Assets > Information Center: Using JD Edwards EnterpriseOne Fixed Assets > Note 835124.1

Fixed Assets comes with standard reports that can be used with the system. These reports are intended to be used as templates to create versions for client usage. Although, the reports are standard they use smart fields that require data selection that is specific to the customer's chart of accounts including the object and subsidiary portion of the accounts.  Until the reports are changed to use to correct chart of accounts/object accounts, the reports will most likely display zero balances in the columns that use smart fields. 

This following information gives hints on where to find what fixed asset accounts to use, what columns need to be updated, and also what smart fields are used for each column. See Document R120000X Reports (R1200001/R1200002/R1200003/R1200004/R1200005/R1200006/R1200007) <626061.1> for additional information on how to change these reports.

Experience is needed in OMW and Report Writer to make these changes.

Report Column Value Hint-How to figure out value Current Data Selection Smart Fields used for columns
R1200001 Life Months AA-Object Cost Acct Range FC AAIs Eq.Status not equal to 1C, 1D, 10, 1S ASSETLM
  Depr Method AA-Object Cost Acct Range FC AAIs Ledger Type-AA ASSETDM
  Original Cost AA-Object Cost Acct Range FC AAIs   ASSETAB
  A/D AA-Object Cost A/D Range FD AAIs   ASSETAB
  NBV Calculate-Don't Change      
  YTD Dep. Expense AA-Object Dep. Exp. Range Some of the FX range/Chart of Accounts/Depreciation Default Coding   ASSETAD
R1200002 Beginning Asset Cost AA-Object Cost Acct Range FC AAIs Blank ASSETPB
  Assets Tran. In AA-Object Cost Acct Range FC AAIs   ASSETTI
  Additions AA-Object Cost Acct Range FC AAIs   ASSETAD
  Asset Sold AA-Object Cost Acct Range FC AAIs   ASSETRT
  Asset Tran. Out AA-Object Cost Acct Range FC AAIs   ASSETTO
  Ending Asset Cost AA-Object Cost Acct Range FC AAIs   ASSETAB
  Beginning AD AA-Object Cost A/D Range FD AAIs   ASSETPB
  Assets Tran. In AA-Object Cost A/D Range FD AAIs   ASSETTI
  YTD Dep. Expense Depreciation Expense Some of the FX range/Chart of Accounts/Depreciation Default Coding   ASSETYC
  Asset Sold AA-Object Cost A/D Range FD AAIs   ASSETRT
  Asset Tran. Out AA-Object Cost A/D Range FD AAIs   ASSETTO
  Ending A/D AA-Object Cost A/D Range FD AAIs   ASSETAB
R1200003 Proceeds from Sale AA-Proceeds Account AA-Bal. Char. 9 -Disposal Rules Eq.Status equal to 1C, 1D, 10, 1S ASSETAB
  Asset Cost G/L AA-Object Cost Acct Range FC AAIs Ledger Type-AA and D1 ASSETRT
  A/D G/L AA-Object Cost A/D Range FD AAIs   ASSETRT
  Asset Cost Tax D1-Object Cost Acct Range FC AAIs   ASSETAB
  Asset A/D Tax D1-Object Cost A/D Range FD AAIs   ASSETAB
R1200004 No changes need on column data selection.     Eq.Status not equal to 1C, 1D, 10, 1S No Smart Field Used
R1200005 No changes need on column data selection.     Company number = to the CO needed No Smart Field Used
        Eq.Status not equal to 1C, 1D, 10, 1S  
R1200006 No changes need on column data selection.     Blank No Smart Field Used
R1200007 Land AA-Land Object Cost Range FC AAIs-Chart of Accounts Company number = to the CO needed ASSETAB
  Building AA-Building Object Cost Range FC AAIs-Chart of Accounts   ASSETAB
  Heavy Equipment AA-Heavy Equip. Object Cost Range FC AAIs-Chart of Accounts   ASSETAB
  Vehicles AA-Vehicles Object Cost Range FC AAIs-Chart of Accounts   ASSETAB
  Furniture & Off. Equip AA-Furniture Object Cost Range FC AAIs-Chart of Accounts   ASSETAB
  Computers AA-Computers Object Cost Range FC AAIs-Chart of Accounts   ASSETAB
  Other Assets AA-Other Assets Object Cost Range FC AAIs-Chart of Accounts   ASSETAB


* Make sure and test this in your test environment since assets need to be added to the system.

Complete the following task to review how the information is reported.

  1. Have your IT Representative change the reports for your specific accounts.
  2. Add an asset and depreciate it for the year for both AA and a Tax Ledger.
  3. Add an asset and depreciate it and dispose of it for both AA and a Tax Ledger.
  4. Add an asset and transfer it to a different department BU or Company for both AA and a Tax Ledger.
  5. Add an asset and split the asset.
  6. Add some assets to each of your object types-Land, Building, Heavy Equipment......
  7. Run the reports on just the above selected assets and review the results.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms