EQ: Equipment/Asset Reporting Center - Fixed Assets/Equip by Disposal Date All Depreciation


EQ: Equipment/Asset Reporting Center - Fixed Assets/Equip by Disposal Date All Depreciation

Issue/Symptom/Question

What is the Fixed Assets/Equip by Disposal Date All Depreciation report? 

Applies To

Workbench (Minimum Penta version 26.1)

EQ: Equipment/Asset Reporting Center

Resolution/Fix/Answer

EQ: Fixed Assets/Equip by Disposal Date All Depreciation Report, accessible from the EQ: Equipment/Asset Reporting Center, provides a list of assets that have been disposed for a specific time period. The listing includes all depreciation bases set up for the fixed asset.

Use this report to identify assets disposed of during a specified date range. This may be necessary during the period closing process or for a year end audit.

This report’s available columns include asset value before and after (in the case of a partial disposal) the disposal, accumulated depreciation value before and after the disposal, Sale price and gain/loss on disposal.

This report provides disposal information as of the date range defined by the “Begin Date” and “End Date.” To view this report, click the Fixed Assets/Equipment by Disposal Date All Depreciation link. .Click the Columns tab to see a list of available fields on this report.

To save a version of this report, click either Save or Save as Company Report.

Users can enter the following parameters to filter the returned data:

Panel Parameters:

Legal Entity OU

Balance Sheet OU

OU

Asset

Status

Begin Date

End Date





Once the initial report is generated, users can modify the layout through the common functionality buttons.

Available Columns:

All/None

Current Rental Rate Source

Legal Entity Currency Name

Usage - Income Account Number

Details Button

Date Asset Was Assigned to OU 

Legal Entity OU ID

Accumulated Depreciation

Acquisition Date

Default Unit of Measure

Legal Entity OU Name

Accumulated Depreciation - Disposals

Asset Class Name

Default Unit of Measure Description

Model ID

Accumulated Depreciation - Ending Balance

Asset Class Number

Depreciable Life

OU ID

Asset Value

Asset Description

Depreciation Base Description

OU Name

Asset Value - Disposals

Asset ID

Depreciation Base Number

Ownership Code

Asset Value - Ending Balance

Balance Sheet OU ID

Depreciation Method Description

Ownership Description

Gain (Loss) on Sale

Balance Sheet OU Name

Depreciation Method Number

Parent Asset Description 

Insured Amount

Barcode

Engine ID

Parent Asset ID

ITC Amount

Current Equipment Rental Schedule Name

Home Yard Name

Rental - Income Account Name

Replacement Amount

Current Minimum Daily Rate

In Service Date

Replacement Date

Salvage Value

Current Per Period Rental Rate

Insured Date

Serial ID

Units

Current Rental Costcode

Job Charge Limit Percentage

Status Code

Units - Disposals

Current Rental Cost Type Code

Last Disposition Date

Status Description

Units - Ending Balance

Current Rental Cost Type Description

Last Disposal Document #

Subject to Mid-Quarter Convention



Current Rental Days in Period

Legal Entity Currency ID

Usage - Income Account Name



Example Report Results: