PeopleSoft Asset Management Reports

AMBU1000

Asset Management Units/Books

Lists all valid business units and asset books. (BI Publisher)

RUN_AMBU1000

AMAE1000

List of Accounting Entry Templates

Lists all accounting entry templates by category. (BI Publisher))

RUN_AMAE1000

AMAE1100

Book Code Discrepancy Report

Lists book code discrepancies where accounting entry templates do not meet the book code validations for pairs distribution types. (SQR)

RUN_AMAE1000

AMAS1100

Asset Categories Report

Lists Asset Categories (BI Publisher).

RUN_AMAS1100

AMAS1600

List of Asset Warranties

Lists all of the warranties that are in place for a specified business unit as of a date that you select. (BI Publisher)

RUN_AMAS1600

AMAS1700

List of Asset Licenses

Lists asset licenses. (BI Publisher)

RUN_AMAS1700

AMAS2000

Cost Activity

Sorts cost activity by ChartField, by Category, or by Account (SQR). Use the PeopleSoft Asset Management report formatting features to include/exclude data and append suffixes to identify report types.

RUN_AMAS2000

AMAS2100

Asset Acquisitions by ChartField

Lists asset information and also includes Cost, LTD and YTD Depreciation and Net Book Value with ChartField, Book and Report totals. (SQR)

RUN_AMAS2100

AMAS2110

Asset Acquisitions by In Service Date

Lists asset information and also includes Cost, LTD and YTD Depreciation and Net Book Value with ChartField, In-service Period/Year, Book and Report totals. (SQR)

RUN_AMAS2100

AMAS2200

Assets by Location

Lists information on assets by location. (SQR)

RUN_AMAS2200

AMAS2210

Assets by Asset ID

Lists assets by Asset ID. (SQR)

RUN_AMAS2200

AMAS2300

Asset Transfers by ChartField

Lists asset transfers transactions ordered by ChartField. (SQR)

RUN_AMAS2300

AMAS2400

Asset Reclassifications

Lists asset recategorizations ordered by ChartField. (SQR)

RUN_AMAS2400

AMAS2201

Hazardous Assets by Location

List assets designated as hazardous, sorted by location. (SQR)

RUN_AMAS2201

AMCH1000

Asset Component Hierarchy Move

List asset component hierarchy moves made through the Manage Component Hierarchy transaction (SQR)

RUN_AMCH1000

AMCP2000

Capital Acquisition Plans

Lists capital acquisition planning information. (SQR)

RUN_AMCP2000

AMCP2010

Capital Acquisition Plans by Department

Lists capital acquisition planning by department. (SQR)

RUN_AMCP2000

AMCP2100

Capital Acquisition Planning Assets

Lists capital acquisitions planning by asset ID. (SQR)

RUN_AMCP2000

AMDP2000

Depreciation Activity

Sorts cost activity by ChartField. (SQR), by Category, or by Account. Use the PeopleSoft Asset Management report formatting features to include/exclude data and append suffixes to identify report types.

RUN_AMDP2000

AMDP2021

Depreciation Activity by Alternate Account

Sorts depreciation activity by alternate account. (SQR)

RUN_AMDP2000

AMDP2100

Net Book Value

Sorts cost activity by ChartField, by Category, Location, or by Account (SQR). Use the PeopleSoft Asset Management report formatting features to include/exclude data and append suffixes to identify report types. This report also provides options for assets that have had their depreciation stopped.

RUN_AMDP2100

AMDP2121

Asset Net Book Value by Alternate Account

Sorts asset net book value information by alternate account. (SQR)

RUN_AMDP2100

AMDP2150

Group Member Estimated NBV

Lists estimated depreciation accumulation of the member. (SQR)

RUN_AMDP2150_RQST

AMDP2200

Depreciation by Period

Sorts assets by period depreciation at asset, category, department, book, or project levels. (SQR) Use the PeopleSoft Asset Management report formatting features to include/exclude data.

RUN_AMDP2200

AMDP2300

Depreciation by Fiscal Year

Sorts assets by fiscal year depreciation at asset, category, project, department, or book levels. (SQR) Use the PeopleSoft Asset Management report formatting features to include/exclude data.

RUN_AMDP2300

AMGL1000

