Data Delivery and Reports

Data Delivery

Your inventory will be delivered electronically as an Excel file along with a hard copy sorted by your choice of the following:

Report Formats

Section/ Trade or Generic: This report lists inventory value subtotals for each section and lists drugs in each section by either trade name or generic name.

Descending dollar reports: are available, listing the item of which you have the highest dollar amount, down to the least.

ABC Listing: This report has three (3) sections; the "A" section list items of "A" value and above in descending dollar order, the "B" section list items of "B" value to "A" value in descending dollar order and the "C" section list items of "B" value and below in descending dollar order. You set the "A" and "B" values.

Comparison Report: This highlights many variances in the inventory levels of each drug between inventory periods. The report compares the current inventory with the previous inventory and lists Qty variance, price variance and total value variance. This report is available after your second inventory. The comparison report comes with a supplemental report listing all items, which have increased or decreased over $500.

Generic Name: This report lists drugs by their generic or chemical name. This is the labeling method most widely used in pharmacies since it widens the choices for filling prescriptions to any brand of the drug as long as it is generically equivalent. This report would be most useful for operations that stock drugs by generic name.

Manufacturer/ Trade or Generic: This report lists inventory items first by the five (5) digit manufacturer code of the NDC number and list each drug under that manufacturer by trade or generic name.

Straight Descending Dollar: This report lists all items in inventory, with the largest dollar value first descending to the smallest dollar value.

Section Descending Dollar: This report lists inventory items by section with the inventory items descending from largest dollar value to the smallest dollar value.

Trade: This report lists drugs by their trade or brand name. Many pharmacies stock drugs by trade name because physicians and nurses on the floor may be more familiar with them. This report would be most useful for operations that stock drugs by trade name.

Hospital formularies are available: The formulary has three (3) sections - the first section is a listing sorted by AHFS Major Class Code and includes a page index, the remaining two (2) sections are cross references; Generic Name to Trade Name; Trade Name to Generic Name.