Asset Management

State of Georgia
Phoenix Program
Implementing Georgias New Millennium Human Resource

and Financial Solutions
Asset Management
10/04
Phoenix End-User Training
SECTION 1:
FUNDAMENTALS
PARTICIPANT GUIDE
PEOPLESOFT FINANCIALS FOR PUBLIC SECTOR 7

PEOPLESOFT ASSET MANAGEMENT
NOVEMBER 2004
PARTICIPANT GUIDE NOVEMBER 2004
Fundamentals
Welcome to the Fundamentals section. This section contains the tools needed to
learn all the concepts and procedures involved in an overview of Asset
Management.
Goal To have the skills and knowledge necessary to understand the overall asset
management process within PeopleSoft.
Participant
Objectives At the end of this module you will be able to
1. Understand the asset management process

2. Understand how PeopleSoft Asset Management is integrated between
applications
3. Understand basic terminology within PeopleSoft Asset Management
4. Enter a new location
Prerequisites Completion of the following modules:
1. Introduction to PeopleSoft
Outline Fundamentals
A. Introduction
B. The Big Picture
C. Concepts
D. Exercises
E. Review Questions
PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-I

PROPRIETARY AND CONFIDENTIAL
NOVEMBER 2004 PARTICIPANT GUIDE
1-II SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

Section Contents
FUNDAMENTALS
A. INTRODUCTION........................................................................................................5
B. THE BIG PICTURE ....................................................................................................7
C. CONCEPTS..................................................................................................................8
D. EXERCISES ...............................................................................................................22
Exercise 1 Understanding Asset Profiles..................................................................23

Exercise 2 Viewing Asset Profiles............................................................................26
Exercise 3 Understanding Asset Categories .............................................................30
Exercise 4 Access and View Asset Categories.........................................................33
Exercise 5 Add a New Location ...............................................................................35
E. SUMMARY AND REVIEW .....................................................................................38
PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-III

1-IV SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

FUNDAMENTALS
A. Introduction
Activity Materials
LECTURE GUIDE FLIPCHART LIBRARY
Step 1 Goal: To have the skills and knowledge necessary to understand the overall
asset management process within PeopleSoft.
Objectives:
2. Identify external sources of asset management data
3. Describe on-line transactions within asset management
4. Review valid asset profiles
5. Review valid asset categories
6. Understand the valid transaction types
7. Add location using the location panels
Expected The goal and objectives are introduced.

Results:
Step 2 Materials:
Participant Guide, flipchart, online Library, PeopleSoft
Expected The materials are introduced.

Results:
PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-5

Introduction (continued)
Step 3 From the Table of Contents window in the online Library, expand down the
following path:
PHOENIX PROGRAM ASSET MANAGEMENT PROCESSES

Asset Management Fundamentals
Introduction
Expected The Asset Management Fundamentals Introduction selection displays.

Results:
Step 4 Note the topics available under Describe Concepts:
The Asset Management Process Flow

Asset Books
Asset Profiles
Asset Categories
Transaction Types
Locations
Note: Not all topics listed in the online Library will be covered in class.
Successfully completing this module of selected topics will provide you
the skills and knowledge necessary to work with the Asset Management
module.
Expected An understanding of the information available in the online Library for Asset
Results: Management Fundamentals.
1-6 SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

B. The Big Picture
Activity Materials
LECTURE GUIDE
What is Asset Management?
What is its
Who has a car? Value in 30 yrs? Category Location
value today?
$0
$15,000 Why? Value declines over Vehicles Garage
the 30 yrs. - Depreciation
This is an asset
What is its
Who has a computer? Value in 7 yrs? Category Location
value today?
$0 Small Home
$1,000 Why? Value declines over
the 7 yrs. - Depreciation Computers Office
This is an asset
What is its
Who has furniture? Value in 20 yrs? Category Location
value today?
$0 Home
$500 Why? Value declines over Furniture
the 20 yrs. - Depreciation Office
This is an asset
With these assets, you can see that we maintain some simple information about these
assets such as their COST, CATEGORY, and LOCATION. Within PeopleSoft, we can
also maintain much more information such as CUSTODIAN, ATTRIBUTES, and
COMMENTS. We will review these concepts more in depth throughout the manual.
Notice that the value of the assets decreases over the life of the asset. This is called
depreciation. Depreciation is the deduction of value of what an asset is worth today to
what it is worth tomorrow.

Asset management is the process of keeping records of the physical and financial information of
the assets in our possession. For GTA, it is the process of keeping a record of the physical and
financial information of GTAs assets.

The Big Picture (continued)
C. Concepts
Activity Materials
Step 1 The main underlying concepts for the Asset Management introduction are listed
below:

Asset Books
Asset Profiles
Asset Categories
Transaction Types
Locations
Expected An understanding of Asset Managements underlying concepts

Results:

Concepts (continued)
PeopleSoft Asset Management Process Flow
With PeopleSoft Asset Management, everyday activities become simpler, faster, and easier to
manage. Decision support and analysis features allow you to incorporate strategies and plan for
the future. You spend less time typing in numbers, and more time efficiently and effectively
planning acquisitions and managing your assets.
PeopleSoft Asset Management is designed to be integrated with the other PeopleSoft products
Payables, Purchasing, Projects, and General Ledger. This allows you to cut down on
information maintenance by sharing common tables and routines, entering assets using Accounts
Payable vouchers, and creating and posting journal entries to general ledger in real time.
The following diagram describes the Asset Management process flow within PeopleSoft.

Asset Management Process Flow

Asset Sources Asset Management General Ledger
#4.
#1. INTFC_PHY_A/B
Purchasing Consolidate/
Unitize Assets
#3. #6.
#2. Pre-Interface Transaction
INTFC_PRE_AM Loaer Program Loader
(AMPS1000) (AMIF1000)
#5.
#1. INTFC_FIN
Accounts Payable Consolidate/
Unitize Assets
#8. #9. #10. #13.

