My Oracle Support Banner

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

Last updated on MAY 22, 2023

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

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.

See KM Document E1: 12: Fixed Asset Report Writer Smart Fields (Doc ID 626066.1) for additional information on how the Smart Fields are derived.

 

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.

 

Note: To change the descriptions on the headings try the following:

There is an override for this column heading.
Use the override and enter the value that is needed and also make sure that the user is not using a Language in the language section of the user profile.

The original value (before the override) are taken from Data Dictionary item that the column is using.  For example, the smart field ASSETPB.

Go into the FAT client and focus on the Column and right click and the Column Heading Properties should display.  Update the Col Heading 1 under the section Column Descriptions.  The override should work.
If it doesn’t, please request assistance from the Tools Group (this is Tools RDA).

 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.