This chapter provides an overview of asset processing and discusses how to:
Define common tables to manage assets.
Define asset attributes.
Set up asset profiles.
Establish asset ownership.
Set up on-demand processing.
Set up reporting options.
Once the basic accounting structure and business units that reflect the organizational and reporting structure for your enterprise have been established, you will set up the various tables and options used to manage the assets within your organization.
Asset processing covers a wide array of activities, tasks and transactions for your enterprise. This includes:
Identifying, classifying and categorizing your assets.
Recording, tracking and maintaining physical attributes, licenses and warranties of assets.
Managing physical location, inventory and custodianship of assets.
Establishing depreciation rules and reporting for assets.
Establishing financial, tax and accounting treatment and reporting for assets.
Asset Management is delivered with a full complement of commonly used and statutory asset management conventions. It is likely that many of these conventions suit the needs of your organization. If so, you can use tableset sharing to share these tables and minimize table setup tasks. Examine these tables before creating additional tables.
This section discusses how to set up your system to enter, manage, and report on your assets.
Before defining options for asset processing, you must first have established the following prerequisites:
Installation options and user preferences for Asset Management.
Financial common definition options such as ChartFields, accounts, departments, funds, ledgers, operating units and so on.
Defined setIDs, tablesets, and trees.
Set up business units and optional cash generating units.
See Also
Defining Asset Management Installation Options
Defining and Using ChartFields
Defining Financials and Supply Chain Management Common Definitions
Establishing Asset Management Business Units
This section provides an overview of common tables and lists the pages used to define common tables.
PeopleSoft delivers the following common tables:
Calendars
Currencies
Units of Measure
Note. You can change any delivered table. To make changes to a table, however, it is best to make a copy of it and modify the copy. Some of these tables contain statutory information mandated by U.S. tax law. As well, the delivered tables are periodically upgraded when you receive new versions of Asset Management. If you modify the original tables, future upgrade installations could cause problems when attempting to overwrite files that no longer exist, or overwrite files that you have modified. Use caution before changing any delivered table.
See Also
PeopleSoft Enterprise Application Fundamentals 8.9 PeopleBook
PeopleSoft Enterprise Global Options and Reports 8.9 PeopleBook
Page Name |
Object Name |
Navigation |
Usage |
DETAIL_CALENDAR1 |
Set Up Financials/Supply Chain, Common Definitions, Calendars/Schedules, Detail Calendar, Calendar Periods |
Define begin/end date and number of accounting periods in fiscal year calendar. Note. You must define calendars so that accounting entries are generated properly. |
|
Currency Code |
CURRENCY_CD_TABLE |
Set Up Financials/Supply Chain, Common Definitions, Calendars/Schedules, Currency, Currency Code |
Define currency common code definitions. |
Units of Measure |
UNITS_OF_MEASURE |
Set Up Financials/Supply Chain, Common Definitions, Units of Measure |
Establish general units of measure for the system. |
To define asset attributes, use the following components:
To set up asset classes, use the Asset Class (ASSET_CLASS) component.
To set up lease payment schedules, use the Payment Schedule (PYMNT_SCHED_TBL) component.
To set up agencies, use the Agencies (AGENCY_DEFN) component.
To set up joint venture allocations, use the Joint Venture Allocation (JV_BUS_ALLOC) component.
To set up maintenance types, use the Maintenance Types (MAINT_TYPE_DEFN) component.
To set up location definitions, use the Location (AM_LOCATION) component.
To set up insurance types, use the Insurance Types (INSURANCE_TYPE) component.
To set up hazardous-material codes, use the Hazardous Codes (ASSET_FSC_DEFN) component.
To set up units of production, use the Units of Production (UOP_DEFN) component.
To set up asset types, use the Asset Type Options (AM_TYPE_OPT) component
To set up asset subtypes, use the Asset Subtype (AM_SUBTYPE) component.
To set up user-defined asset attributes, use the Asset Attribute (AM_UD_ATTR) component.
To set up asset property subclasses, use the Asset Property Subclass (AM_PROP_SUBTYPE) component.
To set up asset meter types, use the Meter Types (AM_METER_TYPE) component.
To set up asset warranties, use the Warranty Type (AM_STD_WRTY) component.
To set up warranty templates, use the Warranty Template (AM_WRTY_TMPL) component.
To set up equipment parts list, use the Equipment Parts List (AM_PART_LIST_TMPL) component.
These components are found in the Set Up Financials/Supply Chain, Product Related, Asset Management menu.
There are several procedures and options for establishing the core tables for Asset Management. As previously noted, many of these tables are optional or conditional. Some are required before you can enter assets into the system; these tables are noted as such.
This section lists the pages used to define asset processing and discusses how to:
Set up asset class definitions.
Define lease payment schedules.
Define agencies.
Define joint venture allocations.
Define maintenance types.
Set up hazardous-material codes.
Set up units of production definitions.
Set up insurance types.
Set up units of production.
Maintain index and units of production tables.
Set up asset physical definitions.
Set up asset meter types.
Set up asset warranties.
Set up equipment parts lists.
Page Name |
Object Name |
Navigation |
Usage |
ASSET_CLASS_DEFN |
Set Up Financials/Supply Chain, Product Related, Asset Management, Financials, Asset Classes |
Maintain asset classes. Asset classes are set up at the tableset level. |
|
VAT Defaults Setup (value-added tax defaults setup) |
VAT_DEFAULTS_DTL |
Click the VAT Default link on the Asset Class definition page. |
Specify VAT defaults setup. |
LEASE_SCH_ID |
Set Up Financials/Supply Chain, Product Related, Asset Management, Payment Schedules |
Add or modify payment schedules. If you will be adding leased assets to your system, you must have at least one payment schedule defined. Asset Management is delivered with one payment schedule already set up in the SHARE tableset. This schedules a payment on the first of each month from January 1960 through December 2025. |
|
AGENCY_DEFN |
Set Up Financials/Supply Chain, Product Related, Asset Management, Profiles, Agencies |
Create agency codes. Keep track of an asset’s registration and licenses by using the information set up in Agency tables. Only agency IDs set up here can be entered on the Asset License/Registration page. |
|
JV_BUS_ALLOC |
Set Up Financials/Supply Chain, Product Related, Asset Management, Financials, Joint Venture Allocation |
Define the percentage of asset ownership allocated to each joint venture participant. Use this page to set up the Joint Venture Allocation table. |
|
MAINT_TYPE_DEFN |
Set Up Financials/Supply Chain, Product Related, Asset Management, Service and Repair, Maintenance Types |
Define maintenance types. |
|
MAINT_CONTRACT_01 |
Asset Management, Service and Maintenance, Maintenance Contract Terms, Detail |
Define the detail terms for maintenance contracts by entering the effective, expiration, and contract dates, contract cost and vendor information. |
|
MAINT_CONTRACT_02 |
Asset Management, Service and Maintenance, Maintenance Contract Terms, Coverage |
Define the maintenance contract coverage including contact information. |
|
Location Definition |
AM_LOCATION_TBL |
Set Up Financials/Supply Chain, Product Related, Asset Management, Location Definition |
Set up locations. |
INSURANCE_TYPE |
Set Up Financials/Supply Chain, Product Related, Asset Management, Service and Repair, Insurance Type |
Enter different types of insurance, such as liability for automobiles or property. |
|
ASSET_FSC_DEFN |
Set Up Financials/Supply Chain, Product Related, Asset Management, Financials, Hazardous Codes |
Define hazardous-asset codes. The PeopleSoft system is delivered with the Federal Supply Class (FSC) codes, which are U.S. federal codes that identify predominantly and significant hazardous materials. You may add other classifications. |
|
UOP_DEFN |
Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Units of Production |
Set up units of production definitions. |
|
UOP_DEFN_WRK |
Set Up Financials/Supply Chain, Product Related, Asset Management, Depreciation, Units of Production, Transaction Information |
Generate open transactions. Each time new detail is added to this table, you can generate open transactions for each asset associated with it. |
|
RUN_AMIF2000 |
Asset Management, Send/Receive Information, Load Interface, Receive UOP and Index Tables |
Load units of production and index tables. |
|
Asset Type Options |
AM_TYPE_OPT |
Set Up Financials/Supply Chain, Product Related, Asset Management, Physical Definitions, Asset Type Options, Asset Type Options |
Define physical asset types to be applied to individual assets. PeopleSoft delivers ten asset types:Hardware, Software, Equipment, Property, Fleet, Machinery, Furniture, Facility, Intangible, Other. |
Define Asset Subtype |
AM_SUBTYPE |
Set Up Financials/Supply Chain, Product Related, Asset Management, Physical Definitions, Asset Subtype, Define Asset Subtype |
Define asset subtypes as they relate to asset types. For example, if the asset type is Hardware, an asset subtype may be defined for a Laptop. |
Work Order Options for Components |
AM_WOM_OPT_SUBTYPE |
Click the Work Order Options for Components link from the Define Asset Subtype page. |
Define Work Management work order options. |
Define Asset Attribute |
AM_UD_ATTR |
Set Up Financials/Supply Chain, Product Related, Asset Management, Physical Definitions, Define Asset Attribute, Define Asset Attribute |
Define any asset physical attribute to be associated with an asset. |
Define Property Subclass |
AM_PROP_SUBCLASS |
Set Up Financials/Supply Chain, Product Related, Asset Management, Physical Definitions, Asset Property Subclass, Define Property Subclass |
Define property asset subclasses as they relate to asset property classes: Site, Building, Floor, Area, Space. |
Meter Type Definition |
AM_METER_TYPE1 |
Set Up Financials/Supply Chain, Product Related, Asset Management, Service and Repair, Meter Types, Meter Type Definition |
Define meter types. |
Meter Type Comments |
AM_METER_TYPE2 |
Set Up Financials/Supply Chain, Product Related, Asset Management, Service and Repair, Meter Types, Meter Type Comments |
Add comments relevant to meter type definition. |
Standard Warranty |
AM_STD_WRTY |
Set Up Financials/Supply Chain, Product Related, Asset Management, Service and Repair, Standard Warranties |
Define standard warranties. |
Warranty Templates |
AM_WRTY_TMPL |
Set Up Financials/Supply Chain, Product Related, Asset Management, Service and Repair, Warranty Templates |
Set up templates for warranty types to apply to asset types. |
Equipment Parts List |
AM_PART_LIST_TMPL |
Set Up Financials/Supply Chain, Product Related, Asset Management, Service and Repair, Equipment Parts List |
Define equipment parts lists to be associated with asset classes, groups, categories, types and subtypes or other asset definition. |
Access the Asset Class page.
To add a new asset class, select the setID and enter the name of the asset class. This information follows to the Asset Class definition page. Complete the fields as appropriate.
Use asset class to classify assets for reporting purposes. It can be used in combination with the category code to refine asset classification. For example, an executive desk is categorized as furniture and fixtures for the balance sheet. Within the broad category of furniture and fixtures, you can use an asset class code to specifically identify the asset as a desk.
When defining asset classes, PeopleSoft provides the option to define Value Added Tax (VAT) processing defaults as well.
Defining Asset Class as VAT Driver
Asset class is also used as a value-added tax (VAT) driver. Create classifications of assets based on the VAT treatment. For example, treatment of assets such as automobiles may be different than for assets such as buildings or leases. In this way, the asset class can be used to determine the VAT treatment.
VAT defaults are also set up at the business unit level.
Access the Payment Schedule page.
When working with leased assets, you must define payment schedules to be assigned to the leased assets.
You must have at least one payment schedule defined when working with leased assets. Asset Management delivers four payment schedules in the SHARE tableset:
End Of Month Due Date |
Select to always schedule the payment on the last day of the month, no matter what date is entered in the Begin Date field. |
Populate |
Click to enable Asset Management to automatically enter the payment dates for the time period that you defined. Be sure to enter the number of payments per year, to ensure that Asset Management can determine the number of lease payments for the lease schedule. |
See Working With Leased Assets.
Access the Joint Venture Allocation page.
Enter each participating business unit and its allocated percentage of equity in the shared assets. The sum of these percentages must equal 100 percent.
The joint venture allocation table affects only newly added assets. Changes made to the allocation table will not affect existing assets. To change ownership percentages of existing assets, you must run a mass change using the template supplied for this purpose. These joint venture mass change templates enable you to:
Add a joint venture business unit.
Remove a joint venture business unit.
Change joint venture ownership allocations.
Once you have changed the assets, change the allocation table to reflect the new equity percentages.
Note. The joint venture allocation as defined in the allocation table need not match the actual ownership percentages. For example, if two companies enter a joint venture on a 60/40 basis, one of them can sell the joint venture asset on a 70/30 basis—effectively giving one party a discount while the other pays a premium. In this case you would first enter the asset at the joint venture business unit level, then change the cost apportionment by using mass change.
See Also
Working with Joint Venture Asset Processing
Access the Maintenance Type page.
Maintenance type identifies the type of maintenance and maintenance procedures that should be followed for a particular asset. For example, you might establish a Tune Up maintenance code that specifies routine maintenance for an automobile.
See Managing Asset Maintenance, Repair, Warranties, and Insurance.
Access the Hazardous-Materials Codes page.
When you manage assets that can be classified as a hazardous material, you must maintain the Hazardous Material codes table. U.S. Federal Supply Class codes are delivered with Asset Management, and you can add codes to supplement the list. Hazardous assets can be reported using asset search functions, and storage locations can be managed with specific building, room, floor, and longitudinal and latitudinal information added to the location page associated with the asset.
Note. Hazardous Material/Waste: Solid, liquid, or gaseous waste, or combination of these wastes, which because of its quantity, concentration or physical, chemical, or infectious characteristics may cause significantly to increase in mortality or an increase in serious irreversible or incapacitating illness or pose a substantial present or potential hazard to human health or the environment when improperly treated, stored, transported, disposed of, or otherwise managed (according to the United States Environmental Protection Agency).
Access the Units of Production page.
When you depreciate assets by using the units of production method, you must set up units of production definitions. This table defines the maximum units that an asset can produce and how many units have been posted for each period.
Adding and Adjusting Units of Production Detail Page
Access the Transaction Information page.
Transaction Date |
Reflects the date on which you made the changes. |
Accounting Date |
Reflects the date on which the entered changes will impact your general ledger. |
Both dates are used in recalculating depreciation. The difference between transaction date and the accounting date determines whether production detail for this transaction will be posted as accumulated production.
The difference between the transaction date and the accounting date determines whether any prior period production needs to be posted. For example, consider a machine that was acquired and placed in service on March 15, 2001 but didn’t get entered in Asset Management until August 1, 2001. All general ledger periods prior to August are closed. In this case, Asset Management automatically posts any accumulated production to the general ledger in August.
Unlike accumulated depreciation, accumulated production is posted exactly like any other production detail. There is nothing to distinguish it as accumulated production.
Accumulated production for a new units of production ID should be posted on a date that falls before any assets associated with the units of production ID are added.
See Also
Creating Asset Management Accounting Entries
You will periodically update the information in your Index and Units of Production tables as you receive new information. You can load or update the Index and Units of production tables automatically using the AMIF2000. This process takes data in a fixed length format ASCII file and loads it into the appropriate table.
Files to be loaded into the Index table should be in this format:
Field |
Length |
SETID |
5 |
INDEX_NAME |
20 |
EFFDT |
8 (MM/DD/YY) |
DESCR |
30 |
INDEX_DETAIL_NAME |
35 |
INDEX_AMOUNT |
15 |
Files to be loaded into the Units of Production table should be in this format:
Field |
Length |
SETID |
5 |
UOP_ID |
10 |
DESCR |
30 |
UOP_IN_SERVICE_DT |
8 (MM/DD/YY) |
UOP_MAX_UNITS |
12 |
UNIT_OF_MEASURE |
3 |
UOP_POSTING_DT |
8 (MM/DD/YY) |
UOP_UNITS |
12 |
To define asset physical definitions, use the following components:
Asset Type Options (AM_TYPE_OPT).
Asset Subtype (AM_SUBTYPE).
Asset Attribute (AM_UD_ATTR).
Asset Property Subclass (AM_PROP_SUBTYPE).
These components are found in the Set Up Financials/Supply Chain, Product Related, Asset Management, Physical Definitions menu.
Define Asset Type Options
Access the Asset Type Options page.
PeopleSoft delivers these asset types: Hardware, Software, Equipment, Property, Fleet, Machinery, Furniture, Facility, Intangible, Other. You can assign the appropriate options that apply to each asset type for Maintenance Management work orders and InterUnit Transfer Default values.
Retire Assets Components |
Select this check box to enable retirement processing for components from work orders. |
TRF Out Components for Reuse |
Select this check box to enable component transfers out for reuse from work orders. |
Transfer In Components |
Select this check box to enable component transfers in from work orders. |
Asset Acquisition Info |
Select to include information derived from the Asset Acquisition Detail (ASSET_ACQ_DETAIL) page and links (ASSET_ACQ_DET_AP, ASSET_ACQ_DET_VAT). |
Asset Attributes Info |
Select to include information derived from the Asset Location/Comments/Attributes (ASSET_IMAGE) page. |
Asset License/Register Info |
Select to include information derived from the Asset Custodian/License/Manufacturer page (ASSET_CUSTODIAN) and links (ASSET_LIC_ADDR_SEC). |
Asset Lease Info |
Select to include information derived from the Leased Assets component pages (ASSET_LEASE_01, ASSET_LEASE_02, ASSSET_LEASE_05, ASSSET_LEASE_03). |
Asset Non-Capitalized Cost |
Select to include information derived from the Asset Acquisition Detail (ASSET_ACQ_DETAIL) page and links (ASSET_ACQ_DET_AP, ASSET_ACQ_DET_VAT). |
Asset Maintenance Info |
Select to include information derived from the Track Service and Repairs component and Meter Reading component pages (ASSET_MAINT_01, ASSET_MAINT_01_S, AM_METER_READ). |
Asset Comments |
Select to include information derived from the Asset Location/Comments/Attributes (ASSET_IMAGE) page. |
Asset Warranty Info |
Select to include information derived from the Asset Custodian/License/Manufacturer page (ASSET_CUSTODIAN) and links (ASSET_WARRANTY). |
Asset Insurance Info |
Select to include information derived from the Asset Custodian/License/Manufacturer page (ASSET_CUSTODIAN) and links (ASSET_INSURANCE). |
Asset Inspection Info |
Select to include information derived from the Asset Custodian/License/Manufacturer page (ASSET_CUSTODIAN) and links (ASSET_INSPECTION). |
Access the Define Asset Subtype page.
Use As Tool |
Check if this subtype is used as a tool in support of another asset. When the asset specifies an asset subtype, the system applies the Use As Tool field value from the asset definition level. When defining assets, you may associate it with a Profile, such as Building or Automobile . If no Profile is specified for the asset, the asset subtype value Use As Tool will apply when this subtype is selected for the asset. The system validation process is: When working with assets in Add mode only, if there is no Asset Subtype specified for the asset, the system checks the Profile. From the Profile definition, the system will populate the asset type and asset subtype values to the new asset. When the Profile specifies an asset subtype, the system sets the Use As Tool field value to the same value of the asset subtype as defined in the associated Profile. When the Profile does not specify an asset subtype, no values are provided by default since the Use As Tool field value is blank on the Profile and the newly added asset will follow suit. |
Cost Rate and Currency Code |
Enter the cost rate and currency to be used if a cost is applied for this asset subtype. |
Billing Rate |
Enter the billing rate to be used if the use of the asset subtype is to be billed. |
Unit of Measure |
Enter the units measured for cost and billing. |
Access the Define Asset Attribute page.
Enter user-defined asset attributes to assign to assets. For examples, you can create asset attributes to specify a quality, aspect, version, or other characteristic that can be applied to an asset. Asset attributes are optional.
Define Asset Property Subclass
Access the Define Property Subclass page.
Define property subclass codes to apply to property asset classes: Site, Building, Floor, Area, Space. For example, you can define the corporate sites and further enter property subclasses for the buildings located on the site.
Access the Meter Type Definition page.
When you manage assets that utilize meters to track asset usage or that provide some other type of measurement associated to the asset, you need to define meter types.
Define meter types within setIDs.
Status |
Set the meter status: Active: The meter is actively measuring. Inactive: The meter is not actively measuring but available. |
Description
Description |
(Required) Enter a meter description. |
UOM (units of measure) |
(Required) Enter the units by which the meter will measure, such as miles, kilometers, gallons, liters, square feet, and so on. Note. Many units of measure are provided by PeopleSoft. You must define units of measure if the measurement is not common and delivered for PeopleSoft. |
Lower Limit and Upper Limit |
(Required) Enter the lowest and highest value readable by the meter. The lower limit is never greater or equal to the upper limit. The upper limit is never less than or equal to the lower limit. |
Maintain Daily Average |
Select to maintain a daily average. The average is informational only for preventive maintenance schedules in Maintenance Management. The option is not selected by default. |
No. of Readings (number of readings) |
Enter the number of readings to calculate the daily average. Required when Maintain Daily Average is selected. |
Meter Options
Increasing or Decreasing |
Select Increasing if the meter should increment along the asset's useful life by the units of measure selected. Select Decreasing if the meter should decrement along the asset's useful life by the unit of measure selected. The Increasing option is selected by default. |
Allow Rollover |
Select if the meter should reset to zero after reaching its defined maximum. It is selected by default. |
Tolerance Range |
Select to establish a tolerance range for a maintenance event. When selected the tolerance range fields become active. |
Lower Tolerance and Upper Tolerance |
Enter the tolerance range. For example, a piece of construction hydraulic equipment may use a pressure meter. If the meter falls below the lower tolerance or above the upper tolerance, you may initiate maintenance or replacement as needed. See Setting Up and Generating Preventive Maintenance Work Orders. |
This section discusses how to:
Set up standard warranties.
Set up warranty templates.
Understanding Warranties
In order to automatically assign one or more warranties to each newly acquired asset, standard equipment warranties and equipment warranty defaults must be defined. Each asset added to the repository is available to have the appropriate warranties automatically attached to it. You can update a warranty for an asset at any time after the addition of the asset to the asset repository, including changing the terms of the warranty, renewing or voiding the warranty associated with the asset, or making other notable changes in coverages or terms.
A warranty is established as a standard warranty that is applied to a single asset. Or a generic warranty that can be applied to multiple assets can be defined as a warranty template. This is useful when the same terms of a general warranty applies to many assets, such as multiple computer work stations, or truck tires for a fleet of trucks. It is also useful when applying multiple standard warranties to assets. For example, an asset may be delivered with a manufacturer's warranty and an additional extended warranty that is purchased separately and provides different coverages.
Setting Up Standard Warranties
Access the Standard Warranties page.
Enter the standard warranty information for an asset type, category, class or other asset definition. Use the standard warranty to associate it with specific asset IDs.
Manufacturer's Warranty |
Check if the warranty is the original manufacturer's warranty. |
Coverage |
Enter a description of the warranty. |
Days for Refund |
Enter the number of days during which the asset is eligible for refund. |
Days to Return |
Enter the number of days during which the asset is eligible for replacement. |
Days for Replacement |
Enter the number of days during which the asset is eligible to be returned. |
RMA Required |
Check this box if an RMA (Return Material Authorization) is to be accompanied with the asset before it can be returned under warranty. |
Loaner Provided |
Check if the asset will be replaced with a similar loaned asset while under repair. |
On-Site Repair |
Check if the asset is eligible for repair at your place of business. |
Warranty Transferable |
Check if this warranty transfers when ownership of the asset transfers. |
Warranty Life |
Select the meters that may be associated with the asset to measure warranty life. For example, a vehicle usually has a warranted life based on miles which are measured by the vehicle odometer. |
Entitlement |
Enter a summary of what the warranty specifically entitles the owner to receive. |
Access the Warranty Templates page.
Define warranty templates that can be applied to multiple assets at one time, such as assets defined by asset type, category, class or other asset definition.
Select all standard warranties that apply to the individual asset category, class, type and so on.
See Also
Access the Equipment Parts List page.
Asset equipment parts lists (EPL) are maintained by setID. You can establish a parts list to correspond with asset classes, groups, categories, types and subtypes, or any asset definition. The EPL can then be associated with a specific asset ID.
See Also
Adding and Maintaining Asset Information
Use the Asset Profile Definition (PROFILE) component to define asset profiles.
This section provides an overview of asset profiles and discusses how to:
Define asset profiles.
Specify asset books for a profile.
Set up special terms for depreciation methods information.
Set up inflation information for a profile.
Set up salvage rounding rules.
Specify tax attributes in a profile.
Specify child asset inheritance attributes in a profile.
An asset profile is a template that contains standard depreciation criteria for an asset type and its corresponding asset books. The information established in an asset profile can be used as default values when you’re adding assets to the system. Profiles associated to indexes enable replacement cost calculations. Profiles are recommended when you have a large number of assets of the same type. Defining default values minimizes data entry, ensures consistency and enhances accuracy levels.
Set up Asset Profiles to match most, if not all, of the major asset categories you track on your books. These can range from the standard categories such as Land, Furniture & Fixtures, Machinery & Equipment, and Expensed Items, to more detailed categories you may want to track, such as Computers, Software, Phones, and Fax Machines.
Note. You must set up at least one asset profile before you can add any assets to the system. Keep in mind that profiles are templates that help reduce data entry when you are actually adding an asset. When you go through the process of entering assets into the system, you can override any of the fields in an asset profile. Because profiles are required when using ExpressAdd, we recommend that you set up a blank “dummy” profile for nonstandard assets.
Page Name |
Object Name |
Navigation |
Usage |
PROFILE_DEFN |
Set Up Financials/Supply Chain, Product Related, Asset Management, Profiles, Asset Profiles |
Define Asset Profiles. |
|
PROFILE_BK_01 |
Set Up Financials/Supply Chain, Product Related, Asset Management, Profiles, Asset Profiles, Depreciation |
Identify the criteria used in depreciation calculations. |
|
PROFILE_DEPR_DETL |
Select the Special Depr check box and click Special Terms on the Depreciation page of the Asset Profiles component. |
Set special depreciation terms for an asset profile and select an accounting method for these special terms. These are commonly used to meet depreciation requirements for specific countries. |
|
PROFILE_SEC |
Set Up Financials/Supply Chain, Product Related, Asset Management, Profiles, Asset Profiles, Depreciation, Inflation Information |
Establish an inflation adjustment factor by selecting the market index and rate to apply. |
|
SALVAGE_OPTION_SEC |
Click Salvage Rounding Options on the Depreciation page. |
Enter options for rounding depreciation amounts for this book. This is for use in Japan. |
|
PROFILE_BK_03 |
Set Up Financials/Supply Chain, Product Related, Asset Management, Profiles, Asset Profiles, Tax |
Specify property type and tax depreciation criteria and to identify which tax credits will be used by the profile. |
|
PROFILE_PAR_BK_ECD |
Set Up Financials/Supply Chain, Product Related, Asset Management, Profiles, Asset Profiles, Child Asset Inheritance |
Specify child asset attributes which will be used by the profile, and inherited from the parent asset during Express Add, Basic Add, and batch-created assets. The inheritance based on the selected items happens upon Defaulting the Profile in Express Add, Capitalizing the asset in Basic Add, and when using Default Profile processing in Transaction Loader if the Business Unit option is turned on. |
|
RUN_AMPRFCHG |
Set Up Financials/Supply Chain, Product Related, Asset Management, Financials, Profile Changes In Mass |
Copy an asset profile from one set ID to another, or to update a profile by changing some of its attributes. |
Access the Asset Profiles - Definition page.
You create asset profiles from the Profile (PROFILE) component. You can create profiles with varying levels of detail. The level you use depends on how much information you want to default into the system when you add an asset. Some asset profiles are used to define for financial attributes, while others are not. To successfully create a financial profile you must enter at least the following information:
Profile ID.
Asset category.
Asset book name.
Depreciation attributes.
Asset type.
Each profile has a unique profile ID. You can use this ID to group profiles by type. For example, you might want to have several automobile profiles, such as Autos, Autos-Luxury, and Autos-Leased.
Asset Description |
Enter a description for this asset profile. |
Asset Class |
Select the asset class to which this asset profile will default. The available options are defined when you establish asset class codes. |
Asset Type |
Select the asset type. PeopleSoft delivers these asset types: Hardware, Software, Equipment, Property, Fleet, Machinery, Furniture, Facility, Intangible, Other. |
Asset Subtype |
Select the asset subtype. Valid values for the selected asset type display from the drop down list. |
Acquisition Code |
Select the acquisition code from the drop-down list. Available options are:
|
Select to indicate that an asset is taggable. Most physical assets can be tagged with a tag number to help keep track of them. Some assets, however, such as buildings or leasehold improvements, cannot be tagged. If an asset is taggable, it probably already has a tag number associated with it, which is recorded when the asset is added. Sometimes, however, an asset may be taggable, but not yet tagged. The Taggable Asset check box can be used to flag this type of asset. Note. In order to use the Physical Inventory functionality in Asset Management, your assets must be tagged. |
|
Select to indicate whether this profile will be used for assets with cost and depreciation associated with them. Most assets in your Asset Management system will be capitalized assets. If you’re setting up a profile for noncapitalized assets , (assets with no cost or depreciation criteria, deselect Capitalized Asset). Typically these assets are expensed, not actually owned, or fully depreciated, but you still want to track them. |
|
Select the index by which replacement or valuation cost will be calculated. When you run the Calculate Replacement Cost (AMRCCALC) process, it multiplies the asset cost by the amount in the index selected here. |
|
SubIndex Name |
Select the subindex category for the index used to calculate replacement or valuation cost. |
Use As Tool |
Select this option if the asset is sued as a tool in connection with the maintenance or repair of another asset. |
(AUS) Using Research and Development Information
Research and Development Information is used to meet Australian asset processing requirements; for others these fields are informational.
R and D Plant Asset (research and development plant asset) |
Select if this asset is being used for Research and Development and is entitled to R&D tax concessions. |
R and D Start Date (research and development start date) |
Enter the date the asset was first used exclusively for R&D. If you leave this field blank, the in service date from the business unit’s tax book will be used as the start date. The start date determines in what year the R&D concessions can first be claimed. |
Use NBV for R and D (use net book value for research and development) |
Select if you want to base the R&D concessions calculation on the net book value of the asset (at the R&D start date) instead of the book cost. This is useful where an asset previously being depreciated as a non-R&D asset subsequently becomes eligible for R&D concessions. |
See (AUS) Using Asset Management Options to Meet Australian Requirements.
Access the Asset Profile - Depreciation page.
Note. Each asset can report to multiple books and have multiple depreciation attributes per book.
Book Name |
Enter a book name that defines the rules for the assets entered with this profile. Books are defined during system setup and associated with business units. Only valid books can be assigned. |
Effective Date |
The date entered in Effective Date field indicates when the convention and depreciation method take effect. If you want a history of changes made to a profile, be sure to add new rows to the table and use effective dating to update profiles, rather than making changes to the initial row. |
Category |
Defines the category of an asset, such as Furniture & Fixtures or Machinery & Equipment. The available category codes are those you entered on the Category Code table. In general, these will correspond to the General Ledger asset accounts. Asset Category is used in accounting entry generation. |
Depreciation Status |
Enter depreciation status. |
Currency Code |
Select a currency code. |
Convention |
Select a depreciation convention. |
Retire Conv |
Select a retirement convention. |
Select a depreciation method. Some depreciation methods require you to enter additional information. Note. If you are specifying the depreciation method as Flat Rate or a Declining Balance method or Manual depreciation for tax books, you should enter the recovery life. |
Note. If you select Non Depreciable on this page, you must still enter values for Useful Life and Convention. However, you need not update the remainder of the Asset Profiles pages. Because the profile is defined for nondepreciable assets, the information in these pages will not be used in any processing.
Make sure that you establish an effective date for the profile that is valid for the currency code specified for the profile.
Depending on the depreciation method that you select, additional fields appear:
Method |
Fields That Appear |
Declining Balance w/SL% /Limit |
DB Pct (Declining Balance Percent), Limit Pct. |
Declining Balance w/SL% |
DB Pct, Monthly. |
Depreciation Schedule |
Schedule. |
Declining Balance |
Percent, Low Limit, Monthly. |
Flat Rate % |
Percent, Low Limit, Avg Option (Averaging Option). |
France Derogatory Balance |
DB Pct, Percent, Low Limit, Depr Pass Life (Depreciate Past Life). |
Germany Staffel Method |
DB Pct, Percent, Low Limit, Depr Pass Life. |
Japan − Intangible/Strt Line |
DB Pct, Percent, Low Limit, Depr Pass Life. |
Japan − Tangible / Declining Balance |
DB Pct, Percent, Low Limit, Depr Pass Life. |
Japan − Tangible/Strt Line |
DB Pct, Percent, Low Limit, Depr Pass Life. |
Japan −Changes DB to SL |
DB Pct, Percent, Low Limit, Depr Pass Life. |
Japanese − Lease Depreciation |
No additional fields appear. |
Manual Depreciation |
No additional fields appear. The Manual Depreciation method enables you to adjust depreciation amounts generated using some other method. To use manual depreciation you must therefore first create depreciation entries using another method. Once this has been done, you can make your adjustments. |
Straight Line |
Useful Life. |
Straight Line Percent |
(IND) Percent. |
Sum of the Years |
N/A |
Units of Production |
UOP ID (Units of Production ID). |
User Defined Method |
Method ID, DB Pct, Percent, Low Limit, Depr Pass Life. |
The following table defines the additional fields:
Limit Pct (limit percent) |
Enter to specify a limit for depreciation as a percentage of cost. |
Enter the units of production ID, production information, and transaction information you’d like to use for this asset. |
|
DB Pct (declining balance percent) |
Enter the percentage of declining balance depreciation to be taken each year until the amount calculated by the straight line method is greater. |
Percent |
Enter the percentage of original basis to be taken in depreciation each year. Required for Straight Line Percent. |
Low Limit |
Enter an amount. When the asset basis reaches this limit, the remaining basis will be taken in depreciation and the asset will be fully reserved. |
Depr Pass Life (depreciate past life) |
Select this if you want to continue to depreciate this asset past its useful life end date. This option is used for certain countries' governmental regulations or for utilities industries that may want to continue to depreciate an asset to the end of a depreciation calendar. |
Method ID |
Select the user-defined method that you want to use. |
Enter a schedule to use for depreciation. |
|
Avg Option (average option) |
Generally used by utility companies to depreciate composite assets. |
The averaging options are expressly designed to work with the flat rate depreciation method. Select an averaging option if you want to use it:
Monthly |
Monthly averaging takes an average monthly asset balance and multiplies it by the annual depreciation rate. The result is then applied against a period allocation (1/12, 2/12, 3/12, and so on) to derive a year-to-date (YTD) depreciation amount. The difference between the newly calculated YTD depreciation and the previous YTD depreciation is the amount booked to the current period. |
Yearly |
Yearly averaging is similar to monthly averaging except that a yearly average balance is used. Because this amount is not known until the end of the year, it is usually estimated and adjusted periodically as the actual figures become known. |
Note. Using the flat rate depreciation method will cause any depreciation to be posted to the end of the calendar. If this is not your intention, you must enter a low limit of .01 when you first selected the depreciation method for this asset. If you have not already done this, update the Depreciation Method field by selecting Flat Rate and entering .01 in the Low Limit additional field that displays.
Calculation Type |
Select the calculation type.
For example, if you took $20,000 depreciation over a two year period but the amount allowed was $24,000, the difference of $4,000 would be expensed as an adjustment to accumulated depreciation in the current period. |
Low Value |
Select to identify assets with costs below a certain level for special depreciation processing. This is a requirement for some countries. |
Useful Life |
Enter in number of periods. This is used to perform the depreciation calculations for the financial books. |
End Date (end depreciation date) |
Enter if you would like depreciation to cease at a particular time. At the end depreciation date the remaining asset basis will be taken in depreciation and the asset will be fully reserved. |
Future Depr Yrs (future depreciation years) |
Asset Management calculates and stores depreciation until the end of the asset’s life. However, for optimal processing performance and greater table efficiency, you can specify a fixed number of years for which depreciation is calculated and stored. Note. PeopleSoft strongly recommends using the Future Depreciation Years option if you are using Group Assets. |
Special Dpr (special depreciation) |
Select if you are working in a global environment and want to use special depreciation terms to meet specific country requirements. Click Special Terms to open the Profiles Depreciation Details page where you can select special terms for depreciation. |
Depr Limit (depreciation limit code) |
Select a depreciation limit code that relates to a specific dollar amount limitation on depreciation for each year of life. Although this can be used for financial depreciation, it is commonly used for U.S. tax purposes, because such depreciation limits exist for items such as luxury automobiles. |
Cost Basis Limit |
Enter the limit on the depreciable basis of this asset. If the actual cost of an asset is greater than its depreciable basis, the difference will result in a gain when the asset is retired. |
Impairment Process |
Select to make the asset available for impairment processing. |
Salvage % of Cost (salvage percentage of cost) and Salvage |
Enter the residual value of the asset subtracted from the cost to determine the depreciable basis used in depreciation calculations. You can enter it either as a flat rate or as a salvage percentage (a percentage of the asset’s total cost). If you use a salvage percentage, the system recalculates the salvage value as you add additional costs for the asset. |
(DEU) Multi-Shift Code |
Enter rates by which depreciation should be increased based on the number of production shifts an asset is used. This is used in Germany. |
Group BU |
Enter the business unit for the group assets. |
Group ID |
Select the group ID. |
Note. Each group member asset profile can be used by only one business unit.
Using the Depreciation Method Information Page
Access the Depreciation Method Information page by clicking the Special Terms link.
Select one of the following accounting method options:
Allowance |
Select Allowance and special depreciation amounts are not booked with the standard depreciation amounts. Journal entries are generated that will include only the standard depreciation. Asset Management does not support automatically generating journal entries for the special depreciation allowance accounting method. You may need to run two reports: Reserve for Special Depreciation and Reversal for Special Depreciation, and then generate the journal entries manually into the General Ledger system. |
Expense |
Select Expense and total amounts of special depreciation and standard depreciation are booked and journal entries are generated that will include the total of standard and special depreciation amounts. |
Reserve |
Select Reserve and special depreciation amounts are not booked with the standard depreciation amounts. Journal entries are generated that will include only the standard depreciation. Asset Management does not support automatically generating journal entries for the special depreciation allowance accounting method. You may need to run two reports: Reserve for Special Depreciation and Reversal for Special Depreciation, and then generate the journal entries manually into the General Ledger system. |
Note. Additional fields are provided to comply with the depreciation methods used in countries other than the U.S.
When you use additional terms, they affect depreciation calculations as follows:
Term |
Depreciation |
Special |
Depreciation x Rate |
Accelerated |
Depreciation x Rate |
Initial |
Cost x Rate |
Increase |
Depreciation x Rate |
Note. Year of Change(displayed from the ASSET_DPR_DETAILS page) is only available when the depreciation method is Japan-Change DB to SL.
(ARG, BRA, and MEX) Setting Up Asset Profile Inflation Information
Access the Inflation Information page.
Market Rate Index |
Select the market rate index to be used for inflation processing. |
Rate Type |
Select the market rate type to be used for inflation processing. |
Term |
Select the term. |
Daily Rate Index |
Select the daily rate index. |
Daily Rate Type |
Select the daily rate type. |
Daily Term |
Select the daily term. |
See Establishing Market Rates.
(JPN) Using the Salvage Rounding Options Page
Access the Salvage Rounding Options page.
Rounding Rule |
The rounding rules delivered with Asset Management are: Down NatRnd Up |
Round Type |
The rounding types delivered with Asset Management are: Currency Generic |
Rounding Precision |
The number of places to the right or left of the decimal point to which the amount or number will be rounded. If you select Currency as the round type, the system will automatically determine the round precision from the currency code. |
Rounding Factor |
The number to which the amount will be rounded. For example, if you select Nat Rnd as the rounding rule, and enter a rounding factor of 25, amounts will be rounded to the nearest multiple of 25, so that an amount of 130 will be rounded to 125, and an amount of 140 will be rounded to 150. If you select Currency as the round type, the system will automatically determine the rounding factor from the currency code. |
Truncation Precision Flag |
Works with the round precision value. When you select it, amounts that contain many decimal places will be truncated to one decimal place to the right of the rounding precision position before rounding is performed. If you so not select it, the entire amount will be rounded. This example illustrates truncation precision:
With Truncation Precision Flag selected, the system truncates the fifth decimal place and rounds 10.0343. Without the check box selected, the system rounds the entire amount. Actual rounding results would depend on the selected rounding rule and round type. |
See Using the Global Features of Asset Management.
Access the Asset Profiles - Tax page.
Note. Asset tax attributes primarily addresses Unites States tax issues except where noted.
Property Type and Property Code |
Determine the amount of gain treated as ordinary income on the disposition of this asset. |
Regulation |
Identifies the depreciation system elected for this asset:
|
Recovery Life and Recovery Subtype |
For reporting purposes, you can further classify the asset by specifying the recovery life expressed in years and the recovery subtype, for example, 15-Year Low-Income Housing. You can also specify the asset guideline class. All current classifications are set up in the Tax Class table in the delivered tableset. |
(IND) Guideline Class |
Processing tax and depreciation in India requires the designation of a tax class rate that is associated to an asset block. To associate the tax class rate to a profile, enter the tax class and associated asset block rate here. |
Corporation Sec. 291 (corporation section 291) |
Select if this company is a corporation. This check box must be turned on if the company is a corporation in order for the AMTX3210 tax report (Tax Retirement Capital Gains) to accurately reflect the correct Sec. 1231/Ordinary gains. |
(FRA) Business Tax |
Select if assets using this profile are subject to a business tax. This is required in some countries. |
Listed Property |
Select this check box to record whether the asset is listed property. Listed property are certain kinds of assets that are conducive to mixed business or personal use, such as:
|
Listed Property Type |
Select the property type that corresponds to the Listed Property check box. |
Business Use % (business use percentage) |
Enter the percentage amount of the business use of this listed property asset in Business Use %. Based on the business use percentage that you enter, the basis calculated for depreciation is: (Basis) = (Cost*Bus_Use_%) |
(USA) Depreciation Bonus |
Used to indicate if the asset qualifies for the U.S. 30 percent to 50 percent depreciation bonus in the first year. The options you see depend on the acquisition date and in service date of the asset as well as state or local application of the depreciation allowance. The options are:
|
(USA) Bonus Percent |
If the asset qualifies for the depreciation bonus based on acquisition date and in service date, select the amount (percentage) to be applied. Note. The U.S. depreciation bonus applies to assets acquired and placed into service by December 31, 2005. After this time the depreciation bonus cannot be used. |
The rate and amount of the tax credit are based on federal tax law and determined by the qualified investment code, tax credit type and code, and the basis reduction option in Asset Management.
Select a qualified investment code if applicable:
A (accelerated): |
Accelerated Cost Recovery System (ACRS) |
D (depreciation): |
Asset Depreciation Range |
F (facts): |
Conventional Facts and Circumstances |
G (guidelines): |
Guideline |
M (modified): |
Modified Accelerated Cost Recovery (MACR) |
Select a tax credit type if applicable. In the U.S., certain business incentive credits may be taken:
R (rehabilitation): |
Rehabilitation Credit |
E (energy): |
Energy Credit |
I (investment): |
Regular Investment Credit |
U (user): |
User-defined |
The tax credit code further defines the tax credit. For example, a 20 percent rehabilitation tax credit is available for historic buildings. Some credits require a corresponding reduction in the asset’s cost basis.
Basis reduction option indicates whether a reduction in the cost basis is required. Three codes are provided:
B (basis): |
Basis Reduction |
P (percentage): |
Percentage Rate Reduction |
N (no): |
No Reduction |
See Also
Using the Global Features of Asset Management
Access the Child Asset Inheritance page, and select the applicable check boxes for inheritance.
Select the attributes and other information that the child asset inherits from the parent asset.
See Also
Adding and Maintaining Asset Information
Establishing Asset Management Business Units
To establish asset ownership, use the Define Asset Owners (AM_OWNER_COMP ) component.
To set up asset owner user, use the Assign Owners to Operators (AM_OWNER_OPR_COMP) component.
This section provides an overview of asset ownership and discusses how to:
Define asset owners.
Assign users to owners.
Define asset owner users.
Asset Management uses a concept called asset ownership in which a relationship is established between assets, ChartField combinations, asset category, asset type, asset location, asset manufacturer or model, or asset department and the individuals who have responsibility for managing them. Asset owners might be plant managers, store managers, or department head and each owner may be associated with multiple asset operators, such as plant engineers, store clerks, and department workers.
An asset ownership definition provides a manager or supervisor discrete visibility into the transactions affecting the assets for which she is responsible and enables the “express” retirement of those assets by means of the Asset Management Disposal Worksheet. The disposal worksheet automates the retirement process between the asset owner and the property accounting personnel responsible for completing the financial transactions relative to the assets themselves including the optional establishment of a role-based approval process. The owner-to-operator definition may optionally authorize operator access to asset cost history data and disposal approval.
Page Name |
Object Name |
Navigation |
Usage |
AM_OWNER_DEFN |
Set Up Financials/Supply Chain, Product Related, Asset Management, Financials, Define Asset Owners |
Define role-based asset owners and assign assets to the owner based on ChartField and other attributes. |
|
AM_OWNER_DEFN2 |
Set Up Financials/Supply Chain, Product Related, Asset Management, Financials, Define Asset Owners, Asset Owner User |
Assign operators to owners. |
|
AM_OWNER_OPR_DEFN |
Set Up Financials/Supply Chain, Product Related, Asset Management, Financials, Assign Owners to Operators |
Define role-based owner users. |
Access the Asset Owner page.
Select the role to be defined as the asset owner.
Asset Selection Attributes |
Using the drop-down search keys, select the field name used to establish assign ownership. For example, the manager may be responsible for all assets in Department 11000 through, Department 12000, Location Sydney, and Category Computer Items. Select Department and define the range of field values, select Location and define the location field value of Sydney, and select Category and define the category field value of Computers. |
Access the Asset Owner User page. To establish asset ownership, operator IDs must be linked to the Asset Owners defined on the Asset Owner page.
Asset Owner User |
Link the asset owner to users or operators. Under User ID, enter the user IDs that are assigned to the asset owner. Select Retire Approval Required to indicate an approval step is required prior to asset disposal. Select Show Cost to indicate whether the user ID will have access to cost information in the express retirement pages. |
Access the Setup Asset Owner User page.
The Asset Owner User page lets you make assignments owner by owner. The Setup Asset Owner User page allows to you add multiple operators and owners in at one time.
Setup Asset Owner User |
Assign User ID to Asset Owner, set up Retire Approval Required and Show Cost options for each user ID. |
Note. A warning displays if the retirement approval and show cost options established here for a user ID are in conflict with those established in the Asset Owner component, Asset Owner User page (AM_OWNER_DEFN2).
To set up on-demand processing options, use the On-Demand Process Options component (RTM_OPTIONS).
This section provides an overview of on-demand processing and lists the page used to set up on-demand processing for Asset Management.
Process groups are groups of processes that certain users can run on demand, directly from transaction entry pages, such as the Invoice Information page in the Voucher component of Payables. The process groups available depend on your user ID and whether or not a given transaction requires the processing.
Before you can use on-demand processing, you must specify the accounting entry definitions that will be used by each source transaction-process group combination, along with other options. Accounting entry definitions define the record and fields that the Journal Generator process uses to extract accounting entries from the system source.
Set up on-demand processing for:
INTFAPAM: AP/AM Interface Application Engine.
AMPS1000: Preinterface loader.
AMIF1000: Transaction loader.
Page Name |
Object Name |
Navigation |
Usage |
On-Demand Processing Options |
RTM_OPTIONS |
Set Up Financials/Supply Chain, Common Definitions, On-Demand Processing, On-Demand Process Options |
Define the process groups that certain users can run on demand |
See Also
Setting Up On-Demand Processing
This section provides an overview of reporting options and discusses how to:
Report drill-down options.
Report suffix options.
Report format templates.
PeopleSoft delivers several kinds of report options within Asset Management.
Online reporting enables users to view details of costs and depreciation from high level summary views to the lowest reporting level available for reporting periods.
Asset Management provides online inquiries of the depreciation reporting table (DEPR_RPT) displaying high level summary data for a period with details available through drill-down functions, defined at the business unit and book definition level. When enabled for online reporting, selection criteria includes business unit, book, fiscal year, period, asset category, profile ID, and ChartFields. The drill-down feature provides the option to view the data presented to the lowest level available.
Report Format Template and Suffix
Most of the reports used for different functions within Asset Management make use of the same data but report it from a different perspective. For example, depreciation is often reviewed by ChartField activity. It is, however, also useful to review depreciation based on a category or location. To that end, you may use a report template that allows you to define the reporting-by method to be used.
PeopleSoft delivers a report template that can be shared by all users but that can be defined by you to include or exclude information of your choosing. The template controls the report title,Report By field name, sort order, field length to display, field label overrides, amount field length, and sub-totaling. To accommodate the varying needs of many users, the report can be generated using Report By as the key, with a report suffix added to the report ID to indicate what value is used for Report By.
Asset Management also provides the tools to produce reports in user-defined formats. Using report IDs or user IDs as keys to reporting templates, multiple groups or individuals use the same general information provided in a report but receive it in a dynamically defined format addressing the particular needs of the group or individual.
Page Name |
Object Name |
Navigation |
Usage |
Reporting Drilldown Fields |
RPT_DRILL_FLD_G |
Set Up Financials/Supply Chain, Product Related, Asset Management, Reporting Setup, Reporting Drilldown Fields |
Define the drill- down group ID and select drill down fields. |
User Preferences - Asset Management |
OPR_DEF_TABLE_AM1 |
Set Up Financials/Supply Chain, Common Definitions, User Preferences, Define User Preferences, Asset Management |
Select a drill-down group to associate with this user ID. |
Report Suffix |
REPORT_SUFFIX |
Set Up Financials/Supply Chain, Product Related, Asset Management, Reporting Setup, Report Suffix |
(Required) Denotes the Report By value for the report, appended to the report ID to uniquely identify it. Default sort order is ChartField, (CF). |
Report Format Template |
RPT_FMT_TMPL_SBP |
Access the run control page for the report to be formatted with user-defined parameters and expand the Report Print Options group box. Click the Update/Add Template link in Report Print Options group box. |
Update or add new report formats. |
Access the Reporting Drilldown Fields page.
Detail View |
Select the corresponding check box for each field that you want available for drill down. Clear any fields to be excluded. For example, if your organization does not track anything by class, a column for the field will appear on your report but no values will appear. To remove the column from a report, clearing the check box on this page. |
Access the User Preferences - Asset Management page. Select a user ID.
Field Drilldown Group Id |
Select the group ID to associate with this user ID. If not set up, all above fields will be available for drill down. The drill-down field list could be very long. To create a drill-down list that is more specific, you can drill down by Project ID and Department ID only, thereby reducing the list using this setup. |
Access the Report Suffix page.
Enter the values to be appended to the report ID, which identify the name of the available field by which the report is run. For example, the report Depreciation Activity by ChartField uses the report ID AMDP2000. When you report by Department, the report suffix 5 is appended to the Report ID, which then displays as AMDP2000-5. This means that the report contents are presented in department order. As you add or change ChartFields, you must add or change the corresponding values in this list.
Access the Update/Add Template page.
Only active General Ledger ChartFields display on the page, in addition to the Asset Management ChartField, Asset Category.
Field Order |
Define the order of the fields to print across the page of your report. For example, Department, Project, Product, Asset Category, and so on. |
Display Length |
Field length defaults automatically appear. Shorten the field lengths as needed. |
Label Override |
Enter the field label to be used for each field included or use the default definitions. |
Include in Report |
All fields are selected to be included in the report by default. Deselect any fields that you do not want to include. |
Print subtotals |
The system prints subtotals for all fields by default. Deselect fields for which you do not want subtotal breaks. If a ChartField is not included in the report, corresponding subtotals will not be printed. |
See Also
Using Asset Management Reporting Options