Inventory Transaction Report

This report (Reports > Report Module > Vaccine Management > Inventory Transaction Report) displays a list of all of the inventory transactions in the Organization (IRMS) for all users during the specified date range, along with the transaction type and cost if the vaccine was ordered using the ordering functionality. The cost is based on the order approval date or, if the order approval date is not available, the cost is pulled based on the order submission date. Multiple vaccines can be selected. A total appears at the bottom of the report for the total number of doses for the Organization (IRMS) and the total cost of the doses. Specifically, the total number of doses calculates from the sum of the doses column, and the total cost calculates from the sum of the total cost column.

This report can also be exported into .csv format. Click Export Report and then Open, after which Microsoft Excel opens with the report results (if it is installed on your computer).

TIP: The User column displays the name of the user who received the order.

Field

Description

Limit Report By

Organization (IRMS), Organization (IRMS) Group, Do Not Limit - Select the Organization (IRMS) or Organization (IRMS) Group from the drop-down list, or select Do Not Limit. The default is the user's Organization (IRMS).
Facility, Facility Group, Do Not Limit - Select the Facility from the drop-down list, or select Do Not Limit.
VFC Vaccines for Children PIN - Select a VFC PIN from the drop-down list to limit the report by this criterion.
Transaction Type - Select one or more transaction types. Use the shift key to select multiple transaction types listed in order, and use the CTRL key to select transaction types that are out of sequential order.
NOTES: Selecting a transaction type causes the Transaction Sub-Type drop-down list to also display. Also, the "Returned to the Depot" reason appears under the "Other-In" transaction type on this report, and "Unaccounted For in Provider Shipment" appears under the Wasted & Disposed transaction type.
Transaction Date Range - To limit the report by the transaction date range, enter the beginning (From) and ending (Through) transaction dates in the respective fields.
Funding Type - Select a funding type from the drop-down list.
Vaccines - From the box on the left, select one or more vaccines and click the >> button to move the selected item(s) to the box on the right, which holds the list of selected vaccines. Use the shift key to select multiple vaccines listed in order, and use the CTRL key to select vaccines that are out of sequential order. To remove one or more vaccines from the box on the right, select the vaccine(s) and click <<.
Lot Number - Enter a specific vaccine lot number.
Sort By - To sort the order of data on the report, select a choice from the drop-down list. Example choices included VFC PIN, IRMS, Facility, Vaccine Name, Report Date, and Transaction Type.
District/Region - Select a specific district or region number or name from the drop-down list.
Separate Reports by Calendar Month - To sort the report data into separate tables for each calendar month within the date range, first enter the transaction date range above and then select this option.