Inventory Report

The Inventory Report module serves as a way to generate basic Fixed Assets data based on a specific Facility, the Inventory Fiscal Year, Misplaced Items, and Uninventoried Items. If looking for a more descriptive report based on item location, description, etc., this report will be more beneficial than the Fixed Assets Report (contains more monetary data) or Inventory Transaction Report (contains more status information).

The Inventory Repport screen also houses the Misscans report, which displays information on all items inventoried at the wrong facility.

The Inventory Report

1. From the Fixed Assets menu, click Inventory Report.

The Inventory Report screen displays several options to generate the report.

Inventory Report

2. Start by selecting a Facility from the pull-down. Note: Only one Facility can be run at a time.

Inventory Report

3. Select the Department from the pull-down from which to filter the report. One or multiple departments can be selected from the pull-down.

Inventory Report

4. Select your Inventory Fiscal Year from the pull-down. Note: The year will default to the current fiscal year.

Inventory Report

5. Select the Misplaced Items check box to display fixed assets marked as Lost.

Inventory Report

6. Select the Uninventoried Items check box to display fixed assets that have not been scanned or entered in the system for inventory.

7. Select the Needs Barcode check box to display all fixed assets that have been marked as Needs Barcode when taking inventory via Take Inventory.

8. Select the Manual Inventories check box to display fixed assets that have been entered into the system manually.

9. When all selections have been made, click Run Report to generate the report.

Inventory Report

The report is extensive, listing all information regarding each pulled fixed asset including: Category, Date Acquired, Capitalized Code, Noncapitalized Code, Description, Manufacturer, Model Number, Serial Number, Barcode, Approved Location (Assigned User, Assigned Student or Student Name / ID, Facility), Inventoried Location (Building, Room, Facility), Building, Room, Department, PO #, Purchased Price, Depreciation, Salvage Price, Net Current Value, Last Inventoried, Audit Date, Inventory Method, Disposition Date, Disposition Code, Status, Lost, Needs Barcode, and Transfer.

Inventory Report

10. Click the Description link to open Manage Assets for the applicable asset.

Inventory Report

Depending on your profile and permissions, you may or may not be able to edit the asset directly from the Manage Assets screen.

Manage Assets

11. Click the PO # link to open Purchase Requests/Orders or Internal Purchase Requests/Orders.

Inventory Report

12. Select the Lost check box if the asset cannot be found. Marking an item as lost also marks the items as inventoried.

13. There are several ways to transfer an item, one of which you can do directly from the Inventory Report. To initiate a transfer, click the Transfer button in the corresponding row.

Inventory Report

Clicking the Transfer button will take you from the Inventory Report to the Transfer Requests screen.

a. Enter the applicable information.

b. When complete, click Request Transfer.

To navigate back to the Inventory Report screen, from the Fixed Assets menu, click Inventory Report. Be aware that, if the report was not saved, the report previously generated will be lost.

Misscans Report

The Misscans report displays information on all items inventoried at the wrong facility via Fixed Assets > Take Inventory.

1. From the Fixed Assets menu, click Inventory Report.

2. Click the Misscans tab.


3. Select the applicable Facility from the pull-down. Note: The report pulls information for assets scanned at the selected facility regardless of where the asset belongs.

4. Select the Inventory Fiscal Year from the pull-down.

5. Click Run Report.

Inventory Report

The report displays the User who scanned the item, the Reason, the Barcode, Description, From Facility where scanned, from Building, From Room, From Department, To Facility, To Building, To Room, To Department, and Inventory Time (date).

Inventory Report
Additional Features

You have the ability to save your report before or after running the report. Click the floppy disk icon to name and save your report.

a. Name the report and click Save.

b. Click the Trash Can icon to delete saved reports.

c. To edit a Report Name after saving, select the report, then click the Blue Arrow next to the Trash Can.

d. In order to generate a saved report, from the Inventory Report screen, select the saved report from the pull-down; your report will generate automatically. Note: Saving your report will not save any filters applied after the report has been generated.

To navigate through the listed pages, click the Prev and Next buttons. To jump to a specific numbered page, type the number in the page text box and press Enter.

Click the Excel icon in the Export section allows you to export the report to an Excel spreadsheet. Click the icon to download the file.

Click the Printer icon in the Export section as shown in the image above. Depending on browser settings, this will generate a print preview where you will have the ability to change the layout, print two-sided, etc.

Click Filters to further breakdown your report without having to change the report criteria and rerun the report.

a. To add more than one filter to a column, click the green plus sign.

b. To delete an additional filter, click the red minus sign.

c. For additional filtering options, click the gray arrow for a filter pull-down.

See Filters for more information.