AM to GL Reconciliation by Department (BI Publisher)

Reconciles AM to GL by ChartField. (BI Publisher)

BI Publisher reports require manual changes when there are ChartField configurations. BI Publisher reports do not require manual changes to support ChartField configuration.

RUN_RPT_TBLS_REPS

AMGL1010

AM to GL Reconciliation by Category (BI Publisher)

Reconciles AM to GL by category. (BI Publisher)

BI Publisher reports require manual changes when there are ChartField configurations. BI Publisher reports do not require manual changes to support ChartField configuration.

RUN_RPT_TBLS_REPS

AMNB1000

Asset NBV by ChartField (BI Publisher)

Sorts net book value by ChartField. (BI Publisher)

BI Publisher reports require manual changes when there are ChartField configurations. BI Publisher reports do not require manual changes to support ChartField configuration.

RUN_RPT_TBLS_REPS

AMNB1010

Asset NBV by Category (BI Publisher)

Lists net book value related amounts sorted by category. (BI Publisher)

BI Publisher reports require manual changes when there are ChartField configurations. BI Publisher reports do not require manual changes to support ChartField configuration.

RUN_RPT_TBLS_REPS

AMNB1030

Asset NBV by Location (BI Publisher)

Lists net book value related amounts sorted by location. (BI Publisher)

BI Publisher reports require manual changes when there are ChartField configurations. BI Publisher reports do not require manual changes to support ChartField configuration.

RUN_RPT_TBLS_REPS

AMIMP001

Impaired Asset Value Report by Category

Lists impaired asset values summarized by asset category. (BI Publisher)

AM_IMP_RPT_RUN_CTL

AMIMP002

Impaired Asset Value Report by CGU

Lists impaired asset values summarized by asset CGU. (BI Publisher)

AM_IMP_RPT_RUN_CTL

AMAS2030

Account Activity Summary - Cost

Lists cost and related transaction amounts per account with ChartFields, book, and report totals. (SQR)

RUN_AMAE2000

AMDP2030

Account Activity Summary - Depreciation

Lists depreciation and related transaction amounts per account with ChartFields, book, and report totals. (SQR)

RUN_AMAE2000

AMDP2130

Account Activity Summary - Net Book Value

Lists cost balance, YTD, LTD, depreciation and NBV amount per account. (SQR)

RUN_AMAE2000

AMAS2031

AltAccount Activity Summary - Cost

Lists cost and related transaction amounts per account with ChartFields, book, and report totals. (SQR)

RUN_AMAE2001

AMAS2021

Cost Activity by Alt Account

Sorts cost activity by Alternate Account. (SQR)

RUN_AMAS2000

AMDP2031

AltAccount Activity Summary - Depreciation

Lists depreciation and related transaction amounts per account with ChartFields, book, and report totals. (SQR)

RUN_AMAE2001

AMDP2131

AltAccount Activity Summary - Net Book Value

Lists cost, depreciation and net book value amounts per account with ChartFields, book, and report totals. This report is similar to the Account Activity Summary Report. (SQR)

RUN_AMAE2001

AMAE2100

Accounting Entry Detail

Lists accounting entry details. (SQR)

RUN_AMAE2100

AMAE2101

Alternate Account Entry Detail

Retrieves alternate account entry information with ChartField, alternate account and report totals. (SQR)

RUN_AMAE2101

AMAE2102

Retired as Expensed Accounting Entry

Retrieves accounting entry information for assets that are disposed as expensed. (SQR)

RUN_AMAE2102

AMAE2110

Accounting Entry Detail - Cost

Lists cost and related transaction amounts per asset, with ChartFields, book, and report totals. (SQR)

RUN_AMAE2000

AMAE2120

Accounting Entry Detail - Depreciation

Lists depreciation and related transaction amounts per asset, with ChartFields, book, and report totals. (SQR)

RUN_AMAE2000

AMAE2130

Accounting Entry Detail - Net Book Value

Lists cost balance, YTD, and LTD depreciation and NBV amounts per asset. (SQR)

RUN_AMAE2000

AMAE2111

Alt Acct Entry Detail − All

Gather alternate account entry detail information. Lists cost beginning and ending balance with related transaction amounts. (SQR)

RUN_AMAE2001

