The Fixed Assets Report allows users to generate a report based on specified criteria. The selected criteria generates the report, which houses information about fixed assets, such as the status, the barcode, description, etc.
1. In the Fixed Assets menu, click Fixed Assets Report.
The General Report tab and the Detailed Report display several options to generate the report. The filters on these two reports include the same options.
2. Start by selecting the applicable facilities from the Facility pull-down. To review fixed assets for all facilities, select all facilities, or leave the pull-down blank.
3. Select the applicable department from the Department pull-down. To review fixed assets for all departments, select all departments from the pull-down or leave the pull-down blank.
4. Select the applicable buildings from the Building pull-down. To review fixed assets for all buildings, select all buildings from the pull-down or leave the pull-down blank.
5. Select the applicable rooms from the Room pull-down. To review fixed assets for all rooms, select all rooms from the pull-down or leave the pull-down blank.
6. Select the applicable categories from the Category pull-down. To review fixed assets for all categories, select all categories from the pull-down or leave the pull-down blank. Categories listed include non-inventoried and inventoried categories.
7. Select the applicable disposition codes from the Disposition Code pull-down. To review fixed assets for all codes, select all codes from the pull-down or leave the pull-down blank.
8. To pull fixed assets associated with a specific general ledger account, select the account from the GL Account pull-down. Note: GL accounts are assigned to a category via the Debit Account or Credit Account pull-down setup via Fixed Assets > Categories.
9. To pull fixed assets based on asset sources, select the source(s) from the Asset Source pull-down. See Fixed Assets > Maintenance > Sources.
10. To pull fixed assets associated with a specific Barcode, enter the number in the corresponding text box.
11. To pull fixed assets associated with a specific Serial #, enter the number in the corresponding text box.
12. To pull fixed assets by a specific Manufacturer, enter the manufacturer name in the text box.
13. To pull fixed assets by a specific Brand, enter the brand name in the text box.
14. To pull fixed assets by a specific Model, enter the model name in the text box.
15. To pull fixed assets that contain a specific Description, enter the description or part of the description in the corresponding text box.
16. To pull fixed assets associated with a specific Requisition #, enter the number in the corresponding text box.
17. To pull fixed assets associated with a specific PO #, enter the purchase order number in the corresponding text box.
18. To pull fixed assets with a specific Invoice #, enter the invoice number in the corresponding text box.
19. To run the report for fixed assets acquired over a specific timeframe, enter a Date Acquired (from) and a Date Acquired (to) date in the provided text boxes.
20. To run the report for specific disposition dates, enter a Disposition Date (from) and a Disposition Date (to) date in the provided text boxes.
21. To run the report for fixed assets with invoices posted over a specific timeframe, enter an Invoice Post Date (from) and an Invoice Post Date (to) date in the provided text boxes.
22. To run the report for specific reconciliation dates, enter a Reconciliation Date (from) and a Reconciliation Date (to) date in the provided text boxes.
23. To run the report for specific addition dates; i.e. the date the fixed asset was added/created, enter an Addition Date (from) and an Addition Date (to) in the provided text boxes.
24. To run the report for a specific Paid Date range, enter the date range in the provided from and to text boxes.
25. To run the report based on the dates the fixed asset was removed by the board, enter the Board Removal Date (from) and the Board Removal Date (to) in the provided text boxes.
26. To run the report based on a purchased price that is less than or equal to a specified amount, enter an amount in the Purchased Price >= text box.
27. To include Missing Items in the report, select the check box.
28. Select the Pending Items check box to include fixed assets that have a pending status in the report.
29. Select the Include Disposed/Inactive check box to include fixed assets that are inactive or have been marked as disposed in the report.
30. To run the report based on account elements, such as a specific Fund, Function, Object, etc.
31. Click Run Report.
The Fixed Assets Report (General tab) displays the Asset Status, the Barcode number, Description, Serial #, the linked Requisition #, the linked PO #'s (purchase order numbers), Invoices #'s, Asset Source, Finance Code, the Manufacturer, Brand, Vehicle ID, License Plate, Capitalized Code, Noncapitalized Code, Model, Inventoried Location account elements, Location, Department, Category, Computer Type, Computer Role, Pallet Number, Condition, Disposition, Date of Disposition, Life Expectancy, Board Removal Date, Acquisitions Date, Reconciliation Date, Invoice Post Date, Last Inventoried Date, Audit Date, Inventoried Method, Paid Date, Purchasing Notes, Purchased Price, Sold Amount, Current Depreciation, Accumulated Depreciation, Net Current Value, Needs Barcode, Missing indicator, Added By, Addition Date, Assigned Student, Assigned User, P-Card, Donation, Gift, and Internal Accounts.
The Fixed Assets Detailed Report displays the Asset Status, Barcode, Description, Serial #, Requisition #, PO #'s, Invoice #'s, Asset Source, Finance Code, Manufacturer, Brand, Vehicle ID, License Plate, Capitalized Code, Noncapitalized Code, Model, Inventoried Location accounting strip elements, Location, Department, Category, Computer Type, Computer Role, Pallet Number, Condition, Disposition, Date of Disposition, Life Expectancy, Board Removal Date, Acquisition Date, Reconciliation Date, Invoice Post Date, Last Inventoried Date, Audit Date, Inventoried Method, Paid Date, Purchasing Notes, Purchased Price, Sold Amount, Current Depreciation, Accumulated Depreciation, Net Current Value, Needs Barcode, Missing indicator, Added By, Addition Date, Assigned Student, Assigned User, applicable accounting strip including the Fund, Function, etc., and the allocation Amount.
Click Requisition # to open Purchase Requests/Orders or Internal Purchase Requests/Orders.
Click the Invoice #'s to open Invoices or Internal Account Invoices.
Hover over and click Description to open the Fixed Asset via the Manage Assets screen.
The report also displays the Capitalized Code, Noncapitalized Code, and Model.
The report also displays the Facility, the Building, the Room, the Department, and Category.
The Fixed Assets Report also displays the Computer Type, Computer Role, Pallet Number, Condition, Disposition, Date of Disposition, Life Expectancy, Board Removal Date, Acquisition Date, Reconciliation Date, Invoice Post Date, Last Inventoried Date, Audit Date, Inventoried Method, Paid Date, Purchased Price, Sold Amount, Current Depreciation, Accumulated Depreciation, Net Current Value, a Needs Barcode indicator, and a Missing check box indicator.
The Fixed Assets Reports displays the Missing check box. If the Missing Items check box is selected when setting the report criteria, only missing items display in the report. You can clear the selected check box to indicate that the assets is no longer missing. You can also select the check box if an asset is missing.
You can edit the Missing check box if you have permission to "Edit Assets" for the Fixed Assets Report via Setup > Profiles > Fixed Assets tab.
The Added By, Addition Date, Assigned Student, and Assigned User columns display at the end of the report.
The report also displays the Transfer button for Lost items. Click Transfer to open the Transfer Requests screen in a pop-up window.
See Additional Features for details on Exporting, Printing, Filtering, Saving the report, and more.
Click the Excel icon and/or the Printer icon in the Export section to export or print the table of data.
The following steps apply to the Detailed Report only.
a. In the pop-up window, select the Repeat details in all rows check box to repeat the main row information on every related detail row in the export or print file. This is useful when sorting, filtering, or creating pivot tables in spreadsheets. If the check box is not selected, repeated information is removed from detail rows to reduce duplicate data in the output.
b. Click Confirm to continue with the export or print using the selected detail row option.