Versions Compared
Version | Old Version 2 | New Version Current |
---|---|---|
Changes made by | ||
Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Table of Contents |
---|
Info |
---|
To access the Drug Inventory Report screen, click on Inventory -> B. Inventory Report. |
Image Removed
|
Overview
The Drug Inventory Report screen allows the user users to view an a detailed inventory report of the drugs available in the pharmacy. The user can narrow down the report by , with options to filter the report based on specific criteria.
Users can narrow their search by entering the beginning of a drug’s Drug's name or its NDC number, control class, price level, quantity selecting a Control Class, Price Level, or the Quantity of the drug on hand, . Additional filters include the last fill date of the drug, whether the drug is type (brand or , generic, or both and/or whether the drug is an ), and classification as prescription (RX, OTC, or both).
These filtering options provide pharmacy with the flexibility to customize the report and quickly access the most relevant inventory information.
To access the Drug Inventory Report screen, click on Inventory ➡️ B. Inventory Report.

To generate a drug inventory report of all drugs, select "All Quantities" in the "Show if QOH is" field using the drop-down list and leave all other fields empty. Then, click the "Generate Report" button or press the "Enter" key when the "Generate Report" button is highlighted to obtain the inventory report.
To narrow down the report by drugInventory Report Filters
Info |
---|
|
|
To narrow down the report by quantity of the drug on hand, use the dropdown list for the "Show if QOH is" field to select the appropriate quantity-on-hand amount.
|
|
|
|
|
The user may narrow down the list using as many restrictions as he/she likes. they like.
When finished, click the "Generate Report" button or press the "Enter" key when the "Generate Report" button is highlighted to obtain the inventory report. Aside from its primary functionality, the
Adjusting Quantity On Hand
The report is very highly useful in adjusting Current Quantity on Hands by enabling the user fast interaction with the field. By simply for adjusting the current quantity on hand, as it enables users to easily modify drug quantities.
By clicking the corresponding field to ‘Curr QOH’ for the drug being adjusted, the software pops up a box that allows for modification of the entry without leaving the generated report.
Image Removed
After entering the appropriate quantity, you can simply repeat for any other drug to be adjusted. This allows for inventory adjustments/corrections to be completed much faster instead of having to do a manual update to each drug record at a time.BestRx opens a prompt that allows the user to modify the entry for Current QOH, Minimum QOH, Default Dispense Qty, and additional QOH Remarks.
Once the appropriate quantity is entered, the pharmacy can quickly repeat the process for any other drug that requires adjustment.
This method significantly speeds up inventory adjustments and corrections, eliminating the need for manual updates by going into each drug file individually.

Print Report
To print the report, click the "Print" button or press the "Enter" key when the "Print" button is highlighted.
Click the "Clear" button or press the "Enter" key when the "Clear" button is highlighted to clear all data displayed on the screen.

Print Special
There are specialty formatting options available if you need this report in a specific format.
Simply click the "Print Special" button or press the "Enter" key when the "Print Special" button is highlighted to open the extra menu. Currently we have an option to print a DEA Inventory Report as well as a Texas Controlled Substance Inventory Worksheet.

If you'd like to export the report to a file, click the "Export Data" button or press the "Enter" key when the "Export Data" button is highlighted.
NOTE: Export to Excel only works on full versions of Microsoft Excel/Office. It does NOT work with the Office Starter 2010 and other starter/third party versions. If using any one of these, export to a Comma Separated Values (CSV) instead.
DEA Inventory Report

Texas Controlled Substance Inventory Worksheet