AMAE2121

Alt Acct Entry Detail − Depr

Gather alternate account entry detail information. Lists cost beginning and ending balance with related transaction amounts. (SQR)

RUN_AMAE2001

AMAE2131

Alt Acct Entry Detail − NBV

Lists Cost Balance, YTD, and LTD Depreciation and NBV amount per asset. (SQR)

RUN_AMAE2001

AMPI2000

Physical Inventory Extract

Gathers PI extract data. (SQR)

RUN_AMPI2000

AMPI2100

Physical Inventory Scan Data

Gathers PI scan data. (SQR)

RUN_AMPI2000

AMPI2200

Physical Inventory Results - INVENTORIED

Gathers PI inventoried results. (SQR)

RUN_AMPI2000

AMPI2210

Physical Inventory Results - UNDER

Gathers PI unders results for financial and non-financial assets. (SQR)

RUN_AMPI2000

AMPI2220

Physical Inventory Results - OVER

Gathers PI overs results. (SQR)

RUN_AMPI2000

AMDE4001

Inventory Report (Detail Version)

Lists detailed information about assets within inventory. (BI Publisher)

RUN_AMAS2200

AMDE4002

Inventory Report (Short Version)

Lists summarized information about assets within inventory. (BI Publisher)

RUN_AMAS2200

AMLE2000

Lease Summary Information

Lists lease summary information. (SQR)

RUN_AMLE2000

AMLE2100

Lease Detail Information

Lists lease detail information. (SQR)

RUN_AMLE2000

AMLE2200

Lease Amortization Schedule

Lists lease detail information. (SQR)

RUN_AMLE2200

AMLE2310

Lease Footnote Disclosure Summary

Lists all outstanding lease commitments for five years and provides the monthly lease payment and yearly totals. (SQR)

RUN_AMLE2300

AMLE2300

Lease Footnote Disclosure Detail

Lists all outstanding lease commitments for five years and provides the monthly lease payment and yearly totals. (SQR)

RUN_AMLE2300

AMLE2400

Lease Expiration

Lists all leases expiring in a certain number of days from a specified date, or leases expiring within a date range that you select. (SQR)

RUN_AMLE2400

AMAP1001

AP/AM Lease Payment Reconciliation Report

Compares information about the lease payments from the Asset Management tables with the voucher information that is automatically generated and stored in the Payables tables.

RUN_AMAPPYMNTREC

AMRT2000

Retirement by ChartField

Sorts retirement information by ChartField. (SQR)

RUN_AMRT2000

AMRT2010

Retirement by In Service Date

Lists retirement information with totals per in service year/period. (SQR)

RUN_AMRT2000

AMRT2100

Retirement Activity

Lists retirement related information. (SQR)

RUN_AMRT2100

AMBI1000

AM/Billing Transaction Status

Create the Assets Pending to Bill and Invoiced report. Lists the status of the transactions sent to Billing.

RUN_AMBI1000

AMRET001

Auto-Retired Assets

Lists all auto-retired assets. (SQR)

RUN_AMRET001

AMTX3000

Tax Acquisitions

Lists acquisition information for tax purposes. (SQR)

RUN_AMTX3000

AMTX3100

Tax Adjustments

Lists adjustment information for tax purposes. (SQR)

RUN_AMTX3000

AMTX3200

Tax Retirements

Lists adjustment information for tax purposes. (SQR) This report can be run in detail or summary mode.

RUN_AMTX3000

AMTX3210

Tax Retirement Capital Gains

Lists retirement capital gains information for tax purposes. (SQR)

RUN_AMTX3000

AMTX3220

Like Kind Exchanges Activity

Use this report to review LKE activity. (SQR).

RUN_AMTX3000

AMTX3500

Tax Depreciation

Gathers depreciation information for tax purposes. (SQR)

RUN_AMTX3000

AMTX3610

Tax Depreciation for Current Year Assets

Similar to Tax Depreciation report, ordered by fiscal year/period or date range. (SQR)

RUN_AMTX3000

AMTX3620

Tax Depreciation for Prior Year Assets

Similar to Tax Depreciation report, ordered by fiscal year/period or date range. (SQR)

RUN_AMTX3000

AMTX3630

Tax Depreciation – Listed Property

