Equipment Inventory Report
Overview
Use the Equipment Inventory report to print an inventory listing of selected Fixed Assets as of a specified date. You can include depreciable, non-depreciable, or both in the report.
The Tier Parameter is determined by the Job to which the asset is assigned on the As of Date indicated.
You may sort this report by Asset ID or Description. You may filter this report by Assets, Asset Categories, asset Types, Job Types, Supervisors, Primary Jobs, and depreciation Methods.
You may elect to print a summary or detail report, and select from various report criteria options.
The Summary report includes the Asset ID #, Description, Type, Serial Number and Date Acquired.
The Detail Report contains all items in the summary report plus the Primary Job #, any job allocation distribution (with percentage), Parent Asset ID, Manufacturer, Vendor and Bar Code.
You can filter, group, and print by Tiers, allowing for total customization of the report. To make filtering easier, for any Tier, you can include All, Pick/Create or Exclude parameters. Using Tier Templates to set up and save report templates makes it easy to generate a specific report each time you need it, without having to recreate the criteria. See Using Tier Templates for more information.
Key Functionality
The FA: Equipment Inventory Report screen has its own Security Group, FA Report Equipment Inventory.
The FA: Equipment Inventory Report Security Group is part of the FA Reports ALL Security Group.
Tip: For more information see Security Groups Overview and Security Groups By Module.
Key Functionality
Type a description to name the report. This description prints above the Report Title.
The Default Company Name for Report is populated from the Company Setup screen. The list contains all companies for which you have security permissions to view. If you have permission for only one company, that will be the only one displayed in the list. If you have permissions to multiple companies, the list will display those companies PLUS the default reporting company.
When discernible, WinTeam will print the appropriate company name and logo on each page; otherwise the Default Company Name will print. That is, if a Company level is included in the tiered section and is displayed in the tiered information at the bottom of the page, then that company's Report Name and Logo (if selected) prints on that page.
If there is not a Company identified in the tier area of the page, then the Default Company Name for Reports is used. The default Company Name and Logo is also used for the Total Enterprise report. For more information see Learning about WinTeam Reports.
Use the Report Format option to choose the level of detail for the report.
The Summary report includes the Asset ID #, Description, Type, Serial Number and Date Acquired.
The Detail Report contains all items in the summary report plus the Primary Job #, any job allocation distribution (with percentage), Parent Asset ID, Manufacturer, Vendor and Bar Code.
Select to include depreciable assets, non-depreciable assets, or both on the report.
These options are both selected by default.
Use the Sort By option to sort the report data by asset ID or asset description.
Click Number to sort report data by Asset ID. This is the default option.
Click Name to sort report data by Asset Description.
The Tier Parameter is determined by the Job to which the asset is assigned on the As of Date indicated.
The As of Date defaults to today's date.
Assets
Use the Assets category to select the assets to include on the report.
Select All to include all asset IDs.
Select Range to define a range of asset IDs for the report. When you select Range, the range fields display. Type the beginning asset ID in the From field and the ending asset ID in the To field, or use the Lookup feature to locate the record.
Select Pick to define specific Assets for the report. When you select Pick, the Assets list displays. Select the check box next to each Asset to include on the report.
Select Create to define your own list of Assets. When you select Create, a small grid displays to the right. Enter the Asset ID Numbers you want to include in the list, or use the Lookup to locate the Asset ID Numbers.
Select Exclude to identify records that should not be included. When you select Exclude, a small grid displays to the right. Enter the Asset ID Numbers you want to exclude in the list, or use the Lookup to locate the Asset ID Numbers.
Date Acquired
Use the Date Acquired category to filter the report criteria by Asset Acquired Dates.
Select All to include all assets regardless of the Asset Acquired Date.
Select Date Range to define a range of Asset Acquired Dates for the report. When you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field.
Date Assigned
Use the Date Assigned category to filter the report by Date Assigned to a Job.
Select All to include all assets, regardless of the Date Assigned.
Select Date Range to define a range of Dates that Assets were assigned to a Job. When you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field.
Date Retired
Use the Date Retired category to filter the report criteria by Asset Retired Date.
Select All to include all assets regardless of the Date Retired.
Select Date Range to define a range of Asset Retired Dates for the report. when you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field.
Date Disposed
This category is available if the selected Type of Report is Disposed.
Use the Date Disposed category to filter the report criteria by Asset Disposed Dates.
Select All to include all assets regardless of the Asset Disposed Date.
Select Date Range to define a range of Asset Disposed Dates for the report. When you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field.
Categories
Use the Categories category to select the Asset Categories to include on the report.
Select All to include all Hours Categories.
Select Pick to define specific Asset Categories for the report. When you select Pick, the Asset Categories list displays. Select the check box next to each Asset Category to include on the report.
Asset Types
Use the Asset Types category to select the Asset Types to include on the report.
Select All to include all Asset Types.
Select Pick to define specific Asset Types for the report. When you select Pick, the Asset Types list displays. Select the check box next to each Asset Type to include on the report.
Primary Depr. Jobs
Use the Primary Depr. Jobs category to select the Primary Depreciable Jobs to include on the report.
Select All to include all Jobs.
Select Range to define a range of Jobs for the report. When you select Range, the range fields display. Type the beginning Job number in the From field and the ending Job Number in the To field, or use the Lookup feature to locate the record.
Select Pick to define specific Jobs for the report. When you select Pick, the Jobs list displays. Select the check box next to each Job to include on the report.
Methods
Use the Methods category to select the Depreciation Methods to include on the report.
Select All to include all Methods on the report.
Select Pick to define specific Methods for the report. When you select Pick, a list of Methods displays. Select the check box next to each Depreciation Method you want to include the on the report.
Vendors
Use the Vendors category to select the Vendors to include on the report. (On the HR: and INS: Benefit Insurance/Other Analysis Reports, this Category is available when the Report Type is Vendor Billing.)
Select All to include all Vendors.
Select Range to define a range of Vendors for the report. When you select Range, the range fields display. Type the beginning Vendor Number in the From field and the ending Vendor Number in the to field, or use the Lookup to locate the Vendor Number.
Select Pick to define specific Vendors for the report. When you select Pick, the Vendor list displays. Select the check box next to each Vendor to include on the report.
Select Create to define your own list of Vendors. When you select Create, a small grid displays to the right. Enter the Vendor Numbers you want to include in the list, or use the Lookup to locate the Vendor Numbers.
Select Exclude to identify records that should not be included. When you select Exclude, a small grid displays to the right. Enter the Vendor Numbers you want to exclude in the list, or use the Lookup to locate the Vendor Numbers.
You may group this report by Asset ID, Asset Type, Category, Date Acquired, Date Assigned, Date Disposed, Date Retired, or Method.
The default Group By is Asset ID.
Use the Tier Template to define and save customized settings for a report. To use an existing template, select the template from the list and click Load.
To create a new template, you can load an existing template, make the necessary modifications, click Save, and define a new template name in the Save As dialog box. Alternatively, you can start with a blank template by clicking the Clear button.
To modify an existing template, load the template, make the necessary modifications, and then click Save. The name of the existing template display in the Save As dialog box. Click OK.
For more information see Using Tier Templates and Using Tier Parameters.
Select the Group By Parent ID check box to group the selected Fixed Assets by Parent ID on the report.
This check box is NOT selected by default.
The Print Enterprise Totals check box is available to users who have more than one company, and may be selected to print enterprise totals on the report. This check box is selected by default.
If this is not selected, the report prints only the tiered reports that are marked for printing.
The Print Company Totals check box is available to users who have only one company, and may be selected to print company totals on the report.
Select the Include Custom Fields check box to include the Custom Fields on the report. Only the Custom Fields that are used will display on the report. You could print all 26 Custom Fields, if used.
This check box is not selected by default.
Select the Include Disposed Assets check box to include disposed assets on the report.
This check box is NOT selected by default.
Select the Include Retired Assets check box to include retired assets on the report.
If checked, the report will include any asset with a Retired Date, but will not include disposed assets unless the option to Include Disposed Assets is also selected.
This check box is NOT selected by default.
Select the Include Notes check box to include Notes (from the FA: Master File) in the report.
This check box is NOT selected by default.
Select this check box to print the company logo on the report. It is selected or cleared by default based on the option selected in SYS:Defaults. However, you can modify the setting on each report.
Select this check box to include a list of the report options selected for the report. The Report Criteria page includes any ranges specified and each Category/Record selection made for the report. This check box is cleared selected by default.
Preview
Click the Preview button (or use the shortcut key, ALT + V) to view the report before printing.
Click the Print button (or press ALT + P) to send the report to your default printer.
Export
Click the Export button (or press ALT + X) to export the report to a specified format. Reports may be exported to Adobe Acrobat (PDF), Excel, Comma-Separated Values (CSV), Grid View and E-mail (available for premise-based clients only).