Inventory Transaction Report

The Inventory Transaction Report module serves as a way to generate basic Fixed Assets data based on acquisition and disposal dates. The report also includes item descriptions as well as addition cost. If looking for more descriptive information based on item locations, description, etc., see the Inventory Report.

Generating the Inventory Transaction Report

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

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

2. Start by entering the Filter Period Start and Filter Period End dates. This is required to run the report.

3. Select a Facility if you want your report to be restricted to one or specific Facilities.

The pull-downs are select multiple; therefore, you can select one, multiple, or all options. Click the Check all visible link to select all options at once. Click the Clear selected link to clear any selections made and start over.

4. You have the option to break down your report by Department(s).

Begin typing the name or number of the data in question in the Filter text box to pull matching information to the beginning of the list.

Inventory Transaction Report

5. Choose a Fixed Asset Category or multiple Categories to help filter your report.

6. To filter the report by disposition codes select the codes from the Disposition Code pull-down.

All of the fields shown on this screen are optional except the Start and End dates. Depending on what information you need to see in the report, you can run the report with all fields blank. Note: Running the report blank may take longer due to the amount of data being pulled.

7. Click Run Report.

The report lists the Item #, Description, and Category for filtered fixed asset information first.

The next four columns list the Acquired Date, Disposal Date, Additions cost, and Disposals cost for filtered fixed asset information.

At the bottom of the page, the Current Page Totals is listed. The totals here will change as you sift through pages. In the image shown, the Current Page Totals is just for page 1.

The amounts shown are totals for the Additions and Disposals columns.  The $88,711.75 represents the Current Page Totals for Additions. The $0.00 next to that number represents Current Page Totals for Disposals. The $208,279.26 below represents the Grand Totals for Additions. The $0.00 represents Grand Totals for Disposals.

Warning: If you use any of the filters to change the data, the Current Page Totals and Grand Totals will change. See Additional Features for more information on how to use filters.

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. 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 Inventory Transaction 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 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.