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.
1. In 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.
4. You have the option to break down your report by Department(s).
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 Acquired Date, Disposal Date, Vendor, Purchase Orders, Invoices, Checks, Asset Purchase Price, Additions, and Disposals are also displayed.
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.
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.
d. Click Clear All Filters to remove the applied filters.
See Filters for more information.