Gathers depreciation information relevant to listed property. (SQR)

RUN_AMTX3000

AMTX3640

Generate Bonus Depreciation Tax Reports

This report is used in conjunction with the bonus depreciation. Use to review bonus depreciation amounts for Non-Listed Property.

RUN_AMTX3000

AMTX3650

Generate Bonus Depreciation Tax Reports

This report is used in conjunction with the bonus depreciation. Use to review bonus depreciation amounts for Listed Property with business use over 50%.

RUN_AMTX3000

AMTX4000

Alternative Minimum Tax (AMT)

Gathers alternative minimum tax information. (SQR)

RUN_AMTX4000

AMTX4100

Adjusted Current Earnings Worksheet (ACE)

Lists adjusted current earnings information. (SQR)

RUN_AMTX4000

AMTX4200

40% Rule Analysis Report

Run to comply with the US Tax 40% Rule. (SQR)

This report can be run in detail or summary mode.

RUN_AMTX4200

AMTX4300

AMT Retirements

Gathers alternative minimum tax information from retirements. (SQR)

RUN_AMTX4000

AMTX4400

ACE Retirements

Gathers adjusted current earnings information from retirements. (SQR)

RUN_AMTX4000

AMTX10AU

AUS RD Tax Deductions

View the amount of research and development concessions that can be claimed. (SQR)

RUN_AMTX10AU

AMTX20AU

Tax Credits by Category (Australia)

Lists total tax credits by business unit. (SQR)

RUN_AMTX20AU

AMRT10AU

Retirement Activity (AUS)

Lists retirement related information relevant to Australian Retirements for a business unit and book. (SQR)

RUN_AMRT10AU

AMRT20AU

Retirement Detail by ChartField (Australia)

Lists assets that have been partially or fully retired in the periods specified for Australia sorted by ChartField. (SQR)

RUN_AMRT20AU

AMTX10CA

CCA Year End Updates CAN

(CAN) Creates and prints columns of information required by Revenue Canada and CCA year end results. (BI Publisher)

RUN_AMTX10CA

AMTX11CA

CCA Report

(CAN) Creates and prints columns of information required by Revenue Canada and CCA year end results. (BI Publisher)

RUN_AMTX10CA

AMTX30AU

Tax CCP − AUS

Monitors CCP adjustments and the review process. (SQR)

RUN_AMTX30AU

AMFR2100

French Retirement Activity

Lists retirement related information relevant to French Retirements. (SQR)

RUN_AMDP2100

AMFR2120

French Net Book Value Account

Reports French asset net book value information.

RUN_AMDP2100

AMFR2121

French Net Book Value by Alternate Account

Similar to Asset Net Book Value by Alternate Account, listing French depreciation related information. (SQR)

RUN_AMDP2100

AM_FV_REPORT

Fair Value Report

Facilitates in the required disclosures of detail and summarized fair value activity.

AM_FV_RUN_CTL

AMDE1000

Asset History Sheet by Category

(DEU) Shows the original asset cost beginning in year 2 of the asset's life. (BI Publisher)

RUN_AMDE1000

AMDE1001

Asset History Sheet by Account

(DEU) Shows the original Asset Cost beginning in year 2 of the asset's life. (BI Publisher)

RUN_AMDE1000

AMDE1002

Asset History Sheet Summary

(DEU) Shows the original Asset Cost beginning in year 2 of the asset's life. (BI Publisher)

RUN_AMDE1000

AMDE1101

Depreciation History

(DEU) Lists chronological history of asset depreciation, including any extraordinary depreciation. (BI Publisher)

RUN_AMDE1000

AMDE1102

Extraordinary Depreciation History

(DEU) Lists chronological detailed history of extraordinary asset depreciation. (BI Publisher)

RUN_AMDE1000

AMDE5001

Reconciliation AP/AM (BI Publisher)

(DEU) Reconciles AP Asset Vouchers with AM asset transaction information. (BI Publisher)

BI Publisher reports require manual changes when there are ChartField configurations. BI Publisher reports do not require manual changes to support ChartField configuration.

RUN_AMDE5000

AMBT1000

Business Tax

(JPN) Gathers business tax information on a specific account and location. (SQR)

RUN_AMBT1000