Depreciation
Asset Table Book Table Cost Table
Table
#7. On-line
Transactions
Express #12.
Add Calculate
#11. Depreciation
Open (AMDPCALC
Lease
Transactions
Express
Add
Basic
#14. #15.
Create Non- Create
Info.
Depreciation Depreciation
#19.
Accounting Entries Accounting Entries
JRNL_LN
(AMAEDIST) (AMDPCLOS)
Adjust
Transfer
#16.
DIST_LN #18.
Distribution Lines JRNL_HEADER
Retire
#17.
Journal Generator

Step 3 (1) Purchasing Accounts Payable
Assets are created outside of Asset Management by Purchasing and Payables. As a purchase
order or invoice is coded into the system, the users code the asset with a proper account and
Profile ID. The following chart shows some of the accounts that will be used.
ACCOUNT NO. ACCOUNT NAME ACCOUNT DEFINITION
Expenditures for items of tangible property of

a generally non expendable nature which
Equipment - maintain their utility over a period of time.
720001 Items charged to this account must be
Machinery & Equipment included on the equipment inventory and meet
the citeria for a movable personal property as
defined in OCGA 50-16-161
Expenditures for EDP Equipment which meet
721001 Computer Equipment the movable personal property requirements
of OGCA 50-16-161
723001 Land Expenditures made for the purchase of land
Expenditures made for acquiring and

Improvemnets
725001 improving buildings. These costs include the
Other than Buildings
principal amount of capital lease paymnets.
Expenditures/expenses for items of tangible
property of a generlly non-expendable
nature which maintain their utility over a
period of time. Items in this category must
Equipment required on have an acquisition cost less than the
616001 inventory, but not standard definition of movable personal
capitalized or depreciated. property set forth in OCGA 50-16-161.
These items however, will have been
included on the property management
inventory for management purposes.
Accounts Payable may also generate a voucher for a subsequent payment on a previous Purchase
Order. If the original Purchase Order or Voucher showed the Asset Management Routing
Indicator to have been clicked On, any subsequent voucher should also show the Asset
Management Routing Indicator as On.
The complete list of accounts can be found in the Accounting Procedures Manual on the Dept of
Audits website, http://www.audits.state.ga.us

Results:


#4.
#1. INTFC_PHY_A/B
Unitize Assets
#3. #6.
(AMPS1000) (AMIF1000)
#5.
#1. INTFC_FIN
Unitize Assets
#8. #9. #10. #13.

Depreciation
Table
#7. On-line
Transactions
Express #12.
Add Calculate
#11. Depreciation
Open (AMDPCALC
Lease
Transactions
Express
Add
Basic
#14. #15.
Create Non- Create
Info.
#19.
JRNL_LN
Adjust
Transfer
#16.
DIST_LN #18.
Retire
#17.
Journal Generator

Step 4 (2) INTFC_PRE_AM
The Purchase Order and Accounts Payable transactions completed each day are
added to the INTFC-PRE-AM Table. The transactions accumulate and remain
here until the Pre-Interface Loader Program (AMPS 1000) is run.

Results:
Step 5 (3) Pre-Interface Loader Program (AMPS 1000)
The Pre-Interface Loader Program (AMPS 1000) is run each Friday night to
move data from the INTFC-PRE_AM Table to the INTFC_PHY-A and INTFC-
FIN Tables.

Results:
Step 6 (4) INTFC_PHY-A
The INTFC_PHY-A Table is the physical Transaction Loader Table. It is used to

populate physical transactions into the Asset Management database. Select users
are allowed access to this table to review interfaced data and perform certain
functions:
Set the Auto Approval Status to On or Off
Change the Load Status from Pending to Errored or from Errored to
Pending
Unitize (Load Unitize Assets Transaction)
Consolidate(Load Consolidate Assets Transaction)
Change the Profile ID or Description Location or Serial No.

Results:

Step 7 (5) INTFC_FIN
The INTFC_FIN Table is the financial Transaction Loader Table. It is used to

functions:
Pending
Consolidate (Load Consolidate Assets Transaction)
Change the Organization

Results:
Step 8 (6) Transaction Loader (AMIF 1000)
The Transaction Loader (AMIF 1000) is run each Friday night, moving asset
information from the INTFC_PHY-A and INTFC_FIN Tables to the Asset
Management Database and to the Open Transaction Table.

Results:
Step 9 (7) On-Line Transactions
On-Line transactions are processed on a daily or as-needed basis to add or modify

asset information. These transactions are stored on various Asset Management
tables and on the Open Transaction Table. The On-Line Transactions include
Asset Express Add, Retire/Reinstate, Adjust, Transfer and Asset Basic
Information (for miscellaneous data maintenance).

Results:

Step 10 (8) Asset Table
The Asset Table is in fact, a series of tables that track the physical attributes of an
asset: Asset ID, Description, Location, Custodian, Acquisition detail, Parent
Asset ID.

Results:
Step 11 (9) Book Table
The Book Table tracks the depreciation definition information for an asset book.

Results:
Step 12 (10) Cost Table
The Cost Table tracks the cost transactions for a given asset book.

Results:
Step 13 (11) Open Transaction Table
The Open Transaction Table is used to track open transactions. An entry is

created in this table for every financial transaction. This table serves as a to do
list for the depreciation calculation (AMDPCALC) and accounting entry creation
(AMAEDIST) programs. This table contains fields which control whether the
depreciation program needs to be executed for each transaction and whether the
accounting entry program needs to be executed for each transaction.

Results:

Step 14 (12) Calculate Depreciation (AMDPCALC)
The depreciation Calculation process (AMDPCALC) is run daily. It uses asset

information on the Open Transaction table to calculate depreciation for the life of
the asset. This information is stored on the Depreciation Table and is used to
create depreciation accounting entries. If subsequent changes are made to the
assets cost or depreciation attributes, depreciation will be recalculated. When
depreciation occurs it will effect the value not the acquisition cost.

Results:
Step 15 (13) Depreciation Table
The Depreciation Table stores depreciation information for each asset. The
depreciation information is created by the Depreciation Calculation program
(AMDPCALC).

Results:
Step 16 (14) Create Non-depreciation Accounting Entries (AMAEDIST)
Accounting Entry Creation (AMAEDIST) is run daily. It generates accounting

entries for all Asset Management transaction not related to depreciation or lease
payments. The accounting entries are written to the DIST_LN Table.

Results:

Step 17 (15) Create Depreciation Accounting Entries (AMDPCLOS)
The Depreciation Close process (AMDPCLOS) is run monthly. It generates

accounting entries for depreciation and lease payments for a given accounting
period. The entries are based on information calculated by the Depreciation
Calculation process and stored on the Depreciation Table. The accounting entries
are written to the DIST_LN Table.

Results:
Step 18 (16) DIST-LN Distribution Lines
The DIST_LN Table stores accounting entries created for an asset.

Results:
Step 19 (17) Journal Generator
The Journal Generator is run daily. It uses information from the DIST_LN Table
and Accounting Entry Templates to create information to send to the General
Ledger Journal Line and Journal Header Tables.

Results:

Step 20 (18) JRNL_HEADER
The Journal Header Table contains summary journal information being sent from
Asset Management to the General Ledger.

Results:
Step 21 (19) JRNL_LN
The Journal Line Table contains detailed journal information being sent from

Results:

Step 22 ACCOUNTING ENTRY GENERATION
The accounting entries which are generated by the Accounting Entry Creation
process (#14) are generated based on the Accounting Entry Template. This
template is setup based on Category and Transaction Type.
As asset transactions occur in the system, they are assigned specific Transaction
Types. These types are distributed to the ledger.
The following table illustrates the Transaction Types and their associated
Sources.
Transaction
Transaction Source
Type
Asset Express Add
ADD AP/PO Interface Add Load Type FAD/Fin Add
Asset Cost Adjustment/Transfer

ADJ AP/PO Interface Adj Load Type ADQ/Adjust CstAcqd
Asset Cost Transfer

TRF
Asset Retirement Transaction
RET
Asset Reinstatement Transaction
REI
Depreciation Entry
DPR
Prior Period Depreciation Entry
PDP

Results:
The following tables will illustrate the account number assignments for each Profile ID. These
tables can be used as a reference in the event that you need to determine the contra accounts that
are setup to be distributed to GL. The tables are separated by Governmental and Proprietary
Agencies.

Step 23 ASSET MANAGEMENT POSTING TO THE GFAAG LEDGER

(FOR GOVERNMENTAL AGENCIES)
USEFUL ASSET ACCUM REMOVAL CONTRA DEPR
PROFILE CATEGORY LIFE ACCT DEPR CONTRA ACCT EXP
ARTDEPDON ARTDD 480 185001 186001 475001 466001 740001
ARTDEPPUR ARTDP 480 185001 186001 475001 726002 740001
ARTNONDON ARTND 480 187001 NA 475001 466001 NA
ARTNONPUR ARTNP 480 187001 NA 475001 726001 NA
BLDG BLDG 378 171001 172001 475001 724001 740001
BLDG_10 BLDG 120 171001 172001 475001 724001 740001
BLDG_15 BLDG 180 171001 172001 475001 724001 740001
BLDG_20 BLDG 240 171001 172001 475001 724001 740001
BLDG_25 BLDG 300 171001 172001 475001 724001 740001
BLDG_30 BLDG 360 171001 172001 475001 724001 740001
BLDG_40 BLDG 480 171001 172001 475001 724001 740001
BLDG_NON SVAL 360 NA NA NA NA NA
BLGIMP05 BLDG 60 171001 172001 475001 724001 740001
BLGIMP10 BLDG 120 171001 172001 475001 724001 740001
BLGIMP15 BLDG 180 171001 172001 475001 724001 740001
BLGIMP20 BLDG 240 171001 172001 475001 724001 740001
COMP M&E 36 175001 176001 475001 720001 740001
COMPEQUIP M&E 60 175001 176001 475001 720001 740001
CSVALAST SVA 60 NA NA NA NA NA
EQ_AV M&E 60 175001 176001 475001 720001 740001
EQ_COMM M&E 60 175001 176001 475001 720001 740001
EQ_MT/FM M&E 60 175001 176001 475001 720001 740001
EQ_M_LAB M&E 60 175001 176001 475001 720001 740001
EQ_OFF_RD M&E 120 175001 176001 475001 720001 740001
EQ_OTHER M&E 60 175001 176001 475001 720001 740001
EQ_SCTY M&E 60 175001 176001 475001 720001 740001
FACIMP 5 IMPR 60 173001 174001 475001 725001 740001
FACIMP10 IMPR 120 173001 174001 475001 725001 740001
FACIMP15 IMPR 180 173001 174001 475001 725001 740001
FACIMP20 IMPR 240 173001 174001 475001 725001 740001
FACIMP25 IMPR 300 173001 174001 475001 725001 740001
FURN M&E 60 175001 176001 475001 720001 740001
HVAC M&E 60 175001 176001 475001 720001 740001
IMPR IMPR 180 173001 174001 475001 725001 740001
INFRA_15 INFR 180 183001 184001 475001 733001 740001
INFRA_20 INFR 240 183001 184001 475001 733001 740001
INFRA_25 INFR 300 183001 184001 475001 733001 740001
LAND LAND 60 170001 NA 475001 723001 NA
LCOMP LM&E 60 175001 176001 475001 200001 740001
LIB_COL LIB 120 177001 178001 475001 727001 740001
LMACH LM&E 60 175001 176001 475001 200001 740001
MACH M&E 60 175001 176001 475001 720001 740001
OFF_MACH M&E 60 175001 176001 475001 720001 740001
SMALLCOMP SVAL 36 NA NA NA NA NA
SMALLVALUE SVAL 60 NA NA NA NA NA
SMALVALVEH SVAL 36 NA NA NA NA NA
SOFT INT 120 168001 169001 475001 663001 740001
SVALASST SVA 60 NA NA NA NA NA
VEHICLE M&E 60 175001 176001 475001 720001 740001
WEAPONS M&E 60 175001 176001 475001 720001 740001
WEAPONSVAL SVAL 60 NA NA NA NA NA
*Loss, Gain, Trade In, Proceeds are charged to 475001 Proceeds from
disposition of General Fixed Assets
Results:

Step 24 ASSET MANAGEMENT POSTING TO THE GAAPACTUAL LEDGER

(FOR PROPRIETARY AGENCIES)
USEFUL ASSET ACCUM REMOVAL CONTRA DEPR
ARTDEPDONZ ARTDD 480 185001 186001 475001 466001 740001
ARTDEPPURZ ARTDP 480 185001 186001 475001 726002 740001
ARTNONDONZ ARTND 480 187001 NA 475001 466001 NA
ARTNONPURZ ARTNP 480 187001 NA 475001 726001 NA
BLDG_10_Z BLDGZ 120 171001 172001 475001 724001 740001
BLDG_15_Z BLDGZ 180 171001 172001 475001 724001 740001
BLDG_20_Z BLDGZ 240 171001 172001 475001 724001 740001
BLDG_25_Z BLDGZ 300 171001 172001 475001 724001 740001
BLDG_30_Z BLDGZ 360 171001 172001 475001 724001 740001
BLDG_40_Z BLDGZ 480 171001 172001 475001 724001 740001
BLDG_Z BLDGZ 378 171001 172001 475001 724001 740001
BLGIMP05Z BLDGZ 60 171001 172001 475001 724001 740001
BLGIMP10Z BLDGZ 120 171001 172001 475001 724001 740001
BLGIMP15Z BLDGZ 180 171001 172001 475001 724001 740001
BLGIMP20Z BLDGZ 240 171001 172001 475001 724001 740001
COMPEQUIPZ M&EZ 60 175001 176001 475001 720001 740001
COMP_Z M&EZ 36 175001 176001 475001 720001 740001
EQ_AV_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_COMM_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_MT/FM_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_M_LAB_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_OFFRD_Z M&EZ 120 175001 176001 475001 720001 740001
EQ_OTHER_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_SCTY_Z M&EZ 60 175001 176001 475001 720001 740001
FACIMP 5Z IMPRZ 60 173001 174001 475001 725001 740001
FACIMP10Z IMPRZ 120 173001 174001 475001 725001 740001
FACIMP15Z IMPRZ 180 173001 174001 475001 725001 740001
FACIMP20Z IMPRZ 240 173001 174001 475001 725001 740001
FACIMP25Z IMPRZ 300 173001 174001 475001 725001 740001
FURN_Z M&EZ 60 175001 176001 475001 720001 740001
HVAC_Z M&EZ 60 175001 176001 475001 720001 740001
IMPR_Z IMPRZ 180 173001 174001 475001 725001 740001
INFRA_15_Z INFRZ 180 183001 184001 475001 733001 740001
INFRA_20_Z INFRZ 240 183001 184001 475001 733001 740001
INFRA_25_Z INFRZ 300 183001 184001 475001 733001 740001
LAND_Z LANDZ 60 170001 NA 475001 723001 NA
LCOMP_Z LM&EZ 60 175001 176001 475001 200001 740001
LIB_COLZ LIBZ 120 177001 178001 475001 727001 740001
LMACH_Z LM&EZ 60 175001 176001 475001 200001 740001
MACH_Z M&EZ 60 175001 176001 475001 720001 740001
OFF_MACH_Z M&EZ 60 175001 176001 475001 720001 740001
SOFTZ INTZ 120 168001 169001 475001 663001 740001
VEHICLE_Z M&EZ 60 175001 176001 475001 720001 740001
WEAPONS_Z M&EZ 60 175001 176001 475001 720001 740001

D. Exercises
Activity Materials
PRACTICE GUIDE LIBRARY
Exercise 1 - Understanding Asset Profiles

Exercise 2 - Viewing Asset Profiles
Exercise 3 - Understanding Asset Categories
Exercise 4 - Viewing Asset Categories
Exercise 5 - Adding new Locations
These exercises will introduce you to some basic concepts within PeopleSoft
Asset Management.

Exercise 1 Understanding Asset Profiles
PeopleSoft Asset Management asset profiles make asset entry a breeze. You establish the
default depreciation calculations, limits, attributes and tax credits once in an asset profile, and
use one of these custom-made templates each time you acquire an asset. You can add assets in
realtime, mass, in process, or retroactively, and automate additions from accounts payable,
purchasing, and project accounting. Then validate asset entry using standard formulas or
defining your own, and post those transactions automatically to your general ledger.
Understanding profiles is one of the major layers of foundation to understanding PeopleSoft

Asset Management. The profile determines how an asset will be processed in the system. Will
the asset be depreciable? What books are going to be affected? What convention will be used
for the asset? These profiles are setup in advance so that when you are prepared to enter an asset
into the system, the amount of information that you will need to enter will be reduced.
ASSET
The following is a list of attributes of the car:

Capitalized asset
Depreciable
The asset is categorized as M&E
Useful life is 60 periods
Depreciation method is Straight Line
Lets say for example that your agency has purchased 50 new vehicles. Would you want to enter
the above detail for each of the 50 cars as you enter them into the system? To keep you from
having to enter the detail individually, PROFILES are setup.

Exercise 1 (continued)
PROFILE
VEHICLE
VEHICLES
Capitalized asset
Depreciable
M&E category
When an asset is added, the system will ask for a PROFILE.
Asset Before Profile: Profile Added After Profile:

to Asset
Capitalize? _________ Capitalize? Yes .
Depreciable? ___________ Depreciable? Yes .
Asset Category: _____________ VEHICLE Category: M&E .
1 Useful Life: ____________ Useful Life: 60 .
Method: _____________ Method: Straight Line .

Capitalize? _________ Capitalize? _________

Depreciable? ___________ Depreciable? ___________
Asset Category: _____________ Category: _____________
3 Useful Life: ____________ Useful Life: ____________
Method: _____________ Method: _____________

Method: _____________ Method: _____________

When adding an asset, once you specify that the asset has a PROFILE of Vehicle, the asset will
automatically receive the attributes: Capitalized, Depreciable, M&E Category, Useful Life of 60
periods, and Straight Line Depreciation.
Why did the attributes not default for Asset 3 and Asset 50?

Exercise 2 Viewing Asset Profiles
Scenario: This is background information for training. Asset Profiles provide

the default information youll use every day. The purpose of this
exercise is to show the valid Profiles in the system and to show
you what type of information defaults onto an asset based on the
profile.
online Library: Asset Profiles
Step 1 Toggle to PeopleSoft.
Logon to PeopleSoft, if necessary.
Expected The PeopleSoft window displays.

Results:
Step 2 Select: GoDefine Business RulesEstablish Asset Processing
Expected The Establish Asset Processing window displays.

Results:
Step 3 Select: Use A-MAsset ProfileDefinitionUpdate/Display
Expected A dialog box displays.

Results:

Step 4 Enter or select the following:
SetID: STATE
Asset Profile ID: COMP
Click: OK
Expected The Definition panel displays.

Results:
Step 5 Describe the significant fields on this panel.
Expected An understanding of the fields for this part of the Asset Profile
Results:
Step 6 Click on the tab for the Book General 1 panel.
Expected The Book General 1 panel displays.

Results:
Results:


Results:
Results:
Step 10 Click on the tab for the Book Tax panel.
Expected The Book Tax panel displays.

Results:
Results:
Step 12 Click on the tab for the Book Tax Credit panel.

Results:

Results:
Step 14
Click: to close this panel without saving any changes.
Expected The panel closes and you return to the Establish Asset Processing window.
Results:
Exercise completed.

Exercise 3 Understanding Asset Categories
Asset Categories classify assets by type for accounting entry purposes. Typically, these
categories reflect how assets are reported on your balance sheets. Examples of commonly used
asset categories are Furniture and Fixtures, Machinery and Equipment, Office Equipment,
Leasehold Improvements, and so forth.
In Exercise 2, we reviewed asset profiles. When asset profiles are setup, an asset category is
attached to that profile. In our previous example for the Vehicle profile, it had a category of
M&E.
PROFILE
VEHICLE
VEHICLES
Capitalized asset
Depreciable
M&E category
Note: When you add an asset, you will not be able to change the CATEGORY. The
category that appears on the asset will default based on the PROFILE ID.

to Asset
Earlier in the chapter, we reviewed the integration diagram which showed the process of how
data moves from AP/PO to AM and then to GL. One of the key aspects of moving data from
AM to GL is accomplished via Asset Categories. When an asset is added, we will specify the
Organization, BY, Cost, as well as additional financial information needed to be recorded for the
asset. However, we do not specify accounts in which to book the activity. This is how
categories are used within the system.

Categories are linked to specific accounts based on the transaction that is being performed on an
asset. A few examples of asset transactions include adds, adjustments, and retirements. These
categories correspond to Accounting Entry Templates that are created in the system. From the
templates, we are able to create balanced accounting entries to send to GL to account for our
assets.
Lets look at an example. Well use our previous example of the car.

to Asset
ACCOUNTING ENTRY TEMPLATE FOR

CATEGORY: M&E
TRANSACTION TYPE: ADD
TYPE ACCOUNT
DEPR EXPENSE 740001
FIXED ASSET 175001
CONTRA ACCOUNT 720001
ACCUM DEPR 176001
We just ADDED the asset into the system. We specified all of the Chartfield data
except for account because the account is assigned by the system based on the
Accounting Entry Template. What accounts will be used to generate the balanced
accounting entries to send to GL?
ACCOUNT ORG FUND PROGRAM SUB-CLS BY PROJECT AMOUNT
ASSET 1 _________ 400CNV A1 CNV CNV 2003 10R 8,000
ASSET 1 _________ 400CNV A1 CNV CNV 2003 10R -8,000
Note: For more account combinations, see Step 23 in the Concepts section of this chapter.

When journal generator is run, the accounting entry for the add will be sent to the general ledger.
A journal will be created and eventually posted to the ledger resulting in new balances for the
ledger accounts.
T-Accounts for the above example.
175001 720001
Dr Cr Dr Cr
8000 -8000
RECAP
VEHICLE M&E
Category
AGENCY ASSET ADDED TO SYSTEM

PURCHASES CAR WITH PROFILE
ACCOUNTING ENTRY
TEMPLATE FOR
CATEGORY: M&E
TYPE ACCOUNT
DEPR EXPENSE 740001
FIXED ASSET 175001
ACCUM DEPR 176001
GL
175001 720001
Dr Cr Dr Cr
8000 -8000 Journals are created and
account balances are
updated in GL
Note: The profile you select when adding an asset has a direct affect on the GL.

Exercise 4 Access and View Asset Categories
Scenario: This is background information for training. Asset Categories

classify assets for accounting entry purposes. The purpose of this
exercise is to show a list of valid categories in the system and to
see how categories affect depreciation.
online Library: Asset Categories

Results:
Step 2 Select: Go Define Business RulesEstablish Asset Processing

Results:
Step 3 Select: UseA-MCategoryUpdate/Display

Results:

SetID: STATE
Asset Category: M&E
Click: OK
Expected The Category panel displays.

Results:
Expected An understanding of the fields for Asset Categories.

Results:
Step 6
Results:
Exercise completed.

Exercise 5 Add a New Location
Locations provide information that is referenced in multiple places in Phoenix, including

business units, purchase orders, asset definitions, and bank accounts. Locations are used by AM,
AP, and PO users. In AM, the location specifies the physical location of an asset.
Note: There is a possibility that one location can be used by each one of these users. In
order to prevent any potential issues with one area modifying a location used by another
area, all AM locations will be added with a prefix of AM_.
Scenario: The purpose of this exercise is to enter into the system a new asset
location that does not currently exist.
online Library: Locations

Results:
Step 2 Select: GoDefine Business RulesDefine General Options
Expected The Define General Options window displays.

Results:
Step 3 Select: UseE-PLocationLocation DefinitionAdd

Results:

Step 4 Enter the following:
SetID: 40100
Location Code: AM_Your User ID
Note: All asset locations should be added with a preface of AM_.
Click: OK
Expected The Location Add panel displays.

Results:
Step 5 On the Location Definition panel.
Enter the following
Descr: Create your own

Address: Create your own
City: Create your own
State: Create your own
Postal: Create your own
Country: Create your own
If applicable, enter Building #, Floor, phone, and fax numbers.
Expected Correct data entry

Results:

Step 6 Location Definition
View the fields on this panel
Expected Correct data entry.

Results:
Step 7 Click: to save.
Expected The new information is saved.

Results:
Note: The Locations panel is used by multiple applications. Therefore, to ensure that
different areas do not update or modify other areas locations, only update locations that
begin with AM_. If you need to update a location that does not begin with AM_, re-add the
location and name it AM_xxx.
Exercise completed.

E. Summary and Review
Activity Materials
LECTURE GUIDE REVIEW
Step 1 ACTIVITY:
Update the Location that you just entered. Insert a new address for the
location which will become effective 10/12/2006.
SETID 40100
LOCATION AM_Your User ID
EFF DATE 10/12/2006

STATUS ACTIVE
DESCR FUTURE ADDRESS
ADDRESS 1 PO BOX 75342
Step 2 Answer the following questions:
1. Name three possible sources for asset data.

2. How does PeopleSoft identify which assets are depreciated and which are
not?
3. How do you access information about an assets profile?
4. What is the purpose of the LOCATION control table?
Hint: Answers can be found in the online Library.
Expected An understanding of the key concepts for Introduction to Asset Management

Results:

Fundamentals
Congratulations! You have just completed the Fundamentals section. This

module contained the tools needed to learn all concepts and procedures
involved in an overview of Asset Management.
Goal To have the skills and knowledge necessary to create and modify asset
information
Participant
Objectives You should be able to:

4. Describe the purpose of a profile
5. Describe the purpose of a category
6. Add a new location

SECTION 1:
FUNDAMENTALS
INSTRUCTOR AND PARTICIPANT GUIDE

NOVEMBER 2004
Fundamentals
Welcome to the Fundamentals section. This section contains the tools needed to
(deliver) learn all the concepts and procedures involved in an overview of Asset
Management.
Goal To have the skills and knowledge necessary to understand the overall asset
management process within PeopleSoft.
Participant

2. Understand how PeopleSoft Asset Management is integrated between
applications
3. Understand basic terminology within PeopleSoft Asset Management
4. Enter a new location
Outline Fundamentals
A. Introduction
B. The Big Picture
C. Concepts
D. Exercises
E. Review Questions
PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-I

NOVEMBER 2004 PARTICIPANT GUIDE INSTRUCTOR AND Participant Guide
1-II SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

Section Contents
FUNDAMENTALS
A. INTRODUCTION........................................................................................................5
B. THE BIG PICTURE ....................................................................................................7
C. CONCEPTS..................................................................................................................8
D. EXERCISES ...............................................................................................................22
Exercise 1 Understanding Asset Profiles..................................................................23

Exercise 2 Viewing Asset Profiles............................................................................26
Exercise 3 Understanding Asset Categories .............................................................30
Exercise 4 Access and View Asset Categories.........................................................33
Exercise 5 Add a New Location ...............................................................................35
PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-III

1-IV SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

FUNDAMENTALS
A. Introduction
Activity Materials Duration
Instructor Led: 15 min.
Introduce the overall goal and objectives.
Step 1 Goal: To have the skills and knowledge necessary to understand the overall
asset management process within PeopleSoft.
Lecture
Objectives:
4. Review valid asset profiles
5. Review valid asset categories
6. Understand the valid transaction types
7. Add location using the location panels

Results:
Introduce materials.
Step 2 Materials:
Lecture Participant Guide, flipchart, online Library, PeopleSoft

Results:

1. Review the course map to show how this module fits into the overall course.
2. Access the online Library on the PC with the participants.
following path:
Instructor/
Participant PHOENIX PROGRAM ASSET MANAGEMENT PROCESSES
Demo
Asset Management Fundamentals
Introduction
Expected The Asset Management Fundamentals Introduction selection displays.

Results:
Have participants view all topics available in the online Library. These topics are accessible in
various ways. Demonstrate using the Section Introduction pop-up links and Table of Contents.
Instructor/ The Asset Management Process Flow

Participant Asset Books
Demo
Asset Profiles
Asset Categories
Transaction Types
Locations
module.
Expected An understanding of the information available in the online Library for Asset
Results: Management Fundamentals.
Transition: Now move on to cover information in Asset Management Fundamentals.

B. The Big Picture
Activity Materials
LECTURE GUIDE
What is its
Who has a car? Value in 30 yrs? Category Location
value today?
$0
$15,000 Why? Value declines over Vehicles Garage
the 30 yrs. - Depreciation
This is an asset
What is its
Who has a computer? Value in 7 yrs? Category Location
value today?
$0 Small Home
$1,000 Why? Value declines over
the 7 yrs. - Depreciation Computers Office
This is an asset
What is its
Who has furniture? Value in 20 yrs? Category Location
value today?
$0 Home
$500 Why? Value declines over Furniture
the 20 yrs. - Depreciation Office
This is an asset
With these assets, you can see that we maintain some simple information about these
assets such as their COST, CATEGORY, and LOCATION. Within PeopleSoft, we can
also maintain much more information such as CUSTODIAN, ATTRIBUTES, and
COMMENTS. We will review these concepts more in depth throughout the manual.
Notice that the value of the assets decreases over the life of the asset. This is called
depreciation. Depreciation is the deduction of value of what an asset is worth today to
what it is worth tomorrow.

Asset management is the process of keeping records of the physical and financial information of
the assets in our possession. For GTA, it is the process of keeping a record of the physical and
financial information of GTAs assets.

The Big Picture (continued)
C. Concepts
Activity Materials
Before participants perform the procedures to successfully complete the objectives, they must
have a good understanding of the underlying concepts. This will serve as an advanced
organizer for the section.
Step 1 The main underlying concepts for the Asset Management introduction are listed
below:
Lecture
Asset Books
Asset Profiles
Asset Categories
Transaction Types
Locations

Results:

PeopleSoft Asset Management Process Flow
With PeopleSoft Asset Management, everyday activities become simpler, faster, and easier to
manage. Decision support and analysis features allow you to incorporate strategies and plan for
the future. You spend less time typing in numbers, and more time efficiently and effectively
planning acquisitions and managing your assets.
PeopleSoft Asset Management is designed to be integrated with the other PeopleSoft products
Payables, Purchasing, Projects, and General Ledger. This allows you to cut down on
information maintenance by sharing common tables and routines, entering assets using Accounts
Payable vouchers, and creating and posting journal entries to general ledger in real time.
The following diagram describes the Asset Management process flow within PeopleSoft.


#4.
#1. INTFC_PHY_A/B
Unitize Assets
#3. #6.
(AMPS1000) (AMIF1000)
#5.
#1. INTFC_FIN
Unitize Assets
#8. #9. #10. #13.

Depreciation
Table
#7. On-line
Transactions
Express #12.
Add Calculate
#11. Depreciation
Open (AMDPCALC
Lease
Transactions
Express
Add
Basic
#14. #15.
Create Non- Create
Info.
#19.
JRNL_LN
Adjust
Transfer
#16.
DIST_LN #18.
Retire
#17.
Journal Generator

Step 3 (1) Purchasing Accounts Payable
Lecture Assets are created outside of Asset Management by Purchasing and Payables. As a purchase
order or invoice is coded into the system, the users code the asset with a proper account and
Profile ID. The following chart shows some of the accounts that will be used.
ACCOUNT NO. ACCOUNT NAME ACCOUNT DEFINITION
Expenditures for items of tangible property of

a generally non expendable nature which
Equipment - maintain their utility over a period of time.
720001 Items charged to this account must be
Machinery & Equipment included on the equipment inventory and meet
the citeria for a movable personal property as
defined in OCGA 50-16-161
Expenditures for EDP Equipment which meet
721001 Computer Equipment the movable personal property requirements
of OGCA 50-16-161
723001 Land Expenditures made for the purchase of land
Expenditures made for acquiring and

Improvemnets
725001 improving buildings. These costs include the
Other than Buildings
principal amount of capital lease paymnets.
Expenditures/expenses for items of tangible
property of a generlly non-expendable
nature which maintain their utility over a
period of time. Items in this category must
Equipment required on have an acquisition cost less than the
616001 inventory, but not standard definition of movable personal
capitalized or depreciated. property set forth in OCGA 50-16-161.
These items however, will have been
included on the property management
inventory for management purposes.
Accounts Payable may also generate a voucher for a subsequent payment on a previous Purchase
Order. If the original Purchase Order or Voucher showed the Asset Management Routing
Indicator to have been clicked On, any subsequent voucher should also show the Asset
Management Routing Indicator as On.
The complete list of accounts can be found in the Accounting Procedures Manual on the Dept of
Audits website, http://www.audits.state.ga.us

Results:


#4.
#1. INTFC_PHY_A/B
Unitize Assets
#3. #6.
(AMPS1000) (AMIF1000)
#5.
#1. INTFC_FIN
Unitize Assets
#8. #9. #10. #13.

Depreciation
Table
#7. On-line
Transactions
Express #12.
Add Calculate
#11. Depreciation
Open (AMDPCALC
Lease
Transactions
Express
Add
Basic
#14. #15.
Create Non- Create
Info.
#19.
JRNL_LN
Adjust
Transfer
#16.
DIST_LN #18.
Retire
#17.
Journal Generator

Step 4 (2) INTFC_PRE_AM
Lecture The Purchase Order and Accounts Payable transactions completed each day are
added to the INTFC-PRE-AM Table. The transactions accumulate and remain
here until the Pre-Interface Loader Program (AMPS 1000) is run.

Results:
Step 5 (3) Pre-Interface Loader Program (AMPS 1000)
Lecture The Pre-Interface Loader Program (AMPS 1000) is run each Friday night to
move data from the INTFC-PRE_AM Table to the INTFC_PHY-A and INTFC-
FIN Tables.

Results:
Step 6 (4) INTFC_PHY-A
Lecture The INTFC_PHY-A Table is the physical Transaction Loader Table. It is used to
functions:
Pending
Consolidate(Load Consolidate Assets Transaction)
Change the Profile ID or Description Location or Serial No.

Results:

Step 7 (5) INTFC_FIN
Lecture The INTFC_FIN Table is the financial Transaction Loader Table. It is used to
functions:
Pending
Consolidate (Load Consolidate Assets Transaction)
Change the Organization

Results:
Step 8 (6) Transaction Loader (AMIF 1000)
Lecture The Transaction Loader (AMIF 1000) is run each Friday night, moving asset
information from the INTFC_PHY-A and INTFC_FIN Tables to the Asset
Management Database and to the Open Transaction Table.

Results:
Step 9 (7) On-Line Transactions
Lecture On-Line transactions are processed on a daily or as-needed basis to add or modify
asset information. These transactions are stored on various Asset Management
tables and on the Open Transaction Table. The On-Line Transactions include
Asset Express Add, Retire/Reinstate, Adjust, Transfer and Asset Basic
Information (for miscellaneous data maintenance).

Results:

Step 10 (8) Asset Table
Lecture The Asset Table is in fact, a series of tables that track the physical attributes of an
asset: Asset ID, Description, Location, Custodian, Acquisition detail, Parent
Asset ID.

Results:
Step 11 (9) Book Table
Lecture The Book Table tracks the depreciation definition information for an asset book.

Results:
Step 12 (10) Cost Table
Lecture The Cost Table tracks the cost transactions for a given asset book.

Results:
Step 13 (11) Open Transaction Table
Lecture The Open Transaction Table is used to track open transactions. An entry is
created in this table for every financial transaction. This table serves as a to do
list for the depreciation calculation (AMDPCALC) and accounting entry creation
(AMAEDIST) programs. This table contains fields which control whether the
depreciation program needs to be executed for each transaction and whether the
accounting entry program needs to be executed for each transaction.

Results:

Step 14 (12) Calculate Depreciation (AMDPCALC)
Lecture The depreciation Calculation process (AMDPCALC) is run daily. It uses asset
information on the Open Transaction table to calculate depreciation for the life of
the asset. This information is stored on the Depreciation Table and is used to
create depreciation accounting entries. If subsequent changes are made to the
assets cost or depreciation attributes, depreciation will be recalculated. When
depreciation occurs it will effect the value not the acquisition cost.

Results:
Step 15 (13) Depreciation Table
Lecture The Depreciation Table stores depreciation information for each asset. The
depreciation information is created by the Depreciation Calculation program
(AMDPCALC).

Results:
Step 16 (14) Create Non-depreciation Accounting Entries (AMAEDIST)
Lecture Accounting Entry Creation (AMAEDIST) is run daily. It generates accounting

entries for all Asset Management transaction not related to depreciation or lease
payments. The accounting entries are written to the DIST_LN Table.

Results:

Step 17 (15) Create Depreciation Accounting Entries (AMDPCLOS)
Lecture The Depreciation Close process (AMDPCLOS) is run monthly. It generates

accounting entries for depreciation and lease payments for a given accounting
period. The entries are based on information calculated by the Depreciation
Calculation process and stored on the Depreciation Table. The accounting entries
are written to the DIST_LN Table.

Results:
Step 18 (16) DIST-LN Distribution Lines
Lecture The DIST_LN Table stores accounting entries created for an asset.

Results:
Step 19 (17) Journal Generator
Lecture The Journal Generator is run daily. It uses information from the DIST_LN Table
and Accounting Entry Templates to create information to send to the General
Ledger Journal Line and Journal Header Tables.

Results:

Step 20 (18) JRNL_HEADER
Lecture The Journal Header Table contains summary journal information being sent from

Results:
Step 21 (19) JRNL_LN
Lecture The Journal Line Table contains detailed journal information being sent from

Results:

Step 22 ACCOUNTING ENTRY GENERATION
Lecture The accounting entries which are generated by the Accounting Entry Creation
process (#14) are generated based on the Accounting Entry Template. This
template is setup based on Category and Transaction Type.
As asset transactions occur in the system, they are assigned specific Transaction
Types. These types are distributed to the ledger.
The following table illustrates the Transaction Types and their associated
Sources.
Transaction
Transaction Source
Type
Asset Express Add
ADD AP/PO Interface Add Load Type FAD/Fin Add
Asset Cost Adjustment/Transfer

ADJ AP/PO Interface Adj Load Type ADQ/Adjust CstAcqd
Asset Cost Transfer

TRF
Asset Retirement Transaction
RET
Asset Reinstatement Transaction
REI
Depreciation Entry
DPR
Prior Period Depreciation Entry
PDP

Results:
The following tables will illustrate the account number assignments for each Profile ID. These
tables can be used as a reference in the event that you need to determine the contra accounts that
are setup to be distributed to GL. The tables are separated by Governmental and Proprietary
Agencies.

Step 23 ASSET MANAGEMENT POSTING TO THE GFAAG LEDGER

(FOR GOVERNMENTAL AGENCIES)
Lecture USEFUL ASSET ACCUM REMOVAL CONTRA DEPR
ARTDEPDON ARTDD 480 185001 186001 475001 466001 740001
ARTDEPPUR ARTDP 480 185001 186001 475001 726002 740001
ARTNONDON ARTND 480 187001 NA 475001 466001 NA
ARTNONPUR ARTNP 480 187001 NA 475001 726001 NA
BLDG BLDG 378 171001 172001 475001 724001 740001
BLDG_10 BLDG 120 171001 172001 475001 724001 740001
BLDG_15 BLDG 180 171001 172001 475001 724001 740001
BLDG_20 BLDG 240 171001 172001 475001 724001 740001
BLDG_25 BLDG 300 171001 172001 475001 724001 740001
BLDG_30 BLDG 360 171001 172001 475001 724001 740001
BLDG_40 BLDG 480 171001 172001 475001 724001 740001
BLDG_NON SVAL 360 NA NA NA NA NA
BLGIMP05 BLDG 60 171001 172001 475001 724001 740001
BLGIMP10 BLDG 120 171001 172001 475001 724001 740001
BLGIMP15 BLDG 180 171001 172001 475001 724001 740001
BLGIMP20 BLDG 240 171001 172001 475001 724001 740001
COMP M&E 36 175001 176001 475001 720001 740001
COMPEQUIP M&E 60 175001 176001 475001 720001 740001
CSVALAST SVA 60 NA NA NA NA NA
EQ_AV M&E 60 175001 176001 475001 720001 740001
EQ_COMM M&E 60 175001 176001 475001 720001 740001
EQ_MT/FM M&E 60 175001 176001 475001 720001 740001
EQ_M_LAB M&E 60 175001 176001 475001 720001 740001
EQ_OFF_RD M&E 120 175001 176001 475001 720001 740001
EQ_OTHER M&E 60 175001 176001 475001 720001 740001
EQ_SCTY M&E 60 175001 176001 475001 720001 740001
FACIMP 5 IMPR 60 173001 174001 475001 725001 740001
FACIMP10 IMPR 120 173001 174001 475001 725001 740001
FACIMP15 IMPR 180 173001 174001 475001 725001 740001
FACIMP20 IMPR 240 173001 174001 475001 725001 740001
FACIMP25 IMPR 300 173001 174001 475001 725001 740001
FURN M&E 60 175001 176001 475001 720001 740001
HVAC M&E 60 175001 176001 475001 720001 740001
IMPR IMPR 180 173001 174001 475001 725001 740001
INFRA_15 INFR 180 183001 184001 475001 733001 740001
INFRA_20 INFR 240 183001 184001 475001 733001 740001
INFRA_25 INFR 300 183001 184001 475001 733001 740001
LAND LAND 60 170001 NA 475001 723001 NA
LCOMP LM&E 60 175001 176001 475001 200001 740001
LIB_COL LIB 120 177001 178001 475001 727001 740001
LMACH LM&E 60 175001 176001 475001 200001 740001
MACH M&E 60 175001 176001 475001 720001 740001
OFF_MACH M&E 60 175001 176001 475001 720001 740001
SMALLCOMP SVAL 36 NA NA NA NA NA
SMALLVALUE SVAL 60 NA NA NA NA NA
SMALVALVEH SVAL 36 NA NA NA NA NA
SOFT INT 120 168001 169001 475001 663001 740001
SVALASST SVA 60 NA NA NA NA NA
VEHICLE M&E 60 175001 176001 475001 720001 740001
WEAPONS M&E 60 175001 176001 475001 720001 740001
WEAPONSVAL SVAL 60 NA NA NA NA NA
Results:

Step 24 ASSET MANAGEMENT POSTING TO THE GAAPACTUAL LEDGER

(FOR PROPRIETARY AGENCIES)
Lecture USEFUL ASSET ACCUM REMOVAL CONTRA DEPR
ARTDEPDONZ ARTDD 480 185001 186001 475001 466001 740001
ARTDEPPURZ ARTDP 480 185001 186001 475001 726002 740001
ARTNONDONZ ARTND 480 187001 NA 475001 466001 NA
ARTNONPURZ ARTNP 480 187001 NA 475001 726001 NA
BLDG_10_Z BLDGZ 120 171001 172001 475001 724001 740001
BLDG_15_Z BLDGZ 180 171001 172001 475001 724001 740001
BLDG_20_Z BLDGZ 240 171001 172001 475001 724001 740001
BLDG_25_Z BLDGZ 300 171001 172001 475001 724001 740001
BLDG_30_Z BLDGZ 360 171001 172001 475001 724001 740001
BLDG_40_Z BLDGZ 480 171001 172001 475001 724001 740001
BLDG_Z BLDGZ 378 171001 172001 475001 724001 740001
BLGIMP05Z BLDGZ 60 171001 172001 475001 724001 740001
BLGIMP10Z BLDGZ 120 171001 172001 475001 724001 740001
BLGIMP15Z BLDGZ 180 171001 172001 475001 724001 740001
BLGIMP20Z BLDGZ 240 171001 172001 475001 724001 740001
COMPEQUIPZ M&EZ 60 175001 176001 475001 720001 740001
COMP_Z M&EZ 36 175001 176001 475001 720001 740001
EQ_AV_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_COMM_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_MT/FM_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_M_LAB_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_OFFRD_Z M&EZ 120 175001 176001 475001 720001 740001
EQ_OTHER_Z M&EZ 60 175001 176001 475001 720001 740001
EQ_SCTY_Z M&EZ 60 175001 176001 475001 720001 740001
FACIMP 5Z IMPRZ 60 173001 174001 475001 725001 740001
FACIMP10Z IMPRZ 120 173001 174001 475001 725001 740001
FACIMP15Z IMPRZ 180 173001 174001 475001 725001 740001
FACIMP20Z IMPRZ 240 173001 174001 475001 725001 740001
FACIMP25Z IMPRZ 300 173001 174001 475001 725001 740001
FURN_Z M&EZ 60 175001 176001 475001 720001 740001
HVAC_Z M&EZ 60 175001 176001 475001 720001 740001
IMPR_Z IMPRZ 180 173001 174001 475001 725001 740001
INFRA_15_Z INFRZ 180 183001 184001 475001 733001 740001
INFRA_20_Z INFRZ 240 183001 184001 475001 733001 740001
INFRA_25_Z INFRZ 300 183001 184001 475001 733001 740001
LAND_Z LANDZ 60 170001 NA 475001 723001 NA
LCOMP_Z LM&EZ 60 175001 176001 475001 200001 740001
LIB_COLZ LIBZ 120 177001 178001 475001 727001 740001
LMACH_Z LM&EZ 60 175001 176001 475001 200001 740001
MACH_Z M&EZ 60 175001 176001 475001 720001 740001
OFF_MACH_Z M&EZ 60 175001 176001 475001 720001 740001
SOFTZ INTZ 120 168001 169001 475001 663001 740001
VEHICLE_Z M&EZ 60 175001 176001 475001 720001 740001
WEAPONS_Z M&EZ 60 175001 176001 475001 720001 740001

D. Exercises
Activity Materials
Review the exercise levels with the participants and let them know you will be walking them
through Level 1 exercises. Upon successful completion of Level 1 exercises, perform a quick
debrief, participants will proceed to Level 2 and 3 exercises.
Participants are directed to begin each exercise from Go in the PeopleSoft menu to clear the
data from the previous exercise. As participants become more comfortable in PeopleSoft, they
may recognize that they are already in the correct window and omit the Go step. In this case,
direct participants to click to close the panel.
Exercise 1 - Understanding Asset Profiles

Instructor/
Exercise 2 - Viewing Asset Profiles
Participant Exercise 3 - Understanding Asset Categories
Demo Exercise 4 - Viewing Asset Categories
Exercise 5 - Adding new Locations
Participant
Hands-on
These exercises will introduce you to some basic concepts within PeopleSoft
Asset Management.
Participant
Hands-on

Exercise 1 Understanding Asset Profiles
PeopleSoft Asset Management asset profiles make asset entry a breeze. You establish the
default depreciation calculations, limits, attributes and tax credits once in an asset profile, and
use one of these custom-made templates each time you acquire an asset. You can add assets in
realtime, mass, in process, or retroactively, and automate additions from accounts payable,
purchasing, and project accounting. Then validate asset entry using standard formulas or
defining your own, and post those transactions automatically to your general ledger.
Understanding profiles is one of the major layers of foundation to understanding PeopleSoft

Asset Management. The profile determines how an asset will be processed in the system. Will
the asset be depreciable? What books are going to be affected? What convention will be used
for the asset? These profiles are setup in advance so that when you are prepared to enter an asset
into the system, the amount of information that you will need to enter will be reduced.
ASSET
The following is a list of attributes of the car:

Capitalized asset
Depreciable
The asset is categorized as M&E
Lets say for example that your agency has purchased 50 new vehicles. Would you want to enter
the above detail for each of the 50 cars as you enter them into the system? To keep you from
having to enter the detail individually, PROFILES are setup.

PROFILE
VEHICLE
VEHICLES
Capitalized asset
Depreciable
M&E category
When an asset is added, the system will ask for a PROFILE.

to Asset


Method: _____________ Method: _____________

Method: _____________ Method: _____________

When adding an asset, once you specify that the asset has a PROFILE of Vehicle, the asset will
automatically receive the attributes: Capitalized, Depreciable, M&E Category, Useful Life of 60
periods, and Straight Line Depreciation.
Why did the attributes not default for Asset 3 and Asset 50?
Answer: No profile was specified for the assets.

Exercise 2 Viewing Asset Profiles
Scenario: This is background information for training. Asset Profiles provide

the default information youll use every day. The purpose of this
exercise is to show the valid Profiles in the system and to show
you what type of information defaults onto an asset based on the
profile.
online Library: Asset Profiles
Instructor/ Logon to PeopleSoft, if necessary.

Participant
Demo

Results:
Step 2 Select: GoDefine Business RulesEstablish Asset Processing

Instructor/
Participant
Demo
Results:
Step 3 Select: Use A-MAsset ProfileDefinitionUpdate/Display

Instructor/
Participant
Demo
Results:


Instructor/
Participant SetID: STATE
Demo
Asset Profile ID: COMP
Click: OK
Expected The Definition panel displays.

Results:

Instructor/
Participant
Demo
Results:

Instructor/
Participant
Demo
Results:

Instructor/
Participant
Demo
Results:


Instructor/
Participant
Demo
Results:

Instructor/
Participant
Demo
Results:
Step 10 Click on the tab for the Book Tax panel.

Instructor/
Participant
Demo
Results:

Instructor/
Participant
Demo
Results:
Step 12 Click on the tab for the Book Tax Credit panel.
Instructor/
Participant
Demo
Results:

Instructor/
Participant
Demo
Results:
Step 14
Results:
Exercise completed.

Exercise 3 Understanding Asset Categories
Asset Categories classify assets by type for accounting entry purposes. Typically, these
categories reflect how assets are reported on your balance sheets. Examples of commonly used
asset categories are Furniture and Fixtures, Machinery and Equipment, Office Equipment,
Leasehold Improvements, and so forth.
In Exercise 2, we reviewed asset profiles. When asset profiles are setup, an asset category is
attached to that profile. In our previous example for the Vehicle profile, it had a category of
M&E.
PROFILE
VEHICLE
VEHICLES
Capitalized asset
Depreciable
M&E category
Note: When you add an asset, you will not be able to change the CATEGORY. The
category that appears on the asset will default based on the PROFILE ID.

to Asset
Earlier in the chapter, we reviewed the integration diagram which showed the process of how
data moves from AP/PO to AM and then to GL. One of the key aspects of moving data from
AM to GL is accomplished via Asset Categories. When an asset is added, we will specify the
Organization, BY, Cost, as well as additional financial information needed to be recorded for the
asset. However, we do not specify accounts in which to book the activity. This is how
categories are used within the system.

Categories are linked to specific accounts based on the transaction that is being performed on an
asset. A few examples of asset transactions include adds, adjustments, and retirements. These
categories correspond to Accounting Entry Templates that are created in the system. From the
templates, we are able to create balanced accounting entries to send to GL to account for our
assets.
Lets look at an example. Well use our previous example of the car.

to Asset
ACCOUNTING ENTRY TEMPLATE FOR

CATEGORY: M&E
TYPE ACCOUNT
DEPR EXPENSE 740001
FIXED ASSET 175001
ACCUM DEPR 176001
We just ADDED the asset into the system. We specified all of the Chartfield data
except for account because the account is assigned by the system based on the
Accounting Entry Template. What accounts will be used to generate the balanced
accounting entries to send to GL?
ACCOUNT ORG FUND PROGRAM SUB-CLS BY PROJECT AMOUNT
ASSET 1 _________ 400CNV A1 CNV CNV 2003 10R 8,000
ASSET 1 _________ 400CNV A1 CNV CNV 2003 10R -8,000
Answer: 175001, 720001
Note: For more account combinations, see Step 23 in the Concepts section of this chapter.

When journal generator is run, the accounting entry for the add will be sent to the general ledger.
A journal will be created and eventually posted to the ledger resulting in new balances for the
ledger accounts.
T-Accounts for the above example.
175001 720001
Dr Cr Dr Cr
8000 -8000
RECAP
VEHICLE M&E
Category
AGENCY ASSET ADDED TO SYSTEM

PURCHASES CAR WITH PROFILE
ACCOUNTING ENTRY
TEMPLATE FOR
CATEGORY: M&E
TYPE ACCOUNT
DEPR EXPENSE 740001
FIXED ASSET 175001
ACCUM DEPR 176001
GL
175001 720001
Dr Cr Dr Cr
8000 -8000 Journals are created and
account balances are
updated in GL
Note: The profile you select when adding an asset has a direct affect on the GL.

Exercise 4 Access and View Asset Categories
Scenario: This is background information for training. Asset Categories

classify assets for accounting entry purposes. The purpose of this
exercise is to show a list of valid categories in the system and to
see how categories affect depreciation.
online Library: Asset Categories

Participant
Demo

Results:
Step 2 Select: Go Define Business RulesEstablish Asset Processing

Instructor/
Participant
Demo
Results:
Step 3 Select: UseA-MCategoryUpdate/Display

Instructor/
Participant
Demo
Results:


Instructor/ SetID: STATE
Participant
Demo Asset Category: M&E
Click: OK
Expected The Category panel displays.

Results:

Instructor/
Participant
Hands-On
Expected An understanding of the fields for Asset Categories.
Results:
Step 6
Instructor/
Participant
Demo
Results:
Exercise completed.

Exercise 5 Add a New Location
Locations provide information that is referenced in multiple places in Phoenix, including

business units, purchase orders, asset definitions, and bank accounts. Locations are used by AM,
AP, and PO users. In AM, the location specifies the physical location of an asset.
Note: There is a possibility that one location can be used by each one of these users. In
order to prevent any potential issues with one area modifying a location used by another
area, all AM locations will be added with a prefix of AM_.
Scenario: The purpose of this exercise is to enter into the system a new asset
location that does not currently exist.
online Library: Locations

Participant
Demo

Results:
Step 2 Select: GoDefine Business RulesDefine General Options

Instructor/
Participant
Demo
Expected The Define General Options window displays.
Results:
Step 3 Select: UseE-PLocationLocation DefinitionAdd

Instructor/
Participant
Demo
Results:


Instructor/
Participant SetID: 40100
Demo
Location Code: AM_Your User ID
Note: All asset locations should be added with a preface of AM_.
Click: OK
Expected The Location Add panel displays.

Results:
Step 5 On the Location Definition panel.

Instructor/
Participant Enter the following
Hands-On
Descr: Create your own

Address: Create your own
City: Create your own
State: Create your own
Postal: Create your own
Country: Create your own
If applicable, enter Building #, Floor, phone, and fax numbers.

Results:

Step 6 Location Definition

Instructor/
Participant View the fields on this panel
Hands-On

Results:

Instructor/
Participant
Demo

Results:
Note: The Locations panel is used by multiple applications. Therefore, to ensure that
different areas do not update or modify other areas locations, only update locations that
begin with AM_. If you need to update a location that does not begin with AM_, re-add the
location and name it AM_xxx.
Exercise completed.


Participant Hands-on: 45 min.
Step 1 ACTIVITY:
Small Group Update the Location that you just entered. Insert a new address for the
Discussion location which will become effective 10/12/2006.
or
SETID 40100
Pair Teaming LOCATION AM_Your User ID
w/Discussion
EFF DATE 10/12/2006
STATUS ACTIVE
DESCR FUTURE ADDRESS
ADDRESS 1 PO BOX 75342
Small Group 1. Name three possible sources for asset data.

Discussion 2. How does PeopleSoft identify which assets are depreciated and which are
or
not?
3. How do you access information about an assets profile?
Pair Teaming 4. What is the purpose of the LOCATION control table?
w/Discussion
Expected An understanding of the key concepts for Introduction to Asset Management

Results:
Answer: Purchasing, Accounts Payable, online asset entry via Asset ExpressAdd
Answer: It provides address information such as street address, suite number, etc.

Fundamentals
Congratulations! You have just completed the Fundamentals section. This

module contained the tools needed to learn all concepts and procedures
involved in an overview of Asset Management.
Goal To have the skills and knowledge necessary to create and modify asset
information
Participant

4. Describe the purpose of a profile
5. Describe the purpose of a category
6. Add a new location

SECTION 2:
ADDING AN ASSET VIA EXPRESSADD

NOVEMBER 2004
INSTRUCTOR AND PARTICIPANT GUIDE November 2004
Adding an Asset via ExpressAdd
Welcome to the Adding an Asset via ExpressAdd section! This section contains
the tools needed to (deliver) learn all the concepts and procedures involved in
performing Adding an Asset via ExpressAdd in Asset Management.
Goal To have the skills and knowledge necessary to create and modify manually
Phoenix asset information.
Participant
1. Add an asset using ExpressAdd

2. Understand parent child relationships
3. Add a parent asset
4. Add a child asset
2. Fundamentals of Asset Management
Outline Adding an Asset via ExpressAdd
A. Introduction
B. Business Process
C. Concepts
D. Exercises
E. Review Questions
PHOENIX - STATE OF GEORGIA SECTION 2: ADDING AN ASSET VIA EXPRESSADD 2-I

NOVEMBER 2004 INSTRUCTOR AND PARTICIPANT GUIDE
2-II SECTION 2: ADDING AN ASSET VIA EXPRESSADD PHOENIX - STATE OF GEORGIA

Section Contents
A. INTRODUCTION........................................................................................................1
B. BUSINESS PROCESS .................................................................................................3
C. CONCEPTS..................................................................................................................4
Adding an Asset using ExpressAdd...............................................................................5

Usage of Asset Dates .....................................................................................................6
D. EXERCISES ...............................................................................................................12
Exercise 1 - Adding an Asset using ExpressAdd ........................................................13

Exercise 2 - Creating Parent Child Relationships........................................................25
Exercise 3 - Add a Parent Asset Using ExpressAdd (Option 2)..................................26
Exercise 4 - Add a Child Asset Using ExpressAdd (Option 2) ...................................32
Exercise 5 - Add an Independent Parent ID (Option 3)...............................................39
PHOENIX - STATE OF GEORGIA SECTION 2: ADDING AN ASSET VIA EXPRESSADD 2-III

Instructor Notes
Before you begin this module
Make sure that students understand how to use their

data sheet
Explain that in the real world, their default business
unit will be based on their Operator ID
Remind them about how to use both the online Library
and PeopleBooks when they need more information
Remind students of navigational high points.
Make sure they understand that this module covers the
majority of work theyll do with the Asset Management
system.
2-IV SECTION 2: ADDING AN ASSET VIA EXPRESSADD PHOENIX - STATE OF GEORGIA

A. Introduction
Activity Materials
Step 1 Goal: To have the skills and knowledge necessary to create and modify asset
information manually.
Lecture
Objectives:
2. Understand parent child relationships
3. Add a parent asset
4. Add a child asset

Results:
Step 2 Materials:

Results:
PHOENIX - STATE OF GEORGIA SECTION 2: ADDING AN ASSET VIA EXPRESSADD 2-1

following path:
Instructor/
Demo
Adding Assets with ExpressAdd
Expected The topics display in the online Library.

Results:
Transition: Now move on to cover the business processes involved in performing manual asset
transactions.
2-2 SECTION 2: ADDING AN ASSET VIA EXPRESSADD PHOENIX - STATE OF GEORGIA

B. Business Process
Activity Materials
LECTURE GUIDE FLIPCHART HANDOUT
Step 1 Discuss the relevant business processes.
Lecture Business Process can be found on the web using the following path:
http://phoenix.gagta.com/
AM004 Asset ExpressADD
Expected The new business processes are identified and understood.

Results:

C. Concepts
Activity Materials
Step 1 The main underlying concepts for Adding an Asset via ExpressAdd are listed
below:
Lecture
Add an asset using ExpressAdd
Understand parent child relationships
Add a parent asset
Add a child asset
Expected An understanding of the major concepts involved in performing manual asset

Results: transactions.
following path:
Lecture
Introduction
Expected The Introduction section displays in the online Library.

Results:

Adding an Asset using ExpressAdd
When using ExpressAdd, adding assets using asset profiles to default book and depreciation
information is quick and efficientassets are automatically capitalized, you enter only the most
critical information, and much of that can be defaulted from the profile (as we saw in chapter 1).
Asset Management stores two types of asset information: financial and physical. Financial
information includes cost, books, depreciation method and convention, life, and so on. Physical
information includes such things as tag number, specifications, location, custodian, and
manufacturer.
In this chapter, we will begin entering assets into the system via the asset ExpressAdd panels.
For those assets that are not generated from AP, we will need to add these assets manually. As
we begin to add our assets, we will see that information is added to multiple panels.
PANEL PURPOSE
General 1 Used to populate your Profile and financial
information for the asset. This is the ONLY
panel you need to populate to add an asset.
General 2 Used to specify the acquisition date and
other descriptive information for the asset.
Book General 1 Used to view the depreciation status of the
asset based on the Profile selected.
Book General 2 Used to view additional depreciation
attributes of the asset based on the Profile
selected. Also used to set the assets in
service date.
Book Tax Used to view tax attributes for the asset
based on the Profile selected.
Book Tax Credits Used to view tax credit options for the asset
based on the Profile selected.
Asset Custodian Used to add the person who will have
possession of the asset.
Asset Comments Used to add any comments you need for
informational purposes.
Note: In the first chapter, we saw how important the profile is when adding an asset. All
of the information that defaults onto the Book -General 1, Book- General 2, Book-Tax, and
Book-Tax Credits panels defaults from the Profile.

Usage of Asset Dates
As you move through the AM system, you will see multiple dates on the panels. Each one of
these dates is used differently. Some of them are used solely for reporting purposes while others
affect depreciation calculation.
Note: Beginning fiscal year 2002, as a result of GASB 34, depreciation began to be
calculated and tracked for all assets over $5000.
The following is a list of the various date fields:
Acquisition Date
Date Time Stamp
In Service Date
Transaction Date
Accounting Date
Begin Depreciation Date
End Depreciation Date
Begin Calculation Date
DATE FIELD USAGE

Does Not Affect
Depreciation
Acquisition Date The date you actually acquired the asset. This field is used
for informational purposes only. It has no affect on
depreciation. The acquisition date will default with the
transaction date from the ADD.
Example
BU 98000 purchases a 2000 Dodge Van
This van was purchased on 10/1/1999.
Acquisition Date: 10/1/1999

Usage of Asset Dates (continued)
DATE FIELD USAGE

Does Not Affect Depreciation
Date Time Stamp The exact date/time that you saved a transaction (asset add,
adjustment, retirement, etc) to the system. The date time
stamp helps to prevent duplicate rows. The date time stamp
field does not affect depreciation.
Example 1
BU 98000 adds the 2000 Dodge Van into PeopleSoft on

11/14/2001 a little after 10am.
The user saves the asset ADD exactly at

2001-11-14-10.00.59.000000.
Date Time Stamp: 2001-11-14-10.00.59.000000
Example 2
BU 98000 adjusts the cost of the 2000 Dodge Van in

PeopleSoft on 2/25/2002 a little after 9am.
The user saves the asset ADJ exactly at

2002-02-25-09.00.23.000000.
Date Time Stamp: 2002-02-25-09.00.23.000000

DATE FIELD USAGE

Affects Depreciation
In Service Date The date the asset is available for use. The default In Service
Date will be the current system date of the entry.
The In Service Date affects when depreciation will begin.

Thus, the In Service Date will affect the Begin Depr Date.
Transaction Date This date reflects the date a transaction occurred for an asset.
The actual date an asset was added, adjusted, retired, etc. If
you purchased the asset 6/1/04, but didnt enter it into the
system until 8/1/04, the transaction date would be 6/1/04.
This represents the actual date the transaction occurred.
The Transaction Date is used in recalculating

depreciation. The difference between Transaction Date and
Accounting Date determines whether current period
depreciation for this transaction will be posted as
accumulated depreciation or whether any prior period
depreciation needs to be posted.
Accounting Date This date reflects the initial date an asset transaction will
impact the general ledger.
The accounting date will default with the current system date.
The accounting date must be within the current open
period, and it cannot be earlier than the transaction date.
Prior period depreciation is calculated if and only if

Accounting Date occurs after Transaction Date.
Begin Depr Date The date that PeopleSoft Asset Management will begin to
calculate depreciation for this asset. This date is system
calculated based on the assets In Service Date and
Convention (currently, all conventions are set to Following
Month).
The Begin Depr Date is used in recalculating depreciation.

DATE FIELD USAGE

Affects Depreciation
End Depr Date The date you would select if you wanted depreciation to cease
at a particular time. At the End Depr Date the remaining
asset basis will be taken in depreciation and the asset will be
fully reserved.
Note: Currently, this option is not available for use.
Begin Calc Date The date that PeopleSoft Asset Management will begin to
calculate depreciation for this asset. This date is system
calculated based on the assets In Service Date and
Convention (currently, all conventions are set to Following
Month).
Example 1
Today is September 1, 2004 and we are adding a new asset into the system.
The asset was placed in service on March 1, 2004 and since we are using the following month
convention, depreciation calculation will begin as of April 1, 2004.
months
1 2 3 4 5 6 7 8 9 10 11 12
period 7 period 8 period 9 period 10 period 11 period 12 period 1 period 2 period 3 period 4 period 5 period 6
3/1/04 4/1/04 9/1/04
In Service Date Begin Depr Date Today

Transaction Date Begin Calc Date Acctng Date
The accounting periods are closed for all previous periods. Since today is 9/1/04, the
only open period is period 3.
The Transaction Date occurs before the Acctng Date. Therefore prior period
depreciation will occur to account for the missed depreciation in periods 10,11,12,1, and
2.
The prior period depreciation will be booked into the current period.
Depreciation will be calculated based on the beginning depreciation date 4/1/04.


Example 2
Today is November 1, 2004 and we need to adjust the cost of an asset.
The asset was placed in service on March 1, 2004, and there was an increase in the cost of the
asset that occurred on July 1, 2004.
months
1 2 3 4 5 6 7 8 9 10 11 12
period 7 period 8 period 9 period 10 period 11 period 12 period 1 period 2 period 3 period 4 period 5 period 6
3/1/04 4/1/04 7/1/04 11/1/04
In Service Date Begin Depr Date Transaction Date Today

Begin Calc Date Acctng Date
The accounting periods are closed for all previous periods. Since today is 11/1/04, the
only open period is period 5.
The Transaction Date occurs before the Acctng Date. Therefore a new prior period
depreciation row will be created.
The prior period depreciation will be booked into the current period.
Depreciation will be calculated based on the beginning depreciation date 4/1/04, but it
will be adjusted as of the new transaction date of 7/1/04.
The new Begin Calc Date is set to the first day of the month in which the new transaction
occurred.

D. Exercises
Activity Materials
through Level 1 exercises. Upon successful completion of Level 1 exercises and a quick
debrief, participants will proceed to Level 2 and 3 exercises. Level 2 and 3 exercises are
performed independently by the participants.
Exercise 1 - Add an asset using ExpressAdd

Instructor/
Exercise 2 - Add a parent asset using ExpressAdd
Participant Exercise 3 - Add a child asset using ExressAdd
Demo
Participant
Hands-on

Exercise 1 - Adding an Asset using ExpressAdd
Scenario: Your department has purchased a new copier. Your goal is to

accurately enter this new copier as an asset in Phoenix.
online Library: Adding Assets with ExpressAdd

Participant
Demo

Results:
Step 2 Select: GoManage AssetsManage Assets
Instructor/
Participant
Demo
Expected The Manage Assets window displays.

Results:
Step 3 Select: UseAsset ExpressAddGeneral 1

Instructor/
Participant
Demo

Results:


Instructor/ Business Unit: 40100
Participant
Demo Asset ID: NEXT
Click: OK
Expected The General 1 panel displays.

Results:

Step 5 PROFILE ID
Instructor/ In Chapter 1, we reviewed the importance of profiles. The profile is used to
Participant
Demo
default pertinent information about the asset including depreciation information.
An important aspect to recognize is that different profiles will default different

information. Therefore, the selection of the profile will determine how the asset
is processed.
When entering an asset, GTA has put in place the policy that all assets over
$5,000 should be depreciated. Profiles can have one of two statuses, depreciable
or nondepreciable.
If you are adding an asset over $5,000, you must use a depreciable profile.
If you are adding an asset under $5,000, you must use a nondepreciable
profile.
The following is a list of nondepreciable profiles:
ARTNONDONZ ART-NON DEPR-DONATED-PROP

ARTNONDON ART-NON DEPR-DONATED- GOVT
ARTNONPUR ART-NON DEPR-PURCHASED-GOVT
ARTNONPURZ ART-NON DEPR-PURCHASED-PROP
BLDG_NON NON DEPRECIABLE BUILDING <100K
LAND LAND GOVT
LAND_Z LAND PROP
SMALLCOMP COMPUTER EQUIP < 5000.00
SMALLVALUE OTH MACH & EQUIP < 5000.00
SMALVALVEH SMALL VALUE VEHICLE < $5,000
WEAPONSVAL WEAPONS-SMALL VALUE < 5000.00
Expected Understanding of how profiles are related to depreciation.

Results:

Step 6 If you select an invalid profile based on the cost of the asset, you will receive a
message similar to one of the following:
Instructor/
Participant
Hands-On
Expected Understanding on selecting the right profile.

Results:
Step 7 Use the following table to enter data on the General 1 panel:
Instructor/ FIELD USAGE

Participant Profile See Step 5.
Hands-On Tag Number The tag number must be unique. You
cannot add multiple assets with the same
tag number for the same business unit.
Location Represents the physical location of the
asset.
Expected Understanding on the General 1 panel.

Results:

Step 8 Click .
Instructor/
Participant
Hands-On
Use the following table to enter the correct Transaction Information data:
FIELD USAGE
Transaction Date Defaults with todays date. The date the
actual transaction occurs.
Accounting Date Defaults with todays date. Represents
the period for which the activity is to be
booked to the general ledger
Note: See Usage of Asset Dates in the Concepts section of this chapter for
more information on the usage of date fields.
Click .

Results:

Step 9 On the Asset ExpressAdd General 1 panel.
Instructor/ Enter the following

Participant
Hands-On
Profile: OFF_MACH
Description: Xerox Copier
Tag Number Create your own number, making it consistent with your
agencys tag number.
Location: Your location created in Section 1 Exercise 3
PO #: Enter Purchase Order number
In the ChartFields panel, enter or select from the following:

Organization: 4011501000
Fund Code 1
Program 01000
Sub-cls 200
By: 2003
Project/Grant 01
Cost: $ 5500.00

Results:

Step 10 View the fields on this panel.
Instructor/
Participant
Demo
Note: This is the only panel you need to populate to add an asset. At this
point, you could save the asset, but we will continue and review the other
panels.
Expected Correct data entry and an understanding of the fields, including how their
Results: information defaults from the profile.

Step 11 Click: the General 2 tab to proceed to the General 2 panel.
Instructor/ The General 2 panel is used to enter additional information for the asset including
Participant the Asset Status and Acquisition Date.
Demo
Note: When an asset is added, it has an asset status of In Service. Once the
asset is retired, the asset will have a status of Disposed. Once an asset is
reinstated, the status will be automatically reset to In Service. The status is
located on the Asset table.
Note: The Acquisition Date will default with the Transaction Date. If you
need to change the Acquisition Date, you may change it on this panel.
Enter the following:
Serial ID: Enter valid serial number.

Step 12 Click the Book-General 2 tab.
Instructor/ The Book-General 2 panel is used to update the In Service Date if it is not the
Participant current date. The rest of the panel is display only with depreciation information
Demo
based on the profile.
Note: The In Service Date field appears blank, but when the asset is saved, it
is saved with the current system date.
Note: To process Prior Period Depreciation, enter an In Service Date which

occurs prior to the Accounting Date.
Expected An understanding of the Book-General 2 panel.

Results:

Step 13 Click the Asset Custodian tab.
Instructor/ The Asset Custodian panel is used to specify who physically has control of the
Participant asset.
Demo
Custodian: Last,First (No Spaces)
Expected The asset custodian is entered.

Results:

Step 14 Click the Asset Comments tab.
Instructor/ The Asset Comments panel is used to enter any pertinent comments about the
Participant asset.
Demo
Name: Last,First (No spaces)

Comments: Enter comment about this asset
Note: If using Value, Amt, Fed, Amt or Ref, Amt in name field, enter the
amount/reference number in Comments section.
Expected Correct data entry and an understanding of the fields.

Results:


Instructor/
Participant Note: The Asset ID is assigned after the asset is saved. Asset IDs are
Demo assigned based on business unit.
Expected The new information is saved. Note that the second book is automatically created
Results: for you. Category will also be added based on the profile ID you selected.
Note: Be sure to write down your tag number and asset ID number; you will be using
them in future exercises.
Instructor/
Participant
Demo
Note: The second book is automatically created for you. Category will also be
added based on the profile ID you selected. Your asset ID number is
generated.

Results:
Exercise completed.

Exercise 2 - Creating Parent Child Relationships
Some assets stand alone, while others are grouped together for ease of processing and reporting.
Parent/child assets are assets that are grouped together. For example, a computer is really a
number of different assetsa monitor, a CPU, and a printer. In PeopleSoft Asset Management
you can add this type of asset in the following ways:
Option 1. Add the computer as a single asset. This would capitalize the asset with one cost,
depreciate it as a single unit, and physically track it as one item. This is normal asset entry with
no parent child relationships.
Option 2. Identify one of the assets components as the parent when you are entering it. Asset
Management calls this a parent component asset. Assign it an Asset ID, and use that ID to tie
together the other components as children. As a result, each component has its own cost basis,
depreciation, and physical tracking information.
Option 3. Create a parent that is not really an asset but a reporting umbrella tying together the
various asset components. Asset Management calls this a parent only asset. Use its Asset ID to
tie together all the components as children. Each component has its own cost basis, depreciation,
and physical tracking information.
OPTION 1 OPTION 2 OPTION 3

1 Asset 2 Assets 2 Assets
Asset ID: 00000001 Asset ID: 00000001 Parent ID: NEWHIRE

CPU AND MONITOR CPU New Hire Computer Package
Cost $800 Cost $500 PARENT
PARENT
Asset ID: 00000002 Asset ID: Asset ID:

MONITOR
00000001 00000002
Cost $300 CPU MONITOR
CHILD Cost $500 Cost $300
CHILD CHILD
Parent asset is a real asset. Parent asset is a reporting entity.

Exercise 3 - Add a Parent Asset Using ExpressAdd (Option 2)
Scenario: Your department has purchased a new central processing unit

(cpu). This cpu must be added as a parent. After the parent is
added as an asset, you will add a color monitor as a child of this
parent.
Online Library: Adding Assets with ExpressAdd

Participant
Demo

Results:

Results:

Results:

Participant
Demo Asset ID: Next
Click: OK
Expected The General Info 1 panel displays.

Results:

Step 5 On the Asset ExpressAdd General 1 panel
Instructor/ Enter or select the following:

Participant
Hands-On
Profile: SMALLCOMP
Description: Dell CPU
Tag Number: Create your own number, making it consistent with your
agency's tag #


Fund Code 1
Program 01000
Sub-cls 200
By: 2003
Project/Grant 01
Cost: $ 500.00

Results:

Instructor/
Participant
Demo

Step 7 Click the General 2 tab to proceed to the General 2 panel.
Instructor/ View the fields on this panel.

Participant
Demo
Serial ID: Enter serial number
Parent/Child: Select Parent

Instructor/ Custodian: Last,First (No spaces)

Participant
Demo
Expected The custodian is added to the asset.

Results:
Instructor/ Enter the following:

Participant
Demo

Results:

Instructor/
Participant Note: Be sure to write down your tag number and asset ID number; you will
Demo be using them in future exercises.

Results:

Instructor/
Participant
Demo
generated.

Results:
Exercise completed.

Exercise 4 - Add a Child Asset Using ExpressAdd (Option 2)
Scenario: Your department has purchased a new 19 monitor to be used with

the Dell CPU. This monitor will be added as a separate asset and
attached to the CPU for reporting purposes. The monitor will be
added as a child of this parent.
Online Library: Adding Assets with ExpressAdd

Participant
Demo

Results:

Results:

Results:

Participant
Demo Asset ID: Next
Click: OK

Results:

Step 5 On the Asset ExpressAdd General 1 panel

Participant
Hands-On
Profile: SMALLCOMP
Description: Dell Color Monitor
Tag Number: Create your own number, making it consistent with your
agency's tag #


Fund Code 1
Program 01000
Sub-cls 200
By: 2003
Project/Grant 01
Cost: $ 300.00

Results:

Instructor/
Participant
Demo

Step 7 Click the General 2 tab to proceed to the General 2 panel.
Instructor/ View the fields on this panel.

Participant
Demo
Serial ID: Enter serial number
Parent/Child: Select Child
Parent ID: Enter Parent ID number of the Dell CPU (Dell CPU Asset ID)

Step 8 Click the Book General 2 tab.
Instructor/ In Service date should be entered on this panel.

Participant
Demo
Expected The in service date is entered.

Results:
Instructor/ Custodian: Last,First (No spaces)

Participant
Demo
Expected The custodian is added to the asset.

Results:


Participant
Demo

Results:

Instructor/
Participant Note: Be sure to write down your tag number and asset ID number; you will
Demo be using them in future exercises.
Expected The new information is saved. .

Results:

Instructor/
Participant
Demo
generated.

Results:
Exercise completed.

Exercise 5 - Add an Independent Parent ID (Option 3)
Scenario: We must keep a good working record of the number of new hire
computer packages. Therefore, the computer components that will
be purchased are going to be tracked for reporting purposes by one
ID number. Add the ID number for which we will be associating
Child assets.

Participant
Demo

Results:

Results:
Step 3 Select: UseParent Assets

Results:

Participant
Demo Parent ID: NEWHIRZZ (ZZ is your initials)
Click: OK

Results:

Instructor/
Participant
Demo

Results:

Step 6 Enter a description and any comments for the Parent ID.

Participant
Demo
Descr: New Hire Computer Package
Comments: This package should include a CPU and a monitor.

Results:

Instructor/
Participant
Demo
Expected The new information is saved. .

Results:
Exercise completed.


GUIDE REVIEW
Step 1 ACTIVITY:
Small Group Add a scanner to the new hire package that you just created. The scanner will
Discussion be added as a child to the new hire package.
or
BUSINESS UNIT 40100
Pair Teaming ASSET ID NEXT
w/Discussion
PROFILE ID SMALLCOMP
DESCRIPTION SCANNER
TAG NUMBER 7455612-ZZ (ZZ is your initials)
LOCATION Your location created in Section 1
Exercise 3
TRANS DATE 08012003
ORGANIZATION 4011501000
FUND 1
PROGRAM 01000
SUB-CLS 200
BY 2003
PROJECT 01
AMOUNT 100.00
SERIAL ID 89522347
PARENT ID NEWHIRZZ (Parent ID you created in
last exercise)
IN SERVICE DT 08012003
Answer: True. The same is true for reducing an assets cost.

Answer: True.

ADDING AN ASSET
BEFORE saving the asset with AFTER saving the asset with
the Profile ID the Profile ID
Second Book and Category are attached.
Depreciation Status is attached.
Depreciation Attributes are attached.

Adding an Asset via ExpressAdd
Congratulations! You have just completed the Adding an Asset via

ExpressAdd section. This section contained the tools needed to present all
the concepts and procedures involved in working with Adding an Asset via
ExpressAdd in Asset Management.
Participant

2. Add a parent asset using ExpressAdd
3. Add a child asset using ExpressAdd
1.
2.
3. Answer: 1. Obtain a number from Surplus Property.
2. Open the Asset Retirement panel for the asset.
3. Click the Retire button.
4. Enter the transaction number in the Reference Code field on the Transaction Info panel, making sure that the
Copy to Other Books checkbox is selected.

SECTION 3:
MANAGING ASSETS

NOVEMBER 2004
MANAGING ASSETS
Welcome to the MANAGING ASSETS section! This section contains the tools
needed to (deliver) learn all the concepts and procedures involved in performing
MANAGING ASSETS in Asset Management.
Goal To have the skills and knowledge necessary to create and modify manually
Phoenix asset information.
Participant
1. View and modify asset basic information

2. Adjust chartfields for an asset
3. Adjust net cost for an asset
4. Adjust quantities for an asset
5. Retire an asset
6. Reinstate an asset
7. Copy an asset
Outline MANAGING ASSETS
A. Introduction
B. Business Process
C. Concepts
D. Exercises
E. Review Questions
PHOENIX - STATE OF GEORGIA SECTION 3: MANAGING ASSETS 3-I

3-II SECTION 3: MANAGING ASSETS PHOENIX - STATE OF GEORGIA

Section Contents
MANAGING ASSETS
A. INTRODUCTION........................................................................................................1
C. CONCEPTS..................................................................................................................4
D. EXERCISES .................................................................................................................6
Exercise 1 - View and Modify Asset Basic Information ...............................................7

Exercise 2 - Adjust ChartFields for an Asset...............................................................17
Exercise 3 - Adjust Net Cost for an Asset ...................................................................22
Exercise 4 - Adjust Quantities for an Asset.................................................................27
Exercise 5 Retire an Asset ........................................................................................32
Exercise 6 Reinstate an Asset ...................................................................................37
Exercise 7 Copying an Asset ....................................................................................40
PHOENIX - STATE OF GEORGIA SECTION 3: MANAGING ASSETS 3-III

Instructor Notes
Before you begin this module
Make sure that students understand how to use their

data sheet
Explain that in the real world, their default business
unit will be based on their Operator ID
Remind them about how to use both the online Library
and PeopleBooks when they need more information
Remind students of navigational high points.
Make sure they understand that this module covers the
majority of work theyll do with the Asset Management
system.
3-IV SECTION 3: MANAGING ASSETS PHOENIX - STATE OF GEORGIA

MANAGING ASSETS
A. Introduction
Activity Materials
Step 1 Goal: To have the skills and knowledge necessary to create and modify asset
information manually.
Lecture
Objectives:
5. Retire an asset
7. Copy an asset

Results:
Step 2 Materials:

Results:
PHOENIX - STATE OF GEORGIA SECTION 3: MANAGING ASSETS 3-1

following path:
Instructor/
Demo
Working with Asset Basic Information
Adjusting, Transferring, and Adjusting Quantities
Adding and Maintaining Asset Leases
Retiring and Reinstating Assets
Expected The topics display in the online Library.

Results:
Transition: Now move on to cover the business processes involved in performing manual asset
transactions.
3-2 SECTION 3: MANAGING ASSETS PHOENIX - STATE OF GEORGIA

B. Business Process
Activity Materials
LECTURE GUIDE FLIPCHART HANDOUT
Lecture Business Process can be found on the web using the following path:
http://phoenix.gagta.com/
AM001 Adjust, Transfer, Assets

AM003 Asset Basic Information
AM006 Asset Retirements

Results:

C. Concepts
Activity Materials
Step 1 The main underlying concepts for MANAGING ASSETS are listed below:
Lecture View and modify asset basic information

Adjust chartfield for an asset
Adjust net cost for an asset
Adjust quantities for an asset
Retire an asset
Reinstate an asset
Copy an asset
Expected An understanding of the major concepts involved in performing manual asset

Results: transactions.
following path:
Lecture
Introduction
Expected The Introduction section displays in the online Library.

Results:

Managing Assets
Asset is purchased
Asset is added into PeopleSoft
NOW WHAT?
UPDATE ASSET ADJUST ASSET TRANSFER RETIRE /

PHYSICAL COST/QTY ASSET REINSTATE
INFORMATION ASSET
This chapter will provide the answers to the following questions:
I incorrectly added the asset with the wrong amount, what do I do?
How do I change the custodian for an asset?
We have sold an old asset, and no longer need to maintain the asset in the system, how do we
retire the asset?
My asset was retired in error, I need to reinstate the asset, what do I do?
How do I transfer an asset to another Org?

D. Exercises
Activity Materials
through Level 1 exercises. Upon successful completion of Level 1 exercises and a quick
debrief, participants will proceed to Level 2 and 3 exercises. Level 2 and 3 exercises are
performed independently by the participants.
Exercise 1 - View and Modify Asset Basic Information

Instructor/
Exercise 2 - Adjust ChartFields for an Asset
Participant Exercise 3 - Adjust Net Cost for an Asset
Demo Exercise 4 - Adjust quantities for an Asset
Exercise 5 - Retire an Asset
Participant Exercise 6 - Reinstate an Asset
Hands-on
Exercise 7 - Copying an Asset

Exercise 1 - View and Modify Asset Basic Information
In the previous chapter, we reviewed how we can add assets via the ExpressAdd panels. Once
the asset is added, you must use the Asset Basic Information panels to update the asset with any
physical attributes.
Used to add an asset
Used to update the

physical information
for an asset
Introduction: In this exercise, you will practice adding comments and custodians
and learn how to change locations. You'll be using the Asset Basic
Information panel group to view the data associated with the asset.
Scenario: You want to add some additional descriptive information about the
Xerox copier you created in Section 1, Exercise 1. Use the Asset
Basic Information panels to view its associated data.
online Library: Working with Asset Basic Information

Participant
Demo

Results:


Results:
Step 3 Select: UseAsset Basic InformationGeneral Info 1Update/Display

Results:

Participant
Demo Asset ID: Enter one of the following options from the asset added in
Section 1, Exercise 1:
Asset ID number
Parent ID number
Tag number
Serial ID number.
Click: OK

Results:

Step 5 General Info 1 Panel
Note: The General Info 1 panel is where you can view the current status of
the asset. As you retire and reinstate an asset, the Asset Status will change.

Results:
Step 6 View each of the following panels to see what information can be modified:
Note scroll Attributes License/Register
bars and
effective dates
Comments Manufacturer
on panels. Use Location Acquisition Detail 1
the online Custodian Acquisition Detail 2
Library to
discuss fields
in detail.
Expected An understanding of the fields on these panels
Results:

Step 7 Click the Comments tab.
This is where you would insert a new comment for the asset.
Note: To make additional comments, first insert a row by click F7 or .

Results:

Step 8 Click the Location tab.
Location Change
within the same
Currently located at New Location
Org
Location AP_402 AM_402
Dept of Dept of
Agriculture(AP Agricultutre (AM
Asset 0000318 Location) Location)
BU 40200
This is where you would insert a new location for the asset. To change a
Location, insert a row by clicking F7 or the Insert Row icon on the toolbar ,
then use the drop-down list attached to the Location field.
Note: If an asset is moved twice on the same day, you must use the Effective
Sequence field.
Note: The location represents the PHYSICAL location for an asset. If an

asset stays within a specific Org but changes physical location, ONLY the
location should be updated. No transfer has occurred.
Results:

Step 9 Click the Custodian tab.
This is where you would enter a new custodian for the asset.
Insert a row by clicking F7 or the Insert Row icon on the toolbar .
Enter name in name field.

Results:

Step 10 Click the Manufacturer tab.
This is where you will enter the federal percentage.
Expected An understanding of the Manufacturer panel

Results:

Step 11 Click the Acquisition Detail 1 tab.
This is where you can view the accounting information for the asset.
Note: This is not the panel in which you would modify the amount or
quantity of the asset to do an adjustment. There is a specific panel for cost
adjustments which we will cover later in this chapter.
Expected An understanding of the Acquisition Detail 1 panel.

Results:

Step 12 Click: Acquisition Detail 2
Note: This panel is where you can see if the asset was sourced from a Purchase
Order or Voucher.
Click or to determine if there is AP or

PO data associated with the asset.
If there is detail, you can also view the PO, Receiver, or voucher by clicking
on the Drilldown button.
Expected An understanding of the Acquisition Detail 2 panel

Results:


Instructor/
Participant
Demo

Results:
Exercise completed.
BEST PRACTICE:
ONLY PERFORM ONE TRASACTION PER DAY ON AN ASSET.
IF AN ASSET IS ADDED ON ONE DAY (FOR EXAMPLE, 5/1/20004),

PLEASE WAIT UNTIL THE NEXT DAY TO PERFORM ANY
ADJUSTMENTS (5/2/2004).
IF AN ADJUSTMENT IS MADE ON ONE DAY (5/2/2004), AND ANOTHER

TRASACTION SUCH AS A RETIREMENT NEEDS TO BE PERFORMED
ON THE ASSET, PLEASE WAIT UNTIL THE NEXT DAY (5/3/2004).
PLEASE CONTACT THE HELP DESK IF YOU HAVE ANY QUESTIONS.

Exercise 2 - Adjust ChartFields for an Asset
Scenario: A Compaq computer is being transferred from one organizational

unit within an agency to another. In this exercise, you will view
and change information on the Asset Cost Adjust/Transfers panel.
Transfer Asset to
Currently booked a new Org New Org
to 4020010205 4020030305
Dairy Lab- Atlanta Market
Asset 0000318
Atlanta Maintenance
BU 40200
online Library: Transferring Assets

Participant
Demo

Results:

Results:
Step 3 Select: UseAsset Cost Adjust/TransferUpdate/Display

Results:


Remind Business Unit: 40100
students to
refer to their Asset ID: 000000XX
Data Sheet for
the Asset ID. (Replace XX with the number assigned to you by your instructor.)
Click: OK
Expected The Current Cost panel displays.

Results:
Step 5 View this panel
Note: Modifications have been made not to allow more than one change per
transaction. Panel will not save more than one transaction and will gray out
after saving. You must then exit panel and re-enter panel to make additional
changes.
Expected Asset cost Adjust/Transfers panel displays.

Results:

Step 6
Click:
You have two options when selecting a Trans Type:
TRF: To transfer an asset to a new Chartfield combination

ADJ: To adjust either the quantity or the cost of an asset
Note: The Trans Date will affect any prior period depreciation that needs to
be booked in the current period if the date is less than the Acctg Date. See
Usage of Dates in Chapter 2 for more information on dates.
Expected The Transaction Information dialog box opens.

Results:
Step 7 Select a transaction type of Transfer and click: OK.
Expected The dialog box closes, saving your changes.

Results:

Step 8 Use the dropdown list to change the ORG Code of 4011501000 to 4011601000.
Instructor/ Note: To establish an audit trail, make one change per transaction and save
Participant the information.
Demo
Expected The panel reflects your changes.

Results:
Step 9 Compare your panel to the one shown here:
Note that the

Asset ID on
their panel
will be
different from
the one here.
Have students
provide
feedback on
the use of
multiple scroll
bars here.
Note: In this example, we conducted a transfer between Org 4011501000

and 4011601000. Only conduct actual transfers with the Cost Adjustment
panel. If this were only a location change, a transfer would not have been
necessary. A location change would have been made on the Asset Basic
Information panel
Expected The updated information is saved.

Results:


Instructor/
Participant
Demo

Results:
Exercise completed.
BEST PRACTICE:



Exercise 3 - Adjust Net Cost for an Asset
Scenario: The Compaq computers cost was incorrectly recorded as $3,500

when it was actually $3,250. A day has passed between the last
transaction, and we can now go back into this asset and make the
extra adjustment. In this exercise, you will view and change cost
information on the Asset Cost Adjust/Transfers panel.
online Library: Adjusting Units or Cost

Participant
Demo

Results:

Results:

Results:

students to
Data Sheet for
Click: OK

Results:

Step 5
Click: .

Results:
Step 6 Select a transaction type of Adjustment and click: OK.

Results:

Step 7
Click:
Expected The Adjust Net Cost dialog box displays.

Results:
Step 8 Enter the following in the Adjust Net Cost dialog box:
Note the use Adjust Cost: -250

of the minus
sign and ask
students how
This reduces the net cost by $250.00
they would
adjust the cost Remove any unnecessary zeros from the field.
UP. The
answer would Click: OK
be to enter a
positive
number in the Note: The Adjust Net Cost dialog box is used to determine by what
field. amount/quantity to increase or decrease the assets amount/quantity.
Note: Always use the adjust net cost button to make adjustments.
Expected The Adjust Net Cost dialog box closes and the Current Cost panel reflects your
Results: changes.

Step 9 Compare your panel to the one in the illustration:
Note the use

of multiple
scroll bars on
this panel.
Note: Modifications have been made not to allow more than one change per
transaction. Panel will not save more than one transaction and will gray out
after saving. You must then exit panel and re-enter panel to make additional
changes.
Results: changes.

Instructor/
Participant
Demo

Results:
Exercise completed.

BEST PRACTICE:



Exercise 4 - Adjust Quantities for an Asset
Scenario: A new piano was recorded as having a quantity of 50 when it was

added as an asset. In this exercise, you will correct this mistake
using the Adjust Cost Adjust/Transfers panels.
online Library: Adjusting Units or Cost

Participant
Demo

Results:

Results:

Results:

students to
refer to Data Asset ID: 000000XX
Sheet for the
Asset ID. (Replace XX with the number assigned to you by your instructor.)
Click: OK

Results:

Step 5
Click: .

Results:
Step 6 Select a transaction type of Adjustment and click: OK.

Results:

Step 7
Click:
Expected The Adjust Net Cost dialog box displays.

Results:
Step 8 Enter the following in the Adjust Net Cost dialog box:
Note the use Adjust Quantity: -49

of the minus
sign and
verify the
The default in the adjustment fields is a positive amount. If you want to adjust by
students a negative, you must include the minus sign.
understanding
Remove any unnecessary zeros from the field.
Click: OK
Note: The Adjust Net Cost dialog box is used to determine by what
amount/quantity to increase or decrease the assets amount/quantity.
Note: Always use the adjust net cost button to make adjustments.
Results: changes.

Step 9 Compare your panel to the one in the illustration:
Instructor/
Participant
Demo
Note the use

of multiple
scroll bars on
this panel.
Note: Modifications have been made that will prevent assets from having
quantities of less than one.
Expected The panel matches. Congratulations!

Results: If these elements do not match, review the steps and consult your Instructor.

Instructor/
Participant
Demo
Expected The updated information is saved.

Results:
Exercise completed.

BEST PRACTICE:



Exercise 5 Retire an Asset
Scenario: A filmstrip projector is no longer in service. Use the Asset

Retirement panels to change its status and record the number.
online Library: Retiring and Reinstating Assets

Participant
Demo

Results:

Results:
Step 3 Select: UseAsset RetirementsGeneral

Results:

students to
Data Sheet for
Click: OK
Expected The General panel displays.

Results:

Step 5
On the General panel, click: .
Note: The asset is not retired by just clicking the Retire button. The asset
will have to be saved before it is actually retired.
Expected The retirement fields become active.

Results:
Step 6 Identify the Transaction and Accounting Date fields.
Click: .
Note: The Trans Date determines when the retirement actually occurred. It
will affect backing out any potential depreciation that has already occurred.
See Usage of Dates in Chapter 2 for more information on dates.
Click OK.
Expected An understanding of the panel fields
Results:
Step 7 Select the following:
Disposal Code: Retirement by sale.
Expected The Quantity and Retire Amt fields change to reflect your selection.
Results:

Step 8 Identify the Quantity field, which is used to process a partial disposal.
Note: The system will automatically attempt to fully retire the asset. In
order to conduct a partial retirement, you will need to modify the quantity
field. By changing the QTY, the system will automatically update the
amount.
Expected An understanding of how to complete fields for a partial disposal
Results:
Step 9 Identify the Retire Amt field, which records the cost associated with processing a
partial disposal.
Note: The system will automatically attempt to fully retire the asset. In
order to conduct a partial retirement, you will need to modify the amount
field. By changing the amount, the system will automatically update the
QTY.
Expected An understanding of how to complete fields for a partial disposal
Results:
NOTE:
ONLY UPDATE THESE FIELDS IF CONDUCTING A PARTIAL

RETIREMENT.
THE BEST PRACTICE IS TO FULLY RETIRE THE ASSET AND LEAVE

THESE FIELDS ALONE. UPDATING THESE FIELDS FROM A
PARTIAL RETIREMENT TO A FULL RETIREMENT COULD CAUSE
THE SYSTEM NOT TO SET THE ASSET STATUS TO DISPOSED.

Step 10 Identify the Proceeds field.
Expected An understanding of how to locate the Proceeds field.

Results:
Step 11 Compare your panel to the one shown below:
Note multiple
scroll bars on
this panel.
Remind
students that
their Asset ID
will differ
from the one
in the
illustration.
Expected The panel matches. Congratulations!

Results: If these elements do not match, review the steps and consult your Instructor.

Instructor/
Participant Note: The asset is now retired.
Demo
Note: The Status in the upper right hand corner of the panel is now set to
Disposed.

Results:
Exercise completed.

BEST PRACTICE:



Exercise 6 Reinstate an Asset
Scenario: Now that you have successfully retired the filmstrip projector, we
determine that it needs to be placed back in service by being
reinstatement. A day has passed between the last transaction, and
we can now go back into this asset and perform the reinstatement.
This exercise will demonstrate how to reinstate a retired asset.
online Library: Retiring and Reinstating Assets

Participant
Demo

Results:

Results:
Step 3 Select: UseAsset RetirementsGeneral

Results:

Students
should use the Business Unit: 40100
Asset ID they
retired. Asset ID: 000000XX
(Replace XX with the number assigned to you by your instructor.)
Click: OK

Results:
Step 5
On the General panel, click: .
Expected Notice that all the fields on the panel become gray and cannot be edited.
Results:
Step 6 View the panels on this field
Expected Upon saving the panel, the asset will be reinstated.

Results:
Note: The asset status will still say Disposed. Cancel out of the panel then
repopen the panel. The status should now be updated to In Service.
Results:
Exercise completed.

BEST PRACTICE:



Exercise 7 Copying an Asset
PeopleSoft Asset Management can copy an asset, saving you time if the financial and physical
information for a new asset is similar to an existing asset. Just copy the existing asset and change
only the financial and/or physical information that is different, the system will automatically
assign the new asset a different asset ID or you can specify an asset ID.
Note: You can only use the Copy Asset feature to copy an asset within a business unit. You
cannot copy an asset to a different business unit.
Scenario: Your department just purchased two new Compaq computers.

Instead of adding the assets manually, well copy an existing asset
to create the two new assets.

Participant
Demo

Results:

Results:
Step 3 Select: UseCopy AssetAsset Copy

Results:


Students
should use the Business Unit: 40100
Asset ID they
retired. Asset ID: 000000XX
(Replace XX with the number assigned to you by your instructor.)
Click: OK

Results:

Step 5 Enter or select the following for the new asset(s) that will be created:
Students
should use the Description: Compaq Desktop Computer
Asset ID they
retired. Tag Number: 78344543-ZZ (ZZ is your initials)
Serial ID: 487952
Note: If you are only creating one new asset, the Description, Tag Number,
and Serial ID will be copied to the new asset. If you are creating more than
one asset, only the Description will be copied to the ADDITIONAL assets.
You will have to type in the Tag Number and Serial ID for each asset by
using the scroll bar.
Change the chartfield information if it is not going to be the same for the new
asset(s).
Note: If you need to allocate the cost across multiple ChartFields, click or
hit F7 on the keyboard to insert a new row. Your cursor must be in one of the
distribution fields in order to insert the row.
Expected The general information for the new asset(s) has been added.
Results:
NOTE: IF YOU ONLY WANT TO CREATE ONE NEW ASSET CLICK THE SAVE
BUTTON AND THE NEW ASSET WILL BE CREATED AND THE NEW ASSET ID
WILL BE ASSIGNED AT THE TOP OF THE PANEL.
TO CREATE MORE THAN ONE ASSET CONTINUE TO STEP 5.

Step 6 Using the folder tabs, select the Copy Options panel.
Students
should use the
Asset ID they
retired.
Expected The Copy Options panel is displayed.

Results:

Step 7 The Copy Options panel is used to determine which characteristics of the original
Students asset you want copied onto the new asset. The asset, book, cost, custodian, and
should use the location information is copied automatically, but you can select which additional
Asset ID they
retired.
attributes you want transferred. You can also specify how many new
ADDITIONAL assets you want created from the original asset.
Note: By default, saving the panel automatically creates a new asset. The
additional copies field specifies how many additional assets you want to
create:
Additional Copies Assets to Create

1 2
2 3
3 4
4 5
Lets create 2 new assets.
Additional Copies: 1
Click .
Note: The assets have not been created yet. The panel must be saved before
the asset(s) are created.
Expected The additional asset will be copied to the Asset Copy panel.
Results:
Step 8 Using the folder tabs, go back to the Asset Copy panel.
Students
should use the
Asset ID they
retired.
Expected The two new assets will appear.

Results:

Step 9 ASSET 1
Students
should use the
Asset ID they
retired.
ASSET 2

Expected The two new assets are created and assigned an asset id.
Results:
Exercise completed.


Step 1 ACTIVITY 1 :
Small Group Today is 4/12/04, and we recently purchased a new color printer for the
Discussion department. The asset has been tagged and needs to be added into PeopleSoft.
or
BUSINESS UNIT 40100
Pair Teaming ASSET ID ZZ-Asset (ZZ is your initials)
w/Discussion
PROFILE ID SMALLVALUE
DESCRIPTION Canon Color Printer
LOCATION Your location created in Section 1
Exercise 3
TRANS DATE 04012004
ORGANIZATION 4011501000
FUND 1
PROGRAM 01000
SUB-CLS 200
BY 2004
PROJECT 01
QUANTITY 5
AMOUNT 900.00
SERIAL ID 78944513

Activity 1 (continued):
Step 1 ACTIVITY 1 (continued):
Small Group The next day, we realize that the asset has the wrong quantity. We added it
Discussion with a quantity of 5 when we should have added it with a quantity of 1.
or
BUSINESS UNIT 40100
Pair Teaming ASSET ID Asset ID of asset you just added
w/Discussion
TRANS TYPE Adjustment
TRANS DATE 04/01/2004
QUANTITY 1
Later that afternoon, we realize that we actually purchased 5 printers, but we

only entered one of the assets into the system. We dont want to manually
enter the 4 additional assets. Make 4 copies of the existing monitor.
BUSINESS UNIT 40100

ASSET ID Asset ID of asset you just added
ADDITIONAL 4
COPIES

SERIAL ID 48789742
SERIAL ID 48789743
SERIAL ID 48789744
SERIAL ID 48789745
SERIAL ID 48789746
Hint: Use the scroll bar to go down to the next asset.

Activity 1 (continued):
Step 1 ACTIVITY 1 (continued):
Small Group Upon saving the assets, you realize that you actually created 5 new assets
Discussion when you only needed to create 4. Since all of the assets have a transaction
or
that has occurred today, lets wait until tomorrow then retire one of the assets.
Pair Teaming On 4/14/2004, we decide to go in to retire one of the assets.

w/Discussion
BUSINESS UNIT 40100
ASSET ID ZZ-Asset (ZZ is your initials)
DISPOSAL CODE Added in Error

TRANS DATE 04/13/2004
Small Group 1. Whats the most important thing to remember when using Asset
Discussion ExpressAdd?
or
2. If an asset has been added without a tag number or serial number, how do
you update the information in the database?
Pair Teaming 3. True or False: when you use Adjust Cost/Transfer to change an assets
w/Discussion ChartFields, its a good idea to change more than one ChartField before
saving the data.
4. True or False: to reduce the quantity for an asset, you enter a negative
number on the Adjust Net Cost window.
5. List the steps for retiring an asset.
Expected An understanding of the key concepts for Working with MANAGING ASSETS
Results:
Answer: To choose the correct Profile ID so that all information defaults correctly.
Answer: Use the Asset Basic Information panels.

Answer: False. Always save , close, and re-open the panel when changing ChartField information.
Answer: True. The same is true for reducing an assets cost.
Answer: True.
MANAGING ASSETS
Congratulations! You have just completed the MANAGING ASSETS

section. This section contained the tools needed to present all the concepts
and procedures involved in working with MANAGING ASSETS in Asset
Management.
Participant

5. Retire an asset
7. Copy an asset
1.
2.
3. Answer: 1. Obtain a number from Surplus Property.
2. Open the Asset Retirement panel for the asset.
3. Click the Retire button.
4. Enter the transaction number in the Reference Code field on the Transaction Info panel, making sure that the
Copy to Other Books checkbox is selected.

SECTION 4:
INQUIRING ON ASSETS

NOVEMBER 2004
INSTRUCTOR AND PARTICIPANT GUIDE NOVEMBER 2004
Inquiry
Welcome to the Inquiry module in Asset Management. This section contains the
tools needed to (deliver) learn all the concepts and procedures involved in
inquiring about asset-related information.
Goal To have the skills and knowledge necessary to view asset-related information.
Participant
1. Review asset cost history

2. Review voucher inquiry panels
3. Review purchase order inquiry panels
4. Review receiving inquiry panels
5. Review system news
Outline Inquiry
A. Introduction
B. Concepts
C. Exercises
D. Review Questions
PHOENIX - STATE OF GEORGIA SECTION 4: INQUIRING ON ASSETS 4-I

4-II SECTION 4: INQUIRING ON ASSETS PHOENIX - STATE OF GEORGIA

Section Contents
INQUIRY
A. INTRODUCTION........................................................................................................1
B. CONCEPTS ...................................................................................................................3
C. EXERCISES .................................................................................................................4
Exercise 1 Inquire about Asset Cost History ..............................................................5

Exercise 2 Inquire about Voucher Information ..........................................................8
Exercise 3 Inquire about Purchase Order Information .............................................10
Exercise 4 Inquire about Receiving Information......................................................19
Exercise 5 - Inquire about News Panel........................................................................21
D. SUMMARY AND REVIEW .....................................................................................23
PHOENIX - STATE OF GEORGIA SECTION 4: INQUIRING ON ASSETS 4-III

4-IV SECTION 4: INQUIRING ON ASSETS PHOENIX - STATE OF GEORGIA

Asset Management Inquiry
A. Introduction
Activity Materials
Step 1 Goal: To have the skills and knowledge necessary to view asset-related
information.
Lecture
Objectives:
5. Review system news

Results:
Step 2 Materials:

Results:
PHOENIX - STATE OF GEORGIA SECTION 4: INQUIRING ON ASSETS 4-1

following path:

Inquiring About Assets
Introduction
Expected The Reviewing Vouchers and Purchasing Information section displays.

Results:
Step 4 Note the topics available under Inquiry Procedures:
Inquiring about Asset Cost History

Inquiring about Vouchers
Inquiring about Purchase Orders
Inquiring about Receiving Information
Inquiring about Assets
Inquiring about System News
system.
Expected An understanding of the concept information in the online Library for Inquiring
Results: about Assets.
4-2 SECTION 4: INQUIRING ON ASSETS PHOENIX - STATE OF GEORGIA

B. Concepts
Activity Materials
Step 1 The main underlying concepts for inquiring about assets are listed below:
Lecture Asset Cost History

Purchase Orders
Vouchers
Receiving
Expected An understanding of this functionalitys underlying concepts

Results:
following path:
Lecture
Introduction
Inquiring about Asset Cost History
Inquiring about Vouchers
Inquiring about Purchase Orders
Inquiring about Receiving
Expected The sections display in the online Library.

Results:
The main concepts should be covered interactively.
Remind the participants that Effective Dating is used extensively throughout the Asset
Management modules. Check for understanding, use additional examples or discuss, if
necessary, as part of the discussion on concepts.

C. Exercises
Activity Materials
Instructor/ Exercise 1 - Inquire about Asset Cost History

Participant Exercise 2 - Inquire about Voucher Information
Demo
Exercise 3 - Inquire about Purchase Order Information
Participant Exercise 4 - Inquire about Receiving Information
Hands-on Exercise 5 - Inquire about News Panel

Exercise 1 Inquire about Asset Cost History
Scenario: Use the Asset Cost History Inquiry panel to view transactions for
an assets cost.
online Library: Inquiring About Assets

Participant
Demo

Results:

Results:
Step 3 Select: InquireAsset Cost HistoryCost History List

Results:
Business Unit: 40100

Asset ID: 00000069
Click: OK
Expected The Cost History List panel displays.

Results:

Step 5 View the information on the Cost History List panel.
Expected An understanding of general information about the assets cost history

Results:
Step 6 Click:
Expected The Cost History Detail panel displays.

Results:

Step 7 View the information on the Cost History Detail panel.
Instructor/
Participant
Hands-On
Expected An understanding of the detail about the assets cost history

Results:
Step 8
Instructor/
Participant
Demo
Expected The inquiry panel closes.

Results:
Exercise completed.

Exercise 2 Inquire about Voucher Information
Scenario: Use the Voucher Inquiry panel to view voucher information.
online Library: Inquiring About Vouchers

Results:

Results:
Step 3 Select: InquireVouchers

Results:
SetID: STATE
Voucher ID: 00000064
Click: OK
Expected The Voucher Inquiry panel displays, showing you the voucher and payment
Results: information.

Step 5 View the information on this panel.
Expected An understanding of the information on the panel

Results:
Step 6
Click: to close this panel.
Expected The panel closes and you return to the Manage Assets window.
Results:
Exercise completed.

Exercise 3 Inquire about Purchase Order Information
Scenario: Use the Purchase Order inquiry panels to view information about
purchase orders.
online Library: Inquiring About Purchase Orders

Results:

Results:
Step 3 Select: InquirePurchase OrdersHeader

Results:

Purchase Order: 0000000003
Click: OK
Expected The Purchase Order inquiry panels open, showing information for the specified
Results: purchase order.

Step 5 View the fields on the Header panel.
Click the tab for the Header 2 panel.
Expected An understanding of the information on the panels

Results:

Step 6 View the fields on the Header 2 panel.
Click the tab for the Lines panel.

Results:

Step 7 View the fields on the Lines panel.
Click the tab for the Line Details panel.

Results:

Step 8 View the fields on the Line Details panel.
Click the tab for the Schedule panel.

Results:

Step 9 View the fields on the Schedule panel.
Click the tab for the Distrib panel.

Results:

Step 10 View the fields on the Distrib panel.
Click the tab for the Distrib 2 panel.

Results:

Step 11 View the fields on the Distrib 2 panel.
Click the tab for the Comments panel.

Results:

Step 12 View the fields on the Comments panel.

Results:
Step 13
Click: to close this panel group.
Expected The panel group closes and you return to the Manage Assets window.
Results:
Exercise completed.

Exercise 4 Inquire about Receiving Information
Scenario: Use the Receiver Lines panel to view voucher information.
online Library: Inquiring About Receiving Information

Results:

Results:
Step 3 Select: InquireReceiving

Results:

Receiver ID Number: 0000000001
Click: OK
Expected A search results window opens, showing the line you specify.
Results:

Step 5 Select the receiver line.
Expected The Receiving Lines panel displays, showing the detail for the receiver you
Results: specify.
Expected An understanding of the information on this inquiry panel

Results:
Step 7
Expected The panel closes and you return to the Manage Assets window.
Results:
Exercise completed.
Exercise 5 - Inquire about News Panel
Scenario: Use the News panel to view changes to procedures and address
problem areas.

Participant
Demo

Results:
Step 2 Select: GoNews
Expected News panel displays.

Results:
Step 3 Select: UseNews

Results:

Remind System News: AM
students to
refer to Data
Sheet for the
Asset ID.
Expected News panel displays.

Results:

Step 5 View the panel to see which news panels have been posted.
Remind
students to
refer to Data
Sheet for the
Asset ID.
Note: The purpose of the News panels is to allow us to address pertinent

information on a more current basis. News panels will be used to notify users of
changes to procedures, to clarify procedures, and to address problems. News
panels will be posted periodically.
Expected An understanding of the fields on this panel.

Results:
Step 6
Instructor/
Participant
Demo
Expected The News panel closes.

Results:
Exercise completed.

D. Summary and Review

Small Group 1. If a Voucher ID is associated with an asset, how do you look up that
Discussion information beginning with the Review Assets option?
or
2. If you know a Receiver ID thats associated with an asset, how do you
inquire to find out more information about the receipt?
Pair Teaming 3. Describe the Asset Cost History Inquiry panels.
w/Discussion
Expected An understanding of the key concepts for Inquiring about Assets

Results:

Inquiry
Congratulations! You have just completed the Inquiry section. This section
contained the tools needed to present all the concepts and procedures
involved in inquiring about assets.
Goal You should have the skills and knowledge necessary to view asset-related
information Answer: 1. Select Inquire, Review Assets, Acquisition Detail 2.
1. Select an asset at the search window.
2. Click the Payables Info pushbutton.
3. View the information on the Payables Detail
Participant
Objectives You should be able to

5. Review the news panel
Answer: 1. Select Inquire, Receivers.

2. Select the Receiver at the search window.
Answer:
The General Information panel provides information about the assets status and acquisition, and indicates whether
this is a parent or child asset.
The Attributes panel provides physical information about the assets color, height, width, etc.
The Location panel provides information about where the asset is.
The Custodian panel provides information about who has or has had custody of the asset.
The License/Register panel provides license and/or registration information for the asset.
The Acquisition Detail 1 panel provides financial information about the acquisition of the asset.
The Acquisition Detail 2 panel enables you to access Purchase Order, Receiving, and Payables information related
to the asset.

SECTION 5:
AUTOMATED INTERFACE
TRANSACTIONS

NOVEMBER 2004
Automated Interface Transactions
Welcome to the Automated Interface Transactions section! This section contains

the tools needed to (deliver) learn all the concepts and procedures involved in
working with automated interface transactions between Phoenix Accounts
Payable/Purchasing and Asset Management.
Goal To have the skills and knowledge necessary to view and update Asset
Management information generated automatically from within Phoenix Accounts
Payable and Purchasing.
Participant
1. Describe the interface process that loads asset data from the Purchasing and
Accounts Payable applications
2. Define the terms consolidate and unitize assets
3. Navigate to and describe the information on the Voucher, Purchase Order, and
Receiving panels in order to review asset-related information
3. Manual Transactions
Outline Automated Interface Transactions

A. Introduction
B. Concepts
C. Exercises
D. Review Questions
PHOENIX STATE OF GEORGIA SECTION 5: AUTOMATED INTERFACE TRANSACTIONS 5-I

5-II SECTION 5: AUTOMATED INTERFACE TRANSACTIONS PHOENIX STATE OF GEORGIA

Section Contents
AUTOMATED INTERFACE TRANSACTIONS
A. INTRODUCTION........................................................................................................1
C. CONCEPTS...................................................................................................................4
D. EXERCISES .................................................................................................................7
Exercise 1 Preview Lines in Loader Tables................................................................9

Exercise 2 Consolidate Asset Load Lines.................................................................16
Exercise 3 Unitize Asset Load Lines........................................................................26
Exercise 4 Review Voucher Information..................................................................32
Exercise 5 Review Purchase Order Information.......................................................35
Exercise 6 Review Receiving Information ...............................................................38
E. SUMMARY AND REVIEW ......................................................................................41
PHOENIX STATE OF GEORGIA SECTION 5: AUTOMATED INTERFACE TRANSACTIONS 5-III

5-IV SECTION 5: AUTOMATED INTERFACE TRANSACTIONS PHOENIX STATE OF GEORGIA

A. Introduction
Activity Materials
Step 1 Goal: To have the skills and knowledge necessary to view and update Asset
Management information generated automatically from within
Lecture Phoenix Accounts Payable and Purchasing.
Objectives:
1. Describe the interface process that loads asset data from the
Purchasing and Accounts Payable applications. Describe on-line
transactions within Asset Management
2. Approve lines in the loader tables
3. Consolidate assets as appropriate
4. Unitize assets as appropriate
5. Describe the process and results of the Transaction Loader panel

Results:
Step 2 Materials:

Results:
PHOENIX STATE OF GEORGIA SECTION 5: AUTOMATED INTERFACE TRANSACTIONS 5-1

following path:

Working with Automated Interface Transactions
Introduction
Expected The Working with Automated Interface Transactions section displays.

Results:
The Purchasing/Payables Interface

Asset Load Line Consolidation
Asset Load Line Unitization
Transaction Loader
system.
Expected An understanding of the concept information in the online Library for Working
Results: with Automated Interface Transactions.
5-2 SECTION 5: AUTOMATED INTERFACE TRANSACTIONS PHOENIX STATE OF GEORGIA

B. Business Process
Activity Materials
Lecture AM002 Payables/Purchasing Interface to Asset Management

Results:

C. Concepts
Activity Materials
Step 1 The main underlying concepts for using the asset management interfaces are
listed below:
Lecture
Transaction Loader
Expected An understanding of this functionalitys underlying concepts

Results:

PAYABLES/PURCHASING INTERFACE
Asset Information can originate from either Purchasing or Payables.
PURCHASE ORDER VOUCHER
Batch Run Populates Batch Run

Payables/Purchasing Pre-AM Load Assets
Interface Table Request
Run every Friday Run nightly
Populates
Unitize
Asset
Management
Assets
Interface
Tables
Physical Financial Consolidate
Information Information Assets
Approved
asset
transactions
Batch Run Creates

Transaction Loader New PeopleSoft assets
for the specified
Run every Friday Business Unit

following path:
Lecture
Working with Automated Interface Transactions
Concepts
Transaction Loader
Expected The Concepts section displays in the online Library.

Results:

D. Exercises
Activity Materials
Exercise 1 - Preview Lines in Loader Tables

Exercise 2 - Consolidate Asset Load Lines
Participant Exercise 3 - Unitize Asset Load Lines
Hands-on Exercise 4 - Review Voucher Information
Exercise 5 - Review Purchase Order Information
Exercise 6 - Review Receiver Information
Participant
Hands-on


Populates
Unitize
Asset
Management
Assets
Interface
Tables
Approved
asset
transactions
Batch Run Creates

for the specified
Business Unit

Exercise 1 Preview Lines in Loader Tables
Once youve loaded your asset data into the loader tables, youll need to verify that the
information in the loader tables is correct, and approve all the load lines that you want to load
into PeopleSoft Asset Management. This review and approval process is designed to prevent
you from inadvertently loading massive amounts of erroneous data into your system.
Load Assets AP/PO Agency

AP Request Interface Intervention
Scenario: Pentium laptops were ordered and received. The voucher was
entered and the batch Load Assets Request and
Payables/Purchasing Interface programs have been run. As a
result, the data for these laptops is in the loader tables. In this
exercise, you will access these asset load lines and preview them.
online Library: Previewing Financial Information

Previewing Physical Information

Results:
Step 2 Select: GoManage AssetsInterface Asset Information
Expected The Interface Asset Information window displays.

Results:
Step 3 Select: UseLoad Preview Financial

Results:

Interface ID: XX
Line Num: X
(Replace the Xs with the numbers assigned to you by your instructor.)
Click: OK
Expected The Financial Transactions panel displays.

Results:

Instructor/ Identify the field that determines whether this asset load line will be used to
Participant create a new asset the next time that the Transaction Loader runs.
Hands-On
Expected An understanding of the fields on this panel

Results:

Step 6 The following table describes the important fields:

Note that the
list buttons Field Usage
gray out when
you select a Auto Approval Status The Auto Approval Status is used to
line. determine if the asset is approved to
be moved the AM tables via
Transaction Loader. If the check box
is off, Transaction Loader will not
pick up this asset, and the asset will
not be created.
Load Status Pending Transaction awaiting to be

processed
Loaded - Transactions loaded
Unitized - Transactions unitized (will
not be loaded)
Errored - Transaction errors
Consolidated - Transactions
consolidated (will not be loaded)
Replaced - Replaced by other
interface records
Note: The Auto Approval Status will automatically be turned on for new
asset adds. When there are cost adjustments, the Auto Approval Status will
be turned off. It is the Agencies responsibility to approve the perspective
adjustment and turn on the flag to send the adjustment to AM. The
adjustment will remain in the interface tables if the flag is not turned on.
Note: All Auto Approval flags should be updated by the Friday of each
week, and before the last day of each month to ensure that these transactions
will be processed in the current period.
Expected Understanding of the fields on the panel.

Results:
Step 7
Note that the Click to view the Load Preview Physical A panel for this asset load line.
list buttons Or
gray out when Select: UseLoad Preview Physical A
you select a
line.
Expected The Physical Transactions A panel displays.

Results:

Identify the field that determines whether this asset load line will be used to
create a new asset the next time that the Transaction Loader runs.
You can view or modify some descriptive information about the asset before it is
moved to the AM tables.
Note: Please be aware of the Load Type. If Load Type is Asset Cost
Adjustment, make sure the adjustment is going to the correct asset.
Note: If the Load Type is Asset Cost Adjustment the Auto Approval Status
will have a default of N. Verify that the transaction will be correct as an
adjustment and that it should not be a new asset ADD (FinAdd).
Expected An understanding of the fields on this panel

Results:

Step 9 Load Preview Phy A Custodians Panel
View the fields on this panel
You have the ability to enter the Custodian on this panel.
Expected An understanding of the fields on this panel.

Results:
Step 10
Expected The panel closes and you return to the Interface Asset Information window.
Results:
Exercise completed.


Populates
Unitize
Asset
Management
Assets
Interface
Tables
Approved
asset
transactions
Batch Run Creates

for the specified
Business Unit

Exercise 2 Consolidate Asset Load Lines
Scenario: A computer and a memory card were ordered and have been
received. The voucher was entered and the batch Load Assets
Request and Payables/Purchasing Interface programs have been
run. In this exercise, you will consolidate two asset load lines, one
for the computer and one for the memory card, into a single new
asset load line.
online Library: Consolidating Asset Load Lines

Results:

Results:
Step 3 Select: UseLoad - Consolidate AssetsFrom AssetsAdd

Results:
Step 4 Leave the ID set to 0 and click: OK.
Expected The FROM Assets panel displays.

Results:

Step 5
Beside the Search Field label, click on the . From the dropdown list, select
PO_ID.
Expected The field displays PO_ID as the Search Field.

Results:
Step 6
Remind Beside the Value: label, click on the to select a voucher ID.
students to
refer to their PO_ID: 70000010XX
Date Sheet for
the Voucher
ID. (Replace XX with the number assigned to you by your instructor.)
Expected The Value field displays the PO ID you select.

Results:
Step 7
Click to refresh the panel with the data that you have requested.
Expected The panel shows the asset load line information for the purchase order you
Results: specify.

Step 8 Notice that the scroll bar indicates there is only one row for this panel.
Verify that the PO ID assigned by your instructor appears on the panel:
The PO ID for the selected asset load line appears here on the panel. The
purchase order ID in the illustration may not be the same as the one assigned to
you. Verify that the system shows the purchase order ID you chose before
continuing with the exercise.
Note: Use scroll bar to view all asset load lines.
Expected The panel accurately reflects the selected data.

Results:

Step 9 When separate purchase orders are generated you may need to pull the second
purchase order down.
Remind
students to get Beside the label Value: click on the to select a second purchase order ID.
the Voucher
ID from their Press: <Tab> to move out of the field and activate the flashlight button.
Data Sheet.
Expected The second purchase order ID is selected for the Value: field.
Results:
Step 10
Click to refresh the panel with the data based on the second voucher ID.
Expected The panel refreshes with the asset load line information for the second purchase
Results: order.
Step 11 Use the scroll bar to view all asset load lines.
Note: To delete load line items that should not participate in the
consolidation, scroll to the line number and click Delete Row or press
F8. A dialog box will display. Click Yes to delete.
Expected Understanding the retrieval of data.

Results:
Step 12
Click on the tab.
Expected You move to the TO Asset panel.

Results:

Step 13 On this panel, you specify the information about the asset that youre creating by
consolidating multiple asset load lines.
Enter the following on the To Asset panel
Profile ID: COMP

Business Unit 40100
Expected As soon as you select the profile for the new asset, information from the asset
Results: load lines populates the TO Asset panel.

Step 14 View the updated panel fields. Note the following:
1. The ChartFields reflect the information from the purchase order

2. The Quantity field reflects the sum of the quantities from the two asset load
lines.
3. The Cost field reflects the sum of the cost from the two asset load lines.
4. The description defaults from the first line you select.
Expected An understanding of the fields that default from the asset load lines.
Results:

Step 15 Update the fields to reflect the following:
Profile ID: COMP
Click in Unit field. The panel will populate at this time.
Quantity: 1
Note: You should never consolidate and create an asset with a Quantity
greater than 1.

Results:
Step 16 Compare your panel to this one to verify the accuracy of your data entry:

Results:

Expected A message tells you, Warning -- The 'To' quantity is not equal to the sum of the
Results: 'From' quantities. Is this okay? (8005,52).
Step 18 Click: OK to accept the message. Since you have intentionally consolidated
multiple quantities from the two vouchers, this message does not indicate a
problem.
Expected Your consolidated asset load line is saved.

Results:
Exercise completed.



Populates
Unitize
Asset
Management
Assets
Interface
Tables
Approved
asset
transactions
Batch Run Creates

for the specified
Business Unit

Exercise 3 Unitize Asset Load Lines
Scenario: Ten Pentium laptops were ordered on a single voucher line. The
voucher was entered and the batch Load Assets Request and
Payables/Purchasing Interface programs have been run. In this
exercise, you will unitize an asset load line so that they will
become ten separate new assets.
online Library: Unitizing Asset Load Lines

Results:

Results:
Step 3 Select: UseLoad - Unitize AssetsFrom Asset

Results:

Step 4 Enter the following on the Update/Display Load Unitize Assets search window:
Remind Interface ID: XX
students to get
the interface Interface Line Number: XX
information Business Unit: 40100
from their
Data Sheet. (Replace the XXs with the numbers assigned by your instructor.)
Click: OK.
Expected A search list opens with the line you specify.

Results:
Step 5 Double-click on the line to select it.
Instructor/
Participant
Hands-On
Expected The FROM Asset panel displays with the selected asset load line.
Results:

Step 6 View the fields on this panel. Note the information in the Amount and Quantity
fields.
Expected An understanding of the fields you can view for the asset load line.
Results:
Step 7
Click: to unitize this asset load line proportionally.
Expected The Proportional Unitization Defaults window opens.

Results:

Step 8 Enter the following in the fields:
Quantity: 10
Profile ID: COMP
Description: Pentium laptop computer
Click: OK
Expected The window closes and the TO Asset panel displays with ten separate, newly
Results: created asset load lines.

Step 9 View the information on this panel. Use the scroll bar to scroll through the new
asset load lines created by unitizing a single asset load line into ten separate
assets.
Expected An understanding of how you can unitize a single asset load line into two or more
Results: assets
Expected The asset load line has been unitized and ten new assets can be created the next
Results: time that the Transaction Loader runs.
Exercise completed.


Populates
Unitize
Asset
Management
Assets
Interface
Tables
Approved
asset
transactions
Batch Run Creates

for the specified
Business Unit
Once Transaction Loader has been run in the batch process, the assets will be
created and can be accessed via the PeopleSoft Asset Management panels for any
updating.

Exercise 4 Review Voucher Information
Scenario: The Steinway pianos asset information is associated with a

voucher. In this exercise, you will look up voucher information.
online Library: Reviewing Voucher Information

Results:

Results:
Step 3 Select: UseAsset Basic InformationAcquisition Detail 2Update/Display

Results:
Step 4 Enter the following on the Update/Display Asset Basic Information search
window:

Asset Identification: 00000132
Click: OK.
Expected The Acquisition Detail 2 panel opens with the information for the asset you
Results: specify.

Step 5
Click: .
Expected The Payables Detail window opens, showing information for the asset..
Results:
Step 6 View the fields on this window.
Expected An understanding of the voucher information for this asset

Results:
Step 7
To see more information about the voucher for this asset, click
Expected An inquiry search window opens, with the voucher information defaulted into the
Results: search fields.
Step 8 The business unit on this search window indicates the AP business unit. Verify
the following information on the search window. If your system shows different
information, enter the following in these fields:
SetID: STATE
Vendor ID: 0000000089
Voucher ID: 00000064
When you have verified or changed these fields, click: OK.
Expected The Voucher Inquiry panel opens, showing you the voucher and payment
Results: information.

Step 9 View the fields on the Voucher panel.
Expected An understanding of the information on the panel

Results:
Step 10 Click to close the Manage Assets Inquire Vouchers window.
Expected The window closes and you return to the previous Manage Assets window.
Results:
Exercise completed.

Exercise 5 Review Purchase Order Information
Scenario: A pickup truck was ordered on a purchase order. In this exercise,

you will look up purchase order information for this asset.
online Library: Reviewing Purchase Order Information

Results:

Results:

Results:
window:

Click: OK.
Results: specify.

Step 5
Click:
Expected The Purchasing/Receiving Detail window opens..

Results:
Step 6 View the fields on this window. In the training database, these fields are not
populated but in your system, information entered to create an asset in the
Purchasing system may appear on the assets Acquisition Detail 2 panel.
Expected An understanding of the purchasing information

Results:
Step 7
To see more information about purchase orders, click beside the PO
Business Unit Field
Expected An inquiry search window opens.

Results:
Step 8 Enter the following information in the search fields:

Purchase Order: 0000000003
Click: OK
Expected The Purchase Order Inquiry panels open, showing information for the specified
Results: purchase order.

Step 9 View the fields on the Header, Lines, Line Detail, and Comments panels.

Results:
Step 10 Click to close the Manage Assets Inquire Purchase Orders window.
Results:
Exercise completed.

Exercise 6 Review Receiving Information
Scenario: The pickup truck from the previous exercise was received before it
became an asset. In this exercise, you will look up receipt
information for this asset.
online Library: Reviewing Receiving Information

Results:

Results:

Results:
window:

Click: OK.
Results: specify.

Step 5
Click:
Expected The Purchasing/Receiving Detail window opens..

Results:
Step 6 View the fields on this window. In the training database, these fields are not
populated but in your system, information entered to create an asset in the
Purchasing system may appear on the assets Acquisition Detail 2 panel.
Expected An understanding of the purchasing information

Results:
Step 7 To see more information about receiving:
Select Go Manage AssetsInquireReceivers.
Expected An inquiry search window opens.

Results:
Step 8 Enter the following information in the search fields:
Receiving Business Unit: 46000

ReceiverID Number: 0000000001
Click: OK
Expected A search results window opens, showing the line you specify.
Results:

Step 9 Select the receiver line.
Expected The Receiver Lines panel displays, showing the detail for the receiver you
Results: specify.
Expected An understanding of the information on this panel

Results:
Step 11 Click to close the Manage Assets Inquire Receivers window.
Results:
Exercise completed.


Small Group 1. Describe the Asset Management Automated Interface Transactions

Discussion process.
or
2. Define unitization and give an example of when your agency would use
this feature.
Pair Teaming 3. Define consolidation and give an example of when your agency would
w/Discussion use this feature.
4. True or false: as soon as asset information is entered in Payables, an asset
is created in Asset Management.
5. Describe the process for not approving an asset load line.
Expected An understanding of the key concepts for Asset Management Automated

Results: Interface Transactions
Answer: Unitization is when you break a single asset load line into multiple assets.
Answer: Consolidation is when you combine multiple asset load lines into a single asset.
Answer: False. The interface processes have to run with approved load lines before assets are created in Asset
Management
Answer: 1. Deselect the Auto Approval checkbox, or select errored.

2. Save the change.
3. Both Physical A and Financial panel are deselected.

BATCH PROCESSING AND AGENCY INTERVENTION
Process Process Frequency

Load Assets Request Daily
Payables Purchasing Interface Every Friday
Transaction Loader Every Friday
Depreciation Calculation Daily
Depreciation Close Once a month on last day of the month
Accounting Entry Creation Daily
MAY
Sun Mon Tue Wed Thurs Fri Sat
1 2 3 4 5 6 7
Agencies update Auto Approvals Trans Load

AP/PO Intf
Depr Calc Depr Calc Depr Calc Depr Calc Depr Calc
AE Creation AE Creation AE Creation AE Creation AE Creation
Load Asset Load Asset Load Asset Load Asset Load Asset
8 9 10 11 12 13 14
Agencies update Auto Approvals
Trans Load
AP/PO Intf
15 16 17 18 19 20 21
Agencies update Auto Approvals Trans Load

AP/PO Intf
22 23 24 25 26 27 28
Trans Load
AP/PO Intf
29 30 31
Depr Close
Depr Calc Depr Calc

AE Creation AE Creation
Load Asset Load Asset

Congratulations! You have just completed the Automated Interface

Transactions section. This section contained the tools needed to present all
the concepts and procedures involved in working with automated interface
transactions between Phoenix Accounts Payable/Purchasing and Asset
Management.
Goal You should have the skills and knowledge necessary to view and update Asset
Management information generated automatically from within Phoenix Accounts
Payable and Purchasing.
Participant
1. Describe the interface process that loads asset data from the Purchasing and
Accounts Payable applications
2. Define the terms consolidate and unitize assets
3. Navigate to and describe the information on the Voucher, Purchase Order, and
Receiving panels in order to review asset-related information

SECTION 6:
REPORTS

NOVEMBER 2004
Reports
Welcome to the Reports section! This section contains the tools needed to
(deliver) learn all the concepts and procedures involved in running reports in Asset
Management.
Goal To have the skills and knowledge necessary to access and run asset management
reports
Participant
1. Access and Run the Agency Inventory Report

2. Access and Run the Acquisition Cost Totals Report
3. Access and Run the Transactions Processed Report
4. Access and Run the Agency Detail/Summary Recon
5. Access and Run the Agency Reconciliation Summary
6. Access and Run the G/L Inventory Report
7. Access and Run the G/L Recon Detail/Summary Report
8. Access and Run the G/L Recon Summary Report
9. Access and Run the Agency Replacement Cost Report
10. Access and Run the Trial Balance Reporting
11. Access and Run the G/L Module Activity Report
12. Access Document Direct
13. Export data from Document Direct to an Excel spreadsheet
3. Manual Transactions in Asset Management
Outline Asset Management Reports
A. Introduction
B. Concepts
C. Exercises
D. Review Questions
PHOENIX - STATE OF GEORGIA SECTION 6: REPORTS 6-I

Section Contents
REPORTS
A. INTRODUCTION........................................................................................................1
B. CONCEPTS ..................................................................................................................3
C. EXERCISES .................................................................................................................6
Exercise 1 Access the Agency Inventory Report........................................................7

Exercise 2 Access and Run the Acquisition Cost Totals Report ..............................11
Exercise 3 Access and Run the Transactions Processed Report...............................13
Exercise 4 Access and Run the Agency Detail/Summary Recon .............................17
Exercise 5 Access and Run the Agency Reconciliation Summary...........................21
Exercise 6 Access and Run the G/L Inventory Report .............................................25
Exercise 7 Access and Run the G/L Recon Detail/Summary Report ......................29
Exercise 8 Access and Run the G/L Recon Summary Report ..................................33
Exercise 9 Access the Agency Replacement Cost Report ........................................37
Exercise 10 Access and Run the Trial Balance Reporting .......................................41
Exercise 11 Access and Run the G/L Module Activity Report ................................46
Exercise 12 Access Document Direct.......................................................................51
Exercise 13 Export Data from Document Direct to an Excel spreadsheet ..............59
D. SUMMARY AND REVIEW .....................................................................................77
6-II SECTION 6: REPORTS PHOENIX - STATE OF GEORGIA

PHOENIX - STATE OF GEORGIA SECTION 6: REPORTS 6-III

Asset Management Reports
A. Introduction
Activity Materials
Step 1 Goal: To have the skills and knowledge necessary to access and run some of
the Asset Management reports
Lecture
Objectives:

13. Export data from Document Direct to an Excel spreadsheet

Results:
Step 2 Materials:
Lecture Participant Guide, flipchart, online Library, Phoenix

Results:
PHOENIX - STATE OF GEORGIA SECTION 6: REPORTS 6-1

following path:
Instructor/
Demo
Processes, Reports, and Queries
Concepts
Process Scheduler, Understanding
Expected The selected section displays.

Results:
Step 4 Note the following topics available under Describe Concepts:
Instructor/ Process Scheduler, Understanding

Participant Reports, Understanding
Demo
Run Controls, Understanding
system.
Expected An understanding of the concept information in the online Library for using
Results: Process Scheduler to run report.
6-2 SECTION 6: REPORTS PHOENIX STATE OF GEORGIA

B. Concepts
Activity Materials
Step 1 The main underlying concepts for using the asset management reports are listed
below:
Lecture
Process Scheduler
Reports
Run Controls
Expected An understanding of this functionalitys underlying concepts.

Results:
following path:
Lecture
Processes, Reports, and Queries
Concepts
Process Scheduler, Understanding
Reports, Understanding
Run Controls, Understanding
Expected The Concepts section displays in the online Library.

Results:

Step 3 Read and discuss the following brief introductions for the main underlying
concepts.
Instructor/
Participant Note: If you do not have access to run G/L Reports , contact your Phoenix
Demo
security administrator to obtain access to the security class MARPTORD
Asset Management reports with Agency as part of the report name are for
internal reconciliation of Asset Management Activity. These reports track
and reconcile activity for the Transaction Dates specified on the Report Panel.
Asset Management reports with General Ledger as part of the report name
are for the external reconciliation of Asset Management Activity i.e.,
reconciling to the General Ledger. These reports track and reconcile Asset
Management activity between the Accounting Periods specified on the Report
Panel.
Agency Reports include all activity entered into the Asset Management data
base, whether posted to the General Ledger or not. These reports include
assets assigned SMALLVALUE and WEAPONSVAL profiles. Agency
Reports are based on Transaction Date.
General Ledger reports include only activity entered into the Asset
Management database that has been posted to the General Ledger. These
reports do not include assets assigned SMALLVALUE and WEAPONSVAL
profiles. General Ledger reports are based on Accounting Period/Fiscal Year.
There are two versions of the Trial Balance, GAAP and Budget Basis.
The primary difference is the GAAP does not include encumbrances in the
beginning balance or in the transactions column. The Budget Basis version
does. The Budget Basis version may be more useful when trying to balance
expenses to a Budget Comparison Report while the GAAP version may be
needed if you want to report expenses separately from encumbrances.
However neither version includes pre-encumbrances (requisitions) in the
balances.
Expected An understanding of reports.

Results:

Step 4 Document Direct: A graphical interface. The tool used to retrieve the stored
information from InfoPac. The data can be displayed or printed at the users
Lecture discretion. Another option is sending the data to Excel for customized
displays.
InfoPac: Report distribution system. Stores, sorts, and directs the data to the
appropriate user.
Crystal Reports: On-line reports from Phoenix. These reports are displayed
on your monitor and the output can be exported directly to Excel.
The Crystal Reports option provides a powerful report writing tool because it
allows you to customize the format of any query result. You can use pre-
defined design layouts as well as customize your own design layouts.
SQR Reports: Are typically overnight, batch processed reports. Some SQR
reports run nightly, Dalies; others must be specifically requested. These
reports are stored in InfoPac and can be accessed from five days to six months
after the initial report request. The length of time depends on the report itself
and the agency making the request. Dalies are not requested by the user or if a
report has aged off the system it will be necessary to call the help desk for
retrieval.

Results:

C. Exercises
Activity Materials
Exercise 1 - Access the Agency Inventory Report

Instructor/
Exercise 2 - Access the Acquisition Cost Totals Report
Participant Exercise 3 - Access the Transactions Processed Report
Demo Exercise 4 - Access and Run the Agency Detail/Summary Recon
Exercise 5 - Access and Run the Agency Reconciliation Summary
Participant Exercise 6 - Access and Run the G/L Inventory Report
Hands-on
Exercise 7 - Access and Run the G/L Recon Detail/Summary Report
Exercise 8 - Access and Run the G/L Recon Summary Report
Exercise 9 - Access and Run the Agency Replacement Cost Report
Participant Exercise 10 - Access the Trial Balance Reporting
Hands-on Exercise 11 - Access and Run the G/L Module Activity Report
Exercise 12 - Access Document Direct
Exercise 13 - Export data from Document Direct to an Excel spreadsheet

Exercise 1 Access the Agency Inventory Report
Scenario: Your supervisor has asked you to run a current Agency Inventory
Report
online Library: Processes/Reports, Running

Participant
Demo

Results:
Instructor/
Participant
Demo
Expected The Manage Assets window opens.

Results:
Step 3 Select: ReportAgency Inventory ReportAdd
Expected A dialog box displays, asking you for a run control.

Results:
Run control: AGENCYINV
Click: OK
Expected The Agency Inventory Report panel opens

Results:

Step 5 On the Agency Inventory Report panel, enter the following:

Profile ID: COMP
Sort Options: By Org, Location, Tag Number
As shown this report lists in service only, to request all assets for all Asset
Statuses (In Service, Stolen, Missing and Disposed) leave status blank.
Note: Choosing any other options will narrow the search.
Agency Inventory Report - AMXXX0402
Expected An understanding of the fields used in the report.

Results:

Step 6
Click to run the report.
Expected The Process Scheduler window opens.

Results:
Step 7 View the fields on the Process Scheduler panel.
Run Location: SERVER

Server: PSUNX
Output Destination: File
File/Printer: To be assigned at agency level
Run Recurrence: Report Request Run Recurrence
Expected An understanding of the run output options

Results:

Step 8 Click: OK to request report.
Note: If reports are requested prior to 12:30 p.m., reports will be run the same
night; if requested after 12:30 p.m., reports will run the following night.
Note: Any asset record where the serial number exceeds the print space allowed,
the serial number field will be blank, a second line will print showing the serial
number in full.
Expected An understanding of when the reports will print.

Results:
Step 9
Click: to close the report panel.
Instructor/
Participant
Demo
Expected The report panel closes and you return to the Manage Assets window.
Results:
Exercise completed.

Exercise 2 Access and Run the Acquisition Cost Totals Report
Scenario: Your supervisor has asked you to run a current Acquisition Cost
Totals Report.

Participant
Demo

Results:

Results:
Step 3 Select: ReportAgency Acquisition Cost TotalsUpdate/Display

Results:
Run control: ACQCOST
Click: OK
Expected The Acquisition Cost Totals Report panel opens

Results:

Step 5 On the Agency Acquisition Cost Totals Report panel.
Enter the following

As of Date: Current Date
Sort Options: By Org, Location,
Note: Report will not run unless a sort option has been chosen.

Results:
Step 6 Click Run Report button to run the report.
Note: This report is different in that you do not go to the process scheduler to
request the report.
.
Expected The Report is requested.
Results:
Exercise completed.

Exercise 3 Access and Run the Transactions Processed Report
Scenario: Your supervisor has asked you to run a current Transactions

Processed Report.

Participant
Demo

Results:

Results:
Step 3 Select: ReportAgency Transactions ProcessedUpdate/Display

Results:
Run control: TRANSACTIONS
Click: OK
Expected The Transactions Processed Report panel opens

Results:

Step 5 On the Agency Transaction Processed Report panel.
Enter the following

From Date: 07/01/2001
Thru Date: Current Date
Sort Options: By Org, Location, Tag Number.
This report lists detail asset activity for the period reported by Transaction Type
(Add, Adjustment, Retirement and Reinstatement). Subtotals are provided after
each Transaction Type, and a Grand Total on the last page of the report. The
Grand total will equal the net total of all Transaction Types reported on the
Detail/Summary Reports.
Transaction Processed Report AMXXX0404

Results:

Step 6

Results:

Server: PSUNX
Expected An understanding of the Process Scheduler options

Results:


Results:
Step 9
Results:
Exercise completed.

Exercise 4 Access and Run the Agency Detail/Summary Recon
Scenario: Your supervisor has asked you to run a current Agency

Detail/Summary Reconciliation Report

Participant
Demo

Results:
Instructor/
Participant
Demo

Results:
Step 3 Select: ReportAgency Detail/Summary Recon Add

Results:
Run control: AGYDET
Click: OK
Expected The Agency Detail/Summary Recon Report panel opens

Results:

Step 5 On the Agency Detail/Summary Recon Report panel.
Enter the following

From Date: 01/31/2002
Thru Date: 02/28/2002
The purpose of the Monthly Balancing of Asset Management Activity is to recap

and report all asset activity entered into Asset Management by month. This
activity includes Adds added manually or Interfaced from PO/AP, Adjustments
added manually or Interfaced from PO/AP, Retirements, Reinstatements of
retired assets. The last page of the report recaps all activity by Transaction Type.
Note: Cost amounts on these reports is defined as Adjusted Cost rather than
Original Acquisition Cost. Adjusted Cost is the net amount by asset after any
Cost Adjust/Transfer Transactions.

Results:

Step 6

Results:

Server: PSUNX
Note: Reports will run overnight.

Results:

Exercise 4 (continued

Results:
Step 9
Instructor/
Participant
Demo
Results:
Exercise completed.

Exercise 5 Access and Run the Agency Reconciliation Summary

Reconciliation Summary Report

Participant
Demo

Results:
Instructor/
Participant
Demo

Results:
Step 3 Select: ReportAgency Reconciliation Summary Add

Results:
Run control: AGYRECON
Click: OK
Expected The Agency Reconciliation Summary Report panel opens

Results:

Step 5 On the Agency Reconciliation Summary Report panel, enter the following:

Previous Ending Balance Date: 01/31/2002
Thru Date: 02/28/2002
The Agency Reconciliation Summary Report: This one page report recaps all
activity by Transaction Type - it is the same as the last page of the Agency
Detail/Summary Reconciliation Report. The Beginning Balance and asset count
for ADD,ADJ,RET,REI transactions, and the Ending Balance and asset count for
the dates requested.
Agency Reconciliation Summary Report - AMXXX0407

Results:

Step 6

Results:

Server: PSUNX

Results:


Results:
Step 9
Instructor/
Participant
Demo
Results:
Exercise completed.

Exercise 6 Access and Run the G/L Inventory Report
Scenario: Your supervisor has asked you to run a current General Ledger
Inventory Report

Participant
Demo

Results:
Instructor/
Participant
Demo

Results:
Step 3 Select: Report G/L Inventory ReportAdd

Results:
Run control: GLINV
Click: OK
Expected The G/L Inventory Report panel opens

Results:

Step 5 On the G/L Inventory Report panel.
Enter the following

Select Book Govt Book
Fiscal year: 2001
Thru Accounting Period: 12
Sort Options: By Location, Org, Tag Number
This report lists all assets by Asset Status (In Service, Stolen, Missing and
Disposed) as of the report date. It contains only transactions, which have been
posted to the General Ledger.
General Ledger Inventory Report - AMXXX0409

Results:

Step 6

Results:

Server: PSUNX
Run Recurrence: Once

Results:

Step 8 To check the status of a report
Select: GoPeopleToolsProcess Monitor
Note: After viewing the status, close the process monitor panel. Do not leave
open.
Expected The Process Scheduler window closes

Results:
Step 9
Instructor/
Participant
Demo
Results:
Exercise completed.

Exercise 7 Access and Run the G/L Recon Detail/Summary Report
Reconciliation Detail/Summary Report

Participant
Demo

Results:
Instructor/
Participant
Demo

Results:
Step 3 Select: Report G/L Recon Detail/Summary ReportAdd

Results:
Run control: GLDETAIL
Click: OK
Expected The G/L Recon Detail/Summary Report panel opens

Results:

Step 5 On the G/L Recon Detail/Summary Report panel, enter the following:

From: Fiscal Year: 2001
Accounting Period: 11
To Fiscal Year: 2001
Select Book: Govt. Book
This report lists detail asset activity for the period reported by Transaction Type
(Add, Adjustment, Retirement and Reinstatement). The last page of this report
recaps all activity by Transaction Type. It contains only transactions, which have
been posted to General Ledger.
General Ledger Reconciliation Detail/Summary Report AMXXX0506

Results:

Step 6

Results:

Server: PSUNX

Results:

open.

Results:
Step 9
Instructor/
Participant
Demo
Results:
Exercise completed.

Exercise 8 Access and Run the G/L Recon Summary Report
Reconciliation Summary Report

Participant
Demo

Results:
Instructor/
Participant
Demo

Results:
Step 3 Select: Report G/L Recon Summary ReportAdd

Results:
Run control: GLSUM
Click: OK
Expected The G/L Recon Summary Report panel opens

Results:

Step 5 On the G/L Recon Summary Report panel, enter the following:

From: Fiscal Year: 2001
To Fiscal Year: 2001
Select Book: Govt. Book
This one page report recaps all activity by Transaction Type. This report is the
same as the last page of the Agency Detail/Summary Reconciliation Report. It
contains only transactions, which have been posted to the General Ledger.
General Ledger Reconciliation Summary Report - AMXXX0507

Results:

Step 6

Results:

Server: PSUNX

Results:

open.

Results:
Step 9
Instructor/
Participant
Demo
Results:
Exercise completed.

Exercise 9 Access the Agency Replacement Cost Report

Replacement Cost Report Trial Balance Report.

Participant
Demo

Results:

Results:
Step 3 Select: Report Agency Replacement Cost Report Add

Results:
Run control: REPLACECOST
Click: OK
Expected The Agency Replacement Cost Report panel opens

Results:

Step 5 On the Agency Replacement Cost Report panel.
Enter the following

Thru Date: 06/30/2001
Sort Options: By Location, Org, Tag Number
Agency Replacement Cost Report AMXXX501

Results:
Step 6

Results:


Server: PSUNX

Results:

Results:

open.

Results:
Step 10
Instructor/
Participant
Demo
Results:
Exercise completed.

Exercise 10 Access and Run the Trial Balance Reporting
Scenario: Your supervisor has asked you to run a current Trial Balance
Report.

Participant
Demo

Results:
Step 2 Select: GoProcess Financial Information Custom G/L Reports

Results:
Step 3 Select: Report Trial Balance ReportingAdd

Results:
Run control: TRIALBAL
Click: OK

Results:

Step 5 On the Trial Balance Reporting panel, specify the information needed,
Enter the following

Ledger: GFAAG
Fiscal Year: 2001
Period From: 1
Period To: 1
Note: When requesting the trial balance use the ACTUALS ledger to look at
expenses, the GFAAG ledger to look at assets.
Note: You have the ability (for either version) to request that expenses and
revenues for only the current budget year be displayed and all prior year expense
and revenue be used to compute a prior year surplus. To request this option you
will need to enter the budget year in the appropriate box. If you leave the box
blank you will get expenses and revenues for all budget years. Simply click the
radio button of the trial balance you want. The Detail trial balances do not use
trees, while the Summary trial balances use trees to summarize at a higher
level.
Trial Balance By Business Unit GLXXX044M

Results:

Step 6 The figures on the trial balance are the summarized version of the daily activity
that occurs on the individual modules. Each night the batch process takes the
Instructor/ modules daily activity and posts it to the General Ledger via the journal
Participant generation process. All daily activity by module is summarized and assigned a
Demo
Journal ID number. The cumulative figure for both the debit and credit entries
from that journal will update the Trial Balance. Therefore, when viewing the
Trial Balance for a specific account the debit and credit figures showing in the
transactions columns will be a summarization of several individual transactions
entered in the modules.
Click: to save.

Results:
Step 7

Results:

Step 8 On the Process Scheduler panel, enter the following

Server: PSUNX
Highlight: Trial Balance Report
Note: In the Description section of the Process Scheduler, Select GLS4040X for
the Budget Basis version or select GLS4042X for the GAAP version.

Results:

open.

Results:
Step 10
Instructor/
Participant
Demo
Results:
Exercise completed

Exercise 11 Access and Run the G/L Module Activity Report
Module Activity Report.

Participant
Demo

Results:
Step 2 Select: GoProcess Financial Information Custom G/L Reports

Results:
Step 3 Select: Report G/L Module Activity ReportAdd.

Results:
Run control: GLMODULE
Click: OK

Results:

Step 5 On the G/L Module Activity Report panel, enter the following:
Report Selection: Asset Management w/full descriptions

Ledger: GFAAG
Fiscal Year: 2001
Accounting Period From: 1
Accounting Period To: 1
Account Range From: 171001
Account Range To: 188001
General Ledger Module Activity Report GLXXX04FD

Results:

Step 6 The primary difference between the G/L Module Activity and G/L Activity Detail
report has more information from other modules, i.e. vendor names, customer
Instructor/ names an check numbers. You can order the specific module report you want or
Participant order all reports. We recommend ordering the specific module report needed to
Demo
decrease processing time. If you are not sure which module reported is needed,
request the Account Summary report first. Account Summary will show modules
with activity. Then order the specific module report.
Reports and their corresponding report IDs are as follows:
Account Summary GLXXX04FA

AP Dtl w/Ref # / Vendor GLXXX04FB
AR Dtl w/Cust and Item # GLXXX04FC
AR Dir Jrnl Dtl wRef # and Dep ID GLXXX04FI
Manual Transaction Detail GLXXX04FH
Year-End Enc/Exp Jrnl Detail GLXXX04FG
Asset Manage w/full descriptions GLXXX04FD
Purchasing Detail w/ Vendor Data GLXXX04FE
Requisitions Detail GLXXX04FF
Click: to save.

Results:
Step 7

Results:

Step 8 On the Process Scheduler panel, enter the following

Server: PSUNX
Note: In the Description section of the Process Scheduler, Select GLS4040X for
the Budget Basis version or select GLS4042X for the GAAP version.

Results:

open.

Results:
Step 10
Instructor/
Participant
Demo
Results:
Exercise completed.

Exercise 12 Access Document Direct
Scenario: You have requested a General Ledger report and would like to
view the report in Document Direct
Step 1 Select: StartPrograms Document DirectDocument Direct
Expected Document Direct opens.

Results:
Step 2
Click:
Or
Select: File Document Explorer

Results:

Step 3 Double Click: SSSTEST: Via TCP/IP
Instructor/ Recipient ID: STUDENTS

Participant Password: INFOPAC
Demo
Click: OK

Results:

Step 4 To display a list of reports click on the plus sign beside the Report.
The reports are on the left side and the descriptions are on the right.
Note: Maximize your screen to view report names.

Results:

Step 5 Note: There are several different ways to locate a report.
1) Use scroll bar, once the report has been found, double click on report name.
2) Click: Locate

Results:

Step 6 Double Click GL40104GA - G/L Combined Detail Report
Expected Reports opens from Document Direct to your monitor.

Results:

Step 7 Report is returned to your window
Note: The scroll bar operates this page, page one. To view another page or the
next one the following icons will allow you to enter the necessary commands.
Expected Report opens.

Results:

Step 8 To navigate in the report:
Click: Previous page

Click: Next page
Click: Go To
This will allow you to select a specific page to view.
Expected Go To listbox opens.

Results:

Step 9 To print the report use File Print
Depending on the size of the document, you have the option to print the complete
report or specific pages.
Expected Print dialog box displays.

Results:
Exercise completed.

Exercise 13 Export data from Document Direct to an Excel spreadsheet
Scenario: After exporting data you will be able to produce a spreadsheet that
contains useful information. In this exercise you will use the
document direct report used in exercise 12.
Step 1 There are two ways to move data from a Document Direct report to Excel.
Instructor/ 1) Copy the Clipboard, then to Excel.

Participant 2) Export to ASCII, then to Excel.
Demo
Expected Understanding of copy and export procedures from Document Direct.

Results:
Step 2 With Document Direct report open
Instructor/ Copy the Clipboard, then to Excel.

Participant
Demo
Edit, Copy to Clipboard
Dialog box displays
Select: or specific pages if desired
Select:
Open Excel, Paste the data into the spreadsheet
The data is transferred to a single column, it is necessary to complete Text to

Column Wizard. Detailed information for this process is taught in the Reports
class.
Expected Copy to Clipboard Dialog box opens.

Results:

Step 3 Select: StartPrograms Microsoft Excel or double click the Excel icon on the
desktop.
Expected The Microsoft Excel window displays.

Results:
Step 4 A spreadsheet opens
Expected Excel window displays.

Results:

Step 5 To copy the entire file to Excel
Click in cell A1
Select: Edit, Paste
Data from Document Direct report is copied Excel, but the spreadsheet lacks
formatting and may contain unnecessary data. Modify the spreadsheet so it is
easier to read and use.
Expected Spreadsheet is populated with report information.

Results:

Step 6 The text information is copied to Excel; all of it is in Column A. To turn the
information into data it will be necessary to delete everything except the data and
Instructor/ column headings.
Participant
Demo
Note: If entire row is not selected a dialog box will prompt for area to delete,
select entire row.
Expected Report title rows are deleted.

Results:

Step 7 To delete page header information
Instructor/ Click and drag on row numbers to highlight and delete area above the column
Participant headings, rows 1-9.
Demo

Results:
Step 8 There are remaining rows between the column headings and the data that need to
be deleted.
Instructor/
Participant Highlight and Delete rows 2 and 5
Demo

Results:

Step 9 All of the information is stored in column A. To continue we will need to move
Participant the text to individual columns. Again, the Text to Columns Wizard tool
Hands-on completes this process.
Click: A to highlight entire column.
Select: Data, Text to Columns
Expected Text to Column Wizard appears.

Results:

Step 10 The Text to Column Wizard is a three step process.
Instructor/ Step 1 Choose the file type that best describes your data
Participant
Demo
Fixed width is the default
Click: Next
Expected Wizard moves to step 2.

Results:

Step 11 Step 2 Determines the width for each column.

Instructor/ Excel attempts to place the data into columns. It is necessary to concentrate on
Participant the data in the columns, then address the column headers.
Demo
Scroll through all columns and make any changes necessary, such as Ref_Id2
Click: Next
Expected Wizard moves to step 3.

Results:

Step 12 Step 3 Sets the data format

Instructor/ Document Direct is a text file but Excel labels all data as General. We need to
Participant identify which columns are text, general, or date formats.
Demo
For this report, all columns are formatted as text unless they are dollar amounts.
Date information is not used.
The group of columns to be formatted is Src AT.

Src is highlighted
Hold: Shift and scroll until AT column appears
Click: AT
Select: Text
Click: Finish
Note: If Office Assistant opens select No and it will disappear.
Expected All columns are formatted correctly.

Results:

Step 13 There is non-data that needs to be removed. The Sort tool will simplify this
process. The non-data sorts to the top and bottom of the sheet.
Highlight entire spreadsheet

Data, Sort
Sort by: Src Ascending defaults
Then by: Ref_Id1
Then by: Rfln
Note: Header row radio button must be selected
Click: OK
Expected Non-data is separated from the rest of the spreadsheet.

Results:

Step 14 Highlight and delete rows 2 49
Expected Data shifts into the row below the header information.
Results:

Step 15 There are several rows of non-data remaining at the end of the sheet; it is more
effective to start at the end of the spreadsheet and scroll up until original data is
visible.
CTRL + End
Highlight and delete rows P539 A363
Note: There are several ways to delete these rows, it is acceptable to start below
the last line of data and scroll down to highlight and delete.
Expected Data and headers remain.

Results:
Step 16 To continue editing the spreadsheet scroll to the top of your page,
CTRL + Home
Expected There are headers above each column of data.

Results:

Step 17 Export to ASCII, then to Excel
With Document Direct report open
Select: File, Export,ASCII
Expected Export to File dialog box opens.

Results:

Step 18 Export to File
Instructor/ Dialog box displays

Participant
Demo
Select: or specific pages if desired
Select:
Filename: C:\temp\test.txt
Open Excel, Paste the data into the spreadsheet
The data is transferred to a single column, it is necessary to complete Text Import

Wizard.
Expected Export to file dialog box opens.

Results:

Step 19 Excel should be open and running at the bottom of your monitor.
Instructor/ Click: File, Open

Participant
Demo
Select: C:\temp\test.txt
Files of Type: All Files
Click: Open
Expected Text Import Wizard dialog box displays. Report opens.

Results:
Step 20 The Text Import Wizard is a three-step process.
Step 1 Choose the file type that best describes your data.
Fixed width is the default
Click: Next
Expected Spreadsheet is saved.

Results:

Step 21 Step 2 Determines the width for each column.

Excel attempts to place the data into columns. It is necessary to concentrate on
Instructor/ the data in the columns, then address the column headers.
Participant
Demo
Scroll through all columns and make any changes necessary, such as Ref_Id2
Click: Next
Expected Entire report is highlighted or in the copy mode.

Results:

Step 22 Step 3 Sets the data format

Document Direct is a text file but Excel labels all data as General. We need to
identify which columns are text, general, or date formats.
For this report, all columns are formatted as text unless they are dollar amounts.
Date information is not used.
The group of columns to be formatted is Src AT.

Src is highlighted
Hold: Shift and scroll until AT column appears
Click: AT
Select: Text
Click: Finish

Results:

Step 23 The steps are the same to clean up the spreadsheet as the previous steps 12- 15.
You will need to delete the header page and sort to remove all page header
information.

Results:

Results:
Exercise completed.


Small Group 1. How do you specify that a report should be run to a file rather than to a
Discussion printer?
or
2. How do you determine the status of a report request?
Pair Teaming Hint: Answers can be found in the online Library.

w/Discussion
Expected An understanding of the key concepts for Using Asset Management Reports
Results:
Answer: On the Process Scheduler window, select the Printer radio button and specify the printer for the output.
Answer: Look at the Process Monitor to view the status of the report.

Reports
Congratulations! You have just completed the Reports section of the Asset
Management module. This section contained the tools needed to present all
the concepts and procedures involved in running reports in Asset
Management.
Goal You should have the skills and knowledge necessary to access and run asset
management reports
Participant


SECTION 7:
QUERIES

NOVEMBER 2004
Queries
Welcome to the Asset Management Queries module! This section contains the
tools needed to (deliver) learn all the concepts and procedures involved in running
asset management queries.
Goal To have the skills and knowledge necessary to access and run some asset
management queries
Participant
1. Access and run an asset management query

2. Access and run a query to Excel
Outline Asset Management Queries
A. Introduction
B. Concepts
C. Exercises
D. Review Questions
PHOENIX - STATE OF GEORGIA SECTION 7: QUERIES 7-I

SECTION 7: QUERIES 7-II PHOENIX - STATE OF GEORGIA

Section Contents
QUERIES
A. INTRODUCTION........................................................................................................1
B. CONCEPTS ...................................................................................................................3
C. EXERCISES .................................................................................................................5
Exercise 1 Identify and Run an Asset Management Query ........................................6

Exercise 2 Run a Query to an Excel Spreadsheet.......................................................9
D. SUMMARY AND REVIEW ......................................................................................12
PHOENIX - STATE OF GEORGIA SECTION 7: QUERIES 7-III

SECTION 7: QUERIES 7-IV PHOENIX - STATE OF GEORGIA

Queries
A. Introduction
Activity Materials
Step 1 Goal: To have the skills and knowledge necessary to access and run asset
management queries
Lecture
Objectives:
1. Run a query to the monitor

2. Run a query to Excel

Results:
Step 2 Materials:

Results:
PHOENIX - STATE OF GEORGIA SECTION 7: QUERIES 7-1

following path:
Instructor/
Demo
Reports, and Queries
Queries, Run
Introduction
Concepts
Reports from the Query Tool, Understanding
Expected The selected section displays.

Results:
Step 4 Read the topic on understanding how to run reports from the Query tool.
Instructor/
Participant Note: Not all topics listed in the online Library will be covered in class.
Demo
system.
Expected An understanding of the concept information in the online Library for using the
Results: Query tool to run reports.
SECTION 7: QUERIES 7-2 PHOENIX - STATE OF GEORGIA

B. Concepts
Activity Materials
Step 1 The main underlying concepts for using the asset management queries are listed
below:
Lecture
Running a query to the monitor
Running a query to Excel
Expected An understanding of this functionalitys underlying concepts.

Results:
following path:
Lecture
Reports, and Queries
Queries, Run
Introduction
Concepts
Reports from the Query Tool, Understanding
Expected The section displays in the online Library.

Results:
The main concepts should be covered interactively.
Remind the participants that Effective Dating is used extensively throughout the Asset
Management modules. Check for understanding, use additional examples or discuss, if
necessary, as part of the discussion on concepts.

Step 3 Read and discuss the following:
Instructor/ Queries - Query is a PeopleSoft tool that allows you to extract information
Participant from the database. The query results can be viewed online, sent to a Crystal
Demo
Report for output or to Excel for further manipulation.
Run Only Queries Run only queries are queries that have been developed
by the Phoenix team. Queries can be run by anyone who has security access
to the Run-Only Query function.
If you do not have access to the Run-Only Query function, a request must be
approved by your Agency Security Officer and forwarded to the Phoenix Security
Team. Descriptions of available queries can be found on the Phoenix website.
www3.state.ga.us/departments/doas/phoenix/
Naming Conventions The queries use the following naming convention:
Position 1 = 0 (zero) PeopleTools Query will sort to the top of the list of
public queries.
Positions 2 and 3 = module identifier in CAPS (examples: AM, AP, AR,
BD, GL, PC, PO).
Positions 4 through 6 all numeric (001 through 999)
Position 7 = _ (underscore)
All other positions are used to describe the query.
Browse the list of queries beginning with zero and the appropriate module
identifier. Select a query based on the description. A list of detailed descriptions
can be found on the Phoenix web site.
Public Queries All queries that begin with a zero can be selected and run at
any time. Queries that begin with anything other than a zero are
Developmental Queries and should not be selected. Typically they are
required to run in an overnight process or they can become "run away"
queries.

Results:

C. Exercises
Activity Materials
Instructor/ Exercise 1 - Access and run an asset management query

Participant Exercise 2 - Access and run a query to Excel
Demo
Participant
Hands-on

Exercise 1 Identify and Run an Asset Management Query
Scenario: Your supervisor has asked you for a list of all asset records coming
over from the interface files. In this exercise, you will locate and
run a query that provides this information.
online Library: Query to Grid Control, Running

Participant
Demo

Results:
Step 2 ViewNavigator DisplayQuery

Instructor/
Participant
Demo

Results:

Step 3 Scroll until you see 0AM001_INTFC_PHY_A_PENDING, then double click

Participant
Demo
Click: OK
Expected The selected query results run.

Results:
Step 4 The following query information displays to your monitor.
Instructor/
Participant
Hands-On
The left-hand panel displays the query names and the right-hand panel shows the
results.
Expected The query runs and the results appear on the monitor.
Results:

Step 5 From this screen data can be sorted by one column.
Click: button from the header row.
Click: button again to return to original sort.
Expected Modified sort results are displayed.

Results:
Exercise completed.

Exercise 2 Run a Query to an Excel Spreadsheet
Scenario: The purpose of this exercise is to define the procedure used to move data from the
query panel to a spreadsheet.

Participant
Demo

Results:
Step 2 ViewNavigator DisplayQuery
Instructor/ Right click on query, 0AM001_INTFC_PHY_A_PENDING

Participant
Demo
Expected Query window opens.

Results:

Step 3 Click: (Left) Run to Excel
Participant
Hands-on
Expected Excel loads and opens on your system.

Results:

Participant
Demo
Click: OK
Expected Dialog box displays. In the background an Excel Spreadsheet displays.

Results:

Step 5 Compare your spreadsheet to the panel below:

Instructor/
Participant
Demo
Expected Query data displays in the newly created spreadsheet.

Results:
Note: If a different query was selected, results will vary.
Step 6 To close current spreadsheet

Instructor/
Participant Select: File, Exit
Hands-On
Dialog box appears asking do you want to save the changes
Click: No
Expected Excel closes.

Results:
Exercise completed.


Small Group 1. How do you run a query so that the results are returned to your monitor?
Discussion 2. What is the different between a Public Query and a Developmental
or
Query?
Pair Teaming
w/Discussion
Expected An understanding of the key concepts for Using Asset Management Queries
Results:
Answer: (1) Double click on the query.

(2) Header
(3) Public Queries can be run during the day, Developmental queries are run @ nite or by the
development team during the day.

Queries
Congratulations! You have just completed the Queries section. This section
contained the tools needed to present all the concepts and procedures
involved in running queries in Asset Management.
Goal You should have the skills and knowledge necessary to access and run some asset
management queries.
Participant
1. Run a query to the monitor
2. Run a query to Excel
3. Cut and paste a query to Excel


Asset Management

Uploaded by

Copyright:

Available Formats

Asset Management

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Asset Management

Uploaded by

Copyright:

Available Formats

What is the purpose of the document?

What is the purpose of the document?

What are the main topics covered in the document?

What are the main topics covered in the document?

State of Georgia

Implementing Georgias New Millennium Human Resource

PEOPLESOFT FINANCIALS FOR PUBLIC SECTOR 7

1. Understand the asset management process

Prerequisites Completion of the following modules:

PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-I

1-II SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

B. THE BIG PICTURE ....................................................................................................7

Exercise 1 Understanding Asset Profiles..................................................................23

E. SUMMARY AND REVIEW .....................................................................................38

PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-III

1-IV SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

LECTURE GUIDE FLIPCHART LIBRARY

Expected The goal and objectives are introduced.

Participant Guide, flipchart, online Library, PeopleSoft

Expected The materials are introduced.

PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-5

PHOENIX PROGRAM ASSET MANAGEMENT PROCESSES

Expected The Asset Management Fundamentals Introduction selection displays.

Step 4 Note the topics available under Describe Concepts:

The Asset Management Process Flow

1-6 SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

B. The Big Picture

What is Asset Management?

What is Asset Management?

PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-7

The Big Picture (continued)

LECTURE GUIDE FLIPCHART LIBRARY

The Asset Management Process Flow

Expected An understanding of Asset Managements underlying concepts

1-8 SECTION 1: FUNDAMENTALS PHOENIX - STATE OF GEORGIA

PeopleSoft Asset Management Process Flow

PHOENIX - STATE OF GEORGIA SECTION 1: FUNDAMENTALS 1-9