Report:  Bulk Bottles Summary

 

(Topic Last Updated On:  05/05/2010)

 

This report displays all bulk bottles currently in bulk inventory for a selected drug and dose type, including basic bottle information for each.  This report is often printed at the end of each dispensing date and compared to physical bulk counts.

 

 

Report Column Explanations

 

Lot Number

This column displays each bulk bottle's lot number, as entered on the Add Bulk Inventory screen.

Bottle Number

This column displays each bulk bottle's bottle number, as entered on the Add Bulk Inventory screen.

Current Status

This column displays the current status of each bulk bottle.  'Received' bottles have been added to inventory and are new bottles.  'Partial-Closed' bottles have been opened in the system, but are currently closed and contain mgs.  'Opened' bottles are currently opened in the system and contain mgs.  'Empty-Closed' bottles contain 0 mgs.

New Bottle Amt (mgs)

This column displays the amount of mgs contained in a new bottle for each bottle, as defined in Inventory Dispensing Rules.

Unit Measure (mgs)

This column displays the size of one unit for each bulk bottle, as defined in Inventory Dispensing Rules.

Current # of Units

This column displays the number of units remaining in each bulk bottle.

Current Amt (mgs)

This column displays the amount of mgs remaining in each bulk bottle, calculated by multiplying the Current # of Units by Unit Measure (mgs).

Bulk Barcode #

This column displays the unique bulk barcode number for each bulk bottle, assigned by the system automatically when the bottles were entered on the Add Bulk Inventory screen.

 

Report Field Explanations

 

Inventory Unit Type

This field displays the type of inventory, Bulk or Unit, being displayed, which on this report is always Bulk.

Total Bottles with mgs.

This field displays the quantity of bulk bottles listed that contain mgs.

Total Full Bottles

This field displays the quantity of bulk bottles listed that contain the amount of mgs equal to its drug/dose type's New Bottle Amt (mgs).

Total Opened/Partial Bottles

This field displays the quantity of bulk bottles listed that have a bottle status of either 'Opened' or 'Partial-Closed'.

Totals for Bulk (mgs)

This field appears on the last page of this report and displays the grand total of mgs for your entire bulk inventory, including all drug and dose type combinations managed at your facility.

 

Criteria Explanations

 

Drug Type

This parameter allows users to limit the report's data to only display bottles of the 'Drug Type' selected here.

Dose Type

This parameter allows users to limit the report's data to only display bottles of the 'Dose Type' selected here.

Include Empty

By default this report does not display bottles with a status of 'Empty-Closed'.  Checking this parameter will include 'Empty-Closed' bottles on this report.

Lot Number Like

This parameter allows users to enter any part of a lot number for bottles they want to view, limiting the report to only include bottles with lot numbers containing the text entered in this field.