Inventory Transaction Report

Show Transaction Report tab is located within the sidemenu tab named Inventory.
You can get to the Transaction Report and search fields by clicking this specific tab, or you can get to the Transaction Report by clicking on a specific medication item name or Lot Number hyperlink from the Show Inventory module and it will take you to this Transaction Report with fields prepopulate with that specific inventory item details to run the report by. This Transaction Report is a report of any and all transactions related to the inventory module.

When you are in the Transaction Report tab, it should show the Transaction Search fields at the top. If it doesn’t, then simply click the Show Search link and the search toolbar will open. You can set this to default to always show or always hide in your MY SETTINGS preference.

Run Transaction Report Search

When you are in the Transaction Report tab, it will show the transaction search fields. To narrow your Inventory Transaction results, enter specifics into the fields to narrow down your search results. You must click the SEARCH button to show the matching results.

These are the search and filter field choices currently available. You do not need to enter in every field, but the more fields (filters) you have entered, the more narrowed down your inventory transaction search results will be.

• Patient Name: You can type in the specific patient’s last name (or beginning portion of a last name) to show results of transactions done for patients with that last name or portion of last name. This is not an auto-complete, but the search will render results based on what you enter here. (Ex, if you just type a Fr, then it will show results for any patients with the last name that begins with an Fr). Same applies to the First Name field.
• Item Name: You can type in the specific medication item name (or beginning portion of a medication) to show results of transactions done of that medication. This is not an auto-complete, but the search will render results based on what you enter here. (Ex, if you just type a Am, then it will show results for all transactions that begin with an Am).
• Item Class: Can limit the results of the Transaction Report to a specific drug class selection of medications.
• Item Manufacturer: You can type in the specific manufacturer (or beginning portion of a manufacturer) to show results of transactions done with that manufacturer. This is not an auto-complete, but the search will render results based on what you enter here. (Ex, if you just type an S, then it will show results for all transactions that have a manufacturer that begins with an S).
• Item Lot: You can type in the specific lot # (or beginning number of the lot) to show results of transactions done with that lot number. This is not an auto-complete, but the search will render results based on what you enter here. (Ex, if you just type an 3, then it will show results for all transactions that have a lot number that begins with an 3).
• Site/Stockpile: Can limit the results of the Transaction Report to specific location(s) and/or stockpile(s).
• UserName: You can type in the specific user or username (or beginning portion of a username) to limit results to show transactions done by that user (username) and select from the auto-complete. This is the user that performed an inventory transaction. If you need to limit the selections that display here, the Inventory Transaction Report Settings tab (found in Control sidemenu tab) controls this field. From the Inv.Trans.Report Settings tab, select the department(s) in this tab, which will be used to display the usernames in the Inventory Transaction Report. This limits the selection down to just those involved in using or dispensing inventory.

• Count by: Check-mark which of these that you wish to show a count for. It will display your results as a count only. This is possibly used to see how many (the count) of transactions by patient, by item or by user.
• Transaction Types: All are defaulted to be check-marked to show all in the results search. You can un-checkmark any to leave those types out. These are transaction types for the inventoried medication. You can show inventory transactions that were:
  • Received: These are transactions when a user entered an inventory from the add screen.
  • Dispensed: These are transactions when a user dispensed inventoried meds from the patient’s chart.
  • Expired: These are transactions when a user used an expire med option and expired some inventoried meds.
  • Transferred: These are transactions when a user used the transfer med option for an inventoried med.
  • Returned: These are transactions when a user entered a return into the inventory.
  • Edited: These are transactions when a user used options to edit an inventoried med.
  • Corrected: This is the transaction when a user changed an inventory item name or sig.
• Prescriber: You can limit the report to show results that are limited to a specific Prescriber/user in the system. Select using the auto-complete.
• RXID: This is the specific dispense/fill id# that Enterprise Health assigns when a medication inventory item is dispensed.
• Date Range: Enter a date range to limit the inventory transactions by.
• Fee Schedule: Ability to search by fee schedule. If a Fee Schedule is selected, the results will include the cost of the items displayed. Click the SEARCH button to render your results by your filters (fields) you entered.

Inventory Transaction Results

Your transaction search results will show below the search toolbar fields and the look and columns of the results differs based on what search filter criteria was entered, especially the “count by” filter if selected.

The View Printable and Show CSV links available above the results will place the data into a black/white view that you can print. Or you can click the Show CSV link to download it into an excel spreadsheet format.

If you have security permission, you can click Edit Transaction in the options column.

It will open the Edit Transaction screen where you can make changes/edits for this specific transaction.

Click SAVE button when done to save the transaction edit.
You will get a confirmation that the transaction was edited successfully.