AMBT1010

Business Tax by Alternate Account

(JPN) Gathers business tax information on a specific alternate account and location. (SQR)

RUN_AMBT1000

AMED1000

Extended Depreciation

(JPN) Gathers business tax information on assets that have extended depreciation. (SQR)

RUN_AMED1000

AMAD1000

Advanced Depreciation Amount

Obtains the advanced depreciation amount for the specified asset ID range. (BI Publisher)

RUN_AMAD1000

AMAD1010

Advanced Depreciation Reverse Amount

Obtains reversal amounts for the specified asset ID range. (BI Publisher)

RUN_AMAD1000

AMIMP001

Imp Asset Value Report by Category

Review impairment asset values by category. (BI Publisher)

RUN_AMIMP001

AMIMP002

Imp Asset Value Report by CGU

Review impairment asset values by CGU. (BI Publisher)

RUN_AMIMP001

AMSP1000

Reserve Detail by Asset ID

Obtains reversal amounts for the specified Asset ID range. (BI Publisher)

RUN_AMSP1000

AMSP1010

Reserve Summary by Category

Lists reserve amounts and details for fiscal years by asset ID. (BI Publisher)

RUN_AMSP1000

AMSP1020

Reverse Detail by Asset ID

Lists reverse amounts and details for fiscal years by Asset ID. (BI Publisher)

RUN_AMSP1000

AMSP1030

Reverse Summary by Category

Lists summarized reverse information by category. (BI Publisher)

RUN_AMSP1000

EU_2054

2054ab Reports by Account

(FRA) View information on the asset, its cost and net book value, information on all transactions that occurred in the specified reporting year, including depreciation and yearly depreciation. (BI Publisher)

EU_AM_RUNCNTRL

EU_2055A

2055a Reports by Account

(FRA) View information on the asset, its cost and net book value, information on all transactions that occurred in the specified reporting year, including depreciation and yearly depreciation. (BI Publisher)

EU_AM_RUNCNTRL

EU_2055B

2055b Reports by Account

(FRA) View information on the asset, its cost and net book value, information on all transactions that occurred in the specified reporting year, including depreciation and yearly depreciation. (BI Publisher)

EU_AM_RUNCNTRL

EU_205X1

2054ab Reports by Alt Account

(FRA) View information on the asset, its cost and net book value, information on all transactions that occurred in the specified reporting year, including depreciation and yearly depreciation. (BI Publisher)

EU_AM_RUNCNTRL

EU_205X2

2054a Reports by Alt Account

(FRA) View information on the asset, its cost and net book value, information on all transactions that occurred in the specified reporting year, including depreciation and yearly depreciation. (BI Publisher)

EU_AM_RUNCNTRL

EU_205X3

2054b Reports by Alt Account

View information on the asset, its cost and net book value, information on all transactions that occurred in the specified reporting year, including depreciation and yearly depreciation. (BI Publisher)

EU_AM_RUNCNTRL

AMLT1000

Japanese Local Tax Roll

(JPN) Local tax report. (SQR)

RUN_AMLT1000

AMLT1100

Japanese Local Tax Increase All Asset List

(JPN) Local tax increase report. (SQR)

RUN_AMLT1100

AMLT1200

Japanese Local Tax Decrease All Asset List

(JPN) Local tax decrease report. (SQR)

RUN_AMLT1100

AMNT1000

Japanese National Tax

(JPN) List depreciation calculation details to be reported to the Japanese Tax Office. The report includes all required information for the National Depreciable Asset Tax Return called Beppyo 16(1),(2) in Japan. (SQR)

RUN_AMNT1000

AMDP2500

Fixed Assets Register Report

(ITA) Run to comply with Italian article 16, D.P.R. 600/73. The fixed asset book lists information relevant to fixed assets. (SQR)

RUN_AMDP2500

AMDP2510

Assets Register INDIA

(IND) Run to generate an historical record of assets over the fiscal year period to comply with The Indian Tax Depreciation Act (Indian Income Tax Act 1961). Can generate by business unit or tax/reporting entity. (SQR).

RUN_AMDP2510

AMTX2000

Depreciation Balance IND

(IND) Calculate the annual tax depreciation balances for India. (BI Publisher)

RUN_AMTX2000