The Finance Code Report displays detailed asset information and allows you to view, organize, and analyze assets based on different financial classifications. The report can group assets by Finance Code, Acquisition Date, or Object Code, making it easier to track and manage assets across your organization. This report is based on the Finance Codes set up via Maintenance > Finance Codes.
1. In the Fixed Assets menu, click Finance Code Report.
2. Select a Subtotal option from the pull-down to group and total assets within the report. The available options include:
- Acquisition Date: Groups assets by the date they were acquired and displays subtotals for each date.
- Finance Code: Groups assets by their assigned finance code, allowing you to quickly compare totals across funding sources.
- Object Code: Groups assets by their object code for easier financial categorization and reporting.
3. Select the Facility from the pull-down to determine which facility's assets are included in the report. You can select a single facility or multiple facilities, as needed, to generate a combined view of asset information across locations. This field is optional.
4. Select the Building from the pull-down to determine which building's assets are included in the report. Multiple buildings can be selected, if needed, to view asset information across several locations at once. This field is optional.
5. Select the Room from the pull-down to determine which room's assets are included in the report. Multiple rooms can be selected, if needed, to view asset information across several locations at once. This field is optional.
6. Select the Department from the pull-down to determine which department's assets are included in the report. Multiple departments can be selected, if needed, to view asset information across several locations at once. This field is optional.
7. Select the Category from the pull-down to determine which asset categories are included in the report. Since this pull-down supports multiple selections, you can choose more than one category to view assets across several groups at the same time. This field is optional.
8. Select the Asset Source from the pull-down to determine which asset sources are included in the report. This pull-down allows multiple selections, so you can include assets from more than one source at the same time. This field is optional.
9. Select the Finance Code from the pull-down to determine which finance codes are included in the report. Multiple finance codes can be selected, if needed. This field is optional.
10. Select the Object from the pull-down to determine which objects are included in the report. Multiple objects can be selected, if needed. This field is optional.
11. Select the Disposition Code from the pull-down to determine which asset disposition codes are included in the report. Multiple codes can be selected, if needed. This field is optional.
12. Enter the Date Acquired (from) and Date Acquired (to) in the provided text boxes to filter records based on the acquisition date range. These fields are optional.
13. Enter a PO # in the provided text box to search for or filter records by a specific purchase order number. This field is optional.
14. Select the Include Disposed/Inactive check box to include disposed and inactive assets in the report.
15. Click Run Report.
The report displayed below was run by Finance Code and includes Acquisition Date, Assets, Total Purchased Price, Barcode, Serial #, Description, Facility, Building, Room, Department, Category, Object, Purchased Price, PO #'s, Check #'s, Acquisition Date, Finance Code, Asset Source, Condition, Disposition, and Date of Disposition.
The report displayed below was run by Acquisition Date.
The report displayed below was run by Object Code.
You have the ability to save your report before or after running the report.
a. Click the floppy disk Save icon to name and save your report.
b. You can also 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 Finance Code Report screen, select the saved report from the pull-down; your report will generate automatically.
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 to download the report as an Excel spreadsheet.
Click the Printer icon in the Export section to print the report.
Click Filters to further breakdown 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.
d. Click Clear All Filters to remove all applied filters.
See Filters for more information.
The columns displayed are included in the report; however, if you find specific columns unnecessary, you can remove columns by clicking Toggle Columns. To hide a column from the report, clear the selected check box. To include the column, select the check box.
If a column has been hidden from the report, upon navigating away from the screen, the column will remain hidden until the check box is selected via Toggle Columns.
The Page Size determines the numbers of results displayed per page. To customize the Page Size, click the field and enter in the desired amount, such as 20.
You can sort data by clicking on any of the headers that display arrows. Click once for ascending results; click twice for descending results.
