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-
GoalFixed 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|
|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.
- Have your IT Representative change the reports for your specific accounts.
- Add an asset and depreciate it for the year for both AA and a Tax Ledger.
- Add an asset and depreciate it and dispose of it for both AA and a Tax Ledger.
- Add an asset and transfer it to a different department BU or Company for both AA and a Tax Ledger.
- Add an asset and split the asset.
- Add some assets to each of your object types-Land, Building, Heavy Equipment......
- 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).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!