More information

Assets List

Access this report using Reports>Fixed Assets>Assets.

Use this report to print a list of assets. Assets were set up using the Maintain>Fixed Assets>Assets form.

This list report can be used:

As an asset inventory, where the totals for each item are displayed or if preferred, the totals can be left off the report.
To reconcile the fixed asset general ledger balance to the asset entries in the Fixed Assets module.

This report contains:

Additional items, columns, and filters are available if any user defined fields were created by the Administrator using Organization>Set Up User Defined Fields. Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No are available in the Items by Page group box and are listed as an available filter. User defined fields with a field type of Currency follow the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).
Currency fields which follow the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Use this tab to determine what data to include in the report and to define the report layout.

By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
Asset ID	The ID assigned to the asset.
Description	The description for the asset.
Status	The status of the Asset ID-Active, Inactive, or Discontinued.
Category	The category selected to group assets.
Acquisition Code	The code used to represent the date an asset was acquired.
Location Code	The code used to represent the location of an asset.
Responsibility Code	The code used to represent the group or person responsible for the asset.
Valuation Code	The code used to represent the value of an asset.
Tag Number	The inventory number for the asset.
Original Asset ID	The ID of the original asset. The Original Asset ID provides a means of tracking assets reclassified or moved to a different location.
Taxable	A designation of Yes or No, depending on if the Taxable check box was selected using the Maintain>Fixed Assets>Assets form.
Zero Book Value	A designation of Yes or No, depending on if a zero book value was entered using Transactions>Enter Cash Disbursements or Enter A/P Invoices>Asset Quick Entry form, or Activities>Purchase Orders>Create/Modify Purchase Orders>Asset Quick Entry form.
Asset Type ID	The asset type assigned to the asset.
Depreciation Code	The depreciation code for the asset type ID.
Switch Depreciation Code	The switch depreciation code for the asset type ID.
Life	The life of the asset. It displays in months, not years.
Distribution Code	The distribution code for the asset type ID.
Expenditure Account	The expenditure code for the asset type ID.
Accumulated Depreciation Account	The accumulated depreciation code for the asset type ID.
Asset Account	The general ledger asset account for the asset type ID.
Cost	The cost or basis of the asset.
Salvage Value	The salvage value of the asset (the expected net recovery when the asset is sold at the end of its useful life).
Amount to Depreciate	The amount to depreciate (the sum of the Cost minus the Salvage Value).
Begin Depreciation Date	The date to begin calculating depreciation.
Last Depreciation Date	The date when the asset was last depreciated.
Accumulated Depreciation Amount	The current depreciation amount for the asset (the accumulated depreciation since the asset was acquired).
Net Book Value	The net value of the asset. It is calculated as Cost minus Accumulated Depreciation.
Months Depreciated	The months that have already been depreciated since the asset was acquired.
Maintenance Date	The date when the asset needs its next maintenance, or it might be a historical date of when the asset last received maintenance.
Warranty	The details about the asset's warranty.
Replacement Cost	The amount it would cost to replace the asset.
Manufacturer/Model Number	The manufacturer name for the asset and its model number.
Serial Number	The serial number that was assigned by the manufacturer.
Payee/Vendor ID	The payee or vendor name where the asset was purchased.
Document/Invoice Number	The invoice or document date used to track the asset.
Acquisition Date	The date the asset was obtained.
PO Number	The purchase order number that was used to purchase the asset.
Asset Quick Entry	A designation of Yes or No, depending on if the asset was entered using Transactions>Enter Cash Disbursements or Enter A/P Invoices>Asset Quick Entry form, or Activities>Purchase Orders>Create/Modify Purchase Orders>Asset Quick Entry form.
Quick Entry Session ID	The session ID entered on the Enter A/P Invoices or Enter Cash Disbursements Session form.
Quick Entry Transaction Source	If an asset was entered on the Asset Quick Entry form, the transaction source (API for A/P Invoices or CD for Cash Disbursements) displays here.
Notes	Any notes entered on the Maintain>Fixed Assets>Assets>Notes tab.
{User Defined Field} - Assets	An asset type user defined field and its data. There will be a separate column for each field that was created by the Administrator using Organization>Set Up User Defined Fields.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.